1877: l_status INTEGER;
1878:
1879: BEGIN
1880: print_debug('... in lock_tree... will create a dbms_lock...');
1881: -- Standard call to check for call compatibility
1882: IF NOT fnd_api.compatible_api_call( l_api_version_number
1883: , p_api_version_number
1884: , l_api_name
1885: , G_PKG_NAME
1981: l_lock_handle VARCHAR2(128);
1982: l_status INTEGER;
1983: BEGIN
1984: print_debug('... in release_lock ...');
1985: -- Standard call to check for call compatibility
1986: IF NOT fnd_api.compatible_api_call(l_api_version_number
1987: , p_api_version_number
1988: , l_api_name
1989: , G_PKG_NAME
2765: -- p_quantity_type
2766: -- p_set_check_mark whether to set do_check mark to the appropriate
2767: -- nodes
2768: -- Output Parameters
2769: -- x_return_status Standard Output Parameters
2770:
2771: -- Bug 2486318. The do check does not work. Trasactions get committed
2772: -- even if there is a node violation. Added p_check_mark_node_only to mark
2773: -- the nodes.
9689: -- Current version 1.0
9690: -- Initial version 1.0
9691: --
9692: -- Input parameters:
9693: -- p_api_version_number standard input parameter
9694: -- p_init_msg_lst standard input parameter
9695: -- p_tree_id tree_id
9696: -- p_revision revision
9697: -- p_lot_number lot_number
9690: -- Initial version 1.0
9691: --
9692: -- Input parameters:
9693: -- p_api_version_number standard input parameter
9694: -- p_init_msg_lst standard input parameter
9695: -- p_tree_id tree_id
9696: -- p_revision revision
9697: -- p_lot_number lot_number
9698: -- p_subinventory_code subinventory code
9698: -- p_subinventory_code subinventory code
9699: -- p_locator_id locator_id
9700: --
9701: -- Output parameters:
9702: -- x_return_status standard output parameter
9703: -- x_msg_count standard output parameter
9704: -- x_msg_data standard output parameter
9705: -- x_qoh qoh
9706: -- x_rqoh rqoh
9699: -- p_locator_id locator_id
9700: --
9701: -- Output parameters:
9702: -- x_return_status standard output parameter
9703: -- x_msg_count standard output parameter
9704: -- x_msg_data standard output parameter
9705: -- x_qoh qoh
9706: -- x_rqoh rqoh
9707: -- x_qr qr
9700: --
9701: -- Output parameters:
9702: -- x_return_status standard output parameter
9703: -- x_msg_count standard output parameter
9704: -- x_msg_data standard output parameter
9705: -- x_qoh qoh
9706: -- x_rqoh rqoh
9707: -- x_qr qr
9708: -- x_qs qs
9834: IF g_debug = 1 THEN
9835: print_debug(l_api_name || ' Entered',9);
9836: END IF;
9837:
9838: -- Standard call to check for call compatibility
9839: IF NOT fnd_api.compatible_api_call(l_api_version_number
9840: , p_api_version_number
9841: , l_api_name
9842: , G_PKG_NAME
10700: -- Current version 1.0
10701: -- Initial version 1.0
10702: --
10703: -- Input parameters:
10704: -- p_api_version_number standard input parameter
10705: -- p_init_msg_lst standard input parameter
10706: -- p_organization_id organzation id
10707: -- p_inventory_item_id inventory_item_id
10708: -- p_tree_mode tree mode, either g_reservation_mode
10701: -- Initial version 1.0
10702: --
10703: -- Input parameters:
10704: -- p_api_version_number standard input parameter
10705: -- p_init_msg_lst standard input parameter
10706: -- p_organization_id organzation id
10707: -- p_inventory_item_id inventory_item_id
10708: -- p_tree_mode tree mode, either g_reservation_mode
10709: -- or g_transaction_mode
10720: -- p_pick_release whether qty tree called from pick release
10721: -- process or not
10722: --
10723: -- Output parameters:
10724: -- x_return_status standard output parameter
10725: -- x_msg_count standard output parameter
10726: -- x_msg_data standard output parameter
10727: -- x_tree_id used later to refer to the same tree
10728: --
10721: -- process or not
10722: --
10723: -- Output parameters:
10724: -- x_return_status standard output parameter
10725: -- x_msg_count standard output parameter
10726: -- x_msg_data standard output parameter
10727: -- x_tree_id used later to refer to the same tree
10728: --
10729: PROCEDURE create_tree
10722: --
10723: -- Output parameters:
10724: -- x_return_status standard output parameter
10725: -- x_msg_count standard output parameter
10726: -- x_msg_data standard output parameter
10727: -- x_tree_id used later to refer to the same tree
10728: --
10729: PROCEDURE create_tree
10730: ( p_api_version_number IN NUMBER
10884: else
10885: print_debug(' >>>>>>>>> In create_tree. mode='||p_tree_mode||', grade='||p_grade_code||', rev_ctl=FALSE. mat_stat='||INV_QUANTITY_TREE_PVT.g_is_mat_status_used);
10886: end if;
10887:
10888: -- Standard call to check for call compatibility
10889: IF NOT fnd_api.compatible_api_call(l_api_version_number
10890: , p_api_version_number
10891: , l_api_name
10892: , G_PKG_NAME
11626: -- Current version 1.0
11627: -- Initial version 1.0
11628: --
11629: -- Input parameters:
11630: -- p_api_version_number standard input parameter
11631: -- p_init_msg_lst standard input parameter
11632: -- p_tree_id tree id
11633: --
11634: -- Output parameters:
11627: -- Initial version 1.0
11628: --
11629: -- Input parameters:
11630: -- p_api_version_number standard input parameter
11631: -- p_init_msg_lst standard input parameter
11632: -- p_tree_id tree id
11633: --
11634: -- Output parameters:
11635: -- x_return_status standard output parameter
11631: -- p_init_msg_lst standard input parameter
11632: -- p_tree_id tree id
11633: --
11634: -- Output parameters:
11635: -- x_return_status standard output parameter
11636: -- x_msg_count standard output parameter
11637: -- x_msg_data standard output parameter
11638: -- x_no_violation true if no violation, false otherwise
11639: --
11632: -- p_tree_id tree id
11633: --
11634: -- Output parameters:
11635: -- x_return_status standard output parameter
11636: -- x_msg_count standard output parameter
11637: -- x_msg_data standard output parameter
11638: -- x_no_violation true if no violation, false otherwise
11639: --
11640: PROCEDURE do_check_pvt
11633: --
11634: -- Output parameters:
11635: -- x_return_status standard output parameter
11636: -- x_msg_count standard output parameter
11637: -- x_msg_data standard output parameter
11638: -- x_no_violation true if no violation, false otherwise
11639: --
11640: PROCEDURE do_check_pvt
11641: ( p_api_version_number IN NUMBER
11652: l_no_violation BOOLEAN;
11653: BEGIN
11654: print_debug('Entering do_check_pvt. tree_id='||p_tree_id);
11655:
11656: -- Standard call to check for call compatibility
11657: IF NOT fnd_api.compatible_api_call(l_api_version_number
11658: , p_api_version_number
11659: , l_api_name
11660: , G_PKG_NAME
11796: -- Current version 1.0
11797: -- Initial version 1.0
11798: --
11799: -- Input parameters:
11800: -- p_api_version_number standard input parameter
11801: -- p_init_msg_lst standard input parameter
11802: --
11803: -- Output parameters:
11804: -- x_return_status standard output parameter
11797: -- Initial version 1.0
11798: --
11799: -- Input parameters:
11800: -- p_api_version_number standard input parameter
11801: -- p_init_msg_lst standard input parameter
11802: --
11803: -- Output parameters:
11804: -- x_return_status standard output parameter
11805: -- x_msg_count standard output parameter
11800: -- p_api_version_number standard input parameter
11801: -- p_init_msg_lst standard input parameter
11802: --
11803: -- Output parameters:
11804: -- x_return_status standard output parameter
11805: -- x_msg_count standard output parameter
11806: -- x_msg_data standard output parameter
11807: -- x_no_violation true if no violation, false otherwise
11808: --
11801: -- p_init_msg_lst standard input parameter
11802: --
11803: -- Output parameters:
11804: -- x_return_status standard output parameter
11805: -- x_msg_count standard output parameter
11806: -- x_msg_data standard output parameter
11807: -- x_no_violation true if no violation, false otherwise
11808: --
11809: PROCEDURE do_check
11802: --
11803: -- Output parameters:
11804: -- x_return_status standard output parameter
11805: -- x_msg_count standard output parameter
11806: -- x_msg_data standard output parameter
11807: -- x_no_violation true if no violation, false otherwise
11808: --
11809: PROCEDURE do_check
11810: ( p_api_version_number IN NUMBER
11826: END IF;
11827:
11828: print_debug('Entering do_check, tree_id='||p_tree_id, 9);
11829:
11830: -- Standard call to check for call compatibility
11831: IF NOT fnd_api.compatible_api_call(l_api_version_number
11832: , p_api_version_number
11833: , l_api_name
11834: , G_PKG_NAME
11926: -- Current version 1.0
11927: -- Initial version 1.0
11928: --
11929: -- Input parameters:
11930: -- p_api_version_number standard input parameter
11931: -- p_init_msg_lst standard input parameter
11932: --
11933: -- Output parameters:
11934: -- x_return_status standard output parameter
11927: -- Initial version 1.0
11928: --
11929: -- Input parameters:
11930: -- p_api_version_number standard input parameter
11931: -- p_init_msg_lst standard input parameter
11932: --
11933: -- Output parameters:
11934: -- x_return_status standard output parameter
11935: -- x_msg_count standard output parameter
11930: -- p_api_version_number standard input parameter
11931: -- p_init_msg_lst standard input parameter
11932: --
11933: -- Output parameters:
11934: -- x_return_status standard output parameter
11935: -- x_msg_count standard output parameter
11936: -- x_msg_data standard output parameter
11937: -- x_no_violation true if no violation, false otherwise
11938: --
11931: -- p_init_msg_lst standard input parameter
11932: --
11933: -- Output parameters:
11934: -- x_return_status standard output parameter
11935: -- x_msg_count standard output parameter
11936: -- x_msg_data standard output parameter
11937: -- x_no_violation true if no violation, false otherwise
11938: --
11939: PROCEDURE do_check
11932: --
11933: -- Output parameters:
11934: -- x_return_status standard output parameter
11935: -- x_msg_count standard output parameter
11936: -- x_msg_data standard output parameter
11937: -- x_no_violation true if no violation, false otherwise
11938: --
11939: PROCEDURE do_check
11940: ( p_api_version_number IN NUMBER
11964: IF g_debug = 1 THEN
11965: print_debug(l_api_name || ' Entered',9);
11966: END IF;
11967:
11968: -- Standard call to check for call compatibility
11969: IF NOT fnd_api.compatible_api_call(l_api_version_number
11970: , p_api_version_number
11971: , l_api_name
11972: , G_PKG_NAME
12095: -- Current version 1.0
12096: -- Initial version 1.0
12097: --
12098: -- Input parameters:
12099: -- p_api_version_number standard input parameter
12100: -- p_init_msg_lst standard input parameter
12101: -- p_tree_id tree id
12102: --
12103: -- Output parameters:
12096: -- Initial version 1.0
12097: --
12098: -- Input parameters:
12099: -- p_api_version_number standard input parameter
12100: -- p_init_msg_lst standard input parameter
12101: -- p_tree_id tree id
12102: --
12103: -- Output parameters:
12104: -- x_return_status standard output parameter
12100: -- p_init_msg_lst standard input parameter
12101: -- p_tree_id tree id
12102: --
12103: -- Output parameters:
12104: -- x_return_status standard output parameter
12105: -- x_msg_count standard output parameter
12106: -- x_msg_data standard output parameter
12107: --
12108: PROCEDURE free_tree_pvt
12101: -- p_tree_id tree id
12102: --
12103: -- Output parameters:
12104: -- x_return_status standard output parameter
12105: -- x_msg_count standard output parameter
12106: -- x_msg_data standard output parameter
12107: --
12108: PROCEDURE free_tree_pvt
12109: ( p_api_version_number IN NUMBER
12102: --
12103: -- Output parameters:
12104: -- x_return_status standard output parameter
12105: -- x_msg_count standard output parameter
12106: -- x_msg_data standard output parameter
12107: --
12108: PROCEDURE free_tree_pvt
12109: ( p_api_version_number IN NUMBER
12110: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
12117: l_api_name CONSTANT VARCHAR2(30) := 'Free_Tree_Pvt';
12118: l_return_status VARCHAR2(1) := fnd_api.g_ret_sts_success;
12119: BEGIN
12120:
12121: -- Standard call to check for call compatibility
12122: IF NOT fnd_api.compatible_api_call(l_api_version_number
12123: , p_api_version_number
12124: , l_api_name
12125: , G_PKG_NAME
12187: -- Current version 1.0
12188: -- Initial version 1.0
12189: --
12190: -- Input parameters:
12191: -- p_api_version_number standard input parameter
12192: -- p_init_msg_lst standard input parameter
12193: --
12194: -- Output parameters:
12195: -- x_return_status standard output parameter
12188: -- Initial version 1.0
12189: --
12190: -- Input parameters:
12191: -- p_api_version_number standard input parameter
12192: -- p_init_msg_lst standard input parameter
12193: --
12194: -- Output parameters:
12195: -- x_return_status standard output parameter
12196: -- x_msg_count standard output parameter
12191: -- p_api_version_number standard input parameter
12192: -- p_init_msg_lst standard input parameter
12193: --
12194: -- Output parameters:
12195: -- x_return_status standard output parameter
12196: -- x_msg_count standard output parameter
12197: -- x_msg_data standard output parameter
12198: --
12199: PROCEDURE free_tree
12192: -- p_init_msg_lst standard input parameter
12193: --
12194: -- Output parameters:
12195: -- x_return_status standard output parameter
12196: -- x_msg_count standard output parameter
12197: -- x_msg_data standard output parameter
12198: --
12199: PROCEDURE free_tree
12200: ( p_api_version_number IN NUMBER
12193: --
12194: -- Output parameters:
12195: -- x_return_status standard output parameter
12196: -- x_msg_count standard output parameter
12197: -- x_msg_data standard output parameter
12198: --
12199: PROCEDURE free_tree
12200: ( p_api_version_number IN NUMBER
12201: , p_init_msg_lst IN VARCHAR2
12216: IF g_debug = 1 THEN
12217: print_debug(l_api_name || ' Entered',9);
12218: END IF;
12219:
12220: -- Standard call to check for call compatibility
12221: IF NOT fnd_api.compatible_api_call(l_api_version_number
12222: , p_api_version_number
12223: , l_api_name
12224: , G_PKG_NAME
12304: -- Current version 1.0
12305: -- Initial version 1.0
12306: --
12307: -- Input parameters:
12308: -- p_api_version_number standard input parameter
12309: -- p_init_msg_lst standard input parameter
12310: --
12311: -- Output parameters:
12312: -- x_return_status standard output parameter
12305: -- Initial version 1.0
12306: --
12307: -- Input parameters:
12308: -- p_api_version_number standard input parameter
12309: -- p_init_msg_lst standard input parameter
12310: --
12311: -- Output parameters:
12312: -- x_return_status standard output parameter
12313: -- x_msg_count standard output parameter
12308: -- p_api_version_number standard input parameter
12309: -- p_init_msg_lst standard input parameter
12310: --
12311: -- Output parameters:
12312: -- x_return_status standard output parameter
12313: -- x_msg_count standard output parameter
12314: -- x_msg_data standard output parameter
12315: --
12316: PROCEDURE free_all
12309: -- p_init_msg_lst standard input parameter
12310: --
12311: -- Output parameters:
12312: -- x_return_status standard output parameter
12313: -- x_msg_count standard output parameter
12314: -- x_msg_data standard output parameter
12315: --
12316: PROCEDURE free_all
12317: ( p_api_version_number IN NUMBER
12310: --
12311: -- Output parameters:
12312: -- x_return_status standard output parameter
12313: -- x_msg_count standard output parameter
12314: -- x_msg_data standard output parameter
12315: --
12316: PROCEDURE free_all
12317: ( p_api_version_number IN NUMBER
12318: , p_init_msg_lst IN VARCHAR2
12328: l_root_id NUMBER;
12329:
12330: BEGIN
12331:
12332: -- Standard call to check for call compatibility
12333: IF NOT fnd_api.compatible_api_call(l_api_version_number
12334: , p_api_version_number
12335: , l_api_name
12336: , G_PKG_NAME
12423: -- Current version 1.0
12424: -- Initial version 1.0
12425: --
12426: -- Input parameters:
12427: -- p_api_version_number standard input parameter
12428: -- p_init_msg_lst standard input parameter
12429: --
12430: -- Output parameters:
12431: -- x_return_status standard output parameter
12424: -- Initial version 1.0
12425: --
12426: -- Input parameters:
12427: -- p_api_version_number standard input parameter
12428: -- p_init_msg_lst standard input parameter
12429: --
12430: -- Output parameters:
12431: -- x_return_status standard output parameter
12432: -- x_msg_count standard output parameter
12427: -- p_api_version_number standard input parameter
12428: -- p_init_msg_lst standard input parameter
12429: --
12430: -- Output parameters:
12431: -- x_return_status standard output parameter
12432: -- x_msg_count standard output parameter
12433: -- x_msg_data standard output parameter
12434: --
12435: PROCEDURE mark_all_for_refresh
12428: -- p_init_msg_lst standard input parameter
12429: --
12430: -- Output parameters:
12431: -- x_return_status standard output parameter
12432: -- x_msg_count standard output parameter
12433: -- x_msg_data standard output parameter
12434: --
12435: PROCEDURE mark_all_for_refresh
12436: ( p_api_version_number IN NUMBER
12429: --
12430: -- Output parameters:
12431: -- x_return_status standard output parameter
12432: -- x_msg_count standard output parameter
12433: -- x_msg_data standard output parameter
12434: --
12435: PROCEDURE mark_all_for_refresh
12436: ( p_api_version_number IN NUMBER
12437: , p_init_msg_lst IN VARCHAR2
12446: l_root_id NUMBER;
12447:
12448: BEGIN
12449:
12450: -- Standard call to check for call compatibility
12451: IF NOT fnd_api.compatible_api_call(l_api_version_number
12452: , p_api_version_number
12453: , l_api_name
12454: , G_PKG_NAME
12517: -- Current version 1.0
12518: -- Initial version 1.0
12519: --
12520: -- Input parameters:
12521: -- p_api_version_number standard input parameter
12522: -- p_init_msg_lst standard input parameter
12523: -- p_tree_id tree_id
12524: -- p_revision revision
12525: -- p_lot_number lot_number
12518: -- Initial version 1.0
12519: --
12520: -- Input parameters:
12521: -- p_api_version_number standard input parameter
12522: -- p_init_msg_lst standard input parameter
12523: -- p_tree_id tree_id
12524: -- p_revision revision
12525: -- p_lot_number lot_number
12526: -- p_subinventory_code subinventory_code
12528: -- p_primary_quantity primary_quantity
12529: -- p_quantity_type
12530: --
12531: -- Output parameters:
12532: -- x_return_status standard output parameter
12533: -- x_msg_count standard output parameter
12534: -- x_msg_data standard output parameter
12535: -- x_tree_id used later to refer to the same tree
12536: -- x_qoh qoh after the update
12529: -- p_quantity_type
12530: --
12531: -- Output parameters:
12532: -- x_return_status standard output parameter
12533: -- x_msg_count standard output parameter
12534: -- x_msg_data standard output parameter
12535: -- x_tree_id used later to refer to the same tree
12536: -- x_qoh qoh after the update
12537: -- x_rqoh rqoh after the update
12530: --
12531: -- Output parameters:
12532: -- x_return_status standard output parameter
12533: -- x_msg_count standard output parameter
12534: -- x_msg_data standard output parameter
12535: -- x_tree_id used later to refer to the same tree
12536: -- x_qoh qoh after the update
12537: -- x_rqoh rqoh after the update
12538: -- x_qr qr after the update
12650: END IF;
12651:
12652: print_debug('Entering update_quantities. primQty='||p_primary_quantity||', secQty='||p_secondary_quantity);
12653:
12654: -- Standard call to check for call compatibility
12655: IF NOT fnd_api.compatible_api_call(l_api_version_number
12656: , p_api_version_number
12657: , l_api_name
12658: , G_PKG_NAME
12800: -- Current version 1.0
12801: -- Initial version 1.0
12802: --
12803: -- Input parameters:
12804: -- p_api_version_number standard input parameter
12805: -- p_init_msg_lst standard input parameter
12806: -- p_tree_id tree_id
12807: -- p_revision revision
12808: -- p_lot_number lot_number
12801: -- Initial version 1.0
12802: --
12803: -- Input parameters:
12804: -- p_api_version_number standard input parameter
12805: -- p_init_msg_lst standard input parameter
12806: -- p_tree_id tree_id
12807: -- p_revision revision
12808: -- p_lot_number lot_number
12809: -- p_subinventory_code subinventory_code
12812: -- p_quantity_type
12813: -- p_call_for_form to check if the call is from form
12814: --
12815: -- Output parameters:
12816: -- x_return_status standard output parameter
12817: -- x_msg_count standard output parameter
12818: -- x_msg_data standard output parameter
12819: -- x_tree_id used later to refer to the same tree
12820: -- x_qoh qoh after the update
12813: -- p_call_for_form to check if the call is from form
12814: --
12815: -- Output parameters:
12816: -- x_return_status standard output parameter
12817: -- x_msg_count standard output parameter
12818: -- x_msg_data standard output parameter
12819: -- x_tree_id used later to refer to the same tree
12820: -- x_qoh qoh after the update
12821: -- x_rqoh rqoh after the update
12814: --
12815: -- Output parameters:
12816: -- x_return_status standard output parameter
12817: -- x_msg_count standard output parameter
12818: -- x_msg_data standard output parameter
12819: -- x_tree_id used later to refer to the same tree
12820: -- x_qoh qoh after the update
12821: -- x_rqoh rqoh after the update
12822: -- x_qr qr after the update
12936: IF g_debug = 1 THEN
12937: print_debug(l_api_name || ' Entered',9);
12938: END IF;
12939:
12940: -- Standard call to check for call compatibility
12941: IF NOT fnd_api.compatible_api_call(l_api_version_number
12942: , p_api_version_number
12943: , l_api_name
12944: , G_PKG_NAME
13441: return TRUE;
13442: end;
13443:
13444: -------------------------------------------------------------------------------
13445: -- Coding standard used in this program
13446: -- 1. PLSQL business object api coding standard
13447: -- 2. Oracle application developer's guide
13448: -- Note:
13449: -- 1. Data types are not initialized to fnd_api.g_miss_???
13442: end;
13443:
13444: -------------------------------------------------------------------------------
13445: -- Coding standard used in this program
13446: -- 1. PLSQL business object api coding standard
13447: -- 2. Oracle application developer's guide
13448: -- Note:
13449: -- 1. Data types are not initialized to fnd_api.g_miss_???
13450: -- 2. Procedures or functions not exposed to user do not have the following parameters: