DBA Data[Home] [Help]

APPS.CSI_ITEM_INSTANCE_PUB dependencies on CSI_DATASTRUCTURES_PUB

Line 51: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec

47: p_api_version IN NUMBER
48: ,p_commit IN VARCHAR2 := fnd_api.g_false
49: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
50: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
51: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
52: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
53: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
54: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
55: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl

Line 52: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl

48: ,p_commit IN VARCHAR2 := fnd_api.g_false
49: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
50: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
51: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
52: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
53: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
54: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
55: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
56: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl

Line 53: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl

49: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
50: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
51: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
52: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
53: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
54: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
55: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
56: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
57: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl

Line 54: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl

50: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
51: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
52: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
53: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
54: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
55: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
56: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
57: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
58: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

Line 55: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl

51: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_rec
52: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
53: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
54: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
55: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
56: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
57: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
58: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
59: ,x_return_status OUT NOCOPY VARCHAR2

Line 56: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl

52: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
53: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
54: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
55: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
56: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
57: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
58: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
59: ,x_return_status OUT NOCOPY VARCHAR2
60: ,x_msg_count OUT NOCOPY NUMBER

Line 57: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl

53: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
54: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
55: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
56: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
57: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
58: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
59: ,x_return_status OUT NOCOPY VARCHAR2
60: ,x_msg_count OUT NOCOPY NUMBER
61: ,x_msg_data OUT NOCOPY VARCHAR2

Line 58: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

54: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
55: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
56: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
57: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
58: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
59: ,x_return_status OUT NOCOPY VARCHAR2
60: ,x_msg_count OUT NOCOPY NUMBER
61: ,x_msg_data OUT NOCOPY VARCHAR2
62: );

Line 98: ,p_instance_rec IN csi_datastructures_pub.instance_rec

94: p_api_version IN NUMBER
95: ,p_commit IN VARCHAR2 := fnd_api.g_false
96: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
97: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
98: ,p_instance_rec IN csi_datastructures_pub.instance_rec
99: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
100: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
101: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
102: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl

Line 99: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl

95: ,p_commit IN VARCHAR2 := fnd_api.g_false
96: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
97: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
98: ,p_instance_rec IN csi_datastructures_pub.instance_rec
99: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
100: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
101: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
102: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
103: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl

Line 100: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl

96: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
97: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
98: ,p_instance_rec IN csi_datastructures_pub.instance_rec
99: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
100: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
101: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
102: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
103: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
104: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl

Line 101: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl

97: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
98: ,p_instance_rec IN csi_datastructures_pub.instance_rec
99: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
100: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
101: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
102: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
103: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
104: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
105: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

Line 102: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl

98: ,p_instance_rec IN csi_datastructures_pub.instance_rec
99: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
100: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
101: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
102: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
103: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
104: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
105: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
106: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl

Line 103: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl

99: ,p_ext_attrib_values_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
100: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
101: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
102: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
103: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
104: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
105: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
106: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
107: ,x_return_status OUT NOCOPY VARCHAR2

Line 104: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl

100: ,p_party_tbl IN OUT NOCOPY csi_datastructures_pub.party_tbl
101: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
102: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
103: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
104: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
105: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
106: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
107: ,x_return_status OUT NOCOPY VARCHAR2
108: ,x_msg_count OUT NOCOPY NUMBER

Line 105: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

101: ,p_account_tbl IN OUT NOCOPY csi_datastructures_pub.party_account_tbl
102: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
103: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
104: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
105: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
106: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
107: ,x_return_status OUT NOCOPY VARCHAR2
108: ,x_msg_count OUT NOCOPY NUMBER
109: ,x_msg_data OUT NOCOPY VARCHAR2

Line 106: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl

102: ,p_pricing_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
103: ,p_org_assignments_tbl IN OUT NOCOPY csi_datastructures_pub.organization_units_tbl
104: ,p_asset_assignment_tbl IN OUT NOCOPY csi_datastructures_pub.instance_asset_tbl
105: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
106: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
107: ,x_return_status OUT NOCOPY VARCHAR2
108: ,x_msg_count OUT NOCOPY NUMBER
109: ,x_msg_data OUT NOCOPY VARCHAR2
110: );

