DBA Data[Home] [Help]

APPS.GME_PENDING_PRODUCT_LOTS_PVT dependencies on GME_MATERIAL_DETAILS

Line 552: ,p_material_detail_rec IN gme_material_details%ROWTYPE

548: END delete_pending_product_lot;
549:
550: PROCEDURE validate_material_for_create
551: (p_batch_header_rec IN gme_batch_header%ROWTYPE
552: ,p_material_detail_rec IN gme_material_details%ROWTYPE
553: ,x_return_status OUT NOCOPY VARCHAR2) IS
554:
555: l_api_name CONSTANT VARCHAR2 (30) := 'validate_material_for_create';
556:

Line 653: (p_material_detail_rec IN gme_material_details%ROWTYPE

649: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
650: END get_last_sequence;
651:
652: PROCEDURE validate_record_for_create
653: (p_material_detail_rec IN gme_material_details%ROWTYPE
654: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
655: ,p_create_lot IN VARCHAR2
656: ,p_generate_lot IN VARCHAR2
657: ,p_generate_parent_lot IN VARCHAR2

Line 838: ,p_material_detail_rec IN gme_material_details%ROWTYPE

834: END validate_record_for_create;
835:
836: PROCEDURE validate_material_for_update
837: (p_batch_header_rec IN gme_batch_header%ROWTYPE
838: ,p_material_detail_rec IN gme_material_details%ROWTYPE
839: ,x_return_status OUT NOCOPY VARCHAR2) IS
840:
841: l_api_name CONSTANT VARCHAR2 (30) := 'validate_material_for_update';
842:

Line 864: (p_material_detail_rec IN gme_material_details%ROWTYPE

860: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
861: END validate_material_for_update;
862:
863: PROCEDURE validate_record_for_update
864: (p_material_detail_rec IN gme_material_details%ROWTYPE
865: ,p_db_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
866: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
867: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE
868: ,x_return_status OUT NOCOPY VARCHAR2) IS

Line 1081: ,p_material_detail_rec IN gme_material_details%ROWTYPE

1077: END validate_record_for_update;
1078:
1079: PROCEDURE validate_material_for_delete
1080: (p_batch_header_rec IN gme_batch_header%ROWTYPE
1081: ,p_material_detail_rec IN gme_material_details%ROWTYPE
1082: ,x_return_status OUT NOCOPY VARCHAR2) IS
1083:
1084: l_api_name CONSTANT VARCHAR2 (30) := 'validate_material_for_delete';
1085:

Line 1107: (p_material_detail_rec IN gme_material_details%ROWTYPE

1103: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1104: END validate_material_for_delete;
1105:
1106: PROCEDURE validate_record_for_delete
1107: (p_material_detail_rec IN gme_material_details%ROWTYPE
1108: ,p_db_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
1109: ,p_pending_product_lots_rec IN gme_pending_product_lots%ROWTYPE
1110: ,x_pending_product_lots_rec OUT NOCOPY gme_pending_product_lots%ROWTYPE
1111: ,x_return_status OUT NOCOPY VARCHAR2) IS

Line 1158: (p_matl_dtl_rec IN gme_material_details%ROWTYPE

1154: END validate_record_for_delete;
1155:
1156: -- Call this procedure at the record level because fields besides lot number are required
1157: FUNCTION validate_quantities
1158: (p_matl_dtl_rec IN gme_material_details%ROWTYPE
1159: ,p_lot_number IN VARCHAR2
1160: ,p_revision IN VARCHAR2
1161: ,p_dtl_qty IN OUT NOCOPY NUMBER
1162: ,p_sec_qty IN OUT NOCOPY NUMBER

Line 1367: FUNCTION validate_sequence (p_matl_dtl_rec IN gme_material_details%ROWTYPE

1363: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1364: RETURN FALSE;
1365: END validate_lot_number;
1366:
1367: FUNCTION validate_sequence (p_matl_dtl_rec IN gme_material_details%ROWTYPE
1368: ,p_sequence IN NUMBER
1369: ,x_return_status OUT NOCOPY VARCHAR2)
1370: RETURN BOOLEAN IS
1371: