DBA Data[Home] [Help]

APPS.CSI_ML_REPLACE_PVT dependencies on CSI_DATASTRUCTURES_PUB

Line 7: x_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl,

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,

Line 8: x_party_tbl OUT NOCOPY csi_datastructures_pub.party_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,

Line 9: x_account_tbl OUT NOCOPY csi_datastructures_pub.party_account_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,

Line 10: x_eav_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl,

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

Line 11: x_price_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,

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: )

Line 12: x_org_assign_tbl OUT NOCOPY csi_datastructures_pub.organization_units_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: )
16: IS

Line 43: l_instance_header_rec csi_datastructures_pub.instance_header_rec;

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);

Line 52: x_party_header_tbl csi_datastructures_pub.party_header_tbl;

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;

Line 53: x_party_cache_tbl csi_datastructures_pub.party_header_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;

Line 54: x_party_account_header_tbl csi_datastructures_pub.party_account_header_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;

Line 55: x_org_units_header_tbl csi_datastructures_pub.org_units_header_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;

Line 56: x_pricing_attribs_tbl csi_datastructures_pub.pricing_attribs_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;

Line 57: x_ext_attrib_value_tbl csi_datastructures_pub.extend_attrib_values_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;
61: l_org_index PLS_INTEGER;

Line 58: x_extend_attrib_tbl csi_datastructures_pub.extend_attrib_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;
62: l_party_index PLS_INTEGER;

Line 59: x_instance_asset_header_tbl csi_datastructures_pub.instance_asset_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;
63: l_party_account_index PLS_INTEGER;

Line 108: p_party_tbl IN csi_datastructures_pub.party_header_tbl,

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