eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_ITEM_INSTANCE_PUB dependencies on CSI_DATASTRUCTURES_PUB

Line 23: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec

19: p_api_version IN NUMBER
20: ,p_commit IN VARCHAR2
21: ,p_init_msg_list IN VARCHAR2
22: ,p_validation_level IN NUMBER
23: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
24: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
25: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
26: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
27: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl

Line 24: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl

20: ,p_commit IN VARCHAR2
21: ,p_init_msg_list IN VARCHAR2
22: ,p_validation_level IN NUMBER
23: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
24: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
25: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
26: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
27: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
28: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl

Line 25: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl

21: ,p_init_msg_list IN VARCHAR2
22: ,p_validation_level IN NUMBER
23: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
24: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
25: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
26: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
27: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
28: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
29: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl

Line 26: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl

22: ,p_validation_level IN NUMBER
23: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
24: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
25: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
26: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
27: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
28: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
29: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
30: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

Line 27: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl

23: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
24: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
25: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
26: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
27: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
28: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
29: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
30: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
31: ,x_return_status OUT NOCOPY VARCHAR2

Line 28: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl

24: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
25: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
26: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
27: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
28: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
29: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
30: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
31: ,x_return_status OUT NOCOPY VARCHAR2
32: ,x_msg_count OUT NOCOPY NUMBER

Line 29: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl

25: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
26: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
27: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
28: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
29: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
30: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
31: ,x_return_status OUT NOCOPY VARCHAR2
32: ,x_msg_count OUT NOCOPY NUMBER
33: ,x_msg_data OUT NOCOPY VARCHAR2

Line 30: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

26: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
27: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
28: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
29: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
30: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
31: ,x_return_status OUT NOCOPY VARCHAR2
32: ,x_msg_count OUT NOCOPY NUMBER
33: ,x_msg_data OUT NOCOPY VARCHAR2
34: )

Line 51: l_version_label_rec csi_datastructures_pub.version_label_rec;

47: l_account_id NUMBER;
48: l_internal_party_id NUMBER;
49: l_party_id NUMBER;
50: l_version_label VARCHAR2(30);
51: l_version_label_rec csi_datastructures_pub.version_label_rec;
52: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
53: l_location_tbl csi_item_instance_pvt.location_tbl;
54: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
55: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;

Line 64: l_party_tbl csi_datastructures_pub.party_tbl;

60: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
61: l_party NUMBER;
62: l_contact NUMBER;
63: l_account NUMBER;
64: l_party_tbl csi_datastructures_pub.party_tbl;
65: lc_party_tbl csi_datastructures_pub.party_tbl;
66: l_temp_party_tbl csi_datastructures_pub.party_tbl;
67: l_account_tbl csi_datastructures_pub.party_account_tbl;
68: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;

Line 65: lc_party_tbl csi_datastructures_pub.party_tbl;

61: l_party NUMBER;
62: l_contact NUMBER;
63: l_account NUMBER;
64: l_party_tbl csi_datastructures_pub.party_tbl;
65: lc_party_tbl csi_datastructures_pub.party_tbl;
66: l_temp_party_tbl csi_datastructures_pub.party_tbl;
67: l_account_tbl csi_datastructures_pub.party_account_tbl;
68: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
69: l_count NUMBER;

Line 66: l_temp_party_tbl csi_datastructures_pub.party_tbl;

62: l_contact NUMBER;
63: l_account NUMBER;
64: l_party_tbl csi_datastructures_pub.party_tbl;
65: lc_party_tbl csi_datastructures_pub.party_tbl;
66: l_temp_party_tbl csi_datastructures_pub.party_tbl;
67: l_account_tbl csi_datastructures_pub.party_account_tbl;
68: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
69: l_count NUMBER;
70: l_t_party_tbl csi_datastructures_pub.party_tbl;

Line 67: l_account_tbl csi_datastructures_pub.party_account_tbl;

63: l_account NUMBER;
64: l_party_tbl csi_datastructures_pub.party_tbl;
65: lc_party_tbl csi_datastructures_pub.party_tbl;
66: l_temp_party_tbl csi_datastructures_pub.party_tbl;
67: l_account_tbl csi_datastructures_pub.party_account_tbl;
68: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
69: l_count NUMBER;
70: l_t_party_tbl csi_datastructures_pub.party_tbl;
71: -- following were added for att enhancements.

Line 68: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;

64: l_party_tbl csi_datastructures_pub.party_tbl;
65: lc_party_tbl csi_datastructures_pub.party_tbl;
66: l_temp_party_tbl csi_datastructures_pub.party_tbl;
67: l_account_tbl csi_datastructures_pub.party_account_tbl;
68: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
69: l_count NUMBER;
70: l_t_party_tbl csi_datastructures_pub.party_tbl;
71: -- following were added for att enhancements.
72: l_component_ins_type VARCHAR2(1):=NULL ;

Line 70: l_t_party_tbl csi_datastructures_pub.party_tbl;

66: l_temp_party_tbl csi_datastructures_pub.party_tbl;
67: l_account_tbl csi_datastructures_pub.party_account_tbl;
68: l_temp_account_tbl csi_datastructures_pub.party_account_tbl;
69: l_count NUMBER;
70: l_t_party_tbl csi_datastructures_pub.party_tbl;
71: -- following were added for att enhancements.
72: l_component_ins_type VARCHAR2(1):=NULL ;
73: l_config_hdr_id NUMBER;
74: l_config_rev_nbr NUMBER;

Line 131: l_config_instance_rec csi_datastructures_pub.instance_rec ;

127: FROM csi_item_instances
128: WHERE config_inst_hdr_id=p_config_inst_hdr_id
129: AND config_inst_item_id=p_config_inst_item_id;
130:
131: l_config_instance_rec csi_datastructures_pub.instance_rec ;
132: l_config_temp_rec csi_datastructures_pub.instance_rec ;
133: l_batch_hdr_id NUMBER;
134: l_batch_rev_nbr NUMBER;
135: l_instance_id_lst csi_datastructures_pub.id_tbl;

Line 132: l_config_temp_rec csi_datastructures_pub.instance_rec ;

128: WHERE config_inst_hdr_id=p_config_inst_hdr_id
129: AND config_inst_item_id=p_config_inst_item_id;
130:
131: l_config_instance_rec csi_datastructures_pub.instance_rec ;
132: l_config_temp_rec csi_datastructures_pub.instance_rec ;
133: l_batch_hdr_id NUMBER;
134: l_batch_rev_nbr NUMBER;
135: l_instance_id_lst csi_datastructures_pub.id_tbl;
136: l_config_ins_rec csi_datastructures_pub.instance_rec;

Line 135: l_instance_id_lst csi_datastructures_pub.id_tbl;

131: l_config_instance_rec csi_datastructures_pub.instance_rec ;
132: l_config_temp_rec csi_datastructures_pub.instance_rec ;
133: l_batch_hdr_id NUMBER;
134: l_batch_rev_nbr NUMBER;
135: l_instance_id_lst csi_datastructures_pub.id_tbl;
136: l_config_ins_rec csi_datastructures_pub.instance_rec;
137: l_config_tmp_rec csi_datastructures_pub.instance_rec;
138: --
139: px_oks_txn_inst_tbl OKS_IBINT_PUB.TXN_INSTANCE_TBL;

Line 136: l_config_ins_rec csi_datastructures_pub.instance_rec;

132: l_config_temp_rec csi_datastructures_pub.instance_rec ;
133: l_batch_hdr_id NUMBER;
134: l_batch_rev_nbr NUMBER;
135: l_instance_id_lst csi_datastructures_pub.id_tbl;
136: l_config_ins_rec csi_datastructures_pub.instance_rec;
137: l_config_tmp_rec csi_datastructures_pub.instance_rec;
138: --
139: px_oks_txn_inst_tbl OKS_IBINT_PUB.TXN_INSTANCE_TBL;
140: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;

Line 137: l_config_tmp_rec csi_datastructures_pub.instance_rec;

133: l_batch_hdr_id NUMBER;
134: l_batch_rev_nbr NUMBER;
135: l_instance_id_lst csi_datastructures_pub.id_tbl;
136: l_config_ins_rec csi_datastructures_pub.instance_rec;
137: l_config_tmp_rec csi_datastructures_pub.instance_rec;
138: --
139: px_oks_txn_inst_tbl OKS_IBINT_PUB.TXN_INSTANCE_TBL;
140: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;
141: l_batch_id NUMBER;

Line 723: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

719: -- issue. -- bug 3558082 (reported in 11.5.8)
720: -- Calling Contracts
721: -- Added on 02-OCT-01
722: -- Added by sk for fixing bug 2245976
723: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
724: csi_gen_utility_pvt.populate_install_param_rec;
725: END IF;
726: --
727: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;

Line 727: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;

723: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
724: csi_gen_utility_pvt.populate_install_param_rec;
725: END IF;
726: --
727: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
728: --
729: BEGIN
730: SELECT cip.party_id
731: INTO l_party_id

Line 1234: ,p_instance_rec IN csi_datastructures_pub.instance_rec

1230: p_api_version IN NUMBER
1231: ,p_commit IN VARCHAR2
1232: ,p_init_msg_list IN VARCHAR2
1233: ,p_validation_level IN NUMBER
1234: ,p_instance_rec IN csi_datastructures_pub.instance_rec
1235: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
1236: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
1237: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
1238: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl

Line 1235: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl

1231: ,p_commit IN VARCHAR2
1232: ,p_init_msg_list IN VARCHAR2
1233: ,p_validation_level IN NUMBER
1234: ,p_instance_rec IN csi_datastructures_pub.instance_rec
1235: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
1236: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
1237: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
1238: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
1239: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl

Line 1236: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl

1232: ,p_init_msg_list IN VARCHAR2
1233: ,p_validation_level IN NUMBER
1234: ,p_instance_rec IN csi_datastructures_pub.instance_rec
1235: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
1236: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
1237: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
1238: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
1239: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
1240: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl

Line 1237: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl

1233: ,p_validation_level IN NUMBER
1234: ,p_instance_rec IN csi_datastructures_pub.instance_rec
1235: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
1236: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
1237: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
1238: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
1239: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
1240: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
1241: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

Line 1238: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl

1234: ,p_instance_rec IN csi_datastructures_pub.instance_rec
1235: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
1236: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
1237: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
1238: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
1239: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
1240: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
1241: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
1242: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl

Line 1239: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl

1235: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
1236: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
1237: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
1238: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
1239: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
1240: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
1241: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
1242: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
1243: ,x_return_status OUT NOCOPY VARCHAR2

Line 1240: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl

1236: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
1237: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
1238: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
1239: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
1240: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
1241: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
1242: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
1243: ,x_return_status OUT NOCOPY VARCHAR2
1244: ,x_msg_count OUT NOCOPY NUMBER

Line 1241: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

1237: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
1238: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
1239: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
1240: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
1241: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
1242: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
1243: ,x_return_status OUT NOCOPY VARCHAR2
1244: ,x_msg_count OUT NOCOPY NUMBER
1245: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1242: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl

1238: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
1239: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
1240: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
1241: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
1242: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
1243: ,x_return_status OUT NOCOPY VARCHAR2
1244: ,x_msg_count OUT NOCOPY NUMBER
1245: ,x_msg_data OUT NOCOPY VARCHAR2
1246: )

Line 1252: l_instance_rec csi_datastructures_pub.instance_rec;

1248: IS
1249: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_ITEM_INSTANCE';
1250: l_api_version CONSTANT NUMBER := 1.0;
1251: l_debug_level NUMBER;
1252: l_instance_rec csi_datastructures_pub.instance_rec;
1253: l_temp_instance_rec csi_datastructures_pub.instance_rec;
1254: l_new_instance_rec csi_datastructures_pub.instance_rec := p_instance_rec;
1255: l_config_instance_rec csi_datastructures_pub.instance_rec ;
1256: l_config_temp_rec csi_datastructures_pub.instance_rec ;

Line 1253: l_temp_instance_rec csi_datastructures_pub.instance_rec;

1249: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_ITEM_INSTANCE';
1250: l_api_version CONSTANT NUMBER := 1.0;
1251: l_debug_level NUMBER;
1252: l_instance_rec csi_datastructures_pub.instance_rec;
1253: l_temp_instance_rec csi_datastructures_pub.instance_rec;
1254: l_new_instance_rec csi_datastructures_pub.instance_rec := p_instance_rec;
1255: l_config_instance_rec csi_datastructures_pub.instance_rec ;
1256: l_config_temp_rec csi_datastructures_pub.instance_rec ;
1257: l_party_tbl csi_datastructures_pub.party_tbl;

Line 1254: l_new_instance_rec csi_datastructures_pub.instance_rec := p_instance_rec;

1250: l_api_version CONSTANT NUMBER := 1.0;
1251: l_debug_level NUMBER;
1252: l_instance_rec csi_datastructures_pub.instance_rec;
1253: l_temp_instance_rec csi_datastructures_pub.instance_rec;
1254: l_new_instance_rec csi_datastructures_pub.instance_rec := p_instance_rec;
1255: l_config_instance_rec csi_datastructures_pub.instance_rec ;
1256: l_config_temp_rec csi_datastructures_pub.instance_rec ;
1257: l_party_tbl csi_datastructures_pub.party_tbl;
1258: l_account_tbl csi_datastructures_pub.party_account_tbl;

Line 1255: l_config_instance_rec csi_datastructures_pub.instance_rec ;

1251: l_debug_level NUMBER;
1252: l_instance_rec csi_datastructures_pub.instance_rec;
1253: l_temp_instance_rec csi_datastructures_pub.instance_rec;
1254: l_new_instance_rec csi_datastructures_pub.instance_rec := p_instance_rec;
1255: l_config_instance_rec csi_datastructures_pub.instance_rec ;
1256: l_config_temp_rec csi_datastructures_pub.instance_rec ;
1257: l_party_tbl csi_datastructures_pub.party_tbl;
1258: l_account_tbl csi_datastructures_pub.party_account_tbl;
1259: l_party_row NUMBER := 1;

Line 1256: l_config_temp_rec csi_datastructures_pub.instance_rec ;

1252: l_instance_rec csi_datastructures_pub.instance_rec;
1253: l_temp_instance_rec csi_datastructures_pub.instance_rec;
1254: l_new_instance_rec csi_datastructures_pub.instance_rec := p_instance_rec;
1255: l_config_instance_rec csi_datastructures_pub.instance_rec ;
1256: l_config_temp_rec csi_datastructures_pub.instance_rec ;
1257: l_party_tbl csi_datastructures_pub.party_tbl;
1258: l_account_tbl csi_datastructures_pub.party_account_tbl;
1259: l_party_row NUMBER := 1;
1260: l_acct_row NUMBER := 1;

Line 1257: l_party_tbl csi_datastructures_pub.party_tbl;

1253: l_temp_instance_rec csi_datastructures_pub.instance_rec;
1254: l_new_instance_rec csi_datastructures_pub.instance_rec := p_instance_rec;
1255: l_config_instance_rec csi_datastructures_pub.instance_rec ;
1256: l_config_temp_rec csi_datastructures_pub.instance_rec ;
1257: l_party_tbl csi_datastructures_pub.party_tbl;
1258: l_account_tbl csi_datastructures_pub.party_account_tbl;
1259: l_party_row NUMBER := 1;
1260: l_acct_row NUMBER := 1;
1261: l_msg_count NUMBER;

Line 1258: l_account_tbl csi_datastructures_pub.party_account_tbl;

1254: l_new_instance_rec csi_datastructures_pub.instance_rec := p_instance_rec;
1255: l_config_instance_rec csi_datastructures_pub.instance_rec ;
1256: l_config_temp_rec csi_datastructures_pub.instance_rec ;
1257: l_party_tbl csi_datastructures_pub.party_tbl;
1258: l_account_tbl csi_datastructures_pub.party_account_tbl;
1259: l_party_row NUMBER := 1;
1260: l_acct_row NUMBER := 1;
1261: l_msg_count NUMBER;
1262: l_msg_data VARCHAR2(2000);

