DBA Data[Home] [Help]

APPS.GME_PENDING_PRODUCT_LOTS_PVT dependencies on GME_MATERIAL_DETAILS

Line 55: ,p_material_detail_rec IN gme_material_details%ROWTYPE

51: ,x_return_status OUT NOCOPY VARCHAR2);
52:
53: PROCEDURE validate_material_for_create
54: (p_batch_header_rec IN gme_batch_header%ROWTYPE
55: ,p_material_detail_rec IN gme_material_details%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

Line 59: (p_material_detail_rec IN gme_material_details%ROWTYPE

55: ,p_material_detail_rec IN gme_material_details%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

Line 72: ,p_material_detail_rec IN gme_material_details%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
72: ,p_material_detail_rec IN gme_material_details%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

Line 76: (p_material_detail_rec IN gme_material_details%ROWTYPE

72: ,p_material_detail_rec IN gme_material_details%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);

Line 84: ,p_material_detail_rec IN gme_material_details%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
84: ,p_material_detail_rec IN gme_material_details%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

Line 88: (p_material_detail_rec IN gme_material_details%ROWTYPE

84: ,p_material_detail_rec IN gme_material_details%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);

Line 99: FUNCTION validate_sequence (p_matl_dtl_rec IN gme_material_details%ROWTYPE

95: ,p_org_id IN NUMBER
96: ,p_lot_number IN VARCHAR2
97: ,x_return_status OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
98:
99: FUNCTION validate_sequence (p_matl_dtl_rec IN gme_material_details%ROWTYPE
100: ,p_sequence IN NUMBER
101: ,x_return_status OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
102:
103: FUNCTION validate_quantities

Line 104: (p_matl_dtl_rec IN gme_material_details%ROWTYPE

100: ,p_sequence IN NUMBER
101: ,x_return_status OUT NOCOPY VARCHAR2) RETURN BOOLEAN;
102:
103: FUNCTION validate_quantities
104: (p_matl_dtl_rec IN gme_material_details%ROWTYPE
105: ,p_lot_number IN VARCHAR2
106: ,p_revision IN VARCHAR2
107: ,p_dtl_qty IN OUT NOCOPY NUMBER
108: ,p_sec_qty IN OUT NOCOPY NUMBER