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 130: l_config_instance_rec csi_datastructures_pub.instance_rec ;

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

Line 131: l_config_temp_rec csi_datastructures_pub.instance_rec ;

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

Line 134: l_instance_id_lst csi_datastructures_pub.id_tbl;

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

Line 135: l_config_ins_rec csi_datastructures_pub.instance_rec;

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

Line 136: l_config_tmp_rec csi_datastructures_pub.instance_rec;

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

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

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

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

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

Line 1216: ,p_instance_rec IN csi_datastructures_pub.instance_rec

1212: p_api_version IN NUMBER
1213: ,p_commit IN VARCHAR2
1214: ,p_init_msg_list IN VARCHAR2
1215: ,p_validation_level IN NUMBER
1216: ,p_instance_rec IN csi_datastructures_pub.instance_rec
1217: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
1218: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
1219: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
1220: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl

Line 1217: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl

1213: ,p_commit IN VARCHAR2
1214: ,p_init_msg_list IN VARCHAR2
1215: ,p_validation_level IN NUMBER
1216: ,p_instance_rec IN csi_datastructures_pub.instance_rec
1217: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
1218: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
1219: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
1220: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
1221: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl

Line 1218: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl

1214: ,p_init_msg_list IN VARCHAR2
1215: ,p_validation_level IN NUMBER
1216: ,p_instance_rec IN csi_datastructures_pub.instance_rec
1217: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
1218: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
1219: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
1220: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
1221: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
1222: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl

Line 1219: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl

1215: ,p_validation_level IN NUMBER
1216: ,p_instance_rec IN csi_datastructures_pub.instance_rec
1217: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
1218: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
1219: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
1220: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
1221: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
1222: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
1223: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

Line 1220: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl

1216: ,p_instance_rec IN csi_datastructures_pub.instance_rec
1217: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
1218: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
1219: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
1220: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
1221: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
1222: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
1223: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
1224: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl

Line 1221: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl

1217: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
1218: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
1219: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
1220: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
1221: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
1222: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
1223: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
1224: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
1225: ,x_return_status OUT NOCOPY VARCHAR2

Line 1222: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl

1218: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
1219: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
1220: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
1221: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
1222: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
1223: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
1224: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
1225: ,x_return_status OUT NOCOPY VARCHAR2
1226: ,x_msg_count OUT NOCOPY NUMBER

Line 1223: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

1219: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
1220: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
1221: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
1222: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
1223: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
1224: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
1225: ,x_return_status OUT NOCOPY VARCHAR2
1226: ,x_msg_count OUT NOCOPY NUMBER
1227: ,x_msg_data OUT NOCOPY VARCHAR2

Line 1224: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl

1220: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
1221: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
1222: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
1223: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
1224: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
1225: ,x_return_status OUT NOCOPY VARCHAR2
1226: ,x_msg_count OUT NOCOPY NUMBER
1227: ,x_msg_data OUT NOCOPY VARCHAR2
1228: )

Line 1234: l_instance_rec csi_datastructures_pub.instance_rec;

1230: IS
1231: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_ITEM_INSTANCE';
1232: l_api_version CONSTANT NUMBER := 1.0;
1233: l_debug_level NUMBER;
1234: l_instance_rec csi_datastructures_pub.instance_rec;
1235: l_temp_instance_rec csi_datastructures_pub.instance_rec;
1236: l_new_instance_rec csi_datastructures_pub.instance_rec := p_instance_rec;
1237: l_config_instance_rec csi_datastructures_pub.instance_rec ;
1238: l_config_temp_rec csi_datastructures_pub.instance_rec ;

Line 1235: l_temp_instance_rec csi_datastructures_pub.instance_rec;

1231: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_ITEM_INSTANCE';
1232: l_api_version CONSTANT NUMBER := 1.0;
1233: l_debug_level NUMBER;
1234: l_instance_rec csi_datastructures_pub.instance_rec;
1235: l_temp_instance_rec csi_datastructures_pub.instance_rec;
1236: l_new_instance_rec csi_datastructures_pub.instance_rec := p_instance_rec;
1237: l_config_instance_rec csi_datastructures_pub.instance_rec ;
1238: l_config_temp_rec csi_datastructures_pub.instance_rec ;
1239: l_party_tbl csi_datastructures_pub.party_tbl;

Line 1236: l_new_instance_rec csi_datastructures_pub.instance_rec := p_instance_rec;

1232: l_api_version CONSTANT NUMBER := 1.0;
1233: l_debug_level NUMBER;
1234: l_instance_rec csi_datastructures_pub.instance_rec;
1235: l_temp_instance_rec csi_datastructures_pub.instance_rec;
1236: l_new_instance_rec csi_datastructures_pub.instance_rec := p_instance_rec;
1237: l_config_instance_rec csi_datastructures_pub.instance_rec ;
1238: l_config_temp_rec csi_datastructures_pub.instance_rec ;
1239: l_party_tbl csi_datastructures_pub.party_tbl;
1240: l_account_tbl csi_datastructures_pub.party_account_tbl;

Line 1237: l_config_instance_rec csi_datastructures_pub.instance_rec ;

1233: l_debug_level NUMBER;
1234: l_instance_rec csi_datastructures_pub.instance_rec;
1235: l_temp_instance_rec csi_datastructures_pub.instance_rec;
1236: l_new_instance_rec csi_datastructures_pub.instance_rec := p_instance_rec;
1237: l_config_instance_rec csi_datastructures_pub.instance_rec ;
1238: l_config_temp_rec csi_datastructures_pub.instance_rec ;
1239: l_party_tbl csi_datastructures_pub.party_tbl;
1240: l_account_tbl csi_datastructures_pub.party_account_tbl;
1241: l_party_row NUMBER := 1;

Line 1238: l_config_temp_rec csi_datastructures_pub.instance_rec ;

1234: l_instance_rec csi_datastructures_pub.instance_rec;
1235: l_temp_instance_rec csi_datastructures_pub.instance_rec;
1236: l_new_instance_rec csi_datastructures_pub.instance_rec := p_instance_rec;
1237: l_config_instance_rec csi_datastructures_pub.instance_rec ;
1238: l_config_temp_rec csi_datastructures_pub.instance_rec ;
1239: l_party_tbl csi_datastructures_pub.party_tbl;
1240: l_account_tbl csi_datastructures_pub.party_account_tbl;
1241: l_party_row NUMBER := 1;
1242: l_acct_row NUMBER := 1;

Line 1239: l_party_tbl csi_datastructures_pub.party_tbl;

1235: l_temp_instance_rec csi_datastructures_pub.instance_rec;
1236: l_new_instance_rec csi_datastructures_pub.instance_rec := p_instance_rec;
1237: l_config_instance_rec csi_datastructures_pub.instance_rec ;
1238: l_config_temp_rec csi_datastructures_pub.instance_rec ;
1239: l_party_tbl csi_datastructures_pub.party_tbl;
1240: l_account_tbl csi_datastructures_pub.party_account_tbl;
1241: l_party_row NUMBER := 1;
1242: l_acct_row NUMBER := 1;
1243: l_msg_count NUMBER;

Line 1240: l_account_tbl csi_datastructures_pub.party_account_tbl;

1236: l_new_instance_rec csi_datastructures_pub.instance_rec := p_instance_rec;
1237: l_config_instance_rec csi_datastructures_pub.instance_rec ;
1238: l_config_temp_rec csi_datastructures_pub.instance_rec ;
1239: l_party_tbl csi_datastructures_pub.party_tbl;
1240: l_account_tbl csi_datastructures_pub.party_account_tbl;
1241: l_party_row NUMBER := 1;
1242: l_acct_row NUMBER := 1;
1243: l_msg_count NUMBER;
1244: l_msg_data VARCHAR2(2000);

Line 1259: l_version_label_rec csi_datastructures_pub.version_label_rec;

1255: l_internal_party_id NUMBER;
1256: l_party_id NUMBER;
1257: l_active_end_date DATE;
1258: l_dummy VARCHAR2(1);
1259: l_version_label_rec csi_datastructures_pub.version_label_rec;
1260: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
1261: l_location_tbl csi_item_instance_pvt.location_tbl;
1262: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
1263: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;

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

1275: l_asset_loc_tbl csi_asset_pvt.asset_loc_tbl;
1276: l_updated BOOLEAN := FALSE;
1277: l_date BOOLEAN := FALSE;
1278: l_curr_party_id NUMBER; -- Added for 2972082
1279: l_cascade_party_tbl csi_datastructures_pub.party_tbl; -- Added for 2972082
1280: l_cascade_account_tbl csi_datastructures_pub.party_account_tbl; -- Added for 2972082
1281: l_found BOOLEAN := FALSE; -- Added for 2972082
1282: -- The following were added for att
1283: l_component_ins_type VARCHAR2(1):=NULL;

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

1276: l_updated BOOLEAN := FALSE;
1277: l_date BOOLEAN := FALSE;
1278: l_curr_party_id NUMBER; -- Added for 2972082
1279: l_cascade_party_tbl csi_datastructures_pub.party_tbl; -- Added for 2972082
1280: l_cascade_account_tbl csi_datastructures_pub.party_account_tbl; -- Added for 2972082
1281: l_found BOOLEAN := FALSE; -- Added for 2972082
1282: -- The following were added for att
1283: l_component_ins_type VARCHAR2(1):=NULL;
1284: l_config_hdr_id NUMBER;

Line 1324: l_t_party_tbl csi_datastructures_pub.party_tbl;

1320:
1321: l_create NUMBER;
1322: l_update NUMBER;
1323: l_p_id NUMBER;
1324: l_t_party_tbl csi_datastructures_pub.party_tbl;
1325: l_t_account_tbl csi_datastructures_pub.party_account_tbl;
1326: l_new_party_tbl csi_datastructures_pub.party_tbl;
1327: l_new_account_tbl csi_datastructures_pub.party_account_tbl;
1328: lb_party_tbl csi_datastructures_pub.party_tbl;

Line 1325: l_t_account_tbl csi_datastructures_pub.party_account_tbl;

1321: l_create NUMBER;
1322: l_update NUMBER;
1323: l_p_id NUMBER;
1324: l_t_party_tbl csi_datastructures_pub.party_tbl;
1325: l_t_account_tbl csi_datastructures_pub.party_account_tbl;
1326: l_new_party_tbl csi_datastructures_pub.party_tbl;
1327: l_new_account_tbl csi_datastructures_pub.party_account_tbl;
1328: lb_party_tbl csi_datastructures_pub.party_tbl;
1329: lc_party_tbl csi_datastructures_pub.party_tbl;

Line 1326: l_new_party_tbl csi_datastructures_pub.party_tbl;

1322: l_update NUMBER;
1323: l_p_id NUMBER;
1324: l_t_party_tbl csi_datastructures_pub.party_tbl;
1325: l_t_account_tbl csi_datastructures_pub.party_account_tbl;
1326: l_new_party_tbl csi_datastructures_pub.party_tbl;
1327: l_new_account_tbl csi_datastructures_pub.party_account_tbl;
1328: lb_party_tbl csi_datastructures_pub.party_tbl;
1329: lc_party_tbl csi_datastructures_pub.party_tbl;
1330: l_temp_party_tbl csi_datastructures_pub.party_tbl;

Line 1327: l_new_account_tbl csi_datastructures_pub.party_account_tbl;

1323: l_p_id NUMBER;
1324: l_t_party_tbl csi_datastructures_pub.party_tbl;
1325: l_t_account_tbl csi_datastructures_pub.party_account_tbl;
1326: l_new_party_tbl csi_datastructures_pub.party_tbl;
1327: l_new_account_tbl csi_datastructures_pub.party_account_tbl;
1328: lb_party_tbl csi_datastructures_pub.party_tbl;
1329: lc_party_tbl csi_datastructures_pub.party_tbl;
1330: l_temp_party_tbl csi_datastructures_pub.party_tbl;
1331: la_account_tbl csi_datastructures_pub.party_account_tbl;

Line 1328: lb_party_tbl csi_datastructures_pub.party_tbl;

1324: l_t_party_tbl csi_datastructures_pub.party_tbl;
1325: l_t_account_tbl csi_datastructures_pub.party_account_tbl;
1326: l_new_party_tbl csi_datastructures_pub.party_tbl;
1327: l_new_account_tbl csi_datastructures_pub.party_account_tbl;
1328: lb_party_tbl csi_datastructures_pub.party_tbl;
1329: lc_party_tbl csi_datastructures_pub.party_tbl;
1330: l_temp_party_tbl csi_datastructures_pub.party_tbl;
1331: la_account_tbl csi_datastructures_pub.party_account_tbl;
1332: l_temp_acct_tbl csi_datastructures_pub.party_account_tbl;

Line 1329: lc_party_tbl csi_datastructures_pub.party_tbl;

1325: l_t_account_tbl csi_datastructures_pub.party_account_tbl;
1326: l_new_party_tbl csi_datastructures_pub.party_tbl;
1327: l_new_account_tbl csi_datastructures_pub.party_account_tbl;
1328: lb_party_tbl csi_datastructures_pub.party_tbl;
1329: lc_party_tbl csi_datastructures_pub.party_tbl;
1330: l_temp_party_tbl csi_datastructures_pub.party_tbl;
1331: la_account_tbl csi_datastructures_pub.party_account_tbl;
1332: l_temp_acct_tbl csi_datastructures_pub.party_account_tbl;
1333:

Line 1330: l_temp_party_tbl csi_datastructures_pub.party_tbl;

1326: l_new_party_tbl csi_datastructures_pub.party_tbl;
1327: l_new_account_tbl csi_datastructures_pub.party_account_tbl;
1328: lb_party_tbl csi_datastructures_pub.party_tbl;
1329: lc_party_tbl csi_datastructures_pub.party_tbl;
1330: l_temp_party_tbl csi_datastructures_pub.party_tbl;
1331: la_account_tbl csi_datastructures_pub.party_account_tbl;
1332: l_temp_acct_tbl csi_datastructures_pub.party_account_tbl;
1333:
1334: -- End of defining variables for bug 2172968

Line 1331: la_account_tbl csi_datastructures_pub.party_account_tbl;

1327: l_new_account_tbl csi_datastructures_pub.party_account_tbl;
1328: lb_party_tbl csi_datastructures_pub.party_tbl;
1329: lc_party_tbl csi_datastructures_pub.party_tbl;
1330: l_temp_party_tbl csi_datastructures_pub.party_tbl;
1331: la_account_tbl csi_datastructures_pub.party_account_tbl;
1332: l_temp_acct_tbl csi_datastructures_pub.party_account_tbl;
1333:
1334: -- End of defining variables for bug 2172968
1335:

Line 1332: l_temp_acct_tbl csi_datastructures_pub.party_account_tbl;

1328: lb_party_tbl csi_datastructures_pub.party_tbl;
1329: lc_party_tbl csi_datastructures_pub.party_tbl;
1330: l_temp_party_tbl csi_datastructures_pub.party_tbl;
1331: la_account_tbl csi_datastructures_pub.party_account_tbl;
1332: l_temp_acct_tbl csi_datastructures_pub.party_account_tbl;
1333:
1334: -- End of defining variables for bug 2172968
1335:
1336: CURSOR config_ins_key (p_config_hdr_id NUMBER, p_config_rev_nbr NUMBER) is

Line 1382: l_tem_acct_tbl csi_datastructures_pub.party_account_tbl;

1378: ,object_version_number
1379: from csi_ip_accounts
1380: where instance_party_id=p_ins_pty_id
1381: and relationship_type_code<>'OWNER';
1382: l_tem_acct_tbl csi_datastructures_pub.party_account_tbl;
1383: l_tem_party_id NUMBER:=NULL;
1384: l_temp_var NUMBER:=1;
1385: l_bacct_row NUMBER;
1386: ------------------------------------------end addition ---

Line 1389: l_instance_id_lst csi_datastructures_pub.id_tbl;

1385: l_bacct_row NUMBER;
1386: ------------------------------------------end addition ---
1387: l_batch_hdr_id NUMBER;
1388: l_batch_rev_nbr NUMBER;
1389: l_instance_id_lst csi_datastructures_pub.id_tbl;
1390: l_config_ins_rec csi_datastructures_pub.instance_rec;
1391: l_config_tmp_rec csi_datastructures_pub.instance_rec;
1392: l_lock_status NUMBER;
1393: --

Line 1390: l_config_ins_rec csi_datastructures_pub.instance_rec;

1386: ------------------------------------------end addition ---
1387: l_batch_hdr_id NUMBER;
1388: l_batch_rev_nbr NUMBER;
1389: l_instance_id_lst csi_datastructures_pub.id_tbl;
1390: l_config_ins_rec csi_datastructures_pub.instance_rec;
1391: l_config_tmp_rec csi_datastructures_pub.instance_rec;
1392: l_lock_status NUMBER;
1393: --
1394: px_oks_txn_inst_tbl OKS_IBINT_PUB.TXN_INSTANCE_TBL;

Line 1391: l_config_tmp_rec csi_datastructures_pub.instance_rec;

1387: l_batch_hdr_id NUMBER;
1388: l_batch_rev_nbr NUMBER;
1389: l_instance_id_lst csi_datastructures_pub.id_tbl;
1390: l_config_ins_rec csi_datastructures_pub.instance_rec;
1391: l_config_tmp_rec csi_datastructures_pub.instance_rec;
1392: l_lock_status NUMBER;
1393: --
1394: px_oks_txn_inst_tbl OKS_IBINT_PUB.TXN_INSTANCE_TBL;
1395: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;

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

1470: l_flag:=CSI_GEN_UTILITY_PVT.enable_trace(l_trace_flag => l_flag);
1471: -- End enable trace
1472: ****/
1473: -- Start API body
1474: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
1475: csi_gen_utility_pvt.populate_install_param_rec;
1476: END IF;
1477: --
1478: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;

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

1474: IF csi_datastructures_pub.g_install_param_rec.fetch_flag IS NULL THEN
1475: csi_gen_utility_pvt.populate_install_param_rec;
1476: END IF;
1477: --
1478: l_internal_party_id := csi_datastructures_pub.g_install_param_rec.internal_party_id;
1479: --
1480: IF l_internal_party_id IS NULL THEN
1481: FND_MESSAGE.SET_NAME('CSI','CSI_API_UNINSTALLED_PARAMETER');
1482: FND_MSG_PUB.ADD;

Line 3458: ,p_instance_rec IN csi_datastructures_pub.instance_rec

3454: p_api_version IN NUMBER
3455: ,p_commit IN VARCHAR2
3456: ,p_init_msg_list IN VARCHAR2
3457: ,p_validation_level IN NUMBER
3458: ,p_instance_rec IN csi_datastructures_pub.instance_rec
3459: ,p_expire_children IN VARCHAR2
3460: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
3461: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
3462: ,x_return_status OUT NOCOPY VARCHAR2

Line 3460: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

3456: ,p_init_msg_list IN VARCHAR2
3457: ,p_validation_level IN NUMBER
3458: ,p_instance_rec IN csi_datastructures_pub.instance_rec
3459: ,p_expire_children IN VARCHAR2
3460: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
3461: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
3462: ,x_return_status OUT NOCOPY VARCHAR2
3463: ,x_msg_count OUT NOCOPY NUMBER
3464: ,x_msg_data OUT NOCOPY VARCHAR2

Line 3461: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl

3457: ,p_validation_level IN NUMBER
3458: ,p_instance_rec IN csi_datastructures_pub.instance_rec
3459: ,p_expire_children IN VARCHAR2
3460: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
3461: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
3462: ,x_return_status OUT NOCOPY VARCHAR2
3463: ,x_msg_count OUT NOCOPY NUMBER
3464: ,x_msg_data OUT NOCOPY VARCHAR2
3465: )

Line 3521: l_config_instance_rec csi_datastructures_pub.instance_rec ;

3517: FROM csi_item_instances
3518: WHERE config_inst_hdr_id=p_config_inst_hdr_id
3519: AND config_inst_item_id=p_config_inst_item_id;
3520:
3521: l_config_instance_rec csi_datastructures_pub.instance_rec ;
3522: l_config_temp_rec csi_datastructures_pub.instance_rec ;
3523: l_batch_hdr_id NUMBER;
3524: l_batch_rev_nbr NUMBER;
3525: l_instance_id_lst csi_datastructures_pub.id_tbl;

Line 3522: l_config_temp_rec csi_datastructures_pub.instance_rec ;

3518: WHERE config_inst_hdr_id=p_config_inst_hdr_id
3519: AND config_inst_item_id=p_config_inst_item_id;
3520:
3521: l_config_instance_rec csi_datastructures_pub.instance_rec ;
3522: l_config_temp_rec csi_datastructures_pub.instance_rec ;
3523: l_batch_hdr_id NUMBER;
3524: l_batch_rev_nbr NUMBER;
3525: l_instance_id_lst csi_datastructures_pub.id_tbl;
3526: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;

