DBA Data[Home] [Help]

APPS.CSI_ORDER_SHIP_PUB dependencies on CSI_T_DATASTRUCTURES_GRP

Line 262: x_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

258: PROCEDURE Construct_for_txn_exists(
259: p_txn_sub_type_rec IN txn_sub_type_rec,
260: p_order_line_rec IN order_line_rec,
261: x_order_shipment_tbl IN OUT NOCOPY order_shipment_tbl,
262: x_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
263: x_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
264: x_return_status OUT NOCOPY VARCHAR2 );
265:
266:

Line 263: x_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

259: p_txn_sub_type_rec IN txn_sub_type_rec,
260: p_order_line_rec IN order_line_rec,
261: x_order_shipment_tbl IN OUT NOCOPY order_shipment_tbl,
262: x_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
263: x_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
264: x_return_status OUT NOCOPY VARCHAR2 );
265:
266:
267: /*----------------------------------------------------------*/

Line 277: p_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,

273: p_api_version IN NUMBER,
274: p_commit IN VARCHAR2 := fnd_api.g_false,
275: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
276: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
277: p_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
278: p_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
279: p_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
280: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
281: p_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

Line 278: p_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

274: p_commit IN VARCHAR2 := fnd_api.g_false,
275: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
276: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
277: p_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
278: p_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
279: p_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
280: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
281: p_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
282: p_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

Line 279: p_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

275: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
276: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
277: p_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
278: p_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
279: p_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
280: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
281: p_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
282: p_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
283: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

Line 280: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

276: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
277: p_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
278: p_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
279: p_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
280: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
281: p_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
282: p_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
283: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
284: p_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,

Line 281: p_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

277: p_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
278: p_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
279: p_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
280: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
281: p_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
282: p_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
283: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
284: p_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
285: p_pricing_attribs_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,

Line 282: p_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,

278: p_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
279: p_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
280: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
281: p_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
282: p_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
283: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
284: p_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
285: p_pricing_attribs_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
286: p_order_line_rec IN order_line_rec,

Line 283: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

279: p_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
280: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
281: p_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
282: p_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
283: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
284: p_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
285: p_pricing_attribs_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
286: p_order_line_rec IN order_line_rec,
287: p_trx_rec IN csi_datastructures_pub.transaction_rec,

Line 284: p_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,

280: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
281: p_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
282: p_txn_ext_attrib_vals_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ext_attrib_vals_tbl,
283: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
284: p_txn_systems_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_systems_tbl,
285: p_pricing_attribs_tbl IN OUT NOCOPY csi_datastructures_pub.pricing_attribs_tbl,
286: p_order_line_rec IN order_line_rec,
287: p_trx_rec IN csi_datastructures_pub.transaction_rec,
288: p_source IN VARCHAR2,

Line 302: x_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

298: /* (instance and qty) txn line details and shipment */
299: /*----------------------------------------------------------*/
300: PROCEDURE match_txn_with_ship(
301: p_serial_code IN NUMBER,
302: x_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
303: x_order_shipment_tbl IN OUT NOCOPY order_shipment_tbl,
304: x_return_status OUT NOCOPY VARCHAR2 );
305:
306: /*----------------------------------------------------------*/

Line 317: x_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

313: PROCEDURE process_txn_dtl(
314: p_serial_code IN NUMBER,
315: p_txn_sub_type_rec IN txn_sub_type_rec,
316: p_order_line_rec IN order_line_rec,
317: x_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
318: x_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
319: x_order_shipment_tbl IN OUT NOCOPY order_shipment_tbl,
320: x_return_status OUT NOCOPY VARCHAR2 );
321:

Line 318: x_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,

314: p_serial_code IN NUMBER,
315: p_txn_sub_type_rec IN txn_sub_type_rec,
316: p_order_line_rec IN order_line_rec,
317: x_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
318: x_txn_ii_rltns_tbl IN csi_t_datastructures_grp.txn_ii_rltns_tbl,
319: x_order_shipment_tbl IN OUT NOCOPY order_shipment_tbl,
320: x_return_status OUT NOCOPY VARCHAR2 );
321:
322: /*----------------------------------------------------------*/

Line 354: p_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,

350: /* Description : Procedure used to for validationg the */
351: /* txn line details and the child tables */
352: /*----------------------------------------------------------*/
353: PROCEDURE validate_txn_tbl(
354: p_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
355: p_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
356: p_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
357: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
358: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

Line 355: p_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,

351: /* txn line details and the child tables */
352: /*----------------------------------------------------------*/
353: PROCEDURE validate_txn_tbl(
354: p_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
355: p_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
356: p_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
357: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
358: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
359: p_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

Line 356: p_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,

352: /*----------------------------------------------------------*/
353: PROCEDURE validate_txn_tbl(
354: p_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
355: p_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
356: p_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
357: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
358: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
359: p_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
360: p_order_line_rec IN OUT NOCOPY order_line_rec,

Line 357: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,

353: PROCEDURE validate_txn_tbl(
354: p_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
355: p_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
356: p_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
357: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
358: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
359: p_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
360: p_order_line_rec IN OUT NOCOPY order_line_rec,
361: p_source IN VARCHAR2,

Line 358: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,

354: p_txn_line_rec IN OUT NOCOPY csi_t_datastructures_grp.txn_line_rec,
355: p_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
356: p_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
357: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
358: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
359: p_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
360: p_order_line_rec IN OUT NOCOPY order_line_rec,
361: p_source IN VARCHAR2,
362: x_return_status OUT NOCOPY VARCHAR2 );

Line 359: p_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,

355: p_txn_line_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_line_detail_tbl,
356: p_txn_party_detail_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_party_detail_tbl,
357: p_txn_pty_acct_dtl_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_pty_acct_detail_tbl,
358: p_txn_ii_rltns_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_ii_rltns_tbl,
359: p_txn_org_assgn_tbl IN OUT NOCOPY csi_t_datastructures_grp.txn_org_assgn_tbl,
360: p_order_line_rec IN OUT NOCOPY order_line_rec,
361: p_source IN VARCHAR2,
362: x_return_status OUT NOCOPY VARCHAR2 );
363: