DBA Data[Home] [Help]

APPS.INV_QUANTITY_TREE_PVT dependencies on FND_API

Line 262: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

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

Line 288: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

284: );
285:
286: PROCEDURE create_tree
287: ( p_api_version_number IN NUMBER
288: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
289: , x_return_status OUT NOCOPY VARCHAR2
290: , x_msg_count OUT NOCOPY NUMBER
291: , x_msg_data OUT NOCOPY VARCHAR2
292: , p_organization_id IN NUMBER

Line 345: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

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

Line 368: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

364: );
365:
366: PROCEDURE query_tree
367: ( p_api_version_number IN NUMBER
368: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
369: , x_return_status OUT NOCOPY VARCHAR2
370: , x_msg_count OUT NOCOPY NUMBER
371: , x_msg_data OUT NOCOPY VARCHAR2
372: , p_tree_id IN INTEGER

Line 405: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

401: -- PQOH of 0.
402:
403: PROCEDURE query_tree
404: ( p_api_version_number IN NUMBER
405: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
406: , x_return_status OUT NOCOPY VARCHAR2
407: , x_msg_count OUT NOCOPY NUMBER
408: , x_msg_data OUT NOCOPY VARCHAR2
409: , p_tree_id IN INTEGER

Line 429: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

425: );
426:
427: PROCEDURE query_tree
428: ( p_api_version_number IN NUMBER
429: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
430: , x_return_status OUT NOCOPY VARCHAR2
431: , x_msg_count OUT NOCOPY NUMBER
432: , x_msg_data OUT NOCOPY VARCHAR2
433: , p_tree_id IN INTEGER

Line 493: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

489: -- x_att att after the update
490: -- x_atr atr after the update
491: PROCEDURE update_quantities
492: ( p_api_version_number IN NUMBER
493: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
494: , x_return_status OUT NOCOPY VARCHAR2
495: , x_msg_count OUT NOCOPY NUMBER
496: , x_msg_data OUT NOCOPY VARCHAR2
497: , p_tree_id IN INTEGER

Line 519: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

515: ) ;
516:
517: PROCEDURE update_quantities
518: ( p_api_version_number IN NUMBER
519: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
520: , x_return_status OUT NOCOPY VARCHAR2
521: , x_msg_count OUT NOCOPY NUMBER
522: , x_msg_data OUT NOCOPY VARCHAR2
523: , p_tree_id IN INTEGER

Line 573: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

569: -- x_no_violation true if no violation, false otherwise
570: --
571: PROCEDURE do_check
572: ( p_api_version_number IN NUMBER
573: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
574: , x_return_status OUT NOCOPY VARCHAR2
575: , x_msg_count OUT NOCOPY NUMBER
576: , x_msg_data OUT NOCOPY VARCHAR2
577: , p_tree_id IN INTEGER

Line 603: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

599: -- x_no_violation true if no violation, false otherwise
600: --
601: PROCEDURE do_check
602: ( p_api_version_number IN NUMBER
603: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
604: , x_return_status OUT NOCOPY VARCHAR2
605: , x_msg_count OUT NOCOPY NUMBER
606: , x_msg_data OUT NOCOPY VARCHAR2
607: , x_no_violation OUT NOCOPY BOOLEAN

Line 632: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

628: -- x_msg_data standard output parameter
629: --
630: PROCEDURE free_tree
631: ( p_api_version_number IN NUMBER
632: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
633: , x_return_status OUT NOCOPY VARCHAR2
634: , x_msg_count OUT NOCOPY NUMBER
635: , x_msg_data OUT NOCOPY VARCHAR2
636: , p_tree_id IN INTEGER

Line 660: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

656: -- x_msg_data standard output parameter
657: --
658: PROCEDURE free_all
659: ( p_api_version_number IN NUMBER
660: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
661: , x_return_status OUT NOCOPY VARCHAR2
662: , x_msg_count OUT NOCOPY NUMBER
663: , x_msg_data OUT NOCOPY VARCHAR2
664: );

Line 818: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

814: -- do not always have to call release_lock explicitly. The lock is
815: -- released automatically at commit, rollback, or session loss.
816: PROCEDURE lock_tree(
817: p_api_version_number IN NUMBER
818: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
819: , x_return_status OUT NOCOPY VARCHAR2
820: , x_msg_count OUT NOCOPY NUMBER
821: , x_msg_data OUT NOCOPY VARCHAR2
822: , p_organization_id IN NUMBER

Line 837: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

833: -- released automatically at commit, rollback, or session loss.
834:
835: PROCEDURE release_lock(
836: p_api_version_number IN NUMBER
837: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
838: , x_return_status OUT NOCOPY VARCHAR2
839: , x_msg_count OUT NOCOPY NUMBER
840: , x_msg_data OUT NOCOPY VARCHAR2
841: , p_organization_id IN NUMBER

Line 952: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

948: -- x_att att after the update
949: -- x_atr atr after the update
950: PROCEDURE update_quantities_for_form
951: ( p_api_version_number IN NUMBER
952: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
953: , x_return_status OUT NOCOPY VARCHAR2
954: , x_msg_count OUT NOCOPY NUMBER
955: , x_msg_data OUT NOCOPY VARCHAR2
956: , p_tree_id IN INTEGER

Line 972: , p_call_for_form IN VARCHAR2 DEFAULT fnd_api.g_true

968: , x_atr OUT NOCOPY NUMBER
969: , p_transfer_subinventory_code IN VARCHAR2 DEFAULT NULL
970: , p_cost_group_id IN NUMBER DEFAULT NULL
971: , p_containerized IN NUMBER DEFAULT g_containerized_false
972: , p_call_for_form IN VARCHAR2 DEFAULT fnd_api.g_true
973: , p_lpn_id IN NUMBER DEFAULT NULL --added for bug7038890
974: ) ;
975:
976: PROCEDURE update_quantities_for_form

Line 978: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false

974: ) ;
975:
976: PROCEDURE update_quantities_for_form
977: ( p_api_version_number IN NUMBER
978: , p_init_msg_lst IN VARCHAR2 DEFAULT fnd_api.g_false
979: , x_return_status OUT NOCOPY VARCHAR2
980: , x_msg_count OUT NOCOPY NUMBER
981: , x_msg_data OUT NOCOPY VARCHAR2
982: , p_tree_id IN INTEGER

Line 1005: , p_call_for_form IN VARCHAR2 DEFAULT fnd_api.g_true

1001: , x_satr OUT NOCOPY NUMBER
1002: , p_transfer_subinventory_code IN VARCHAR2 DEFAULT NULL
1003: , p_cost_group_id IN NUMBER DEFAULT NULL
1004: , p_containerized IN NUMBER DEFAULT g_containerized_false
1005: , p_call_for_form IN VARCHAR2 DEFAULT fnd_api.g_true
1006: , p_lpn_id IN NUMBER DEFAULT NULL --added for bug7038890
1007: ) ;
1008:
1009: function do_check_release_locks return boolean;