Line 1277: l_version_label_rec csi_datastructures_pub.version_label_rec;

1273: l_internal_party_id NUMBER;
1274: l_party_id NUMBER;
1275: l_active_end_date DATE;
1276: l_dummy VARCHAR2(1);
1277: l_version_label_rec csi_datastructures_pub.version_label_rec;
1278: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
1279: l_location_tbl csi_item_instance_pvt.location_tbl;
1280: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
1281: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;

Line 1297: l_cascade_party_tbl csi_datastructures_pub.party_tbl; -- Added for 2972082

1293: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1294: l_updated BOOLEAN := FALSE;
1295: l_date BOOLEAN := FALSE;
1296: l_curr_party_id NUMBER; -- Added for 2972082
1297: l_cascade_party_tbl csi_datastructures_pub.party_tbl; -- Added for 2972082
1298: l_cascade_account_tbl csi_datastructures_pub.party_account_tbl; -- Added for 2972082
1299: l_found BOOLEAN := FALSE; -- Added for 2972082
1300: -- The following were added for att
1301: l_component_ins_type VARCHAR2(1):=NULL;

Line 1298: l_cascade_account_tbl csi_datastructures_pub.party_account_tbl; -- Added for 2972082

1294: l_updated BOOLEAN := FALSE;
1295: l_date BOOLEAN := FALSE;
1296: l_curr_party_id NUMBER; -- Added for 2972082
1297: l_cascade_party_tbl csi_datastructures_pub.party_tbl; -- Added for 2972082
1298: l_cascade_account_tbl csi_datastructures_pub.party_account_tbl; -- Added for 2972082
1299: l_found BOOLEAN := FALSE; -- Added for 2972082
1300: -- The following were added for att
1301: l_component_ins_type VARCHAR2(1):=NULL;
1302: l_config_hdr_id NUMBER;

Line 1344: l_t_party_tbl csi_datastructures_pub.party_tbl;

1340:
1341: l_create NUMBER;
1342: l_update NUMBER;
1343: l_p_id NUMBER;
1344: l_t_party_tbl csi_datastructures_pub.party_tbl;
1345: l_t_account_tbl csi_datastructures_pub.party_account_tbl;
1346: l_new_party_tbl csi_datastructures_pub.party_tbl;
1347: l_new_account_tbl csi_datastructures_pub.party_account_tbl;
1348: lb_party_tbl csi_datastructures_pub.party_tbl;

Line 1345: l_t_account_tbl csi_datastructures_pub.party_account_tbl;

1341: l_create NUMBER;
1342: l_update NUMBER;
1343: l_p_id NUMBER;
1344: l_t_party_tbl csi_datastructures_pub.party_tbl;
1345: l_t_account_tbl csi_datastructures_pub.party_account_tbl;
1346: l_new_party_tbl csi_datastructures_pub.party_tbl;
1347: l_new_account_tbl csi_datastructures_pub.party_account_tbl;
1348: lb_party_tbl csi_datastructures_pub.party_tbl;
1349: lc_party_tbl csi_datastructures_pub.party_tbl;

Line 1346: l_new_party_tbl csi_datastructures_pub.party_tbl;

1342: l_update NUMBER;
1343: l_p_id NUMBER;
1344: l_t_party_tbl csi_datastructures_pub.party_tbl;
1345: l_t_account_tbl csi_datastructures_pub.party_account_tbl;
1346: l_new_party_tbl csi_datastructures_pub.party_tbl;
1347: l_new_account_tbl csi_datastructures_pub.party_account_tbl;
1348: lb_party_tbl csi_datastructures_pub.party_tbl;
1349: lc_party_tbl csi_datastructures_pub.party_tbl;
1350: l_temp_party_tbl csi_datastructures_pub.party_tbl;

Line 1347: l_new_account_tbl csi_datastructures_pub.party_account_tbl;

1343: l_p_id NUMBER;
1344: l_t_party_tbl csi_datastructures_pub.party_tbl;
1345: l_t_account_tbl csi_datastructures_pub.party_account_tbl;
1346: l_new_party_tbl csi_datastructures_pub.party_tbl;
1347: l_new_account_tbl csi_datastructures_pub.party_account_tbl;
1348: lb_party_tbl csi_datastructures_pub.party_tbl;
1349: lc_party_tbl csi_datastructures_pub.party_tbl;
1350: l_temp_party_tbl csi_datastructures_pub.party_tbl;
1351: la_account_tbl csi_datastructures_pub.party_account_tbl;

Line 1348: lb_party_tbl csi_datastructures_pub.party_tbl;

1344: l_t_party_tbl csi_datastructures_pub.party_tbl;
1345: l_t_account_tbl csi_datastructures_pub.party_account_tbl;
1346: l_new_party_tbl csi_datastructures_pub.party_tbl;
1347: l_new_account_tbl csi_datastructures_pub.party_account_tbl;
1348: lb_party_tbl csi_datastructures_pub.party_tbl;
1349: lc_party_tbl csi_datastructures_pub.party_tbl;
1350: l_temp_party_tbl csi_datastructures_pub.party_tbl;
1351: la_account_tbl csi_datastructures_pub.party_account_tbl;
1352: l_temp_acct_tbl csi_datastructures_pub.party_account_tbl;

Line 1349: lc_party_tbl csi_datastructures_pub.party_tbl;

1345: l_t_account_tbl csi_datastructures_pub.party_account_tbl;
1346: l_new_party_tbl csi_datastructures_pub.party_tbl;
1347: l_new_account_tbl csi_datastructures_pub.party_account_tbl;
1348: lb_party_tbl csi_datastructures_pub.party_tbl;
1349: lc_party_tbl csi_datastructures_pub.party_tbl;
1350: l_temp_party_tbl csi_datastructures_pub.party_tbl;
1351: la_account_tbl csi_datastructures_pub.party_account_tbl;
1352: l_temp_acct_tbl csi_datastructures_pub.party_account_tbl;
1353:

Line 1350: l_temp_party_tbl csi_datastructures_pub.party_tbl;

1346: l_new_party_tbl csi_datastructures_pub.party_tbl;
1347: l_new_account_tbl csi_datastructures_pub.party_account_tbl;
1348: lb_party_tbl csi_datastructures_pub.party_tbl;
1349: lc_party_tbl csi_datastructures_pub.party_tbl;
1350: l_temp_party_tbl csi_datastructures_pub.party_tbl;
1351: la_account_tbl csi_datastructures_pub.party_account_tbl;
1352: l_temp_acct_tbl csi_datastructures_pub.party_account_tbl;
1353:
1354: -- End of defining variables for bug 2172968

Line 1351: la_account_tbl csi_datastructures_pub.party_account_tbl;

1347: l_new_account_tbl csi_datastructures_pub.party_account_tbl;
1348: lb_party_tbl csi_datastructures_pub.party_tbl;
1349: lc_party_tbl csi_datastructures_pub.party_tbl;
1350: l_temp_party_tbl csi_datastructures_pub.party_tbl;
1351: la_account_tbl csi_datastructures_pub.party_account_tbl;
1352: l_temp_acct_tbl csi_datastructures_pub.party_account_tbl;
1353:
1354: -- End of defining variables for bug 2172968
1355:

Line 1352: l_temp_acct_tbl csi_datastructures_pub.party_account_tbl;

1348: lb_party_tbl csi_datastructures_pub.party_tbl;
1349: lc_party_tbl csi_datastructures_pub.party_tbl;
1350: l_temp_party_tbl csi_datastructures_pub.party_tbl;
1351: la_account_tbl csi_datastructures_pub.party_account_tbl;
1352: l_temp_acct_tbl csi_datastructures_pub.party_account_tbl;
1353:
1354: -- End of defining variables for bug 2172968
1355:
1356: CURSOR config_ins_key (p_config_hdr_id NUMBER, p_config_rev_nbr NUMBER) is

