eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GME_VALIDATE_FLEX_FLD_PVT dependencies on GME_BATCH_STEP_ACTIVITIES

Line 1463: -- This procedure will validate the GME_BATCH_STEP_ACTIVITIES_FLEX, descriptive flex field

1459: -- NAME
1460: -- validate_flex_step_activities
1461: --
1462: -- DESCRIPTION
1463: -- This procedure will validate the GME_BATCH_STEP_ACTIVITIES_FLEX, descriptive flex field
1464: -- for batch step activities using serverside flex field validation package FND_FLEX_DESCVAL.
1465: --
1466: -- SYNOPSIS:
1467:

Line 1490: p_step_activities IN gme_batch_step_activities%ROWTYPE

1486: -- This is a follow up fix to bug 3649415.
1487: -- Only flex field data will be overwritten in x_material_detail parameter.
1488: ======================================================================= */
1489: PROCEDURE validate_flex_step_activities (
1490: p_step_activities IN gme_batch_step_activities%ROWTYPE
1491: ,x_step_activities IN OUT NOCOPY gme_batch_step_activities%ROWTYPE
1492: ,x_return_status OUT NOCOPY VARCHAR2)
1493: IS
1494: l_attribute_category VARCHAR2 (240);

Line 1491: ,x_step_activities IN OUT NOCOPY gme_batch_step_activities%ROWTYPE

1487: -- Only flex field data will be overwritten in x_material_detail parameter.
1488: ======================================================================= */
1489: PROCEDURE validate_flex_step_activities (
1490: p_step_activities IN gme_batch_step_activities%ROWTYPE
1491: ,x_step_activities IN OUT NOCOPY gme_batch_step_activities%ROWTYPE
1492: ,x_return_status OUT NOCOPY VARCHAR2)
1493: IS
1494: l_attribute_category VARCHAR2 (240);
1495: appl_short_name VARCHAR2 (30) := 'GME';

Line 1497: := 'GME_BATCH_STEP_ACTIVITIES_FLEX';

1493: IS
1494: l_attribute_category VARCHAR2 (240);
1495: appl_short_name VARCHAR2 (30) := 'GME';
1496: desc_flex_name VARCHAR2 (30)
1497: := 'GME_BATCH_STEP_ACTIVITIES_FLEX';
1498: values_or_ids VARCHAR2 (10) := 'I';
1499: validation_date DATE := SYSDATE;
1500: error_msg VARCHAR2 (5000);
1501: validation_error EXCEPTION;

Line 1506: l_step_activities_row gme_batch_step_activities%ROWTYPE;

1502: step_fetch_error EXCEPTION;
1503: l_field_value VARCHAR2 (240);
1504: l_field_name VARCHAR2 (100);
1505: n NUMBER := 0;
1506: l_step_activities_row gme_batch_step_activities%ROWTYPE;
1507: --3556979
1508: l_exists NUMBER;
1509: l_dummy BOOLEAN;
1510:

Line 1514: FROM gme_batch_step_activities

1510:
1511: CURSOR cur_record_exists (v_rec_id NUMBER)
1512: IS
1513: SELECT 1
1514: FROM gme_batch_step_activities
1515: WHERE batchstep_activity_id = v_rec_id;
1516: BEGIN
1517: /* Set return status to success initially */
1518: x_return_status := fnd_api.g_ret_sts_success;

Line 1551: gme_batch_step_activities_dbl.fetch_row (p_step_activities

1547: IF cur_record_exists%NOTFOUND THEN
1548: l_step_activities_row := p_step_activities;
1549: ELSE
1550: l_dummy :=
1551: gme_batch_step_activities_dbl.fetch_row (p_step_activities
1552: ,l_step_activities_row);
1553: END IF;
1554:
1555: CLOSE cur_record_exists;

Line 5676: p_step_activities IN gme_batch_step_activities%ROWTYPE,

5672: -- This procedure will assign the default values of the segments into the columns.
5673: -- SYNOPSIS:
5674:
5675: create_flex_step_activities (
5676: p_step_activities IN gme_batch_step_activities%ROWTYPE,
5677: x_step_activities IN OUT NOCOPY gme_batch_step_activities%ROWTYPE,
5678: x_return_status OUT NOCOPY VARCHAR2
5679: -- HISTORY
5680: -- K.Swapna 07-MAR-2005 Created --BUG#4050727

Line 5677: x_step_activities IN OUT NOCOPY gme_batch_step_activities%ROWTYPE,

5673: -- SYNOPSIS:
5674:
5675: create_flex_step_activities (
5676: p_step_activities IN gme_batch_step_activities%ROWTYPE,
5677: x_step_activities IN OUT NOCOPY gme_batch_step_activities%ROWTYPE,
5678: x_return_status OUT NOCOPY VARCHAR2
5679: -- HISTORY
5680: -- K.Swapna 07-MAR-2005 Created --BUG#4050727
5681: --K Swapna Bug#4257930 25-MAY-2005

Line 5687: p_step_activities IN gme_batch_step_activities%ROWTYPE,

5683: fnd_flex_descval.validate_desccols with the parameter,values_or_ids as 'D'
5684: and erroring out from the procedure based on global validate flag
5685: ======================================================================= */
5686: PROCEDURE create_flex_step_activities (
5687: p_step_activities IN gme_batch_step_activities%ROWTYPE,
5688: x_step_activities IN OUT NOCOPY gme_batch_step_activities%ROWTYPE,
5689: x_return_status OUT NOCOPY VARCHAR2
5690: ) IS
5691: appl_short_name VARCHAR2 (30) := 'GME';

Line 5688: x_step_activities IN OUT NOCOPY gme_batch_step_activities%ROWTYPE,

5684: and erroring out from the procedure based on global validate flag
5685: ======================================================================= */
5686: PROCEDURE create_flex_step_activities (
5687: p_step_activities IN gme_batch_step_activities%ROWTYPE,
5688: x_step_activities IN OUT NOCOPY gme_batch_step_activities%ROWTYPE,
5689: x_return_status OUT NOCOPY VARCHAR2
5690: ) IS
5691: appl_short_name VARCHAR2 (30) := 'GME';
5692: desc_flex_name VARCHAR2 (30) := 'GME_BATCH_STEP_ACTIVITIES_FLEX';

Line 5692: desc_flex_name VARCHAR2 (30) := 'GME_BATCH_STEP_ACTIVITIES_FLEX';

5688: x_step_activities IN OUT NOCOPY gme_batch_step_activities%ROWTYPE,
5689: x_return_status OUT NOCOPY VARCHAR2
5690: ) IS
5691: appl_short_name VARCHAR2 (30) := 'GME';
5692: desc_flex_name VARCHAR2 (30) := 'GME_BATCH_STEP_ACTIVITIES_FLEX';
5693: values_or_ids VARCHAR2 (10) := 'D';
5694: validation_date DATE := SYSDATE;
5695: error_msg VARCHAR2 (5000);
5696: n NUMBER := 0;