Line 3525: l_instance_id_lst csi_datastructures_pub.id_tbl;

3521: l_config_instance_rec csi_datastructures_pub.instance_rec ;
3522: l_config_temp_rec csi_datastructures_pub.instance_rec ;
3523: l_batch_hdr_id NUMBER;
3524: l_batch_rev_nbr NUMBER;
3525: l_instance_id_lst csi_datastructures_pub.id_tbl;
3526: l_item_attribute_tbl csi_item_instance_pvt.item_attribute_tbl;
3527: l_location_tbl csi_item_instance_pvt.location_tbl;
3528: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
3529: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;

Line 3531: l_config_ins_rec csi_datastructures_pub.instance_rec;

3527: l_location_tbl csi_item_instance_pvt.location_tbl;
3528: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
3529: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
3530: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
3531: l_config_ins_rec csi_datastructures_pub.instance_rec;
3532: l_config_tmp_rec csi_datastructures_pub.instance_rec;
3533: --
3534: px_oks_txn_inst_tbl OKS_IBINT_PUB.TXN_INSTANCE_TBL;
3535: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;

Line 3532: l_config_tmp_rec csi_datastructures_pub.instance_rec;

3528: l_generic_id_tbl csi_item_instance_pvt.generic_id_tbl;
3529: l_lookup_tbl csi_item_instance_pvt.lookup_tbl;
3530: l_ins_count_rec csi_item_instance_pvt.ins_count_rec;
3531: l_config_ins_rec csi_datastructures_pub.instance_rec;
3532: l_config_tmp_rec csi_datastructures_pub.instance_rec;
3533: --
3534: px_oks_txn_inst_tbl OKS_IBINT_PUB.TXN_INSTANCE_TBL;
3535: px_child_inst_tbl csi_item_instance_grp.child_inst_tbl;
3536: l_batch_type VARCHAR2(50);

Line 4086: ,p_instance_query_rec IN csi_datastructures_pub.instance_query_rec

4082: p_api_version IN NUMBER
4083: ,p_commit IN VARCHAR2
4084: ,p_init_msg_list IN VARCHAR2
4085: ,p_validation_level IN NUMBER
4086: ,p_instance_query_rec IN csi_datastructures_pub.instance_query_rec
4087: ,p_party_query_rec IN csi_datastructures_pub.party_query_rec
4088: ,p_account_query_rec IN csi_datastructures_pub.party_account_query_rec
4089: ,p_transaction_id IN NUMBER
4090: ,p_resolve_id_columns IN VARCHAR2

Line 4087: ,p_party_query_rec IN csi_datastructures_pub.party_query_rec

4083: ,p_commit IN VARCHAR2
4084: ,p_init_msg_list IN VARCHAR2
4085: ,p_validation_level IN NUMBER
4086: ,p_instance_query_rec IN csi_datastructures_pub.instance_query_rec
4087: ,p_party_query_rec IN csi_datastructures_pub.party_query_rec
4088: ,p_account_query_rec IN csi_datastructures_pub.party_account_query_rec
4089: ,p_transaction_id IN NUMBER
4090: ,p_resolve_id_columns IN VARCHAR2
4091: ,p_active_instance_only IN VARCHAR2

Line 4088: ,p_account_query_rec IN csi_datastructures_pub.party_account_query_rec

4084: ,p_init_msg_list IN VARCHAR2
4085: ,p_validation_level IN NUMBER
4086: ,p_instance_query_rec IN csi_datastructures_pub.instance_query_rec
4087: ,p_party_query_rec IN csi_datastructures_pub.party_query_rec
4088: ,p_account_query_rec IN csi_datastructures_pub.party_account_query_rec
4089: ,p_transaction_id IN NUMBER
4090: ,p_resolve_id_columns IN VARCHAR2
4091: ,p_active_instance_only IN VARCHAR2
4092: ,x_instance_header_tbl OUT NOCOPY csi_datastructures_pub.instance_header_tbl

Line 4092: ,x_instance_header_tbl OUT NOCOPY csi_datastructures_pub.instance_header_tbl

4088: ,p_account_query_rec IN csi_datastructures_pub.party_account_query_rec
4089: ,p_transaction_id IN NUMBER
4090: ,p_resolve_id_columns IN VARCHAR2
4091: ,p_active_instance_only IN VARCHAR2
4092: ,x_instance_header_tbl OUT NOCOPY csi_datastructures_pub.instance_header_tbl
4093: ,x_return_status OUT NOCOPY VARCHAR2
4094: ,x_msg_count OUT NOCOPY NUMBER
4095: ,x_msg_data OUT NOCOPY VARCHAR2
4096: )IS

Line 4101: l_instance_rec csi_datastructures_pub.instance_rec;

4097:
4098: l_api_name CONSTANT VARCHAR2(30) := 'GET_ITEM_INSTANCES';
4099: l_api_version CONSTANT NUMBER := 1.0;
4100: l_debug_level NUMBER;
4101: l_instance_rec csi_datastructures_pub.instance_rec;
4102: l_descriptions_rec csi_datastructures_pub.instance_rec;
4103: l_txn_rec csi_datastructures_pub.transaction_rec;
4104: l_flag VARCHAR2(1) :='N';
4105: l_error_code VARCHAR2(10);

Line 4102: l_descriptions_rec csi_datastructures_pub.instance_rec;

4098: l_api_name CONSTANT VARCHAR2(30) := 'GET_ITEM_INSTANCES';
4099: l_api_version CONSTANT NUMBER := 1.0;
4100: l_debug_level NUMBER;
4101: l_instance_rec csi_datastructures_pub.instance_rec;
4102: l_descriptions_rec csi_datastructures_pub.instance_rec;
4103: l_txn_rec csi_datastructures_pub.transaction_rec;
4104: l_flag VARCHAR2(1) :='N';
4105: l_error_code VARCHAR2(10);
4106: l_return_status NUMBER;

Line 4103: l_txn_rec csi_datastructures_pub.transaction_rec;

4099: l_api_version CONSTANT NUMBER := 1.0;
4100: l_debug_level NUMBER;
4101: l_instance_rec csi_datastructures_pub.instance_rec;
4102: l_descriptions_rec csi_datastructures_pub.instance_rec;
4103: l_txn_rec csi_datastructures_pub.transaction_rec;
4104: l_flag VARCHAR2(1) :='N';
4105: l_error_code VARCHAR2(10);
4106: l_return_status NUMBER;
4107: l_msg_count NUMBER;

Line 4113: l_instance_header_rec csi_datastructures_pub.instance_header_rec;

4109: l_msg_index NUMBER;
4110: l_line_count NUMBER;
4111: l_cur_get_inst_rel NUMBER;
4112: l_where_clause VARCHAR2(20000) := '';
4113: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
4114: l_party_rec csi_datastructures_pub.party_rec;
4115: l_party_account_rec csi_datastructures_pub.party_account_rec;
4116: l_instance_id_list VARCHAR2(2000):= '';
4117: l_instance_id NUMBER;

