3:
4: PROCEDURE process_replace (
5: p_txn_identifier IN VARCHAR2,
6: p_source_system_name IN VARCHAR2,
7: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
8: x_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl,
9: x_account_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
10: x_eav_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
11: x_price_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
4: PROCEDURE process_replace (
5: p_txn_identifier IN VARCHAR2,
6: p_source_system_name IN VARCHAR2,
7: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
8: x_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl,
9: x_account_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
10: x_eav_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
11: x_price_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
12: x_org_assign_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
5: p_txn_identifier IN VARCHAR2,
6: p_source_system_name IN VARCHAR2,
7: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
8: x_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl,
9: x_account_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
10: x_eav_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
11: x_price_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
12: x_org_assign_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
13: x_return_status OUT NOCOPY VARCHAR2,
6: p_source_system_name IN VARCHAR2,
7: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
8: x_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl,
9: x_account_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
10: x_eav_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
11: x_price_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
12: x_org_assign_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
13: x_return_status OUT NOCOPY VARCHAR2,
14: x_error_message OUT NOCOPY VARCHAR2
7: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,
8: x_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl,
9: x_account_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
10: x_eav_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
11: x_price_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
12: x_org_assign_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
13: x_return_status OUT NOCOPY VARCHAR2,
14: x_error_message OUT NOCOPY VARCHAR2
15: )
8: x_party_tbl OUT NOCOPY csi_datastructures_pub.party_tbl,
9: x_account_tbl OUT NOCOPY csi_datastructures_pub.party_account_tbl,
10: x_eav_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,
11: x_price_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
12: x_org_assign_tbl OUT NOCOPY csi_datastructures_pub.organization_units_tbl,
13: x_return_status OUT NOCOPY VARCHAR2,
14: x_error_message OUT NOCOPY VARCHAR2
15: )
16: IS
39:
40: l_end_date DATE := SYSDATE + 1;
41: l_api_name VARCHAR2 (255)
42: := 'CSI_ML_REPLACE_PVT.PROCESS_REPLACE';
43: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
44: l_msg_count NUMBER (3);
45: l_msg_data VARCHAR2 (200);
46: l_msg_index NUMBER (3);
47: l_sql_error VARCHAR2 (2000);
48: l_api_version NUMBER (3) := 1.0;
49: l_init_msg_list VARCHAR2 (1) := fnd_api.g_true;
50: l_commit VARCHAR2 (1) := fnd_api.g_false;
51: e_error EXCEPTION;
52: x_party_header_tbl csi_datastructures_pub.party_header_tbl;
53: x_party_cache_tbl csi_datastructures_pub.party_header_tbl;
54: x_party_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
55: x_org_units_header_tbl csi_datastructures_pub.org_units_header_tbl;
56: x_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
49: l_init_msg_list VARCHAR2 (1) := fnd_api.g_true;
50: l_commit VARCHAR2 (1) := fnd_api.g_false;
51: e_error EXCEPTION;
52: x_party_header_tbl csi_datastructures_pub.party_header_tbl;
53: x_party_cache_tbl csi_datastructures_pub.party_header_tbl;
54: x_party_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
55: x_org_units_header_tbl csi_datastructures_pub.org_units_header_tbl;
56: x_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
57: x_ext_attrib_value_tbl csi_datastructures_pub.extend_attrib_values_tbl;
50: l_commit VARCHAR2 (1) := fnd_api.g_false;
51: e_error EXCEPTION;
52: x_party_header_tbl csi_datastructures_pub.party_header_tbl;
53: x_party_cache_tbl csi_datastructures_pub.party_header_tbl;
54: x_party_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
55: x_org_units_header_tbl csi_datastructures_pub.org_units_header_tbl;
56: x_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
57: x_ext_attrib_value_tbl csi_datastructures_pub.extend_attrib_values_tbl;
58: x_extend_attrib_tbl csi_datastructures_pub.extend_attrib_tbl;
51: e_error EXCEPTION;
52: x_party_header_tbl csi_datastructures_pub.party_header_tbl;
53: x_party_cache_tbl csi_datastructures_pub.party_header_tbl;
54: x_party_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
55: x_org_units_header_tbl csi_datastructures_pub.org_units_header_tbl;
56: x_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
57: x_ext_attrib_value_tbl csi_datastructures_pub.extend_attrib_values_tbl;
58: x_extend_attrib_tbl csi_datastructures_pub.extend_attrib_tbl;
59: x_instance_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
52: x_party_header_tbl csi_datastructures_pub.party_header_tbl;
53: x_party_cache_tbl csi_datastructures_pub.party_header_tbl;
54: x_party_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
55: x_org_units_header_tbl csi_datastructures_pub.org_units_header_tbl;
56: x_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
57: x_ext_attrib_value_tbl csi_datastructures_pub.extend_attrib_values_tbl;
58: x_extend_attrib_tbl csi_datastructures_pub.extend_attrib_tbl;
59: x_instance_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
60: l_price_index PLS_INTEGER;
53: x_party_cache_tbl csi_datastructures_pub.party_header_tbl;
54: x_party_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
55: x_org_units_header_tbl csi_datastructures_pub.org_units_header_tbl;
56: x_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
57: x_ext_attrib_value_tbl csi_datastructures_pub.extend_attrib_values_tbl;
58: x_extend_attrib_tbl csi_datastructures_pub.extend_attrib_tbl;
59: x_instance_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
60: l_price_index PLS_INTEGER;
61: l_org_index PLS_INTEGER;
54: x_party_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
55: x_org_units_header_tbl csi_datastructures_pub.org_units_header_tbl;
56: x_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
57: x_ext_attrib_value_tbl csi_datastructures_pub.extend_attrib_values_tbl;
58: x_extend_attrib_tbl csi_datastructures_pub.extend_attrib_tbl;
59: x_instance_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
60: l_price_index PLS_INTEGER;
61: l_org_index PLS_INTEGER;
62: l_party_index PLS_INTEGER;
55: x_org_units_header_tbl csi_datastructures_pub.org_units_header_tbl;
56: x_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_tbl;
57: x_ext_attrib_value_tbl csi_datastructures_pub.extend_attrib_values_tbl;
58: x_extend_attrib_tbl csi_datastructures_pub.extend_attrib_tbl;
59: x_instance_asset_header_tbl csi_datastructures_pub.instance_asset_header_tbl;
60: l_price_index PLS_INTEGER;
61: l_org_index PLS_INTEGER;
62: l_party_index PLS_INTEGER;
63: l_party_account_index PLS_INTEGER;
104: RETURN NULL;
105: END get_parent_tbl_index;
106:
107: FUNCTION get_obj_ver_num (
108: p_party_tbl IN csi_datastructures_pub.party_header_tbl,
109: p_instance_party_id IN NUMBER
110: )
111: RETURN PLS_INTEGER
112: IS