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.GME_PENDING_PRODUCT_LOTS_PVT dependencies on GME_PENDING_PRODUCT_LOTS

Line 1: PACKAGE gme_pending_product_lots_pvt AUTHID CURRENT_USER AS

1: PACKAGE gme_pending_product_lots_pvt AUTHID CURRENT_USER AS
2: /* $Header: GMEVPPLS.pls 120.11 2011/05/20 14:45:11 gmurator ship $ */
3:
4: g_sequence_increment CONSTANT NUMBER := 100;
5:

Line 35: (p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE

31: ,x_mmli_tbl OUT NOCOPY gme_common_pvt.mtl_trans_lots_inter_tbl
32: ,x_return_status OUT NOCOPY VARCHAR2);
33:
34: PROCEDURE create_pending_product_lot
35: (p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
36: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE
37: ,x_return_status OUT NOCOPY VARCHAR2);
38:
39: PROCEDURE update_pending_product_lot

Line 36: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE

32: ,x_return_status OUT NOCOPY VARCHAR2);
33:
34: PROCEDURE create_pending_product_lot
35: (p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
36: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE
37: ,x_return_status OUT NOCOPY VARCHAR2);
38:
39: PROCEDURE update_pending_product_lot
40: (p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE

Line 40: (p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE

36: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE
37: ,x_return_status OUT NOCOPY VARCHAR2);
38:
39: PROCEDURE update_pending_product_lot
40: (p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
41: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE
42: ,x_return_status OUT NOCOPY VARCHAR2);
43:
44: PROCEDURE delete_pending_product_lot

Line 41: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE

37: ,x_return_status OUT NOCOPY VARCHAR2);
38:
39: PROCEDURE update_pending_product_lot
40: (p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
41: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE
42: ,x_return_status OUT NOCOPY VARCHAR2);
43:
44: PROCEDURE delete_pending_product_lot
45: (p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE

Line 45: (p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE

41: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE
42: ,x_return_status OUT NOCOPY VARCHAR2);
43:
44: PROCEDURE delete_pending_product_lot
45: (p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
46: ,x_return_status OUT NOCOPY VARCHAR2);
47:
48: --Bug#5078853 created the following over loaded procedure
49: PROCEDURE delete_pending_product_lot

Line 60: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE

56: ,x_return_status OUT NOCOPY VARCHAR2);
57:
58: PROCEDURE validate_record_for_create
59: (p_material_detail_rec IN gme_material_details%ROWTYPE
60: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
61: ,p_create_lot IN VARCHAR2
62: ,p_generate_lot IN VARCHAR2
63: ,p_generate_parent_lot IN VARCHAR2
64: ,p_parent_lot IN mtl_lot_numbers.lot_number%TYPE := NULL

Line 67: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE

63: ,p_generate_parent_lot IN VARCHAR2
64: ,p_parent_lot IN mtl_lot_numbers.lot_number%TYPE := NULL
65: /* nsinghi bug#4486074 Added the p_expiration_Date parameter. */
66: ,p_expiration_date IN mtl_lot_numbers.expiration_date%TYPE := NULL
67: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE
68: ,x_return_status OUT NOCOPY VARCHAR2);
69:
70: PROCEDURE validate_material_for_update
71: (p_batch_header_rec IN gme_batch_header%ROWTYPE

Line 77: ,p_db_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE

73: ,x_return_status OUT NOCOPY VARCHAR2);
74:
75: PROCEDURE validate_record_for_update
76: (p_material_detail_rec IN gme_material_details%ROWTYPE
77: ,p_db_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
78: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
79: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE
80: ,x_return_status OUT NOCOPY VARCHAR2);
81:

Line 78: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE

74:
75: PROCEDURE validate_record_for_update
76: (p_material_detail_rec IN gme_material_details%ROWTYPE
77: ,p_db_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
78: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
79: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE
80: ,x_return_status OUT NOCOPY VARCHAR2);
81:
82: PROCEDURE validate_material_for_delete

Line 79: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE

75: PROCEDURE validate_record_for_update
76: (p_material_detail_rec IN gme_material_details%ROWTYPE
77: ,p_db_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
78: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
79: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE
80: ,x_return_status OUT NOCOPY VARCHAR2);
81:
82: PROCEDURE validate_material_for_delete
83: (p_batch_header_rec IN gme_batch_header%ROWTYPE

Line 89: ,p_db_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE

85: ,x_return_status OUT NOCOPY VARCHAR2);
86:
87: PROCEDURE validate_record_for_delete
88: (p_material_detail_rec IN gme_material_details%ROWTYPE
89: ,p_db_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
90: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
91: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE
92: ,x_return_status OUT NOCOPY VARCHAR2);
93:

Line 90: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE

86:
87: PROCEDURE validate_record_for_delete
88: (p_material_detail_rec IN gme_material_details%ROWTYPE
89: ,p_db_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
90: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
91: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE
92: ,x_return_status OUT NOCOPY VARCHAR2);
93:
94: FUNCTION validate_lot_number (p_inv_item_id IN NUMBER

Line 91: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE

87: PROCEDURE validate_record_for_delete
88: (p_material_detail_rec IN gme_material_details%ROWTYPE
89: ,p_db_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
90: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
91: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE
92: ,x_return_status OUT NOCOPY VARCHAR2);
93:
94: FUNCTION validate_lot_number (p_inv_item_id IN NUMBER
95: ,p_org_id IN NUMBER

Line 128: END gme_pending_product_lots_pvt;

124: p_mtl_dtl_id IN NUMBER
125: ,x_pnd_prod_lot_qty OUT NOCOPY NUMBER
126: ,x_return_status OUT NOCOPY VARCHAR2);
127:
128: END gme_pending_product_lots_pvt;