DBA Data[Home] [Help]

APPS.CSI_PROCESS_TXN_PVT dependencies on CSI_PROCESS_TXN_PVT

Line 1: PACKAGE BODY csi_process_txn_pvt AS

1: PACKAGE BODY csi_process_txn_pvt AS
2: /* $Header: csivptxb.pls 120.40.12020000.4 2013/04/12 18:38:02 dsingire ship $ */
3:
4: PROCEDURE debug (
5: p_message IN varchar2)

Line 19: p_pkg_name => 'csi_process_txn_pvt',

15: p_api_name IN varchar2)
16: IS
17: BEGIN
18: csi_t_gen_utility_pvt.dump_api_info(
19: p_pkg_name => 'csi_process_txn_pvt',
20: p_api_name => p_api_name);
21: EXCEPTION
22: WHEN others THEN
23: null;

Line 461: x_item_attr_rec OUT NOCOPY csi_process_txn_pvt.item_attr_rec,

457: p_sub_type_rec IN csi_txn_sub_types%rowtype,
458: p_inventory_item_id IN number,
459: p_organization_id IN number,
460: p_mtl_transaction_id IN NUMBER,
461: x_item_attr_rec OUT NOCOPY csi_process_txn_pvt.item_attr_rec,
462: x_return_status OUT NOCOPY varchar2,
463: p_inv_txn_typeid_from_cs IN NUMBER DEFAULT -1)
464: IS
465:

Line 466: l_item_attr_rec csi_process_txn_pvt.item_attr_rec;

462: x_return_status OUT NOCOPY varchar2,
463: p_inv_txn_typeid_from_cs IN NUMBER DEFAULT -1)
464: IS
465:
466: l_item_attr_rec csi_process_txn_pvt.item_attr_rec;
467:
468: l_serial_code mtl_system_items.serial_number_control_code%TYPE;
469: l_lot_code mtl_system_items.lot_control_code%TYPE;
470: l_locator_code mtl_system_items.location_control_code%TYPE;

Line 628: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,

624: /* -------------------------------------------------------------------- */
625:
626: PROCEDURE validate_instance_rec(
627: p_instance_rec IN csi_process_txn_grp.txn_instance_rec,
628: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
629: x_return_status OUT NOCOPY varchar2)
630: IS
631: BEGIN
632:

Line 711: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,

707: p_in_out_flag IN varchar2,
708: p_sub_type_rec IN csi_txn_sub_types%rowtype,
709: p_instance_rec IN csi_process_txn_grp.txn_instance_rec,
710: p_dest_location_rec IN csi_process_txn_grp.dest_location_rec,
711: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
712: x_instance_query_rec OUT NOCOPY csi_datastructures_pub.instance_query_rec,
713: x_return_status OUT NOCOPY varchar2)
714: IS
715:

Line 1024: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,

1020: p_in_out_flag IN varchar2,
1021: p_sub_type_rec IN csi_txn_sub_types%rowtype,
1022: p_instance_rec IN csi_process_txn_grp.txn_instance_rec,
1023: p_dest_location_rec IN csi_process_txn_grp.dest_location_rec,
1024: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
1025: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
1026: x_instance_id OUT NOCOPY number,
1027: x_return_status OUT NOCOPY varchar2)
1028: IS

