APPS.GME_VALIDATE_FLEX_FLD_PVT dependencies on GME_MATERIAL_DETAILS

Line 3640: p_material_detail_rec IN gme_material_details%ROWTYPE

3636: -- rewritten the following procedure
3637: ======================================================================= */
3638:
3639: PROCEDURE validate_flex_material_details (
3640: p_material_detail_rec IN gme_material_details%ROWTYPE
3641: ,x_material_detail_rec IN OUT NOCOPY gme_material_details%ROWTYPE
3642: ,x_return_status OUT NOCOPY VARCHAR2)
3643: IS
3644: l_attribute_category VARCHAR2 (240);

Line 3641: ,x_material_detail_rec IN OUT NOCOPY gme_material_details%ROWTYPE

3637: ======================================================================= */
3638:
3639: PROCEDURE validate_flex_material_details (
3640: p_material_detail_rec IN gme_material_details%ROWTYPE
3641: ,x_material_detail_rec IN OUT NOCOPY gme_material_details%ROWTYPE
3642: ,x_return_status OUT NOCOPY VARCHAR2)
3643: IS
3644: l_attribute_category VARCHAR2 (240);
3645: appl_short_name VARCHAR2 (30) := 'GME';

Line 3653: l_material_detail_rec gme_material_details%ROWTYPE;

3649: error_msg VARCHAR2 (5000);
3650: l_field_value VARCHAR2 (240);
3651: l_field_name VARCHAR2 (100);
3652: n NUMBER;
3653: l_material_detail_rec gme_material_details%ROWTYPE;
3654:
3655: validation_error EXCEPTION;
3656: material_fetch_err EXCEPTION;
3657: BEGIN

Line 3683: IF NOT gme_material_details_dbl.fetch_row(p_material_detail_rec, l_material_detail_rec) THEN

3679: RETURN;
3680: END IF;
3681:
3682: IF p_material_detail_rec.material_detail_id IS NOT NULL THEN
3683: IF NOT gme_material_details_dbl.fetch_row(p_material_detail_rec, l_material_detail_rec) THEN
3684: RAISE material_fetch_err;
3685: END IF;
3686: ELSE
3687: l_material_detail_rec := p_material_detail_rec;

Line 6479: p_material_detail IN gme_material_details%ROWTYPE,

6475: * and erroring out from the procedure based on global validate flag
6476: * ======================================================================= */
6477:
6478: PROCEDURE create_flex_material_details (
6479: p_material_detail IN gme_material_details%ROWTYPE,
6480: x_material_detail IN OUT NOCOPY gme_material_details%ROWTYPE,
6481: x_return_status OUT NOCOPY VARCHAR2
6482: ) IS
6483: appl_short_name VARCHAR2 (30) := 'GME';

Line 6480: x_material_detail IN OUT NOCOPY gme_material_details%ROWTYPE,

6476: * ======================================================================= */
6477:
6478: PROCEDURE create_flex_material_details (
6479: p_material_detail IN gme_material_details%ROWTYPE,
6480: x_material_detail IN OUT NOCOPY gme_material_details%ROWTYPE,
6481: x_return_status OUT NOCOPY VARCHAR2
6482: ) IS
6483: appl_short_name VARCHAR2 (30) := 'GME';
6484: desc_flex_name VARCHAR2 (30) := 'BATCH_DTL_FLEX';