Line 4114: l_party_rec csi_datastructures_pub.party_rec;

4110: l_line_count NUMBER;
4111: l_cur_get_inst_rel NUMBER;
4112: l_where_clause VARCHAR2(20000) := '';
4113: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
4114: l_party_rec csi_datastructures_pub.party_rec;
4115: l_party_account_rec csi_datastructures_pub.party_account_rec;
4116: l_instance_id_list VARCHAR2(2000):= '';
4117: l_instance_id NUMBER;
4118: l_rows_processed NUMBER;

Line 4115: l_party_account_rec csi_datastructures_pub.party_account_rec;

4111: l_cur_get_inst_rel NUMBER;
4112: l_where_clause VARCHAR2(20000) := '';
4113: l_instance_header_rec csi_datastructures_pub.instance_header_rec;
4114: l_party_rec csi_datastructures_pub.party_rec;
4115: l_party_account_rec csi_datastructures_pub.party_account_rec;
4116: l_instance_id_list VARCHAR2(2000):= '';
4117: l_instance_id NUMBER;
4118: l_rows_processed NUMBER;
4119: l_count NUMBER := 0;

Line 4377: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_header_rec

4373: p_api_version IN NUMBER
4374: ,p_commit IN VARCHAR2
4375: ,p_init_msg_list IN VARCHAR2
4376: ,p_validation_level IN NUMBER
4377: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_header_rec
4378: ,p_get_parties IN VARCHAR2
4379: ,p_party_header_tbl OUT NOCOPY csi_datastructures_pub.party_header_tbl
4380: ,p_get_accounts IN VARCHAR2
4381: ,p_account_header_tbl OUT NOCOPY csi_datastructures_pub.party_account_header_tbl

Line 4379: ,p_party_header_tbl OUT NOCOPY csi_datastructures_pub.party_header_tbl

4375: ,p_init_msg_list IN VARCHAR2
4376: ,p_validation_level IN NUMBER
4377: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_header_rec
4378: ,p_get_parties IN VARCHAR2
4379: ,p_party_header_tbl OUT NOCOPY csi_datastructures_pub.party_header_tbl
4380: ,p_get_accounts IN VARCHAR2
4381: ,p_account_header_tbl OUT NOCOPY csi_datastructures_pub.party_account_header_tbl
4382: ,p_get_org_assignments IN VARCHAR2
4383: ,p_org_header_tbl OUT NOCOPY csi_datastructures_pub.org_units_header_tbl

Line 4381: ,p_account_header_tbl OUT NOCOPY csi_datastructures_pub.party_account_header_tbl

4377: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_header_rec
4378: ,p_get_parties IN VARCHAR2
4379: ,p_party_header_tbl OUT NOCOPY csi_datastructures_pub.party_header_tbl
4380: ,p_get_accounts IN VARCHAR2
4381: ,p_account_header_tbl OUT NOCOPY csi_datastructures_pub.party_account_header_tbl
4382: ,p_get_org_assignments IN VARCHAR2
4383: ,p_org_header_tbl OUT NOCOPY csi_datastructures_pub.org_units_header_tbl
4384: ,p_get_pricing_attribs IN VARCHAR2
4385: ,p_pricing_attrib_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl

Line 4383: ,p_org_header_tbl OUT NOCOPY csi_datastructures_pub.org_units_header_tbl

4379: ,p_party_header_tbl OUT NOCOPY csi_datastructures_pub.party_header_tbl
4380: ,p_get_accounts IN VARCHAR2
4381: ,p_account_header_tbl OUT NOCOPY csi_datastructures_pub.party_account_header_tbl
4382: ,p_get_org_assignments IN VARCHAR2
4383: ,p_org_header_tbl OUT NOCOPY csi_datastructures_pub.org_units_header_tbl
4384: ,p_get_pricing_attribs IN VARCHAR2
4385: ,p_pricing_attrib_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
4386: ,p_get_ext_attribs IN VARCHAR2
4387: ,p_ext_attrib_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl

Line 4385: ,p_pricing_attrib_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl

4381: ,p_account_header_tbl OUT NOCOPY csi_datastructures_pub.party_account_header_tbl
4382: ,p_get_org_assignments IN VARCHAR2
4383: ,p_org_header_tbl OUT NOCOPY csi_datastructures_pub.org_units_header_tbl
4384: ,p_get_pricing_attribs IN VARCHAR2
4385: ,p_pricing_attrib_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
4386: ,p_get_ext_attribs IN VARCHAR2
4387: ,p_ext_attrib_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
4388: ,p_ext_attrib_def_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_tbl --added
4389: ,p_get_asset_assignments IN VARCHAR2

Line 4387: ,p_ext_attrib_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl

4383: ,p_org_header_tbl OUT NOCOPY csi_datastructures_pub.org_units_header_tbl
4384: ,p_get_pricing_attribs IN VARCHAR2
4385: ,p_pricing_attrib_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
4386: ,p_get_ext_attribs IN VARCHAR2
4387: ,p_ext_attrib_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
4388: ,p_ext_attrib_def_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_tbl --added
4389: ,p_get_asset_assignments IN VARCHAR2
4390: ,p_asset_header_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_header_tbl
4391: ,p_resolve_id_columns IN VARCHAR2

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

4384: ,p_get_pricing_attribs IN VARCHAR2
4385: ,p_pricing_attrib_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
4386: ,p_get_ext_attribs IN VARCHAR2
4387: ,p_ext_attrib_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
4388: ,p_ext_attrib_def_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_tbl --added
4389: ,p_get_asset_assignments IN VARCHAR2
4390: ,p_asset_header_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_header_tbl
4391: ,p_resolve_id_columns IN VARCHAR2
4392: ,p_time_stamp IN DATE

Line 4390: ,p_asset_header_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_header_tbl

4386: ,p_get_ext_attribs IN VARCHAR2
4387: ,p_ext_attrib_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
4388: ,p_ext_attrib_def_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_tbl --added
4389: ,p_get_asset_assignments IN VARCHAR2
4390: ,p_asset_header_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_header_tbl
4391: ,p_resolve_id_columns IN VARCHAR2
4392: ,p_time_stamp IN DATE
4393: ,x_return_status OUT NOCOPY VARCHAR2
4394: ,x_msg_count OUT NOCOPY NUMBER

Line 4401: l_party_query_rec csi_datastructures_pub.party_query_rec;

4397: IS
4398: l_api_name CONSTANT VARCHAR2(30) := 'GET_ITEM_INSTANCE_DETAILS';
4399: l_api_version CONSTANT NUMBER := 1.0;
4400: l_debug_level NUMBER;
4401: l_party_query_rec csi_datastructures_pub.party_query_rec;
4402: l_account_query_rec csi_datastructures_pub.party_account_query_rec;
4403: l_org_unit_query_rec csi_datastructures_pub.organization_unit_query_rec;
4404: l_pricing_attrib_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
4405: l_extend_attrib_query_rec csi_datastructures_pub.extend_attrib_query_rec;

