DBA Data[Home] [Help]

APPS.GME_VALIDATE_FLEX_FLD_PVT dependencies on GME_BATCH_STEPS

Line 772: p_batch_step IN gme_batch_steps%ROWTYPE

768: -- This is a follow up fix to bug 3649415.
769: -- Only flex field data will be overwritten in x_material_detail parameter.
770: ======================================================================= */
771: PROCEDURE validate_flex_batch_step (
772: p_batch_step IN gme_batch_steps%ROWTYPE
773: ,x_batch_step IN OUT NOCOPY gme_batch_steps%ROWTYPE
774: ,x_return_status OUT NOCOPY VARCHAR2)
775: IS
776: l_attribute_category VARCHAR2 (240);

Line 773: ,x_batch_step IN OUT NOCOPY gme_batch_steps%ROWTYPE

769: -- Only flex field data will be overwritten in x_material_detail parameter.
770: ======================================================================= */
771: PROCEDURE validate_flex_batch_step (
772: p_batch_step IN gme_batch_steps%ROWTYPE
773: ,x_batch_step IN OUT NOCOPY gme_batch_steps%ROWTYPE
774: ,x_return_status OUT NOCOPY VARCHAR2)
775: IS
776: l_attribute_category VARCHAR2 (240);
777: appl_short_name VARCHAR2 (30) := 'GME';

Line 787: l_batch_step_row gme_batch_steps%ROWTYPE;

783: step_fetch_error EXCEPTION;
784: l_field_value VARCHAR2 (240);
785: l_field_name VARCHAR2 (100);
786: n NUMBER := 0;
787: l_batch_step_row gme_batch_steps%ROWTYPE;
788: --3556979
789: l_exists NUMBER;
790: l_dummy BOOLEAN;
791:

Line 795: FROM gme_batch_steps

791:
792: CURSOR cur_record_exists (v_rec_id NUMBER)
793: IS
794: SELECT 1
795: FROM gme_batch_steps
796: WHERE batchstep_id = v_rec_id;
797: BEGIN
798: /* Set return status to success initially */
799: x_return_status := fnd_api.g_ret_sts_success;

Line 832: gme_batch_steps_dbl.fetch_row (p_batch_step, l_batch_step_row);

828: IF cur_record_exists%NOTFOUND THEN
829: l_batch_step_row := p_batch_step;
830: ELSE
831: l_dummy :=
832: gme_batch_steps_dbl.fetch_row (p_batch_step, l_batch_step_row);
833: END IF;
834:
835: CLOSE cur_record_exists;
836:

Line 5413: p_batch_step IN gme_batch_steps%ROWTYPE,

5409: -- This procedure will assign the default values of the segments into the columns.
5410: -- SYNOPSIS:
5411:
5412: create_flex_batch_step (
5413: p_batch_step IN gme_batch_steps%ROWTYPE,
5414: x_batch_step IN OUT NOCOPY gme_batch_steps%ROWTYPE,
5415: x_return_status OUT NOCOPY VARCHAR2);
5416: -- HISTORY
5417: -- K.Swapna 07-MAR-2005 Created --BUG#4050727

Line 5414: x_batch_step IN OUT NOCOPY gme_batch_steps%ROWTYPE,

5410: -- SYNOPSIS:
5411:
5412: create_flex_batch_step (
5413: p_batch_step IN gme_batch_steps%ROWTYPE,
5414: x_batch_step IN OUT NOCOPY gme_batch_steps%ROWTYPE,
5415: x_return_status OUT NOCOPY VARCHAR2);
5416: -- HISTORY
5417: -- K.Swapna 07-MAR-2005 Created --BUG#4050727
5418: --K Swapna Bug#4257930 25-MAY-2005

Line 5424: p_batch_step IN gme_batch_steps%ROWTYPE,

5420: fnd_flex_descval.validate_desccols with the parameter,values_or_ids as 'D'
5421: and erroring out from the procedure based on global validate flag
5422: ======================================================================= */
5423: PROCEDURE create_flex_batch_step (
5424: p_batch_step IN gme_batch_steps%ROWTYPE,
5425: x_batch_step IN OUT NOCOPY gme_batch_steps%ROWTYPE,
5426: x_return_status OUT NOCOPY VARCHAR2
5427: ) IS
5428: appl_short_name VARCHAR2 (30) := 'GME';

Line 5425: x_batch_step IN OUT NOCOPY gme_batch_steps%ROWTYPE,

5421: and erroring out from the procedure based on global validate flag
5422: ======================================================================= */
5423: PROCEDURE create_flex_batch_step (
5424: p_batch_step IN gme_batch_steps%ROWTYPE,
5425: x_batch_step IN OUT NOCOPY gme_batch_steps%ROWTYPE,
5426: x_return_status OUT NOCOPY VARCHAR2
5427: ) IS
5428: appl_short_name VARCHAR2 (30) := 'GME';
5429: desc_flex_name VARCHAR2 (30) := 'BATCH_STEPS_DTL_FLEX';