Line 1402: l_tem_acct_tbl csi_datastructures_pub.party_account_tbl;

1398: ,object_version_number
1399: from csi_ip_accounts
1400: where instance_party_id=p_ins_pty_id
1401: and relationship_type_code<>'OWNER';
1402: l_tem_acct_tbl csi_datastructures_pub.party_account_tbl;
1403: l_tem_party_id NUMBER:=NULL;
1404: l_temp_var NUMBER:=1;
1405: l_bacct_row NUMBER;
1406: l_src_change_owner VARCHAR2(1);

Line 1410: l_instance_id_lst csi_datastructures_pub.id_tbl;

1406: l_src_change_owner VARCHAR2(1);
1407: ------------------------------------------end addition ---
1408: l_batch_hdr_id NUMBER;
1409: l_batch_rev_nbr NUMBER;
1410: l_instance_id_lst csi_datastructures_pub.id_tbl;
1411: l_config_ins_rec csi_datastructures_pub.instance_rec;
1412: l_config_tmp_rec csi_datastructures_pub.instance_rec;
1413: l_lock_status NUMBER;
1414: --

Line 1411: l_config_ins_rec csi_datastructures_pub.instance_rec;

1407: ------------------------------------------end addition ---
1408: l_batch_hdr_id NUMBER;
1409: l_batch_rev_nbr NUMBER;
1410: l_instance_id_lst csi_datastructures_pub.id_tbl;
1411: l_config_ins_rec csi_datastructures_pub.instance_rec;
1412: l_config_tmp_rec csi_datastructures_pub.instance_rec;
1413: l_lock_status NUMBER;
1414: --
1415: px_oks_txn_inst_tbl OKS_IBINT_PUB.TXN_INSTANCE_TBL;

Line 1412: l_config_tmp_rec csi_datastructures_pub.instance_rec;

1408: l_batch_hdr_id NUMBER;
1409: l_batch_rev_nbr NUMBER;
1410: l_instance_id_lst csi_datastructures_pub.id_tbl;
1411: l_config_ins_rec csi_datastructures_pub.instance_rec;
1412: l_config_tmp_rec csi_datastructures_pub.instance_rec;
1413: l_lock_status NUMBER;
1414: --
1415: px_oks_txn_inst_tbl OKS_IBINT_PUB.TXN_INSTANCE_TBL;
1416: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;

Line 1495: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN

1491: l_flag:=CSI_GEN_UTILITY_PVT.enable_trace(l_trace_flag => l_flag);
1492: -- End enable trace
1493: ****/
1494: -- Start API body
1495: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
1496: csi_gen_utility_pvt.populate_install_param_rec;
1497: END IF;
1498: --
1499: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;

Line 1499: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;

1495: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
1496: csi_gen_utility_pvt.populate_install_param_rec;
1497: END IF;
1498: --
1499: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
1500: --
1501: IF l_internal_party_id IS NULL THEN
1502: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
1503: FND_MSG_PUB.ADD;

Line 3495: ,p_instance_rec IN csi_datastructures_pub.instance_rec

3491: p_api_version IN NUMBER
3492: ,p_commit IN VARCHAR2
3493: ,p_init_msg_list IN VARCHAR2
3494: ,p_validation_level IN NUMBER
3495: ,p_instance_rec IN csi_datastructures_pub.instance_rec
3496: ,p_expire_children IN VARCHAR2
3497: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
3498: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
3499: ,x_return_status OUT NOCOPY VARCHAR2

Line 3497: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

3493: ,p_init_msg_list IN VARCHAR2
3494: ,p_validation_level IN NUMBER
3495: ,p_instance_rec IN csi_datastructures_pub.instance_rec
3496: ,p_expire_children IN VARCHAR2
3497: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
3498: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
3499: ,x_return_status OUT NOCOPY VARCHAR2
3500: ,x_msg_count OUT NOCOPY NUMBER
3501: ,x_msg_data OUT NOCOPY VARCHAR2

Line 3498: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl

3494: ,p_validation_level IN NUMBER
3495: ,p_instance_rec IN csi_datastructures_pub.instance_rec
3496: ,p_expire_children IN VARCHAR2
3497: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
3498: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
3499: ,x_return_status OUT NOCOPY VARCHAR2
3500: ,x_msg_count OUT NOCOPY NUMBER
3501: ,x_msg_data OUT NOCOPY VARCHAR2
3502: )

Line 3558: l_config_instance_rec csi_datastructures_pub.instance_rec ;

3554: FROM csi_item_instances
3555: WHERE config_inst_hdr_id=p_config_inst_hdr_id
3556: AND config_inst_item_id=p_config_inst_item_id;
3557:
3558: l_config_instance_rec csi_datastructures_pub.instance_rec ;
3559: l_config_temp_rec csi_datastructures_pub.instance_rec ;
3560: l_batch_hdr_id NUMBER;
3561: l_batch_rev_nbr NUMBER;
3562: l_instance_id_lst csi_datastructures_pub.id_tbl;

Line 3559: l_config_temp_rec csi_datastructures_pub.instance_rec ;

3555: WHERE config_inst_hdr_id=p_config_inst_hdr_id
3556: AND config_inst_item_id=p_config_inst_item_id;
3557:
3558: l_config_instance_rec csi_datastructures_pub.instance_rec ;
3559: l_config_temp_rec csi_datastructures_pub.instance_rec ;
3560: l_batch_hdr_id NUMBER;
3561: l_batch_rev_nbr NUMBER;
3562: l_instance_id_lst csi_datastructures_pub.id_tbl;
3563: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;

Line 3562: l_instance_id_lst csi_datastructures_pub.id_tbl;

3558: l_config_instance_rec csi_datastructures_pub.instance_rec ;
3559: l_config_temp_rec csi_datastructures_pub.instance_rec ;
3560: l_batch_hdr_id NUMBER;
3561: l_batch_rev_nbr NUMBER;
3562: l_instance_id_lst csi_datastructures_pub.id_tbl;
3563: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
3564: l_location_tbl csi_item_instance_pvt.location_tbl;
3565: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
3566: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;

Line 3568: l_config_ins_rec csi_datastructures_pub.instance_rec;

3564: l_location_tbl csi_item_instance_pvt.location_tbl;
3565: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
3566: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
3567: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
3568: l_config_ins_rec csi_datastructures_pub.instance_rec;
3569: l_config_tmp_rec csi_datastructures_pub.instance_rec;
3570: --
3571: px_oks_txn_inst_tbl OKS_IBINT_PUB.TXN_INSTANCE_TBL;
3572: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;

Line 3569: l_config_tmp_rec csi_datastructures_pub.instance_rec;

3565: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
3566: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
3567: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
3568: l_config_ins_rec csi_datastructures_pub.instance_rec;
3569: l_config_tmp_rec csi_datastructures_pub.instance_rec;
3570: --
3571: px_oks_txn_inst_tbl OKS_IBINT_PUB.TXN_INSTANCE_TBL;
3572: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;
3573: l_batch_type VARCHAR2(50);

Line 4128: ,p_instance_query_rec IN csi_datastructures_pub.instance_query_rec

4124: p_api_version IN NUMBER
4125: ,p_commit IN VARCHAR2
4126: ,p_init_msg_list IN VARCHAR2
4127: ,p_validation_level IN NUMBER
4128: ,p_instance_query_rec IN csi_datastructures_pub.instance_query_rec
4129: ,p_party_query_rec IN csi_datastructures_pub.party_query_rec
4130: ,p_account_query_rec IN csi_datastructures_pub.party_account_query_rec
4131: ,p_transaction_id IN NUMBER
4132: ,p_resolve_id_columns IN VARCHAR2

Line 4129: ,p_party_query_rec IN csi_datastructures_pub.party_query_rec

