DBA Data[Home] [Help]

APPS.GME_PENDING_PRODUCT_LOTS_PVT dependencies on GME_MATERIAL_DETAILS

Line 565: ,p_material_detail_rec IN gme_material_details%ROWTYPE

561: END delete_pending_product_lot;
562:
563: PROCEDURE validate_material_for_create
564: (p_batch_header_rec IN gme_batch_header%ROWTYPE
565: ,p_material_detail_rec IN gme_material_details%ROWTYPE
566: ,x_return_status OUT NOCOPY VARCHAR2) IS
567:
568: l_api_name CONSTANT VARCHAR2 (30) := 'validate_material_for_create';
569:

Line 666: (p_material_detail_rec IN gme_material_details%ROWTYPE

662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
663: END get_last_sequence;
664:
665: PROCEDURE validate_record_for_create
666: (p_material_detail_rec IN gme_material_details%ROWTYPE
667: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
668: ,p_create_lot IN VARCHAR2
669: ,p_generate_lot IN VARCHAR2
670: ,p_generate_parent_lot IN VARCHAR2

Line 851: ,p_material_detail_rec IN gme_material_details%ROWTYPE

847: END validate_record_for_create;
848:
849: PROCEDURE validate_material_for_update
850: (p_batch_header_rec IN gme_batch_header%ROWTYPE
851: ,p_material_detail_rec IN gme_material_details%ROWTYPE
852: ,x_return_status OUT NOCOPY VARCHAR2) IS
853:
854: l_api_name CONSTANT VARCHAR2 (30) := 'validate_material_for_update';
855:

Line 877: (p_material_detail_rec IN gme_material_details%ROWTYPE

873: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
874: END validate_material_for_update;
875:
876: PROCEDURE validate_record_for_update
877: (p_material_detail_rec IN gme_material_details%ROWTYPE
878: ,p_db_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
879: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
880: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE
881: ,x_return_status OUT NOCOPY VARCHAR2) IS

Line 1094: ,p_material_detail_rec IN gme_material_details%ROWTYPE

1090: END validate_record_for_update;
1091:
1092: PROCEDURE validate_material_for_delete
1093: (p_batch_header_rec IN gme_batch_header%ROWTYPE
1094: ,p_material_detail_rec IN gme_material_details%ROWTYPE
1095: ,x_return_status OUT NOCOPY VARCHAR2) IS
1096:
1097: l_api_name CONSTANT VARCHAR2 (30) := 'validate_material_for_delete';
1098:

Line 1120: (p_material_detail_rec IN gme_material_details%ROWTYPE

1116: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1117: END validate_material_for_delete;
1118:
1119: PROCEDURE validate_record_for_delete
1120: (p_material_detail_rec IN gme_material_details%ROWTYPE
1121: ,p_db_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
1122: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
1123: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE
1124: ,x_return_status OUT NOCOPY VARCHAR2) IS

Line 1171: (p_matl_dtl_rec IN gme_material_details%ROWTYPE

1167: END validate_record_for_delete;
1168:
1169: -- Call this procedure at the record level because fields besides lot number are required
1170: FUNCTION validate_quantities
1171: (p_matl_dtl_rec IN gme_material_details%ROWTYPE
1172: ,p_lot_number IN VARCHAR2
1173: ,p_revision IN VARCHAR2
1174: ,p_dtl_qty IN OUT NOCOPY NUMBER
1175: ,p_sec_qty IN OUT NOCOPY NUMBER

Line 1380: FUNCTION validate_sequence (p_matl_dtl_rec IN gme_material_details%ROWTYPE

1376: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1377: RETURN FALSE;
1378: END validate_lot_number;
1379:
1380: FUNCTION validate_sequence (p_matl_dtl_rec IN gme_material_details%ROWTYPE
1381: ,p_sequence IN NUMBER
1382: ,x_return_status OUT NOCOPY VARCHAR2)
1383: RETURN BOOLEAN IS
1384: