eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.INV_QUANTITY_TREE_PVT dependencies on FND_API

Line 264: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

260: -- x_tree_id used later to refer to the same tree
261: --
262: PROCEDURE create_tree
263: ( p_api_version_number IN NUMBER
264: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
265: , x_return_status OUT NOCOPY VARCHAR2
266: , x_msg_count OUT NOCOPY NUMBER
267: , x_msg_data OUT NOCOPY VARCHAR2
268: , p_organization_id IN NUMBER

Line 291: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

287:
288: -- invConv changes begin : OVERLOAD ANYWAY.
289: PROCEDURE create_tree
290: ( p_api_version_number IN NUMBER
291: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
292: , x_return_status OUT NOCOPY VARCHAR2
293: , x_msg_count OUT NOCOPY NUMBER
294: , x_msg_data OUT NOCOPY VARCHAR2
295: , p_organization_id IN NUMBER

Line 348: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

344: -- x_atr atr
345: --
346: PROCEDURE query_tree
347: ( p_api_version_number IN NUMBER
348: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
349: , x_return_status OUT NOCOPY VARCHAR2
350: , x_msg_count OUT NOCOPY NUMBER
351: , x_msg_data OUT NOCOPY VARCHAR2
352: , p_tree_id IN INTEGER

Line 372: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

368:
369: -- invConv changes begin : overload
370: PROCEDURE query_tree
371: ( p_api_version_number IN NUMBER
372: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
373: , x_return_status OUT NOCOPY VARCHAR2
374: , x_msg_count OUT NOCOPY NUMBER
375: , x_msg_data OUT NOCOPY VARCHAR2
376: , p_tree_id IN INTEGER

Line 410: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

406: -- PQOH of 0.
407:
408: PROCEDURE query_tree
409: ( p_api_version_number IN NUMBER
410: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
411: , x_return_status OUT NOCOPY VARCHAR2
412: , x_msg_count OUT NOCOPY NUMBER
413: , x_msg_data OUT NOCOPY VARCHAR2
414: , p_tree_id IN INTEGER

Line 435: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

431:
432: -- invConv changes begin: overload
433: PROCEDURE query_tree
434: ( p_api_version_number IN NUMBER
435: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
436: , x_return_status OUT NOCOPY VARCHAR2
437: , x_msg_count OUT NOCOPY NUMBER
438: , x_msg_data OUT NOCOPY VARCHAR2
439: , p_tree_id IN INTEGER

Line 500: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

496: -- x_att att after the update
497: -- x_atr atr after the update
498: PROCEDURE update_quantities
499: ( p_api_version_number IN NUMBER
500: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
501: , x_return_status OUT NOCOPY VARCHAR2
502: , x_msg_count OUT NOCOPY NUMBER
503: , x_msg_data OUT NOCOPY VARCHAR2
504: , p_tree_id IN INTEGER

Line 527: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

523:
524: -- invConv changes begin: overload
525: PROCEDURE update_quantities
526: ( p_api_version_number IN NUMBER
527: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
528: , x_return_status OUT NOCOPY VARCHAR2
529: , x_msg_count OUT NOCOPY NUMBER
530: , x_msg_data OUT NOCOPY VARCHAR2
531: , p_tree_id IN INTEGER

Line 582: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

578: -- x_no_violation true if no violation, false otherwise
579: --
580: PROCEDURE do_check
581: ( p_api_version_number IN NUMBER
582: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
583: , x_return_status OUT NOCOPY VARCHAR2
584: , x_msg_count OUT NOCOPY NUMBER
585: , x_msg_data OUT NOCOPY VARCHAR2
586: , p_tree_id IN INTEGER

Line 612: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

608: -- x_no_violation true if no violation, false otherwise
609: --
610: PROCEDURE do_check
611: ( p_api_version_number IN NUMBER
612: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
613: , x_return_status OUT NOCOPY VARCHAR2
614: , x_msg_count OUT NOCOPY NUMBER
615: , x_msg_data OUT NOCOPY VARCHAR2
616: , x_no_violation OUT NOCOPY BOOLEAN

Line 641: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

637: -- x_msg_data standard output parameter
638: --
639: PROCEDURE free_tree
640: ( p_api_version_number IN NUMBER
641: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
642: , x_return_status OUT NOCOPY VARCHAR2
643: , x_msg_count OUT NOCOPY NUMBER
644: , x_msg_data OUT NOCOPY VARCHAR2
645: , p_tree_id IN INTEGER

Line 669: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

665: -- x_msg_data standard output parameter
666: --
667: PROCEDURE free_all
668: ( p_api_version_number IN NUMBER
669: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
670: , x_return_status OUT NOCOPY VARCHAR2
671: , x_msg_count OUT NOCOPY NUMBER
672: , x_msg_data OUT NOCOPY VARCHAR2
673: );

Line 827: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

823: -- do not always have to call release_lock explicitly. The lock is
824: -- released automatically at commit, rollback, or session loss.
825: PROCEDURE lock_tree(
826: p_api_version_number IN NUMBER
827: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
828: , x_return_status OUT NOCOPY VARCHAR2
829: , x_msg_count OUT NOCOPY NUMBER
830: , x_msg_data OUT NOCOPY VARCHAR2
831: , p_organization_id IN NUMBER

Line 846: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

842: -- released automatically at commit, rollback, or session loss.
843:
844: PROCEDURE release_lock(
845: p_api_version_number IN NUMBER
846: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
847: , x_return_status OUT NOCOPY VARCHAR2
848: , x_msg_count OUT NOCOPY NUMBER
849: , x_msg_data OUT NOCOPY VARCHAR2
850: , p_organization_id IN NUMBER

Line 947: -- 1. fnd_api.g_ret_sts_success for success --

943: -- with value of g_pick_release_no --
944: -- Output Parameters --
945: -- x_return_status --
946: -- standard output parameter. Possible values are --
947: -- 1. fnd_api.g_ret_sts_success for success --
948: -- 2. fnd_api.g_ret_sts_exc_error for expected error --
949: -- 3. fnd_api.g_ret_sts_unexp_error for unexpected error --
950: -------------------------------------------------------------------------------
951: PROCEDURE build_sql

Line 948: -- 2. fnd_api.g_ret_sts_exc_error for expected error --

944: -- Output Parameters --
945: -- x_return_status --
946: -- standard output parameter. Possible values are --
947: -- 1. fnd_api.g_ret_sts_success for success --
948: -- 2. fnd_api.g_ret_sts_exc_error for expected error --
949: -- 3. fnd_api.g_ret_sts_unexp_error for unexpected error --
950: -------------------------------------------------------------------------------
951: PROCEDURE build_sql
952: (

Line 949: -- 3. fnd_api.g_ret_sts_unexp_error for unexpected error --

945: -- x_return_status --
946: -- standard output parameter. Possible values are --
947: -- 1. fnd_api.g_ret_sts_success for success --
948: -- 2. fnd_api.g_ret_sts_exc_error for expected error --
949: -- 3. fnd_api.g_ret_sts_unexp_error for unexpected error --
950: -------------------------------------------------------------------------------
951: PROCEDURE build_sql
952: (
953: x_return_status OUT NOCOPY VARCHAR2

Line 1104: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

1100: -- x_att att after the update
1101: -- x_atr atr after the update
1102: PROCEDURE update_quantities_for_form
1103: ( p_api_version_number IN NUMBER
1104: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
1105: , x_return_status OUT NOCOPY VARCHAR2
1106: , x_msg_count OUT NOCOPY NUMBER
1107: , x_msg_data OUT NOCOPY VARCHAR2
1108: , p_tree_id IN INTEGER

Line 1124: , p_call_for_form IN VARCHAR2 DEFAULT fnd_api.g_true

1120: , x_atr OUT NOCOPY NUMBER
1121: , p_transfer_subinventory_code IN VARCHAR2 DEFAULT NULL
1122: , p_cost_group_id IN NUMBER DEFAULT NULL
1123: , p_containerized IN NUMBER DEFAULT g_containerized_false
1124: , p_call_for_form IN VARCHAR2 DEFAULT fnd_api.g_true
1125: ) ;
1126:
1127: -- invConv changes begin: overload
1128: PROCEDURE update_quantities_for_form

Line 1130: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

1126:
1127: -- invConv changes begin: overload
1128: PROCEDURE update_quantities_for_form
1129: ( p_api_version_number IN NUMBER
1130: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
1131: , x_return_status OUT NOCOPY VARCHAR2
1132: , x_msg_count OUT NOCOPY NUMBER
1133: , x_msg_data OUT NOCOPY VARCHAR2
1134: , p_tree_id IN INTEGER

Line 1157: , p_call_for_form IN VARCHAR2 DEFAULT fnd_api.g_true

1153: , x_satr OUT NOCOPY NUMBER -- invConv change
1154: , p_transfer_subinventory_code IN VARCHAR2 DEFAULT NULL
1155: , p_cost_group_id IN NUMBER DEFAULT NULL
1156: , p_containerized IN NUMBER DEFAULT g_containerized_false
1157: , p_call_for_form IN VARCHAR2 DEFAULT fnd_api.g_true
1158: ) ;
1159: -- invConv changes end.
1160:
1161: function do_check_release_locks return boolean;