4125: ,p_commit IN VARCHAR2
4126: ,p_init_msg_list IN VARCHAR2
4127: ,p_validation_level IN NUMBER
4128: ,p_instance_query_rec IN csi_datastructures_pub.instance_query_rec
4129: ,p_party_query_rec IN csi_datastructures_pub.party_query_rec
4130: ,p_account_query_rec IN csi_datastructures_pub.party_account_query_rec
4131: ,p_transaction_id IN NUMBER
4132: ,p_resolve_id_columns IN VARCHAR2
4133: ,p_active_instance_only IN VARCHAR2

Line 4130: ,p_account_query_rec IN csi_datastructures_pub.party_account_query_rec

4126: ,p_init_msg_list IN VARCHAR2
4127: ,p_validation_level IN NUMBER
4128: ,p_instance_query_rec IN csi_datastructures_pub.instance_query_rec
4129: ,p_party_query_rec IN csi_datastructures_pub.party_query_rec
4130: ,p_account_query_rec IN csi_datastructures_pub.party_account_query_rec
4131: ,p_transaction_id IN NUMBER
4132: ,p_resolve_id_columns IN VARCHAR2
4133: ,p_active_instance_only IN VARCHAR2
4134: ,x_instance_header_tbl OUT NOCOPY csi_datastructures_pub.instance_header_tbl

Line 4134: ,x_instance_header_tbl OUT NOCOPY csi_datastructures_pub.instance_header_tbl

4130: ,p_account_query_rec IN csi_datastructures_pub.party_account_query_rec
4131: ,p_transaction_id IN NUMBER
4132: ,p_resolve_id_columns IN VARCHAR2
4133: ,p_active_instance_only IN VARCHAR2
4134: ,x_instance_header_tbl OUT NOCOPY csi_datastructures_pub.instance_header_tbl
4135: ,x_return_status OUT NOCOPY VARCHAR2
4136: ,x_msg_count OUT NOCOPY NUMBER
4137: ,x_msg_data OUT NOCOPY VARCHAR2
4138: )IS

Line 4143: l_instance_rec csi_datastructures_pub.instance_rec;

4139:
4140: l_api_name CONSTANT VARCHAR2(30) := 'GET_ITEM_INSTANCES';
4141: l_api_version CONSTANT NUMBER := 1.0;
4142: l_debug_level NUMBER;
4143: l_instance_rec csi_datastructures_pub.instance_rec;
4144: l_descriptions_rec csi_datastructures_pub.instance_rec;
4145: l_txn_rec csi_datastructures_pub.transaction_rec;
4146: l_flag VARCHAR2(1) :='N';
4147: l_error_code VARCHAR2(10);

Line 4144: l_descriptions_rec csi_datastructures_pub.instance_rec;

4140: l_api_name CONSTANT VARCHAR2(30) := 'GET_ITEM_INSTANCES';
4141: l_api_version CONSTANT NUMBER := 1.0;
4142: l_debug_level NUMBER;
4143: l_instance_rec csi_datastructures_pub.instance_rec;
4144: l_descriptions_rec csi_datastructures_pub.instance_rec;
4145: l_txn_rec csi_datastructures_pub.transaction_rec;
4146: l_flag VARCHAR2(1) :='N';
4147: l_error_code VARCHAR2(10);
4148: l_return_status NUMBER;

Line 4145: l_txn_rec csi_datastructures_pub.transaction_rec;

4141: l_api_version CONSTANT NUMBER := 1.0;
4142: l_debug_level NUMBER;
4143: l_instance_rec csi_datastructures_pub.instance_rec;
4144: l_descriptions_rec csi_datastructures_pub.instance_rec;
4145: l_txn_rec csi_datastructures_pub.transaction_rec;
4146: l_flag VARCHAR2(1) :='N';
4147: l_error_code VARCHAR2(10);
4148: l_return_status NUMBER;
4149: l_msg_count NUMBER;

Line 4155: l_instance_header_rec csi_datastructures_pub.instance_header_rec;

4151: l_msg_index NUMBER;
4152: l_line_count NUMBER;
4153: l_cur_get_inst_rel NUMBER;
4154: l_where_clause VARCHAR2(20000) := '';
4155: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
4156: l_party_rec csi_datastructures_pub.party_rec;
4157: l_party_account_rec csi_datastructures_pub.party_account_rec;
4158: l_instance_id_list VARCHAR2(2000):= '';
4159: l_instance_id NUMBER;

Line 4156: l_party_rec csi_datastructures_pub.party_rec;

4152: l_line_count NUMBER;
4153: l_cur_get_inst_rel NUMBER;
4154: l_where_clause VARCHAR2(20000) := '';
4155: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
4156: l_party_rec csi_datastructures_pub.party_rec;
4157: l_party_account_rec csi_datastructures_pub.party_account_rec;
4158: l_instance_id_list VARCHAR2(2000):= '';
4159: l_instance_id NUMBER;
4160: l_rows_processed NUMBER;

Line 4157: l_party_account_rec csi_datastructures_pub.party_account_rec;

4153: l_cur_get_inst_rel NUMBER;
4154: l_where_clause VARCHAR2(20000) := '';
4155: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
4156: l_party_rec csi_datastructures_pub.party_rec;
4157: l_party_account_rec csi_datastructures_pub.party_account_rec;
4158: l_instance_id_list VARCHAR2(2000):= '';
4159: l_instance_id NUMBER;
4160: l_rows_processed NUMBER;
4161: l_count NUMBER := 0;

Line 4423: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_header_rec

4419: p_api_version IN NUMBER
4420: ,p_commit IN VARCHAR2
4421: ,p_init_msg_list IN VARCHAR2
4422: ,p_validation_level IN NUMBER
4423: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_header_rec
4424: ,p_get_parties IN VARCHAR2
4425: ,p_party_header_tbl OUT NOCOPY csi_datastructures_pub.party_header_tbl
4426: ,p_get_accounts IN VARCHAR2
4427: ,p_account_header_tbl OUT NOCOPY csi_datastructures_pub.party_account_header_tbl

Line 4425: ,p_party_header_tbl OUT NOCOPY csi_datastructures_pub.party_header_tbl

4421: ,p_init_msg_list IN VARCHAR2
4422: ,p_validation_level IN NUMBER
4423: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_header_rec
4424: ,p_get_parties IN VARCHAR2
4425: ,p_party_header_tbl OUT NOCOPY csi_datastructures_pub.party_header_tbl
4426: ,p_get_accounts IN VARCHAR2
4427: ,p_account_header_tbl OUT NOCOPY csi_datastructures_pub.party_account_header_tbl
4428: ,p_get_org_assignments IN VARCHAR2
4429: ,p_org_header_tbl OUT NOCOPY csi_datastructures_pub.org_units_header_tbl

Line 4427: ,p_account_header_tbl OUT NOCOPY csi_datastructures_pub.party_account_header_tbl

4423: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_header_rec
4424: ,p_get_parties IN VARCHAR2
4425: ,p_party_header_tbl OUT NOCOPY csi_datastructures_pub.party_header_tbl
4426: ,p_get_accounts IN VARCHAR2
4427: ,p_account_header_tbl OUT NOCOPY csi_datastructures_pub.party_account_header_tbl
4428: ,p_get_org_assignments IN VARCHAR2
4429: ,p_org_header_tbl OUT NOCOPY csi_datastructures_pub.org_units_header_tbl
4430: ,p_get_pricing_attribs IN VARCHAR2
4431: ,p_pricing_attrib_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl

Line 4429: ,p_org_header_tbl OUT NOCOPY csi_datastructures_pub.org_units_header_tbl

4425: ,p_party_header_tbl OUT NOCOPY csi_datastructures_pub.party_header_tbl
4426: ,p_get_accounts IN VARCHAR2
4427: ,p_account_header_tbl OUT NOCOPY csi_datastructures_pub.party_account_header_tbl
4428: ,p_get_org_assignments IN VARCHAR2
4429: ,p_org_header_tbl OUT NOCOPY csi_datastructures_pub.org_units_header_tbl
4430: ,p_get_pricing_attribs IN VARCHAR2
4431: ,p_pricing_attrib_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
4432: ,p_get_ext_attribs IN VARCHAR2
4433: ,p_ext_attrib_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl

Line 4431: ,p_pricing_attrib_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl

4427: ,p_account_header_tbl OUT NOCOPY csi_datastructures_pub.party_account_header_tbl
4428: ,p_get_org_assignments IN VARCHAR2
4429: ,p_org_header_tbl OUT NOCOPY csi_datastructures_pub.org_units_header_tbl
4430: ,p_get_pricing_attribs IN VARCHAR2
4431: ,p_pricing_attrib_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
4432: ,p_get_ext_attribs IN VARCHAR2
4433: ,p_ext_attrib_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
4434: ,p_ext_attrib_def_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_tbl --added
4435: ,p_get_asset_assignments IN VARCHAR2

Line 4433: ,p_ext_attrib_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl

4429: ,p_org_header_tbl OUT NOCOPY csi_datastructures_pub.org_units_header_tbl
4430: ,p_get_pricing_attribs IN VARCHAR2
4431: ,p_pricing_attrib_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
4432: ,p_get_ext_attribs IN VARCHAR2
4433: ,p_ext_attrib_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
4434: ,p_ext_attrib_def_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_tbl --added
4435: ,p_get_asset_assignments IN VARCHAR2
4436: ,p_asset_header_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_header_tbl
4437: ,p_resolve_id_columns IN VARCHAR2

Line 4434: ,p_ext_attrib_def_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_tbl --added

4430: ,p_get_pricing_attribs IN VARCHAR2
4431: ,p_pricing_attrib_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
4432: ,p_get_ext_attribs IN VARCHAR2
4433: ,p_ext_attrib_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
4434: ,p_ext_attrib_def_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_tbl --added
4435: ,p_get_asset_assignments IN VARCHAR2
4436: ,p_asset_header_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_header_tbl
4437: ,p_resolve_id_columns IN VARCHAR2
4438: ,p_time_stamp IN DATE

Line 4436: ,p_asset_header_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_header_tbl

4432: ,p_get_ext_attribs IN VARCHAR2
4433: ,p_ext_attrib_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
4434: ,p_ext_attrib_def_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_tbl --added
4435: ,p_get_asset_assignments IN VARCHAR2
4436: ,p_asset_header_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_header_tbl
4437: ,p_resolve_id_columns IN VARCHAR2
4438: ,p_time_stamp IN DATE
4439: ,x_return_status OUT NOCOPY VARCHAR2
4440: ,x_msg_count OUT NOCOPY NUMBER

Line 4447: l_party_query_rec csi_datastructures_pub.party_query_rec;

4443: IS
4444: l_api_name CONSTANT VARCHAR2(30) := 'GET_ITEM_INSTANCE_DETAILS';
4445: l_api_version CONSTANT NUMBER := 1.0;
4446: l_debug_level NUMBER;
4447: l_party_query_rec csi_datastructures_pub.party_query_rec;
4448: l_account_query_rec csi_datastructures_pub.party_account_query_rec;
4449: l_org_unit_query_rec csi_datastructures_pub.organization_unit_query_rec;
4450: l_pricing_attrib_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
4451: l_extend_attrib_query_rec csi_datastructures_pub.extend_attrib_query_rec;

Line 4448: l_account_query_rec csi_datastructures_pub.party_account_query_rec;

4444: l_api_name CONSTANT VARCHAR2(30) := 'GET_ITEM_INSTANCE_DETAILS';
4445: l_api_version CONSTANT NUMBER := 1.0;
4446: l_debug_level NUMBER;
4447: l_party_query_rec csi_datastructures_pub.party_query_rec;
4448: l_account_query_rec csi_datastructures_pub.party_account_query_rec;
4449: l_org_unit_query_rec csi_datastructures_pub.organization_unit_query_rec;
4450: l_pricing_attrib_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
4451: l_extend_attrib_query_rec csi_datastructures_pub.extend_attrib_query_rec;
4452: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;

Line 4449: l_org_unit_query_rec csi_datastructures_pub.organization_unit_query_rec;

4445: l_api_version CONSTANT NUMBER := 1.0;
4446: l_debug_level NUMBER;
4447: l_party_query_rec csi_datastructures_pub.party_query_rec;
4448: l_account_query_rec csi_datastructures_pub.party_account_query_rec;
4449: l_org_unit_query_rec csi_datastructures_pub.organization_unit_query_rec;
4450: l_pricing_attrib_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
4451: l_extend_attrib_query_rec csi_datastructures_pub.extend_attrib_query_rec;
4452: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
4453: l_version_label_query_rec csi_datastructures_pub.version_label_query_rec;

Line 4450: l_pricing_attrib_query_rec csi_datastructures_pub.pricing_attribs_query_rec;

4446: l_debug_level NUMBER;
4447: l_party_query_rec csi_datastructures_pub.party_query_rec;
4448: l_account_query_rec csi_datastructures_pub.party_account_query_rec;
4449: l_org_unit_query_rec csi_datastructures_pub.organization_unit_query_rec;
4450: l_pricing_attrib_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
4451: l_extend_attrib_query_rec csi_datastructures_pub.extend_attrib_query_rec;
4452: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
4453: l_version_label_query_rec csi_datastructures_pub.version_label_query_rec;
4454: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;

Line 4451: l_extend_attrib_query_rec csi_datastructures_pub.extend_attrib_query_rec;

4447: l_party_query_rec csi_datastructures_pub.party_query_rec;
4448: l_account_query_rec csi_datastructures_pub.party_account_query_rec;
4449: l_org_unit_query_rec csi_datastructures_pub.organization_unit_query_rec;
4450: l_pricing_attrib_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
4451: l_extend_attrib_query_rec csi_datastructures_pub.extend_attrib_query_rec;
4452: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
4453: l_version_label_query_rec csi_datastructures_pub.version_label_query_rec;
4454: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
4455: l_acct_header_row NUMBER;

Line 4452: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;

4448: l_account_query_rec csi_datastructures_pub.party_account_query_rec;
4449: l_org_unit_query_rec csi_datastructures_pub.organization_unit_query_rec;
4450: l_pricing_attrib_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
4451: l_extend_attrib_query_rec csi_datastructures_pub.extend_attrib_query_rec;
4452: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
4453: l_version_label_query_rec csi_datastructures_pub.version_label_query_rec;
4454: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
4455: l_acct_header_row NUMBER;
4456: l_flag VARCHAR2(1) :='N';

Line 4453: l_version_label_query_rec csi_datastructures_pub.version_label_query_rec;

4449: l_org_unit_query_rec csi_datastructures_pub.organization_unit_query_rec;
4450: l_pricing_attrib_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
4451: l_extend_attrib_query_rec csi_datastructures_pub.extend_attrib_query_rec;
4452: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
4453: l_version_label_query_rec csi_datastructures_pub.version_label_query_rec;
4454: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
4455: l_acct_header_row NUMBER;
4456: l_flag VARCHAR2(1) :='N';
4457: l_msg_data VARCHAR2(100);

Line 4454: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;

4450: l_pricing_attrib_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
4451: l_extend_attrib_query_rec csi_datastructures_pub.extend_attrib_query_rec;
4452: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
4453: l_version_label_query_rec csi_datastructures_pub.version_label_query_rec;
4454: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
4455: l_acct_header_row NUMBER;
4456: l_flag VARCHAR2(1) :='N';
4457: l_msg_data VARCHAR2(100);
4458: l_msg_count NUMBER;

Line 4462: l_instance_rec csi_datastructures_pub.instance_header_rec;

4458: l_msg_count NUMBER;
4459: l_msg_index NUMBER;
4460: l_cur_get_instance_rel NUMBER;
4461: l_where_clause VARCHAR2(20000) := '';
4462: l_instance_rec csi_datastructures_pub.instance_header_rec;
4463: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;
4464: l_rows_processed NUMBER;
4465: l_count NUMBER := 0;
4466: l_instance_query_rec csi_datastructures_pub.instance_query_rec;

Line 4463: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;