Line 4402: l_account_query_rec csi_datastructures_pub.party_account_query_rec;

4398: l_api_name CONSTANT VARCHAR2(30) := 'GET_ITEM_INSTANCE_DETAILS';
4399: l_api_version CONSTANT NUMBER := 1.0;
4400: l_debug_level NUMBER;
4401: l_party_query_rec csi_datastructures_pub.party_query_rec;
4402: l_account_query_rec csi_datastructures_pub.party_account_query_rec;
4403: l_org_unit_query_rec csi_datastructures_pub.organization_unit_query_rec;
4404: l_pricing_attrib_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
4405: l_extend_attrib_query_rec csi_datastructures_pub.extend_attrib_query_rec;
4406: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;

Line 4403: l_org_unit_query_rec csi_datastructures_pub.organization_unit_query_rec;

4399: l_api_version CONSTANT NUMBER := 1.0;
4400: l_debug_level NUMBER;
4401: l_party_query_rec csi_datastructures_pub.party_query_rec;
4402: l_account_query_rec csi_datastructures_pub.party_account_query_rec;
4403: l_org_unit_query_rec csi_datastructures_pub.organization_unit_query_rec;
4404: l_pricing_attrib_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
4405: l_extend_attrib_query_rec csi_datastructures_pub.extend_attrib_query_rec;
4406: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
4407: l_version_label_query_rec csi_datastructures_pub.version_label_query_rec;

Line 4404: l_pricing_attrib_query_rec csi_datastructures_pub.pricing_attribs_query_rec;

4400: l_debug_level NUMBER;
4401: l_party_query_rec csi_datastructures_pub.party_query_rec;
4402: l_account_query_rec csi_datastructures_pub.party_account_query_rec;
4403: l_org_unit_query_rec csi_datastructures_pub.organization_unit_query_rec;
4404: l_pricing_attrib_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
4405: l_extend_attrib_query_rec csi_datastructures_pub.extend_attrib_query_rec;
4406: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
4407: l_version_label_query_rec csi_datastructures_pub.version_label_query_rec;
4408: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;

Line 4405: l_extend_attrib_query_rec csi_datastructures_pub.extend_attrib_query_rec;

4401: l_party_query_rec csi_datastructures_pub.party_query_rec;
4402: l_account_query_rec csi_datastructures_pub.party_account_query_rec;
4403: l_org_unit_query_rec csi_datastructures_pub.organization_unit_query_rec;
4404: l_pricing_attrib_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
4405: l_extend_attrib_query_rec csi_datastructures_pub.extend_attrib_query_rec;
4406: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
4407: l_version_label_query_rec csi_datastructures_pub.version_label_query_rec;
4408: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
4409: l_acct_header_row NUMBER;

Line 4406: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;

4402: l_account_query_rec csi_datastructures_pub.party_account_query_rec;
4403: l_org_unit_query_rec csi_datastructures_pub.organization_unit_query_rec;
4404: l_pricing_attrib_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
4405: l_extend_attrib_query_rec csi_datastructures_pub.extend_attrib_query_rec;
4406: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
4407: l_version_label_query_rec csi_datastructures_pub.version_label_query_rec;
4408: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
4409: l_acct_header_row NUMBER;
4410: l_flag VARCHAR2(1) :='N';

Line 4407: l_version_label_query_rec csi_datastructures_pub.version_label_query_rec;

4403: l_org_unit_query_rec csi_datastructures_pub.organization_unit_query_rec;
4404: l_pricing_attrib_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
4405: l_extend_attrib_query_rec csi_datastructures_pub.extend_attrib_query_rec;
4406: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
4407: l_version_label_query_rec csi_datastructures_pub.version_label_query_rec;
4408: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
4409: l_acct_header_row NUMBER;
4410: l_flag VARCHAR2(1) :='N';
4411: l_msg_data VARCHAR2(100);

Line 4408: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;

4404: l_pricing_attrib_query_rec csi_datastructures_pub.pricing_attribs_query_rec;
4405: l_extend_attrib_query_rec csi_datastructures_pub.extend_attrib_query_rec;
4406: l_instance_asset_query_rec csi_datastructures_pub.instance_asset_query_rec;
4407: l_version_label_query_rec csi_datastructures_pub.version_label_query_rec;
4408: l_account_header_tbl csi_datastructures_pub.party_account_header_tbl;
4409: l_acct_header_row NUMBER;
4410: l_flag VARCHAR2(1) :='N';
4411: l_msg_data VARCHAR2(100);
4412: l_msg_count NUMBER;

Line 4416: l_instance_rec csi_datastructures_pub.instance_header_rec;

4412: l_msg_count NUMBER;
4413: l_msg_index NUMBER;
4414: l_cur_get_instance_rel NUMBER;
4415: l_where_clause VARCHAR2(20000) := '';
4416: l_instance_rec csi_datastructures_pub.instance_header_rec;
4417: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;
4418: l_rows_processed NUMBER;
4419: l_count NUMBER := 0;
4420: l_instance_query_rec csi_datastructures_pub.instance_query_rec;

Line 4417: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;

4413: l_msg_index NUMBER;
4414: l_cur_get_instance_rel NUMBER;
4415: l_where_clause VARCHAR2(20000) := '';
4416: l_instance_rec csi_datastructures_pub.instance_header_rec;
4417: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;
4418: l_rows_processed NUMBER;
4419: l_count NUMBER := 0;
4420: l_instance_query_rec csi_datastructures_pub.instance_query_rec;
4421: --Modified the select for R12 build to resolve column sequencing issue in table--

Line 4420: l_instance_query_rec csi_datastructures_pub.instance_query_rec;

4416: l_instance_rec csi_datastructures_pub.instance_header_rec;
4417: l_instance_header_tbl csi_datastructures_pub.instance_header_tbl;
4418: l_rows_processed NUMBER;
4419: l_count NUMBER := 0;
4420: l_instance_query_rec csi_datastructures_pub.instance_query_rec;
4421: --Modified the select for R12 build to resolve column sequencing issue in table--
4422: l_select_stmt VARCHAR2(20000) := ' select instance_id,instance_number, external_reference, '||
4423: 'inventory_item_id,inventory_revision,inv_master_organization_id,serial_number, '||
4424: 'mfg_serial_number_flag,lot_number,quantity,unit_of_measure,accounting_class_code, '||

Line 4879: ,p_version_label_query_rec IN csi_datastructures_pub.version_label_query_rec

