System Administration APIs:
FND_GLOBAL.USER_ID - Gives login userid of the oracle applications.
FND_GLOBAL.RESP_ID - Gives login application id of the oracle applications.
FND_GLOBAL.RESP_APPL_ID - Gives responsibility application id of the oracle applications.
FND_GLOBAL.APPS_INITIALIZE(USER_ID,APPL_ID,RESP_APPL_ID) - will be used to initialize the apps
FND_PRIFILE.VALUE('PROFILE_OPTION_NAME') -- This is used to get the value of the profile option.
FND_REQUEST.SUBMIT_REQUEST -- This is useful to submit a concurrent request.
FND_API.G_RET_STS_ERROR - This gives value 1
FND_API.G_RET_STS_UNEXP_ERROR - This gives value2
fnd_attached_documents_pkg.insert_row - Used to insert atttachments.
Advance Pricing APIs Version 12.1.3
QP_PRICE_LIST_PUB
This is used to upload prices lists and below procedure is used for this.
process_price_list
OM APIs
Version 12.1.3
OE_ORDER_PUB
This will be used to process the sales order. It contains following procedures/functions.
PROCESS_LINE
PROCESS_HEADER
DELETE_ORDER
DELETE_LINE
UPDATE_HEADER
UPDATE_LINE
PROCESS_ORDER
LOCK_ORDER
GET_ORDER
ID_TO_VALUE
PROCESS_MACD_ORDER
OE_CREDIT_PUB
CHECK_AVAILABLE_CREDIT - Main line function that will read an order header and determine if should be checked, consumes available credit and applies a credit hold if appropriate.
CHECK_ORDER - To determine if the order is subject to credit check.
CHECK_EXPOSURE - To determine credit exposure.
CHECK_AVAILABLE_CREDIT_LINE - New procedure for line level credit checking
CHECK_EXPOSURE_LINE - To determine credit exposure for line level.
OE_HEADER_STATUS_PUB
GET_BOOKED_STATUS - It takes header_id and return a 'Y' if the order has been booked, else 'N'.
GET_CLOSED_STATUS - It takes header_id and return a 'Y' if the order has been closed, else 'N'.
This will be used to process the sales order. It contains following procedures/functions.
PROCESS_LINE
PROCESS_HEADER
DELETE_ORDER
DELETE_LINE
UPDATE_HEADER
UPDATE_LINE
PROCESS_ORDER
LOCK_ORDER
GET_ORDER
ID_TO_VALUE
PROCESS_MACD_ORDER
OE_CREDIT_PUB
CHECK_AVAILABLE_CREDIT - Main line function that will read an order header and determine if should be checked, consumes available credit and applies a credit hold if appropriate.
CHECK_ORDER - To determine if the order is subject to credit check.
CHECK_EXPOSURE - To determine credit exposure.
CHECK_AVAILABLE_CREDIT_LINE - New procedure for line level credit checking
CHECK_EXPOSURE_LINE - To determine credit exposure for line level.
OE_HEADER_STATUS_PUB
GET_BOOKED_STATUS - It takes header_id and return a 'Y' if the order has been booked, else 'N'.
GET_CLOSED_STATUS - It takes header_id and return a 'Y' if the order has been closed, else 'N'.
GET_CANCELLED_STATUS-It takes header_id and return a 'Y' if the order has been booked, else 'N'.
GET_LINE_STATUS_PUB
GET_CLOSED_STATUS
GET_PURCHASE_RELEASE_STATUS
GET_SHIP_STATUS
GET_PICK_STATUS
GET_RECEIVED_STATUS
GET_INVOICED_STATUS
GET_LINE_STATUS
BOM APIs
Version 12.1.3
BOM_BOM_COPYORG_IMP
This API will get all BOMs from source organization and pass all Bills to BOM interface tables. BOM open interface program 'Bills and Routing Interface' program will be used to copy these into other organizations.
BOM_IMPORT_PUB
This package provides APIs for importing structure and its related entities through open interface or through web-adi interface.
BOM_BULKLOAD_PVT_PKG
This will be helpful to bulk loading data into the BOM interface tables from the Item Interface Tables. This API will be called through EGO bulk load program after item interface tables are populated.
BOM_COMMON_UTILS
Some important useful common utilities.
This API is useful to create the BOM with ECO
ECO APIs
ENG_ECO_PUB.PROCESS_ECOThis API is useful to create the BOM with ECO
OTL ( Oracle Time and Labor)
hxc_timestore_deposit.update_building_block
This API is useful to update the time building block, i.e a time card entry on a particular date.hxc_timestore_deposit.update_building_block(
p_building_block_id => p_time_building_block_id,
p_measure => p_updated_time,
p_unit_of_measure => 'HOURS',
p_comment_text => '',
p_deposit_process => 'OTL Deposit Process',
p_app_blocks => l_tbl_timecard_info,
p_app_attributes => l_tbl_attributes_info
);
p_time_building_block_id : is the time building block id of the day.
p_updated_hours : is the updated time.
Above API will only populate the time card information into pl/sql tables, after this, we should run the below API to post the changes to database.
hxc_timestore_deposit.execute_deposit_process (
p_validate => FALSE,
p_mode => 'SUBMIT',
p_deposit_process => 'OTL Deposit Process',
p_app_attributes => l_tbl_attributes_info,
p_app_blocks => l_tbl_timecard_info,
p_messages => l_tbl_messages,
p_timecard_id => l_out_timecard_id,
p_timecard_ovn => l_out_timecard_ovn);
GL APIs:
Below API is used to convert amount
gl_currency_api.convert_amount (oeh.transactional_curr_code ,'USD' ,DLIV.confirm_date ,'Corporate' ,oel.unit_selling_price)
Bank, Bank Branch, Bank Branch Accounts APIs:
apps.iby_ext_bankacct_pub.create_ext_bank ( p_api_version => l_api_version
,p_init_msg_list => FND_API.G_TRUE
,p_ext_bank_rec => l_extbank_rec
,x_bank_id => l_bank_id
,x_return_status => l_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data
,x_response => l_response_rec );
apps.IBY_EXT_BANKACCT_PUB.CREATE_EXT_BANK_BRANCH (p_api_version => l_api_version
,p_init_msg_list => FND_API.G_TRUE
,p_ext_bank_branch_rec => l_ext_bank_branch_rec
,x_branch_id => l_branch_id
,x_return_status => l_return_status1
,x_msg_count => l_msg_count1
,x_msg_data => l_msg_data1
,x_response => l_response_rec);
apps.iby_ext_bankacct_pub.create_ext_bank_acct ( p_api_version => l_api_version
,p_init_msg_list => l_init_msg_lISt
,p_ext_bank_acct_rec => l_bank_acct_rec
,p_association_level => 'SS'
,p_supplier_site_id => rec_supp_bank_acct.vendor_site_id
,p_party_site_id => rec_supp_bank_acct.party_site_id
,p_org_id => rec_supp_bank_acct.org_id
,p_org_type => 'OPERATING_UNIT'
,x_acct_id => l_acct
,x_return_status => l_return_status2
,x_msg_count => l_msg_count2
,x_msg_data => l_msg_data2
,x_response => l_response_rec );
Sales Reps: In-order to create sales rep first create resource, sales reps and territory optionally. Below are the three apis.
jtf_rs_resource_pub.create_resource(p_api_version =>l_api_version
,p_init_msg_list =>fnd_api.g_false
,p_commit =>fnd_api.g_false
,p_category =>UPPER(rec_salesrep.category)
,p_source_id =>rec_salesrep.person_id
,p_contact_id =>NULL
,p_managing_emp_id =>NULL
,p_managing_emp_num =>NULL
,p_start_date_active =>l_start_date
,p_end_date_active =>rec_salesrep.end_date_active
,x_return_status =>x_return_status
,x_msg_count =>x_msg_count
,x_msg_data =>x_msg_data
,x_resource_id =>l_resource_id
,x_resource_number =>l_resource_number
,p_resource_name =>rec_salesrep.salesrep_name
,p_source_name =>NULL
,p_source_email =>rec_salesrep.email_address
,p_source_number =>rec_salesrep.source_number );
JTF_RS_SALESREPS_PUB.CREATE_SALESREP(p_api_version =>l_api_version
,p_init_msg_list =>fnd_api.g_false
,p_commit =>fnd_api.g_false
,p_resource_id =>NVL(l_resource_id,rec_salesrep.resource_id)
,p_name =>rec_salesrep.salesrep_name--l_name
,p_start_date_active =>l_start_date
,p_salesrep_number =>l_salesrep_number
,p_sales_credit_type_id =>l_sales_credit_type_id
,p_end_date_active =>l_end_date_active
,p_email_address =>l_email_address
,p_org_id =>l_org_id--Added on May 15th
,p_status => 'A'
,x_return_status =>l_return_status
,x_msg_count =>l_msg_count
,x_msg_data =>l_msg_data
,x_salesrep_id =>l_salesrep_id );
JTF_RS_SRP_TERRITORIES_PUB.CREATE_RS_SRP_TERRITORIES(p_api_version =>l_api_version
,p_init_msg_list =>fnd_api.g_false
,p_commit =>fnd_api.g_false
,p_salesrep_id =>l_salesrep_id
,p_territory_id =>l_territory_id
,p_start_date_active =>l_start_date
,p_end_date_active =>l_end_date_active
,x_return_status =>l_return_status--l_return_status1
,x_msg_count =>l_msg_count--l_msg_count1
,x_msg_data =>l_msg_data--l_msg_data1
,x_salesrep_territory_id =>l_salesrep_territory_id);
Stock Locators:
inv_loc_wms_pub.create_locator( x_return_status => l_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data
,x_inventory_location_id => l_inventory_location_id
,x_locator_exists => l_locator_exists
,p_organization_id => l_organization_id
,p_organization_code => NULL
,p_concatenated_segments => l_concatenated_segments
,p_description => l_description
,p_inventory_location_type => NULL
,p_picking_order => NULL
,p_location_maximum_units => NULL
,p_subinventory_code => l_code_segment
,p_location_weight_uom_code => NULL
,p_max_weight => NULL
,p_volume_uom_code => NULL
,p_max_cubic_area => NULL
,p_x_coordinate => NULL
,p_y_coordinate => NULL
,p_z_coordinate => NULL
,p_physical_location_id => NULL
,p_pick_uom_code => NULL
,p_dimension_uom_code => NULL
,p_length => NULL
,p_width => NULL
,p_height => NULL
,p_status_id => 1
,p_dropping_order => NULL
);
EAM - Creating Preventive Maintenance Schedule ( PM Schedule):
EAM_PMDef_Pub.create_PM_def
( p_api_version => 1.0,
p_init_msg_list => fnd_api.g_false,
p_commit => fnd_api.g_false,
p_validation_level => fnd_api.g_valid_level_full,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_pm_schedule_rec => l_pm_schedule_rec,
p_pm_activities_tbl => l_pm_activities_tbl,
p_pm_day_interval_rules_tbl => l_pm_day_interval_rules_tbl,
p_pm_runtime_rules_tbl => l_pm_runtime_rules_tbl,
p_pm_list_date_rules_tbl => l_pm_list_date_rules_tbl,
x_new_pm_schedule_id => l_new_pm_schedule_id
);
Formula , Recipe and Recipe Validity Rules:
APPS.GMD_FORMULA_PUB.INSERT_FORMULA(p_api_version => l_api_version
,p_init_msg_list => fnd_api.g_true
,p_commit => fnd_api.g_false
,p_called_from_forms => 'NO'
,x_return_status => l_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data
,p_formula_header_tbl => rec_formula_rec_tbl);
apps.gmd_recipe_header.create_recipe_header(p_api_version => 1.0
,p_init_msg_list => l_init_msg_list
,p_commit => l_commit
,p_called_from_forms => 'NO'
,x_return_status => l_rcp_return_status
,x_msg_count => l_rcp_msg_count
,x_msg_data => l_rcp_msg_data
,p_recipe_header_tbl => type_gmd_rec_header_tbl
,p_recipe_header_flex => type_gmd_rec_header_flex
);
apps.gmd_recipe_detail.create_recipe_vr(p_api_version =>1.0
,p_init_msg_list =>l_init_msg_list
,p_commit =>l_commit
,p_called_from_forms =>'NO'
,x_return_status =>l_rcpvr_return_status
,x_msg_count =>l_rcpvr_msg_count
,x_msg_data =>l_rcpvr_msg_data
,p_recipe_vr_tbl =>type_gmd_rec_vr_tbl
,p_recipe_vr_flex =>type_gmd_rec_vr_flex);
Quality Specifications:
GMD_SPEC_PUB.CREATE_SPEC( p_api_version => 2.0
,p_init_msg_list => fnd_api.g_true
,p_commit => fnd_api.g_false
,p_validation_level => fnd_api.g_valid_level_full
,p_spec => l_spec
,p_spec_tests_tbl => l_spec_tests_tbl1
,p_user_name => rec_qty_spec.owner
,x_spec => l_spec_out
,x_spec_tests_tbl => l_spec_tests_tbl
,x_return_status => l_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data1);
Quality Specification Validity Rules ( Inventory, WIP, Customers, Suppliers ):
gmd_spec_vrs_pub.create_inventory_spec_vrs
( p_api_version => 1.0
, p_init_msg_list => fnd_api.g_true
, p_commit => fnd_api.g_false
, p_inventory_spec_vrs_tbl => l_inventory_spec_vrs_tbl
, p_user_name => l_user_name
, x_inventory_spec_vrs_tbl => l_inventory_spec_vrs_tbl_out
, x_return_status => l_return_status
, x_msg_count => l_msg_count
, x_msg_data => l_msg_data
);
gmd_spec_vrs_pub.create_wip_spec_vrs
( p_api_version => 1.0
, p_init_msg_list => fnd_api.g_true
, p_commit => fnd_api.g_false
, p_wip_spec_vrs_tbl => l_wip_spec_vrs_tbl
, p_user_name => l_user_name
, x_wip_spec_vrs_tbl => l_wip_spec_vrs_tbl_out
, x_return_status => l_return_status
, x_msg_count => l_msg_count
, x_msg_data => l_msg_data
);
gmd_spec_vrs_pub.create_customer_spec_vrs
( p_api_version => 1.0
, p_init_msg_list => fnd_api.g_true
, p_commit => fnd_api.g_false
, p_customer_spec_vrs_tbl => l_customer_spec_vrs_tbl
, p_user_name => l_user_name
, x_customer_spec_vrs_tbl => l_customer_spec_vrs_tbl_out
, x_return_status => l_return_status
, x_msg_count => l_msg_count
, x_msg_data => l_msg_data
);
gmd_spec_vrs_pub.create_supplier_spec_vrs
( p_api_version => 1.0
, p_init_msg_list => fnd_api.g_true
, p_commit => fnd_api.g_false
, p_supplier_spec_vrs_tbl => l_supplier_spec_vrs_tbl
, p_user_name => l_user_name
, x_supplier_spec_vrs_tbl => l_supplier_spec_vrs_tbl_out
, x_return_status => l_return_status
, x_msg_count => l_msg_count
, x_msg_data => l_msg_data
);
Customer creation APIs
hz_cust_account_v2pub.create_cust_account(p_init_msg_list => fnd_api.g_true
,p_cust_account_rec => l_cust_account_rec
,p_organization_rec => l_organization_rec
,p_customer_profile_rec => l_customer_profile_rec
,p_create_profile_amt => fnd_api.g_false
,x_cust_account_id => x_cust_account_id
,x_account_number => x_account_number
,x_party_id => x_party_id
,x_party_number => x_party_number
,x_profile_id => x_profile_id
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data);
hz_location_v2pub.create_location(p_init_msg_list => fnd_api.g_true
,p_location_rec => l_location_rec
,x_location_id => x_location_id
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data);
hz_party_site_v2pub.create_party_site(p_init_msg_list => fnd_api.g_true
,p_party_site_rec => l_party_site_rec
,x_party_site_id => x_party_site_id
,x_party_site_number => x_party_site_number
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data);
hz_cust_account_site_v2pub.create_cust_acct_site(p_init_msg_list => fnd_api.g_true
,p_cust_acct_site_rec => l_cust_acct_site_rec
,x_cust_acct_site_id => x_cust_acct_site_id
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data);
hz_cust_account_site_v2pub.create_cust_site_use(p_init_msg_list => l_init_msg_list
,p_cust_site_use_rec => l_cust_site_use_rec
,p_customer_profile_rec => l_customer_profile_rec
,p_create_profile => fnd_api.g_false
,p_create_profile_amt => fnd_api.g_false
,x_site_use_id => x_site_use_id
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data);
hz_customer_profile_v2pub.create_customer_profile(p_init_msg_list => l_init_msg_list
,p_customer_profile_rec => l_cust_site_profile_rec
,p_create_profile_amt => fnd_api.g_false
,x_cust_account_profile_id => x_cust_account_profile_id
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data);
hz_customer_profile_v2pub.create_cust_profile_amt(p_init_msg_list => l_init_msg_list
,p_check_foreign_key => fnd_api.g_false
,p_cust_profile_amt_rec => l_cust_profile_amt_rec
,x_cust_acct_profile_amt_id => x_cust_acct_profile_amt_id
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data);
hz_contact_point_v2pub.create_email_contact_point(p_init_msg_list => fnd_api.g_true
,p_contact_point_rec => l_contact_point_rec
,p_email_rec => l_email_rec
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,x_contact_point_id => x_contact_point_id);
hz_contact_point_v2pub.create_phone_contact_point(p_init_msg_list => fnd_api.g_true
,p_contact_point_rec => l_contact_point_rec
,p_phone_rec => l_phone_rec
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,x_contact_point_id => x_contact_point_id);
hz_contact_point_v2pub.create_email_contact_point(p_init_msg_list => fnd_api.g_true
,p_contact_point_rec => l_contact_point_rec
,p_email_rec => l_email_rec
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,x_contact_point_id => x_contact_point_id);
hz_party_v2pub.create_person(p_init_msg_list => fnd_api.g_true
,p_person_rec => l_person_rec
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,x_party_id => x_person_party_id
,x_party_number => x_person_party_number
,x_profile_id => x_person_profile_id);
hz_party_contact_v2pub.create_org_contact(p_init_msg_list => fnd_api.g_true
,p_org_contact_rec => l_org_contact_rec
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,x_org_contact_id => x_org_contact_id
,x_party_rel_id => x_party_rel_id
,x_party_id => x_org_cont_party_id
,x_party_number => x_org_cont_party_number);
hz_cust_account_role_v2pub.create_cust_account_role(p_init_msg_list => fnd_api.g_true
,p_cust_account_role_rec => l_cust_acct_role_rec
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,x_cust_account_role_id => x_cust_account_role_id);
hz_cust_account_role_v2pub.create_role_responsibility(p_init_msg_list => fnd_api.g_true
,p_role_responsibility_rec => l_role_responsibility_rec
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,x_responsibility_id => x_responsibility_id);
Bank, Bank Branch, Bank Branch Accounts APIs:
apps.iby_ext_bankacct_pub.create_ext_bank ( p_api_version => l_api_version
,p_init_msg_list => FND_API.G_TRUE
,p_ext_bank_rec => l_extbank_rec
,x_bank_id => l_bank_id
,x_return_status => l_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data
,x_response => l_response_rec );
apps.IBY_EXT_BANKACCT_PUB.CREATE_EXT_BANK_BRANCH (p_api_version => l_api_version
,p_init_msg_list => FND_API.G_TRUE
,p_ext_bank_branch_rec => l_ext_bank_branch_rec
,x_branch_id => l_branch_id
,x_return_status => l_return_status1
,x_msg_count => l_msg_count1
,x_msg_data => l_msg_data1
,x_response => l_response_rec);
apps.iby_ext_bankacct_pub.create_ext_bank_acct ( p_api_version => l_api_version
,p_init_msg_list => l_init_msg_lISt
,p_ext_bank_acct_rec => l_bank_acct_rec
,p_association_level => 'SS'
,p_supplier_site_id => rec_supp_bank_acct.vendor_site_id
,p_party_site_id => rec_supp_bank_acct.party_site_id
,p_org_id => rec_supp_bank_acct.org_id
,p_org_type => 'OPERATING_UNIT'
,x_acct_id => l_acct
,x_return_status => l_return_status2
,x_msg_count => l_msg_count2
,x_msg_data => l_msg_data2
,x_response => l_response_rec );
Sales Reps: In-order to create sales rep first create resource, sales reps and territory optionally. Below are the three apis.
jtf_rs_resource_pub.create_resource(p_api_version =>l_api_version
,p_init_msg_list =>fnd_api.g_false
,p_commit =>fnd_api.g_false
,p_category =>UPPER(rec_salesrep.category)
,p_source_id =>rec_salesrep.person_id
,p_contact_id =>NULL
,p_managing_emp_id =>NULL
,p_managing_emp_num =>NULL
,p_start_date_active =>l_start_date
,p_end_date_active =>rec_salesrep.end_date_active
,x_return_status =>x_return_status
,x_msg_count =>x_msg_count
,x_msg_data =>x_msg_data
,x_resource_id =>l_resource_id
,x_resource_number =>l_resource_number
,p_resource_name =>rec_salesrep.salesrep_name
,p_source_name =>NULL
,p_source_email =>rec_salesrep.email_address
,p_source_number =>rec_salesrep.source_number );
JTF_RS_SALESREPS_PUB.CREATE_SALESREP(p_api_version =>l_api_version
,p_init_msg_list =>fnd_api.g_false
,p_commit =>fnd_api.g_false
,p_resource_id =>NVL(l_resource_id,rec_salesrep.resource_id)
,p_name =>rec_salesrep.salesrep_name--l_name
,p_start_date_active =>l_start_date
,p_salesrep_number =>l_salesrep_number
,p_sales_credit_type_id =>l_sales_credit_type_id
,p_end_date_active =>l_end_date_active
,p_email_address =>l_email_address
,p_org_id =>l_org_id--Added on May 15th
,p_status => 'A'
,x_return_status =>l_return_status
,x_msg_count =>l_msg_count
,x_msg_data =>l_msg_data
,x_salesrep_id =>l_salesrep_id );
JTF_RS_SRP_TERRITORIES_PUB.CREATE_RS_SRP_TERRITORIES(p_api_version =>l_api_version
,p_init_msg_list =>fnd_api.g_false
,p_commit =>fnd_api.g_false
,p_salesrep_id =>l_salesrep_id
,p_territory_id =>l_territory_id
,p_start_date_active =>l_start_date
,p_end_date_active =>l_end_date_active
,x_return_status =>l_return_status--l_return_status1
,x_msg_count =>l_msg_count--l_msg_count1
,x_msg_data =>l_msg_data--l_msg_data1
,x_salesrep_territory_id =>l_salesrep_territory_id);
Stock Locators:
inv_loc_wms_pub.create_locator( x_return_status => l_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data
,x_inventory_location_id => l_inventory_location_id
,x_locator_exists => l_locator_exists
,p_organization_id => l_organization_id
,p_organization_code => NULL
,p_concatenated_segments => l_concatenated_segments
,p_description => l_description
,p_inventory_location_type => NULL
,p_picking_order => NULL
,p_location_maximum_units => NULL
,p_subinventory_code => l_code_segment
,p_location_weight_uom_code => NULL
,p_max_weight => NULL
,p_volume_uom_code => NULL
,p_max_cubic_area => NULL
,p_x_coordinate => NULL
,p_y_coordinate => NULL
,p_z_coordinate => NULL
,p_physical_location_id => NULL
,p_pick_uom_code => NULL
,p_dimension_uom_code => NULL
,p_length => NULL
,p_width => NULL
,p_height => NULL
,p_status_id => 1
,p_dropping_order => NULL
);
EAM - Creating Preventive Maintenance Schedule ( PM Schedule):
EAM_PMDef_Pub.create_PM_def
( p_api_version => 1.0,
p_init_msg_list => fnd_api.g_false,
p_commit => fnd_api.g_false,
p_validation_level => fnd_api.g_valid_level_full,
x_return_status => l_return_status,
x_msg_count => l_msg_count,
x_msg_data => l_msg_data,
p_pm_schedule_rec => l_pm_schedule_rec,
p_pm_activities_tbl => l_pm_activities_tbl,
p_pm_day_interval_rules_tbl => l_pm_day_interval_rules_tbl,
p_pm_runtime_rules_tbl => l_pm_runtime_rules_tbl,
p_pm_list_date_rules_tbl => l_pm_list_date_rules_tbl,
x_new_pm_schedule_id => l_new_pm_schedule_id
);
Formula , Recipe and Recipe Validity Rules:
APPS.GMD_FORMULA_PUB.INSERT_FORMULA(p_api_version => l_api_version
,p_init_msg_list => fnd_api.g_true
,p_commit => fnd_api.g_false
,p_called_from_forms => 'NO'
,x_return_status => l_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data
,p_formula_header_tbl => rec_formula_rec_tbl);
apps.gmd_recipe_header.create_recipe_header(p_api_version => 1.0
,p_init_msg_list => l_init_msg_list
,p_commit => l_commit
,p_called_from_forms => 'NO'
,x_return_status => l_rcp_return_status
,x_msg_count => l_rcp_msg_count
,x_msg_data => l_rcp_msg_data
,p_recipe_header_tbl => type_gmd_rec_header_tbl
,p_recipe_header_flex => type_gmd_rec_header_flex
);
apps.gmd_recipe_detail.create_recipe_vr(p_api_version =>1.0
,p_init_msg_list =>l_init_msg_list
,p_commit =>l_commit
,p_called_from_forms =>'NO'
,x_return_status =>l_rcpvr_return_status
,x_msg_count =>l_rcpvr_msg_count
,x_msg_data =>l_rcpvr_msg_data
,p_recipe_vr_tbl =>type_gmd_rec_vr_tbl
,p_recipe_vr_flex =>type_gmd_rec_vr_flex);
Quality Specifications:
GMD_SPEC_PUB.CREATE_SPEC( p_api_version => 2.0
,p_init_msg_list => fnd_api.g_true
,p_commit => fnd_api.g_false
,p_validation_level => fnd_api.g_valid_level_full
,p_spec => l_spec
,p_spec_tests_tbl => l_spec_tests_tbl1
,p_user_name => rec_qty_spec.owner
,x_spec => l_spec_out
,x_spec_tests_tbl => l_spec_tests_tbl
,x_return_status => l_return_status
,x_msg_count => l_msg_count
,x_msg_data => l_msg_data1);
Quality Specification Validity Rules ( Inventory, WIP, Customers, Suppliers ):
gmd_spec_vrs_pub.create_inventory_spec_vrs
( p_api_version => 1.0
, p_init_msg_list => fnd_api.g_true
, p_commit => fnd_api.g_false
, p_inventory_spec_vrs_tbl => l_inventory_spec_vrs_tbl
, p_user_name => l_user_name
, x_inventory_spec_vrs_tbl => l_inventory_spec_vrs_tbl_out
, x_return_status => l_return_status
, x_msg_count => l_msg_count
, x_msg_data => l_msg_data
);
gmd_spec_vrs_pub.create_wip_spec_vrs
( p_api_version => 1.0
, p_init_msg_list => fnd_api.g_true
, p_commit => fnd_api.g_false
, p_wip_spec_vrs_tbl => l_wip_spec_vrs_tbl
, p_user_name => l_user_name
, x_wip_spec_vrs_tbl => l_wip_spec_vrs_tbl_out
, x_return_status => l_return_status
, x_msg_count => l_msg_count
, x_msg_data => l_msg_data
);
gmd_spec_vrs_pub.create_customer_spec_vrs
( p_api_version => 1.0
, p_init_msg_list => fnd_api.g_true
, p_commit => fnd_api.g_false
, p_customer_spec_vrs_tbl => l_customer_spec_vrs_tbl
, p_user_name => l_user_name
, x_customer_spec_vrs_tbl => l_customer_spec_vrs_tbl_out
, x_return_status => l_return_status
, x_msg_count => l_msg_count
, x_msg_data => l_msg_data
);
gmd_spec_vrs_pub.create_supplier_spec_vrs
( p_api_version => 1.0
, p_init_msg_list => fnd_api.g_true
, p_commit => fnd_api.g_false
, p_supplier_spec_vrs_tbl => l_supplier_spec_vrs_tbl
, p_user_name => l_user_name
, x_supplier_spec_vrs_tbl => l_supplier_spec_vrs_tbl_out
, x_return_status => l_return_status
, x_msg_count => l_msg_count
, x_msg_data => l_msg_data
);
Customer creation APIs
hz_cust_account_v2pub.create_cust_account(p_init_msg_list => fnd_api.g_true
,p_cust_account_rec => l_cust_account_rec
,p_organization_rec => l_organization_rec
,p_customer_profile_rec => l_customer_profile_rec
,p_create_profile_amt => fnd_api.g_false
,x_cust_account_id => x_cust_account_id
,x_account_number => x_account_number
,x_party_id => x_party_id
,x_party_number => x_party_number
,x_profile_id => x_profile_id
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data);
hz_location_v2pub.create_location(p_init_msg_list => fnd_api.g_true
,p_location_rec => l_location_rec
,x_location_id => x_location_id
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data);
hz_party_site_v2pub.create_party_site(p_init_msg_list => fnd_api.g_true
,p_party_site_rec => l_party_site_rec
,x_party_site_id => x_party_site_id
,x_party_site_number => x_party_site_number
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data);
hz_cust_account_site_v2pub.create_cust_acct_site(p_init_msg_list => fnd_api.g_true
,p_cust_acct_site_rec => l_cust_acct_site_rec
,x_cust_acct_site_id => x_cust_acct_site_id
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data);
hz_cust_account_site_v2pub.create_cust_site_use(p_init_msg_list => l_init_msg_list
,p_cust_site_use_rec => l_cust_site_use_rec
,p_customer_profile_rec => l_customer_profile_rec
,p_create_profile => fnd_api.g_false
,p_create_profile_amt => fnd_api.g_false
,x_site_use_id => x_site_use_id
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data);
hz_customer_profile_v2pub.create_customer_profile(p_init_msg_list => l_init_msg_list
,p_customer_profile_rec => l_cust_site_profile_rec
,p_create_profile_amt => fnd_api.g_false
,x_cust_account_profile_id => x_cust_account_profile_id
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data);
hz_customer_profile_v2pub.create_cust_profile_amt(p_init_msg_list => l_init_msg_list
,p_check_foreign_key => fnd_api.g_false
,p_cust_profile_amt_rec => l_cust_profile_amt_rec
,x_cust_acct_profile_amt_id => x_cust_acct_profile_amt_id
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data);
hz_contact_point_v2pub.create_email_contact_point(p_init_msg_list => fnd_api.g_true
,p_contact_point_rec => l_contact_point_rec
,p_email_rec => l_email_rec
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,x_contact_point_id => x_contact_point_id);
hz_contact_point_v2pub.create_phone_contact_point(p_init_msg_list => fnd_api.g_true
,p_contact_point_rec => l_contact_point_rec
,p_phone_rec => l_phone_rec
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,x_contact_point_id => x_contact_point_id);
hz_contact_point_v2pub.create_email_contact_point(p_init_msg_list => fnd_api.g_true
,p_contact_point_rec => l_contact_point_rec
,p_email_rec => l_email_rec
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,x_contact_point_id => x_contact_point_id);
hz_party_v2pub.create_person(p_init_msg_list => fnd_api.g_true
,p_person_rec => l_person_rec
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,x_party_id => x_person_party_id
,x_party_number => x_person_party_number
,x_profile_id => x_person_profile_id);
hz_party_contact_v2pub.create_org_contact(p_init_msg_list => fnd_api.g_true
,p_org_contact_rec => l_org_contact_rec
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,x_org_contact_id => x_org_contact_id
,x_party_rel_id => x_party_rel_id
,x_party_id => x_org_cont_party_id
,x_party_number => x_org_cont_party_number);
hz_cust_account_role_v2pub.create_cust_account_role(p_init_msg_list => fnd_api.g_true
,p_cust_account_role_rec => l_cust_acct_role_rec
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,x_cust_account_role_id => x_cust_account_role_id);
hz_cust_account_role_v2pub.create_role_responsibility(p_init_msg_list => fnd_api.g_true
,p_role_responsibility_rec => l_role_responsibility_rec
,x_return_status => x_return_status
,x_msg_count => x_msg_count
,x_msg_data => x_msg_data
,x_responsibility_id => x_responsibility_id);
No comments:
Post a Comment