Line 124: ,p_instance_rec IN csi_datastructures_pub.instance_rec

120: p_api_version IN NUMBER
121: ,p_commit IN VARCHAR2 := fnd_api.g_false
122: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
123: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
124: ,p_instance_rec IN csi_datastructures_pub.instance_rec
125: ,p_expire_children IN VARCHAR2 := fnd_api.g_false
126: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
127: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
128: ,x_return_status OUT NOCOPY VARCHAR2

Line 126: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

122: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
123: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
124: ,p_instance_rec IN csi_datastructures_pub.instance_rec
125: ,p_expire_children IN VARCHAR2 := fnd_api.g_false
126: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
127: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
128: ,x_return_status OUT NOCOPY VARCHAR2
129: ,x_msg_count OUT NOCOPY NUMBER
130: ,x_msg_data OUT NOCOPY VARCHAR2

Line 127: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl

123: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
124: ,p_instance_rec IN csi_datastructures_pub.instance_rec
125: ,p_expire_children IN VARCHAR2 := fnd_api.g_false
126: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
127: ,x_instance_id_lst OUT NOCOPY csi_datastructures_pub.id_tbl
128: ,x_return_status OUT NOCOPY VARCHAR2
129: ,x_msg_count OUT NOCOPY NUMBER
130: ,x_msg_data OUT NOCOPY VARCHAR2
131: );

Line 166: ,p_instance_query_rec IN csi_datastructures_pub.instance_query_rec

162: p_api_version IN NUMBER
163: ,p_commit IN VARCHAR2 := fnd_api.g_false
164: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
165: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
166: ,p_instance_query_rec IN csi_datastructures_pub.instance_query_rec
167: ,p_party_query_rec IN csi_datastructures_pub.party_query_rec
168: ,p_account_query_rec IN csi_datastructures_pub.party_account_query_rec
169: ,p_transaction_id IN NUMBER
170: ,p_resolve_id_columns IN VARCHAR2 := fnd_api.g_false

Line 167: ,p_party_query_rec IN csi_datastructures_pub.party_query_rec

163: ,p_commit IN VARCHAR2 := fnd_api.g_false
164: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
165: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
166: ,p_instance_query_rec IN csi_datastructures_pub.instance_query_rec
167: ,p_party_query_rec IN csi_datastructures_pub.party_query_rec
168: ,p_account_query_rec IN csi_datastructures_pub.party_account_query_rec
169: ,p_transaction_id IN NUMBER
170: ,p_resolve_id_columns IN VARCHAR2 := fnd_api.g_false
171: ,p_active_instance_only IN VARCHAR2 := fnd_api.g_true

Line 168: ,p_account_query_rec IN csi_datastructures_pub.party_account_query_rec

164: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
165: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
166: ,p_instance_query_rec IN csi_datastructures_pub.instance_query_rec
167: ,p_party_query_rec IN csi_datastructures_pub.party_query_rec
168: ,p_account_query_rec IN csi_datastructures_pub.party_account_query_rec
169: ,p_transaction_id IN NUMBER
170: ,p_resolve_id_columns IN VARCHAR2 := fnd_api.g_false
171: ,p_active_instance_only IN VARCHAR2 := fnd_api.g_true
172: ,x_instance_header_tbl OUT NOCOPY csi_datastructures_pub.instance_header_tbl

Line 172: ,x_instance_header_tbl OUT NOCOPY csi_datastructures_pub.instance_header_tbl

168: ,p_account_query_rec IN csi_datastructures_pub.party_account_query_rec
169: ,p_transaction_id IN NUMBER
170: ,p_resolve_id_columns IN VARCHAR2 := fnd_api.g_false
171: ,p_active_instance_only IN VARCHAR2 := fnd_api.g_true
172: ,x_instance_header_tbl OUT NOCOPY csi_datastructures_pub.instance_header_tbl
173: ,x_return_status OUT NOCOPY VARCHAR2
174: ,x_msg_count OUT NOCOPY NUMBER
175: ,x_msg_data OUT NOCOPY VARCHAR2
176: );

Line 223: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_header_rec