Line 1192: csi_process_txn_pvt.create_zero_qty_instance(

1188: l_negative_code := nvl(fnd_profile.value('inv_override_neg_for_backflush'), 2);
1189: END IF;
1190: IF l_negative_code = 1 and p_item_attr_rec.src_serial_control_flag = 'N' THEN
1191: debug('Org allows negative quantities. So creating an instance with 0 quantity.');
1192: csi_process_txn_pvt.create_zero_qty_instance(
1193: p_instance_rec => p_instance_rec,
1194: p_txn_rec => p_transaction_rec,
1195: x_instance_id => x_instance_id,
1196: x_return_status => l_return_status);

Line 1273: csi_process_txn_pvt.create_zero_qty_instance(

1269: raise fnd_api.g_exc_error;
1270: END IF;
1271: IF l_negative_code = 1 and p_item_attr_rec.src_serial_control_flag = 'N' THEN
1272: debug('Org allows negative quantities. So creating an instance with 0 quantity.');
1273: csi_process_txn_pvt.create_zero_qty_instance(
1274: p_instance_rec => p_instance_rec,
1275: p_txn_rec => p_transaction_rec,
1276: x_instance_id => x_instance_id,
1277: x_return_status => l_return_status);

Line 1353: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,

1349: p_in_out_flag IN varchar2,
1350: p_sub_type_rec IN csi_txn_sub_types%rowtype,
1351: p_instance_rec IN csi_process_txn_grp.txn_instance_rec,
1352: p_dest_location_rec IN csi_process_txn_grp.dest_location_rec,
1353: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
1354: x_instance_id OUT NOCOPY number,
1355: x_return_status OUT NOCOPY varchar2)
1356:
1357: IS

Line 1515: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,

1511: /* ---------------------------------------------------------------------*/
1512:
1513: PROCEDURE build_instance_rec(
1514: p_sub_type_rec IN csi_txn_sub_types%rowtype,
1515: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
1516: p_instance_rec IN csi_process_txn_grp.txn_instance_rec,
1517: p_dest_location_rec IN csi_process_txn_grp.dest_location_rec,
1518: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
1519: x_process_mode OUT NOCOPY varchar2,

Line 2443: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,

2439: x_return_status := fnd_api.g_ret_sts_error;
2440: END unexpire_instance;
2441:
2442: PROCEDURE preserve_ownership(
2443: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
2444: p_instance_rec IN csi_datastructures_pub.instance_rec,
2445: px_parties_tbl IN OUT nocopy csi_datastructures_pub.party_tbl,
2446: px_pty_accts_tbl IN OUT nocopy csi_datastructures_pub.party_account_tbl,
2447: x_return_status OUT nocopy varchar2)

Line 2555: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,

2551:
2552: PROCEDURE process_ib(
2553: p_in_out_flag IN varchar2,
2554: p_sub_type_rec IN csi_txn_sub_types%rowtype,
2555: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
2556: p_instance_index IN binary_integer,
2557: p_dest_location_rec IN csi_process_txn_grp.dest_location_rec,
2558: p_instance_rec IN OUT NOCOPY csi_process_txn_grp.txn_instance_rec,
2559: p_i_parties_tbl IN OUT NOCOPY csi_process_txn_grp.txn_i_parties_tbl,

Line 2796: csi_process_txn_pvt.get_dest_instance_id(

2792:
2793: /* check if a destination instance is found , if found then update
2794: the destination instance otherwise create
2795: */
2796: csi_process_txn_pvt.get_dest_instance_id(
2797: p_in_out_flag => p_in_out_flag,
2798: p_sub_type_rec => p_sub_type_rec,
2799: p_instance_rec => p_instance_rec,
2800: p_dest_location_rec => p_dest_location_rec,

Line 2806: debug('csi_process_txn_pvt.get_dest_instance_id Failed.');

2802: x_instance_id => l_dest_instance_id,
2803: x_return_status => l_return_status);
2804:
2805: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2806: debug('csi_process_txn_pvt.get_dest_instance_id Failed.');
2807: RAISE fnd_api.g_exc_error;
2808: END IF;
2809:
2810: IF nvl(l_dest_instance_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

Line 3644: csi_process_txn_pvt.get_dest_instance_id(

3640: -- 155 - item uninstall
3641: -- 109 - in service
3642: l_dest_instance_id := fnd_api.g_miss_num;
3643: ELSE
3644: csi_process_txn_pvt.get_dest_instance_id(
3645: p_in_out_flag => p_in_out_flag,
3646: p_sub_type_rec => p_sub_type_rec,
3647: p_instance_rec => p_instance_rec,
3648: p_dest_location_rec => p_dest_location_rec,

Line 3898: csi_process_txn_pvt.get_src_instance_id(

3894:
3895: debug('ship/install operation of a non serial/soi item');
3896:
3897: -- decrement source instance
3898: csi_process_txn_pvt.get_src_instance_id(
3899: p_in_out_flag => p_in_out_flag,
3900: p_sub_type_rec => p_sub_type_rec,
3901: p_instance_rec => p_instance_rec,
3902: p_dest_location_rec => p_dest_location_rec,

Line 4639: END csi_process_txn_pvt;

4635: WHEN fnd_api.g_exc_error THEN
4636: x_return_status := fnd_api.g_ret_sts_error;
4637: END check_and_break_relation;
4638:
4639: END csi_process_txn_pvt;