4459: l_msg_index NUMBER;
4460: l_cur_get_instance_rel NUMBER;
4461: l_where_clause VARCHAR2(20000) := '';
4462: l_instance_rec csi_datastructures_pub.instance_header_rec;
4463: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;
4464: l_rows_processed NUMBER;
4465: l_count NUMBER := 0;
4466: l_instance_query_rec csi_datastructures_pub.instance_query_rec;
4467: --Modified the select for R12 build to resolve column sequencing issue in table--

Line 4466: l_instance_query_rec csi_datastructures_pub.instance_query_rec;

4462: l_instance_rec csi_datastructures_pub.instance_header_rec;
4463: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;
4464: l_rows_processed NUMBER;
4465: l_count NUMBER := 0;
4466: l_instance_query_rec csi_datastructures_pub.instance_query_rec;
4467: --Modified the select for R12 build to resolve column sequencing issue in table--
4468: l_select_stmt VARCHAR2(20000) := ' select instance_id,instance_number, external_reference, '||
4469: 'inventory_item_id,inventory_revision,inv_master_organization_id,serial_number, '||
4470: 'mfg_serial_number_flag,lot_number,quantity,unit_of_measure,accounting_class_code, '||

Line 4931: ,p_version_label_query_rec IN csi_datastructures_pub.version_label_query_rec

4927: ( p_api_version IN NUMBER
4928: ,p_commit IN VARCHAR2
4929: ,p_init_msg_list IN VARCHAR2
4930: ,p_validation_level IN NUMBER
4931: ,p_version_label_query_rec IN csi_datastructures_pub.version_label_query_rec
4932: ,p_time_stamp IN DATE
4933: ,x_version_label_tbl OUT NOCOPY csi_datastructures_pub.version_label_tbl
4934: ,x_return_status OUT NOCOPY VARCHAR2
4935: ,x_msg_count OUT NOCOPY NUMBER

Line 4933: ,x_version_label_tbl OUT NOCOPY csi_datastructures_pub.version_label_tbl

4929: ,p_init_msg_list IN VARCHAR2
4930: ,p_validation_level IN NUMBER
4931: ,p_version_label_query_rec IN csi_datastructures_pub.version_label_query_rec
4932: ,p_time_stamp IN DATE
4933: ,x_version_label_tbl OUT NOCOPY csi_datastructures_pub.version_label_tbl
4934: ,x_return_status OUT NOCOPY VARCHAR2
4935: ,x_msg_count OUT NOCOPY NUMBER
4936: ,x_msg_data OUT NOCOPY VARCHAR2
4937: )IS

Line 4943: l_version_label_tbl csi_datastructures_pub.version_label_tbl;

4939: l_api_name CONSTANT VARCHAR2(30) := 'GET_VERSION_LABEL';
4940: l_api_version CONSTANT NUMBER := 1.0;
4941: l_debug_level NUMBER;
4942: l_version_label_id NUMBER;
4943: l_version_label_tbl csi_datastructures_pub.version_label_tbl;
4944: l_line_count NUMBER;
4945: l_msg_index NUMBER;
4946: l_count NUMBER := 0;
4947: l_where_clause VARCHAR2(2000) ;

Line 4951: l_version_label_rec csi_datastructures_pub.version_label_rec;

4947: l_where_clause VARCHAR2(2000) ;
4948: l_get_ver_cursor_id NUMBER ;
4949: l_flag VARCHAR2(1) :='N';
4950: l_rows_processed NUMBER ;
4951: l_version_label_rec csi_datastructures_pub.version_label_rec;
4952: l_select_stmt VARCHAR2(20000) := ' SELECT * FROM CSI_I_VERSION_LABELS ';
4953:
4954: BEGIN
4955: -- Standard Start of API savepoint

Line 5123: ,p_version_label_tbl IN OUT NOCOPY csi_datastructures_pub.version_label_tbl

5119: ( p_api_version IN NUMBER
5120: ,p_commit IN VARCHAR2
5121: ,p_init_msg_list IN VARCHAR2
5122: ,p_validation_level IN NUMBER
5123: ,p_version_label_tbl IN OUT NOCOPY csi_datastructures_pub.version_label_tbl
5124: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
5125: ,x_return_status OUT NOCOPY VARCHAR2
5126: ,x_msg_count OUT NOCOPY NUMBER
5127: ,x_msg_data OUT NOCOPY VARCHAR2

Line 5124: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

5120: ,p_commit IN VARCHAR2
5121: ,p_init_msg_list IN VARCHAR2
5122: ,p_validation_level IN NUMBER
5123: ,p_version_label_tbl IN OUT NOCOPY csi_datastructures_pub.version_label_tbl
5124: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
5125: ,x_return_status OUT NOCOPY VARCHAR2
5126: ,x_msg_count OUT NOCOPY NUMBER
5127: ,x_msg_data OUT NOCOPY VARCHAR2
5128: ) IS

Line 5133: l_version_label_rec csi_datastructures_pub.version_label_rec;

5129: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_VERSION_LABEL';
5130: l_api_version CONSTANT NUMBER := 1.0 ;
5131: l_debug_level NUMBER ;
5132: l_line_count NUMBER ;
5133: l_version_label_rec csi_datastructures_pub.version_label_rec;
5134: l_msg_index NUMBER ;
5135: l_flag VARCHAR2(1) :='N' ;
5136: l_msg_count NUMBER;
5137: BEGIN

Line 5291: ,p_version_label_tbl IN csi_datastructures_pub.version_label_tbl

5287: ( p_api_version IN NUMBER
5288: ,p_commit IN VARCHAR2
5289: ,p_init_msg_list IN VARCHAR2
5290: ,p_validation_level IN NUMBER
5291: ,p_version_label_tbl IN csi_datastructures_pub.version_label_tbl
5292: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
5293: ,x_return_status OUT NOCOPY VARCHAR2
5294: ,x_msg_count OUT NOCOPY NUMBER
5295: ,x_msg_data OUT NOCOPY VARCHAR2

Line 5292: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

5288: ,p_commit IN VARCHAR2
5289: ,p_init_msg_list IN VARCHAR2
5290: ,p_validation_level IN NUMBER
5291: ,p_version_label_tbl IN csi_datastructures_pub.version_label_tbl
5292: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
5293: ,x_return_status OUT NOCOPY VARCHAR2
5294: ,x_msg_count OUT NOCOPY NUMBER
5295: ,x_msg_data OUT NOCOPY VARCHAR2
5296: ) IS

Line 5301: l_version_label_rec csi_datastructures_pub.version_label_rec;

5297:
5298: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_VERSION_LABEL';
5299: l_api_version CONSTANT NUMBER := 1.0;
5300: l_debug_level NUMBER;
5301: l_version_label_rec csi_datastructures_pub.version_label_rec;
5302: l_msg_index NUMBER;
5303: l_line_count NUMBER ;
5304: l_flag VARCHAR2(1) :='N';
5305: l_msg_count NUMBER;

Line 5459: ,p_version_label_tbl IN csi_datastructures_pub.version_label_tbl

5455: ( p_api_version IN NUMBER
5456: ,p_commit IN VARCHAR2
5457: ,p_init_msg_list IN VARCHAR2
5458: ,p_validation_level IN NUMBER
5459: ,p_version_label_tbl IN csi_datastructures_pub.version_label_tbl
5460: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
5461: ,x_return_status OUT NOCOPY VARCHAR2
5462: ,x_msg_count OUT NOCOPY NUMBER
5463: ,x_msg_data OUT NOCOPY VARCHAR2

Line 5460: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

5456: ,p_commit IN VARCHAR2
5457: ,p_init_msg_list IN VARCHAR2
5458: ,p_validation_level IN NUMBER
5459: ,p_version_label_tbl IN csi_datastructures_pub.version_label_tbl
5460: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
5461: ,x_return_status OUT NOCOPY VARCHAR2
5462: ,x_msg_count OUT NOCOPY NUMBER
5463: ,x_msg_data OUT NOCOPY VARCHAR2
5464: ) IS

Line 5468: l_version_label_rec csi_datastructures_pub.version_label_rec;

5464: ) IS
5465: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_VERSION_LABEL';
5466: l_api_version CONSTANT NUMBER := 1.0;
5467: l_debug_level NUMBER;
5468: l_version_label_rec csi_datastructures_pub.version_label_rec;
5469: l_msg_index NUMBER;
5470: l_line_count NUMBER;
5471: l_version_label_id NUMBER;
5472: l_flag VARCHAR2(1) :='N';

Line 5619: ,p_ext_attribs_query_rec IN csi_datastructures_pub.extend_attrib_query_rec

5615: ( p_api_version IN NUMBER
5616: ,p_commit IN VARCHAR2
5617: ,p_init_msg_list IN VARCHAR2
5618: ,p_validation_level IN NUMBER
5619: ,p_ext_attribs_query_rec IN csi_datastructures_pub.extend_attrib_query_rec
5620: ,p_time_stamp IN DATE
5621: ,x_ext_attrib_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
5622: ,x_ext_attrib_def_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_tbl -- added
5623: ,x_return_status OUT NOCOPY VARCHAR2

Line 5621: ,x_ext_attrib_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl

5617: ,p_init_msg_list IN VARCHAR2
5618: ,p_validation_level IN NUMBER
5619: ,p_ext_attribs_query_rec IN csi_datastructures_pub.extend_attrib_query_rec
5620: ,p_time_stamp IN DATE
5621: ,x_ext_attrib_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
5622: ,x_ext_attrib_def_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_tbl -- added
5623: ,x_return_status OUT NOCOPY VARCHAR2
5624: ,x_msg_count OUT NOCOPY NUMBER
5625: ,x_msg_data OUT NOCOPY VARCHAR2

Line 5622: ,x_ext_attrib_def_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_tbl -- added

5618: ,p_validation_level IN NUMBER
5619: ,p_ext_attribs_query_rec IN csi_datastructures_pub.extend_attrib_query_rec
5620: ,p_time_stamp IN DATE
5621: ,x_ext_attrib_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
5622: ,x_ext_attrib_def_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_tbl -- added
5623: ,x_return_status OUT NOCOPY VARCHAR2
5624: ,x_msg_count OUT NOCOPY NUMBER
5625: ,x_msg_data OUT NOCOPY VARCHAR2
5626: )

Line 5632: l_ext_rec csi_datastructures_pub.extend_attrib_values_rec;

5628: IS
5629: l_api_name CONSTANT VARCHAR2(30) := 'get_extended_attrib_values';
5630: l_api_version CONSTANT NUMBER := 1.0;
5631: l_debug_level NUMBER;
5632: l_ext_rec csi_datastructures_pub.extend_attrib_values_rec;
5633: l_rows_processed NUMBER;
5634: l_where_clause VARCHAR2(2000) := '' ;
5635: l_select_stmt VARCHAR2(20000);
5636: l_cur_get_ext NUMBER;

Line 6053: ,p_ext_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl

6049: ( p_api_version IN NUMBER
6050: ,p_commit IN VARCHAR2
6051: ,p_init_msg_list IN VARCHAR2
6052: ,p_validation_level IN NUMBER
6053: ,p_ext_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
6054: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
6055: ,x_return_status OUT NOCOPY VARCHAR2
6056: ,x_msg_count OUT NOCOPY NUMBER
6057: ,x_msg_data OUT NOCOPY VARCHAR2

Line 6054: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

6050: ,p_commit IN VARCHAR2
6051: ,p_init_msg_list IN VARCHAR2
6052: ,p_validation_level IN NUMBER
6053: ,p_ext_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
6054: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
6055: ,x_return_status OUT NOCOPY VARCHAR2
6056: ,x_msg_count OUT NOCOPY NUMBER
6057: ,x_msg_data OUT NOCOPY VARCHAR2
6058: )

Line 6250: ,p_ext_attrib_tbl IN csi_datastructures_pub.extend_attrib_values_tbl

6246: ( p_api_version IN NUMBER
6247: ,p_commit IN VARCHAR2
6248: ,p_init_msg_list IN VARCHAR2
6249: ,p_validation_level IN NUMBER
6250: ,p_ext_attrib_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
6251: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
6252: ,x_return_status OUT NOCOPY VARCHAR2
6253: ,x_msg_count OUT NOCOPY NUMBER
6254: ,x_msg_data OUT NOCOPY VARCHAR2

Line 6251: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

6247: ,p_commit IN VARCHAR2
6248: ,p_init_msg_list IN VARCHAR2
6249: ,p_validation_level IN NUMBER
6250: ,p_ext_attrib_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
6251: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
6252: ,x_return_status OUT NOCOPY VARCHAR2
6253: ,x_msg_count OUT NOCOPY NUMBER
6254: ,x_msg_data OUT NOCOPY VARCHAR2
6255: )

Line 6442: ,p_ext_attrib_tbl IN csi_datastructures_pub.extend_attrib_values_tbl

6438: ( p_api_version IN NUMBER
6439: ,p_commit IN VARCHAR2
6440: ,p_init_msg_list IN VARCHAR2
6441: ,p_validation_level IN NUMBER
6442: ,p_ext_attrib_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
6443: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
6444: ,x_return_status OUT NOCOPY VARCHAR2
6445: ,x_msg_count OUT NOCOPY NUMBER
6446: ,x_msg_data OUT NOCOPY VARCHAR2

Line 6443: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

6439: ,p_commit IN VARCHAR2
6440: ,p_init_msg_list IN VARCHAR2
6441: ,p_validation_level IN NUMBER
6442: ,p_ext_attrib_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
6443: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
6444: ,x_return_status OUT NOCOPY VARCHAR2
6445: ,x_msg_count OUT NOCOPY NUMBER
6446: ,x_msg_data OUT NOCOPY VARCHAR2
6447: )

Line 6633: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec

6629: p_api_version IN NUMBER
6630: ,p_commit IN VARCHAR2
6631: ,p_init_msg_list IN VARCHAR2
6632: ,p_validation_level IN NUMBER
6633: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
6634: ,p_copy_ext_attribs IN VARCHAR2
6635: ,p_copy_org_assignments IN VARCHAR2
6636: ,p_copy_parties IN VARCHAR2
6637: ,p_copy_party_contacts IN VARCHAR2

Line 6642: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

6638: ,p_copy_accounts IN VARCHAR2
6639: ,p_copy_asset_assignments IN VARCHAR2
6640: ,p_copy_pricing_attribs IN VARCHAR2
6641: ,p_copy_inst_children IN VARCHAR2
6642: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
6643: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
6644: ,x_return_status OUT NOCOPY VARCHAR2
6645: ,x_msg_count OUT NOCOPY NUMBER
6646: ,x_msg_data OUT NOCOPY VARCHAR2

Line 6643: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl

6639: ,p_copy_asset_assignments IN VARCHAR2
6640: ,p_copy_pricing_attribs IN VARCHAR2
6641: ,p_copy_inst_children IN VARCHAR2
6642: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
6643: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
6644: ,x_return_status OUT NOCOPY VARCHAR2
6645: ,x_msg_count OUT NOCOPY NUMBER
6646: ,x_msg_data OUT NOCOPY VARCHAR2
6647: )

Line 6811: ,p_instance_rec IN CSI_DATASTRUCTURES_PUB.INSTANCE_REC

6807: PROCEDURE get_oks_txn_types (
6808: p_api_version IN NUMBER
6809: ,p_commit IN VARCHAR2
6810: ,p_init_msg_list IN VARCHAR2
6811: ,p_instance_rec IN CSI_DATASTRUCTURES_PUB.INSTANCE_REC
6812: ,p_check_contracts_yn IN VARCHAR2
6813: ,p_txn_type IN VARCHAR2
6814: ,x_txn_type_tbl OUT NOCOPY CSI_ITEM_INSTANCE_PUB.TXN_OKS_TYPE_TBL
6815: ,x_configflag OUT NOCOPY VARCHAR2