4875: ( p_api_version IN NUMBER
4876: ,p_commit IN VARCHAR2
4877: ,p_init_msg_list IN VARCHAR2
4878: ,p_validation_level IN NUMBER
4879: ,p_version_label_query_rec IN csi_datastructures_pub.version_label_query_rec
4880: ,p_time_stamp IN DATE
4881: ,x_version_label_tbl OUT NOCOPY csi_datastructures_pub.version_label_tbl
4882: ,x_return_status OUT NOCOPY VARCHAR2
4883: ,x_msg_count OUT NOCOPY NUMBER

Line 4881: ,x_version_label_tbl OUT NOCOPY csi_datastructures_pub.version_label_tbl

4877: ,p_init_msg_list IN VARCHAR2
4878: ,p_validation_level IN NUMBER
4879: ,p_version_label_query_rec IN csi_datastructures_pub.version_label_query_rec
4880: ,p_time_stamp IN DATE
4881: ,x_version_label_tbl OUT NOCOPY csi_datastructures_pub.version_label_tbl
4882: ,x_return_status OUT NOCOPY VARCHAR2
4883: ,x_msg_count OUT NOCOPY NUMBER
4884: ,x_msg_data OUT NOCOPY VARCHAR2
4885: )IS

Line 4891: l_version_label_tbl csi_datastructures_pub.version_label_tbl;

4887: l_api_name CONSTANT VARCHAR2(30) := 'GET_VERSION_LABEL';
4888: l_api_version CONSTANT NUMBER := 1.0;
4889: l_debug_level NUMBER;
4890: l_version_label_id NUMBER;
4891: l_version_label_tbl csi_datastructures_pub.version_label_tbl;
4892: l_line_count NUMBER;
4893: l_msg_index NUMBER;
4894: l_count NUMBER := 0;
4895: l_where_clause VARCHAR2(2000) ;

Line 4899: l_version_label_rec csi_datastructures_pub.version_label_rec;

4895: l_where_clause VARCHAR2(2000) ;
4896: l_get_ver_cursor_id NUMBER ;
4897: l_flag VARCHAR2(1) :='N';
4898: l_rows_processed NUMBER ;
4899: l_version_label_rec csi_datastructures_pub.version_label_rec;
4900: l_select_stmt VARCHAR2(20000) := ' SELECT * FROM CSI_I_VERSION_LABELS ';
4901:
4902: BEGIN
4903: -- Standard Start of API savepoint

Line 5067: ,p_version_label_tbl IN OUT NOCOPY csi_datastructures_pub.version_label_tbl

5063: ( p_api_version IN NUMBER
5064: ,p_commit IN VARCHAR2
5065: ,p_init_msg_list IN VARCHAR2
5066: ,p_validation_level IN NUMBER
5067: ,p_version_label_tbl IN OUT NOCOPY csi_datastructures_pub.version_label_tbl
5068: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
5069: ,x_return_status OUT NOCOPY VARCHAR2
5070: ,x_msg_count OUT NOCOPY NUMBER
5071: ,x_msg_data OUT NOCOPY VARCHAR2

Line 5068: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

5064: ,p_commit IN VARCHAR2
5065: ,p_init_msg_list IN VARCHAR2
5066: ,p_validation_level IN NUMBER
5067: ,p_version_label_tbl IN OUT NOCOPY csi_datastructures_pub.version_label_tbl
5068: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
5069: ,x_return_status OUT NOCOPY VARCHAR2
5070: ,x_msg_count OUT NOCOPY NUMBER
5071: ,x_msg_data OUT NOCOPY VARCHAR2
5072: ) IS

Line 5077: l_version_label_rec csi_datastructures_pub.version_label_rec;

5073: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_VERSION_LABEL';
5074: l_api_version CONSTANT NUMBER := 1.0 ;
5075: l_debug_level NUMBER ;
5076: l_line_count NUMBER ;
5077: l_version_label_rec csi_datastructures_pub.version_label_rec;
5078: l_msg_index NUMBER ;
5079: l_flag VARCHAR2(1) :='N' ;
5080: l_msg_count NUMBER;
5081: BEGIN

Line 5231: ,p_version_label_tbl IN csi_datastructures_pub.version_label_tbl

5227: ( p_api_version IN NUMBER
5228: ,p_commit IN VARCHAR2
5229: ,p_init_msg_list IN VARCHAR2
5230: ,p_validation_level IN NUMBER
5231: ,p_version_label_tbl IN csi_datastructures_pub.version_label_tbl
5232: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
5233: ,x_return_status OUT NOCOPY VARCHAR2
5234: ,x_msg_count OUT NOCOPY NUMBER
5235: ,x_msg_data OUT NOCOPY VARCHAR2

Line 5232: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

5228: ,p_commit IN VARCHAR2
5229: ,p_init_msg_list IN VARCHAR2
5230: ,p_validation_level IN NUMBER
5231: ,p_version_label_tbl IN csi_datastructures_pub.version_label_tbl
5232: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
5233: ,x_return_status OUT NOCOPY VARCHAR2
5234: ,x_msg_count OUT NOCOPY NUMBER
5235: ,x_msg_data OUT NOCOPY VARCHAR2
5236: ) IS

Line 5241: l_version_label_rec csi_datastructures_pub.version_label_rec;

5237:
5238: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_VERSION_LABEL';
5239: l_api_version CONSTANT NUMBER := 1.0;
5240: l_debug_level NUMBER;
5241: l_version_label_rec csi_datastructures_pub.version_label_rec;
5242: l_msg_index NUMBER;
5243: l_line_count NUMBER ;
5244: l_flag VARCHAR2(1) :='N';
5245: l_msg_count NUMBER;

Line 5395: ,p_version_label_tbl IN csi_datastructures_pub.version_label_tbl

5391: ( p_api_version IN NUMBER
5392: ,p_commit IN VARCHAR2
5393: ,p_init_msg_list IN VARCHAR2
5394: ,p_validation_level IN NUMBER
5395: ,p_version_label_tbl IN csi_datastructures_pub.version_label_tbl
5396: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
5397: ,x_return_status OUT NOCOPY VARCHAR2
5398: ,x_msg_count OUT NOCOPY NUMBER
5399: ,x_msg_data OUT NOCOPY VARCHAR2

Line 5396: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

5392: ,p_commit IN VARCHAR2
5393: ,p_init_msg_list IN VARCHAR2
5394: ,p_validation_level IN NUMBER
5395: ,p_version_label_tbl IN csi_datastructures_pub.version_label_tbl
5396: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
5397: ,x_return_status OUT NOCOPY VARCHAR2
5398: ,x_msg_count OUT NOCOPY NUMBER
5399: ,x_msg_data OUT NOCOPY VARCHAR2
5400: ) IS

Line 5404: l_version_label_rec csi_datastructures_pub.version_label_rec;

5400: ) IS
5401: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_VERSION_LABEL';
5402: l_api_version CONSTANT NUMBER := 1.0;
5403: l_debug_level NUMBER;
5404: l_version_label_rec csi_datastructures_pub.version_label_rec;
5405: l_msg_index NUMBER;
5406: l_line_count NUMBER;
5407: l_version_label_id NUMBER;
5408: l_flag VARCHAR2(1) :='N';

Line 5551: ,p_ext_attribs_query_rec IN csi_datastructures_pub.extend_attrib_query_rec

5547: ( p_api_version IN NUMBER
5548: ,p_commit IN VARCHAR2
5549: ,p_init_msg_list IN VARCHAR2
5550: ,p_validation_level IN NUMBER
5551: ,p_ext_attribs_query_rec IN csi_datastructures_pub.extend_attrib_query_rec
5552: ,p_time_stamp IN DATE
5553: ,x_ext_attrib_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
5554: ,x_ext_attrib_def_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_tbl -- added
5555: ,x_return_status OUT NOCOPY VARCHAR2

Line 5553: ,x_ext_attrib_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl

5549: ,p_init_msg_list IN VARCHAR2
5550: ,p_validation_level IN NUMBER
5551: ,p_ext_attribs_query_rec IN csi_datastructures_pub.extend_attrib_query_rec
5552: ,p_time_stamp IN DATE
5553: ,x_ext_attrib_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
5554: ,x_ext_attrib_def_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_tbl -- added
5555: ,x_return_status OUT NOCOPY VARCHAR2
5556: ,x_msg_count OUT NOCOPY NUMBER
5557: ,x_msg_data OUT NOCOPY VARCHAR2

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

5550: ,p_validation_level IN NUMBER
5551: ,p_ext_attribs_query_rec IN csi_datastructures_pub.extend_attrib_query_rec
5552: ,p_time_stamp IN DATE
5553: ,x_ext_attrib_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
5554: ,x_ext_attrib_def_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_tbl -- added
5555: ,x_return_status OUT NOCOPY VARCHAR2
5556: ,x_msg_count OUT NOCOPY NUMBER
5557: ,x_msg_data OUT NOCOPY VARCHAR2
5558: )

Line 5564: l_ext_rec csi_datastructures_pub.extend_attrib_values_rec;

5560: IS
5561: l_api_name CONSTANT VARCHAR2(30) := 'get_extended_attrib_values';
5562: l_api_version CONSTANT NUMBER := 1.0;
5563: l_debug_level NUMBER;
5564: l_ext_rec csi_datastructures_pub.extend_attrib_values_rec;
5565: l_rows_processed NUMBER;
5566: l_where_clause VARCHAR2(2000) := '' ;
5567: l_select_stmt VARCHAR2(20000);
5568: l_cur_get_ext NUMBER;

Line 5981: ,p_ext_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl

5977: ( p_api_version IN NUMBER
5978: ,p_commit IN VARCHAR2
5979: ,p_init_msg_list IN VARCHAR2
5980: ,p_validation_level IN NUMBER
5981: ,p_ext_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
5982: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
5983: ,x_return_status OUT NOCOPY VARCHAR2
5984: ,x_msg_count OUT NOCOPY NUMBER
5985: ,x_msg_data OUT NOCOPY VARCHAR2

Line 5982: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

5978: ,p_commit IN VARCHAR2
5979: ,p_init_msg_list IN VARCHAR2
5980: ,p_validation_level IN NUMBER
5981: ,p_ext_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
5982: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
5983: ,x_return_status OUT NOCOPY VARCHAR2
5984: ,x_msg_count OUT NOCOPY NUMBER
5985: ,x_msg_data OUT NOCOPY VARCHAR2
5986: )

Line 6174: ,p_ext_attrib_tbl IN csi_datastructures_pub.extend_attrib_values_tbl

6170: ( p_api_version IN NUMBER
6171: ,p_commit IN VARCHAR2
6172: ,p_init_msg_list IN VARCHAR2
6173: ,p_validation_level IN NUMBER
6174: ,p_ext_attrib_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
6175: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
6176: ,x_return_status OUT NOCOPY VARCHAR2
6177: ,x_msg_count OUT NOCOPY NUMBER
6178: ,x_msg_data OUT NOCOPY VARCHAR2

Line 6175: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

6171: ,p_commit IN VARCHAR2
6172: ,p_init_msg_list IN VARCHAR2
6173: ,p_validation_level IN NUMBER
6174: ,p_ext_attrib_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
6175: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
6176: ,x_return_status OUT NOCOPY VARCHAR2
6177: ,x_msg_count OUT NOCOPY NUMBER
6178: ,x_msg_data OUT NOCOPY VARCHAR2
6179: )

Line 6362: ,p_ext_attrib_tbl IN csi_datastructures_pub.extend_attrib_values_tbl

6358: ( p_api_version IN NUMBER
6359: ,p_commit IN VARCHAR2
6360: ,p_init_msg_list IN VARCHAR2
6361: ,p_validation_level IN NUMBER
6362: ,p_ext_attrib_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
6363: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
6364: ,x_return_status OUT NOCOPY VARCHAR2
6365: ,x_msg_count OUT NOCOPY NUMBER
6366: ,x_msg_data OUT NOCOPY VARCHAR2

Line 6363: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

6359: ,p_commit IN VARCHAR2
6360: ,p_init_msg_list IN VARCHAR2
6361: ,p_validation_level IN NUMBER
6362: ,p_ext_attrib_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
6363: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
6364: ,x_return_status OUT NOCOPY VARCHAR2
6365: ,x_msg_count OUT NOCOPY NUMBER
6366: ,x_msg_data OUT NOCOPY VARCHAR2
6367: )

Line 6549: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec

6545: p_api_version IN NUMBER
6546: ,p_commit IN VARCHAR2
6547: ,p_init_msg_list IN VARCHAR2
6548: ,p_validation_level IN NUMBER
6549: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
6550: ,p_copy_ext_attribs IN VARCHAR2
6551: ,p_copy_org_assignments IN VARCHAR2
6552: ,p_copy_parties IN VARCHAR2
6553: ,p_copy_party_contacts IN VARCHAR2

Line 6558: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

6554: ,p_copy_accounts IN VARCHAR2
6555: ,p_copy_asset_assignments IN VARCHAR2
6556: ,p_copy_pricing_attribs IN VARCHAR2
6557: ,p_copy_inst_children IN VARCHAR2
6558: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
6559: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
6560: ,x_return_status OUT NOCOPY VARCHAR2
6561: ,x_msg_count OUT NOCOPY NUMBER
6562: ,x_msg_data OUT NOCOPY VARCHAR2

Line 6559: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl

6555: ,p_copy_asset_assignments IN VARCHAR2
6556: ,p_copy_pricing_attribs IN VARCHAR2
6557: ,p_copy_inst_children IN VARCHAR2
6558: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
6559: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
6560: ,x_return_status OUT NOCOPY VARCHAR2
6561: ,x_msg_count OUT NOCOPY NUMBER
6562: ,x_msg_data OUT NOCOPY VARCHAR2
6563: )

Line 6723: ,p_instance_rec IN CSI_DATASTRUCTURES_PUB.INSTANCE_REC

6719: PROCEDURE get_oks_txn_types (
6720: p_api_version IN NUMBER
6721: ,p_commit IN VARCHAR2
6722: ,p_init_msg_list IN VARCHAR2
6723: ,p_instance_rec IN CSI_DATASTRUCTURES_PUB.INSTANCE_REC
6724: ,p_check_contracts_yn IN VARCHAR2
6725: ,p_txn_type IN VARCHAR2
6726: ,x_txn_type_tbl OUT NOCOPY CSI_ITEM_INSTANCE_PUB.TXN_OKS_TYPE_TBL
6727: ,x_configflag OUT NOCOPY VARCHAR2