219: p_api_version IN NUMBER
220: ,p_commit IN VARCHAR2 := fnd_api.g_false
221: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
222: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
223: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_header_rec
224: ,p_get_parties IN VARCHAR2 := fnd_api.g_false
225: ,p_party_header_tbl OUT NOCOPY csi_datastructures_pub.party_header_tbl
226: ,p_get_accounts IN VARCHAR2 := fnd_api.g_false
227: ,p_account_header_tbl OUT NOCOPY csi_datastructures_pub.party_account_header_tbl

Line 225: ,p_party_header_tbl OUT NOCOPY csi_datastructures_pub.party_header_tbl

221: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
222: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
223: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_header_rec
224: ,p_get_parties IN VARCHAR2 := fnd_api.g_false
225: ,p_party_header_tbl OUT NOCOPY csi_datastructures_pub.party_header_tbl
226: ,p_get_accounts IN VARCHAR2 := fnd_api.g_false
227: ,p_account_header_tbl OUT NOCOPY csi_datastructures_pub.party_account_header_tbl
228: ,p_get_org_assignments IN VARCHAR2 := fnd_api.g_false
229: ,p_org_header_tbl OUT NOCOPY csi_datastructures_pub.org_units_header_tbl

Line 227: ,p_account_header_tbl OUT NOCOPY csi_datastructures_pub.party_account_header_tbl

223: ,p_instance_rec IN OUT NOCOPY csi_datastructures_pub.instance_header_rec
224: ,p_get_parties IN VARCHAR2 := fnd_api.g_false
225: ,p_party_header_tbl OUT NOCOPY csi_datastructures_pub.party_header_tbl
226: ,p_get_accounts IN VARCHAR2 := fnd_api.g_false
227: ,p_account_header_tbl OUT NOCOPY csi_datastructures_pub.party_account_header_tbl
228: ,p_get_org_assignments IN VARCHAR2 := fnd_api.g_false
229: ,p_org_header_tbl OUT NOCOPY csi_datastructures_pub.org_units_header_tbl
230: ,p_get_pricing_attribs IN VARCHAR2 := fnd_api.g_false
231: ,p_pricing_attrib_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl

Line 229: ,p_org_header_tbl OUT NOCOPY csi_datastructures_pub.org_units_header_tbl

225: ,p_party_header_tbl OUT NOCOPY csi_datastructures_pub.party_header_tbl
226: ,p_get_accounts IN VARCHAR2 := fnd_api.g_false
227: ,p_account_header_tbl OUT NOCOPY csi_datastructures_pub.party_account_header_tbl
228: ,p_get_org_assignments IN VARCHAR2 := fnd_api.g_false
229: ,p_org_header_tbl OUT NOCOPY csi_datastructures_pub.org_units_header_tbl
230: ,p_get_pricing_attribs IN VARCHAR2 := fnd_api.g_false
231: ,p_pricing_attrib_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
232: ,p_get_ext_attribs IN VARCHAR2 := fnd_api.g_false
233: ,p_ext_attrib_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl

Line 231: ,p_pricing_attrib_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl

227: ,p_account_header_tbl OUT NOCOPY csi_datastructures_pub.party_account_header_tbl
228: ,p_get_org_assignments IN VARCHAR2 := fnd_api.g_false
229: ,p_org_header_tbl OUT NOCOPY csi_datastructures_pub.org_units_header_tbl
230: ,p_get_pricing_attribs IN VARCHAR2 := fnd_api.g_false
231: ,p_pricing_attrib_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
232: ,p_get_ext_attribs IN VARCHAR2 := fnd_api.g_false
233: ,p_ext_attrib_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
234: ,p_ext_attrib_def_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_tbl --added
235: ,p_get_asset_assignments IN VARCHAR2 := fnd_api.g_false

Line 233: ,p_ext_attrib_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl

229: ,p_org_header_tbl OUT NOCOPY csi_datastructures_pub.org_units_header_tbl
230: ,p_get_pricing_attribs IN VARCHAR2 := fnd_api.g_false
231: ,p_pricing_attrib_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
232: ,p_get_ext_attribs IN VARCHAR2 := fnd_api.g_false
233: ,p_ext_attrib_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
234: ,p_ext_attrib_def_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_tbl --added
235: ,p_get_asset_assignments IN VARCHAR2 := fnd_api.g_false
236: ,p_asset_header_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_header_tbl
237: ,p_resolve_id_columns IN VARCHAR2 := fnd_api.g_false

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

230: ,p_get_pricing_attribs IN VARCHAR2 := fnd_api.g_false
231: ,p_pricing_attrib_tbl OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl
232: ,p_get_ext_attribs IN VARCHAR2 := fnd_api.g_false
233: ,p_ext_attrib_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
234: ,p_ext_attrib_def_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_tbl --added
235: ,p_get_asset_assignments IN VARCHAR2 := fnd_api.g_false
236: ,p_asset_header_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_header_tbl
237: ,p_resolve_id_columns IN VARCHAR2 := fnd_api.g_false
238: ,p_time_stamp IN DATE

Line 236: ,p_asset_header_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_header_tbl

232: ,p_get_ext_attribs IN VARCHAR2 := fnd_api.g_false
233: ,p_ext_attrib_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
234: ,p_ext_attrib_def_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_tbl --added
235: ,p_get_asset_assignments IN VARCHAR2 := fnd_api.g_false
236: ,p_asset_header_tbl OUT NOCOPY csi_datastructures_pub.instance_asset_header_tbl
237: ,p_resolve_id_columns IN VARCHAR2 := fnd_api.g_false
238: ,p_time_stamp IN DATE
239: ,x_return_status OUT NOCOPY VARCHAR2
240: ,x_msg_count OUT NOCOPY NUMBER

Line 256: ,p_version_label_query_rec IN csi_datastructures_pub.version_label_query_rec

252: ( p_api_version IN NUMBER
253: ,p_commit IN VARCHAR2 := fnd_api.g_false
254: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
255: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
256: ,p_version_label_query_rec IN csi_datastructures_pub.version_label_query_rec
257: ,p_time_stamp IN DATE
258: ,x_version_label_tbl OUT NOCOPY csi_datastructures_pub.version_label_tbl
259: ,x_return_status OUT NOCOPY VARCHAR2
260: ,x_msg_count OUT NOCOPY NUMBER

Line 258: ,x_version_label_tbl OUT NOCOPY csi_datastructures_pub.version_label_tbl

254: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
255: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
256: ,p_version_label_query_rec IN csi_datastructures_pub.version_label_query_rec
257: ,p_time_stamp IN DATE
258: ,x_version_label_tbl OUT NOCOPY csi_datastructures_pub.version_label_tbl
259: ,x_return_status OUT NOCOPY VARCHAR2
260: ,x_msg_count OUT NOCOPY NUMBER
261: ,x_msg_data OUT NOCOPY VARCHAR2 );
262:

Line 275: ,p_version_label_tbl IN OUT NOCOPY csi_datastructures_pub.version_label_tbl

271: ( p_api_version IN NUMBER
272: ,p_commit IN VARCHAR2 := fnd_api.g_false
273: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
274: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
275: ,p_version_label_tbl IN OUT NOCOPY csi_datastructures_pub.version_label_tbl
276: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
277: ,x_return_status OUT NOCOPY VARCHAR2
278: ,x_msg_count OUT NOCOPY NUMBER
279: ,x_msg_data OUT NOCOPY VARCHAR2 );

Line 276: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

272: ,p_commit IN VARCHAR2 := fnd_api.g_false
273: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
274: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
275: ,p_version_label_tbl IN OUT NOCOPY csi_datastructures_pub.version_label_tbl
276: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
277: ,x_return_status OUT NOCOPY VARCHAR2
278: ,x_msg_count OUT NOCOPY NUMBER
279: ,x_msg_data OUT NOCOPY VARCHAR2 );
280:

Line 293: ,p_version_label_tbl IN csi_datastructures_pub.version_label_tbl

289: ( p_api_version IN NUMBER
290: ,p_commit IN VARCHAR2 := fnd_api.g_false
291: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
292: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
293: ,p_version_label_tbl IN csi_datastructures_pub.version_label_tbl
294: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
295: ,x_return_status OUT NOCOPY VARCHAR2
296: ,x_msg_count OUT NOCOPY NUMBER
297: ,x_msg_data OUT NOCOPY VARCHAR2 );

Line 294: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

290: ,p_commit IN VARCHAR2 := fnd_api.g_false
291: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
292: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
293: ,p_version_label_tbl IN csi_datastructures_pub.version_label_tbl
294: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
295: ,x_return_status OUT NOCOPY VARCHAR2
296: ,x_msg_count OUT NOCOPY NUMBER
297: ,x_msg_data OUT NOCOPY VARCHAR2 );
298:

Line 311: ,p_version_label_tbl IN csi_datastructures_pub.version_label_tbl

307: ( p_api_version IN NUMBER
308: ,p_commit IN VARCHAR2 := fnd_api.g_false
309: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
310: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
311: ,p_version_label_tbl IN csi_datastructures_pub.version_label_tbl
312: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
313: ,x_return_status OUT NOCOPY VARCHAR2
314: ,x_msg_count OUT NOCOPY NUMBER
315: ,x_msg_data OUT NOCOPY VARCHAR2 );

Line 312: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

308: ,p_commit IN VARCHAR2 := fnd_api.g_false
309: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
310: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
311: ,p_version_label_tbl IN csi_datastructures_pub.version_label_tbl
312: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
313: ,x_return_status OUT NOCOPY VARCHAR2
314: ,x_msg_count OUT NOCOPY NUMBER
315: ,x_msg_data OUT NOCOPY VARCHAR2 );
316:

Line 328: ,p_ext_attribs_query_rec IN csi_datastructures_pub.extend_attrib_query_rec

324: ( p_api_version IN NUMBER
325: ,p_commit IN VARCHAR2 := fnd_api.g_false
326: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
327: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
328: ,p_ext_attribs_query_rec IN csi_datastructures_pub.extend_attrib_query_rec
329: ,p_time_stamp IN DATE
330: ,x_ext_attrib_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
331: ,x_ext_attrib_def_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_tbl -- added
332: ,x_return_status OUT NOCOPY VARCHAR2

Line 330: ,x_ext_attrib_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl

326: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
327: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
328: ,p_ext_attribs_query_rec IN csi_datastructures_pub.extend_attrib_query_rec
329: ,p_time_stamp IN DATE
330: ,x_ext_attrib_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
331: ,x_ext_attrib_def_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_tbl -- added
332: ,x_return_status OUT NOCOPY VARCHAR2
333: ,x_msg_count OUT NOCOPY NUMBER
334: ,x_msg_data OUT NOCOPY VARCHAR2

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

327: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
328: ,p_ext_attribs_query_rec IN csi_datastructures_pub.extend_attrib_query_rec
329: ,p_time_stamp IN DATE
330: ,x_ext_attrib_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
331: ,x_ext_attrib_def_tbl OUT NOCOPY csi_datastructures_pub.extend_attrib_tbl -- added
332: ,x_return_status OUT NOCOPY VARCHAR2
333: ,x_msg_count OUT NOCOPY NUMBER
334: ,x_msg_data OUT NOCOPY VARCHAR2
335: );

Line 348: ,p_ext_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl

344: ( p_api_version IN NUMBER
345: ,p_commit IN VARCHAR2 := fnd_api.g_false
346: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
347: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
348: ,p_ext_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
349: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
350: ,x_return_status OUT NOCOPY VARCHAR2
351: ,x_msg_count OUT NOCOPY NUMBER
352: ,x_msg_data OUT NOCOPY VARCHAR2

Line 349: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

345: ,p_commit IN VARCHAR2 := fnd_api.g_false
346: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
347: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
348: ,p_ext_attrib_tbl IN OUT NOCOPY csi_datastructures_pub.extend_attrib_values_tbl
349: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
350: ,x_return_status OUT NOCOPY VARCHAR2
351: ,x_msg_count OUT NOCOPY NUMBER
352: ,x_msg_data OUT NOCOPY VARCHAR2
353: );

Line 366: ,p_ext_attrib_tbl IN csi_datastructures_pub.extend_attrib_values_tbl

362: ( p_api_version IN NUMBER
363: ,p_commit IN VARCHAR2 := fnd_api.g_false
364: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
365: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
366: ,p_ext_attrib_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
367: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
368: ,x_return_status OUT NOCOPY VARCHAR2
369: ,x_msg_count OUT NOCOPY NUMBER
370: ,x_msg_data OUT NOCOPY VARCHAR2

Line 367: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

363: ,p_commit IN VARCHAR2 := fnd_api.g_false
364: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
365: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
366: ,p_ext_attrib_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
367: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
368: ,x_return_status OUT NOCOPY VARCHAR2
369: ,x_msg_count OUT NOCOPY NUMBER
370: ,x_msg_data OUT NOCOPY VARCHAR2
371: );

Line 384: ,p_ext_attrib_tbl IN csi_datastructures_pub.extend_attrib_values_tbl

380: ( p_api_version IN NUMBER
381: ,p_commit IN VARCHAR2 := fnd_api.g_false
382: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
383: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
384: ,p_ext_attrib_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
385: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
386: ,x_return_status OUT NOCOPY VARCHAR2
387: ,x_msg_count OUT NOCOPY NUMBER
388: ,x_msg_data OUT NOCOPY VARCHAR2

Line 385: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

381: ,p_commit IN VARCHAR2 := fnd_api.g_false
382: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
383: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
384: ,p_ext_attrib_tbl IN csi_datastructures_pub.extend_attrib_values_tbl
385: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
386: ,x_return_status OUT NOCOPY VARCHAR2
387: ,x_msg_count OUT NOCOPY NUMBER
388: ,x_msg_data OUT NOCOPY VARCHAR2
389: );

Line 431: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec

427: p_api_version IN NUMBER
428: ,p_commit IN VARCHAR2 := fnd_api.g_false
429: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
430: ,p_validation_level IN NUMBER := fnd_api.g_valid_level_full
431: ,p_source_instance_rec IN csi_datastructures_pub.instance_rec
432: ,p_copy_ext_attribs IN VARCHAR2 := fnd_api.g_false
433: ,p_copy_org_assignments IN VARCHAR2 := fnd_api.g_false
434: ,p_copy_parties IN VARCHAR2 := fnd_api.g_false
435: ,p_copy_party_contacts IN VARCHAR2 := fnd_api.g_false

Line 440: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec

436: ,p_copy_accounts IN VARCHAR2 := fnd_api.g_false
437: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_false
438: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_false
439: ,p_copy_inst_children IN VARCHAR2 := fnd_api.g_false
440: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
441: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
442: ,x_return_status OUT NOCOPY VARCHAR2
443: ,x_msg_count OUT NOCOPY NUMBER
444: ,x_msg_data OUT NOCOPY VARCHAR2

Line 441: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl

437: ,p_copy_asset_assignments IN VARCHAR2 := fnd_api.g_false
438: ,p_copy_pricing_attribs IN VARCHAR2 := fnd_api.g_false
439: ,p_copy_inst_children IN VARCHAR2 := fnd_api.g_false
440: ,p_txn_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec
441: ,x_new_instance_tbl OUT NOCOPY csi_datastructures_pub.instance_tbl
442: ,x_return_status OUT NOCOPY VARCHAR2
443: ,x_msg_count OUT NOCOPY NUMBER
444: ,x_msg_data OUT NOCOPY VARCHAR2
445: );

Line 453: ,p_instance_rec IN CSI_DATASTRUCTURES_PUB.INSTANCE_REC

449: PROCEDURE get_oks_txn_types (
450: p_api_version IN NUMBER
451: ,p_commit IN VARCHAR2
452: ,p_init_msg_list IN VARCHAR2
453: ,p_instance_rec IN CSI_DATASTRUCTURES_PUB.INSTANCE_REC
454: ,p_check_contracts_yn IN VARCHAR2
455: ,p_txn_type IN VARCHAR2
456: ,x_txn_type_tbl OUT NOCOPY CSI_ITEM_INSTANCE_PUB.TXN_OKS_TYPE_TBL
457: ,x_configflag OUT NOCOPY VARCHAR2