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.27 2007/08/29 10:41:34 rasahoo 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 400: x_item_attr_rec OUT NOCOPY csi_process_txn_pvt.item_attr_rec,

396: p_in_out_flag IN varchar2,
397: p_sub_type_rec IN csi_txn_sub_types%rowtype,
398: p_inventory_item_id IN number,
399: p_organization_id IN number,
400: x_item_attr_rec OUT NOCOPY csi_process_txn_pvt.item_attr_rec,
401: x_return_status OUT NOCOPY varchar2)
402: IS
403:
404: l_item_attr_rec csi_process_txn_pvt.item_attr_rec;

Line 404: l_item_attr_rec csi_process_txn_pvt.item_attr_rec;

400: x_item_attr_rec OUT NOCOPY csi_process_txn_pvt.item_attr_rec,
401: x_return_status OUT NOCOPY varchar2)
402: IS
403:
404: l_item_attr_rec csi_process_txn_pvt.item_attr_rec;
405:
406: l_serial_code mtl_system_items.serial_number_control_code%TYPE;
407: l_lot_code mtl_system_items.lot_control_code%TYPE;
408: l_locator_code mtl_system_items.location_control_code%TYPE;

Line 528: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,

524: /* -------------------------------------------------------------------- */
525:
526: PROCEDURE validate_instance_rec(
527: p_instance_rec IN csi_process_txn_grp.txn_instance_rec,
528: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
529: x_return_status OUT NOCOPY varchar2)
530: IS
531: BEGIN
532:

Line 611: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,

607: p_in_out_flag IN varchar2,
608: p_sub_type_rec IN csi_txn_sub_types%rowtype,
609: p_instance_rec IN csi_process_txn_grp.txn_instance_rec,
610: p_dest_location_rec IN csi_process_txn_grp.dest_location_rec,
611: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
612: x_instance_query_rec OUT NOCOPY csi_datastructures_pub.instance_query_rec,
613: x_return_status OUT NOCOPY varchar2)
614: IS
615:

Line 876: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,

872: p_in_out_flag IN varchar2,
873: p_sub_type_rec IN csi_txn_sub_types%rowtype,
874: p_instance_rec IN csi_process_txn_grp.txn_instance_rec,
875: p_dest_location_rec IN csi_process_txn_grp.dest_location_rec,
876: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
877: p_transaction_rec IN OUT NOCOPY csi_datastructures_pub.transaction_rec,
878: x_instance_id OUT NOCOPY number,
879: x_return_status OUT NOCOPY varchar2)
880: IS

Line 996: csi_process_txn_pvt.create_zero_qty_instance(

992: l_negative_code := nvl(fnd_profile.value('inv_override_neg_for_backflush'), 2);
993: END IF;
994: IF l_negative_code = 1 and p_item_attr_rec.src_serial_control_flag = 'N' THEN
995: debug('Org allows negative quantities. So creating an instance with 0 quantity.');
996: csi_process_txn_pvt.create_zero_qty_instance(
997: p_instance_rec => p_instance_rec,
998: p_txn_rec => p_transaction_rec,
999: x_instance_id => x_instance_id,
1000: x_return_status => l_return_status);

Line 1077: csi_process_txn_pvt.create_zero_qty_instance(

1073: raise fnd_api.g_exc_error;
1074: END IF;
1075: IF l_negative_code = 1 and p_item_attr_rec.src_serial_control_flag = 'N' THEN
1076: debug('Org allows negative quantities. So creating an instance with 0 quantity.');
1077: csi_process_txn_pvt.create_zero_qty_instance(
1078: p_instance_rec => p_instance_rec,
1079: p_txn_rec => p_transaction_rec,
1080: x_instance_id => x_instance_id,
1081: x_return_status => l_return_status);

Line 1142: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,

1138: p_in_out_flag IN varchar2,
1139: p_sub_type_rec IN csi_txn_sub_types%rowtype,
1140: p_instance_rec IN csi_process_txn_grp.txn_instance_rec,
1141: p_dest_location_rec IN csi_process_txn_grp.dest_location_rec,
1142: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
1143: x_instance_id OUT NOCOPY number,
1144: x_return_status OUT NOCOPY varchar2)
1145:
1146: IS

Line 1253: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,

1249: /* ---------------------------------------------------------------------*/
1250:
1251: PROCEDURE build_instance_rec(
1252: p_sub_type_rec IN csi_txn_sub_types%rowtype,
1253: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
1254: p_instance_rec IN csi_process_txn_grp.txn_instance_rec,
1255: p_dest_location_rec IN csi_process_txn_grp.dest_location_rec,
1256: x_instance_rec OUT NOCOPY csi_datastructures_pub.instance_rec,
1257: x_process_mode OUT NOCOPY varchar2,

Line 2181: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,

2177: x_return_status := fnd_api.g_ret_sts_error;
2178: END unexpire_instance;
2179:
2180: PROCEDURE preserve_ownership(
2181: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
2182: p_instance_rec IN csi_datastructures_pub.instance_rec,
2183: px_parties_tbl IN OUT nocopy csi_datastructures_pub.party_tbl,
2184: px_pty_accts_tbl IN OUT nocopy csi_datastructures_pub.party_account_tbl,
2185: x_return_status OUT nocopy varchar2)

Line 2293: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,

2289:
2290: PROCEDURE process_ib(
2291: p_in_out_flag IN varchar2,
2292: p_sub_type_rec IN csi_txn_sub_types%rowtype,
2293: p_item_attr_rec IN csi_process_txn_pvt.item_attr_rec,
2294: p_instance_index IN binary_integer,
2295: p_dest_location_rec IN csi_process_txn_grp.dest_location_rec,
2296: p_instance_rec IN OUT NOCOPY csi_process_txn_grp.txn_instance_rec,
2297: p_i_parties_tbl IN OUT NOCOPY csi_process_txn_grp.txn_i_parties_tbl,

Line 2534: csi_process_txn_pvt.get_dest_instance_id(

2530:
2531: /* check if a destination instance is found , if found then update
2532: the destination instance otherwise create
2533: */
2534: csi_process_txn_pvt.get_dest_instance_id(
2535: p_in_out_flag => p_in_out_flag,
2536: p_sub_type_rec => p_sub_type_rec,
2537: p_instance_rec => p_instance_rec,
2538: p_dest_location_rec => p_dest_location_rec,

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

2540: x_instance_id => l_dest_instance_id,
2541: x_return_status => l_return_status);
2542:
2543: IF l_return_status <> fnd_api.g_ret_sts_success THEN
2544: debug('csi_process_txn_pvt.get_dest_instance_id Failed.');
2545: RAISE fnd_api.g_exc_error;
2546: END IF;
2547:
2548: IF nvl(l_dest_instance_id, fnd_api.g_miss_num) = fnd_api.g_miss_num THEN

Line 3330: csi_process_txn_pvt.get_dest_instance_id(

3326: -- 155 - item uninstall
3327: -- 109 - in service
3328: l_dest_instance_id := fnd_api.g_miss_num;
3329: ELSE
3330: csi_process_txn_pvt.get_dest_instance_id(
3331: p_in_out_flag => p_in_out_flag,
3332: p_sub_type_rec => p_sub_type_rec,
3333: p_instance_rec => p_instance_rec,
3334: p_dest_location_rec => p_dest_location_rec,

Line 3534: csi_process_txn_pvt.get_src_instance_id(

3530:
3531: debug('ship/install operation of a non serial/soi item');
3532:
3533: -- decrement source instance
3534: csi_process_txn_pvt.get_src_instance_id(
3535: p_in_out_flag => p_in_out_flag,
3536: p_sub_type_rec => p_sub_type_rec,
3537: p_instance_rec => p_instance_rec,
3538: p_dest_location_rec => p_dest_location_rec,

Line 4275: END csi_process_txn_pvt;

4271: WHEN fnd_api.g_exc_error THEN
4272: x_return_status := fnd_api.g_ret_sts_error;
4273: END check_and_break_relation;
4274:
4275: END csi_process_txn_pvt;