DBA Data[Home] [Help]

APPS.GME_API_PUB dependencies on GME_BATCH_STEP_ACTIVITIES

Line 6586: FROM gme_batch_step_activities

6582: /* Cursor Declarations */
6583: CURSOR cur_validate_activity (v_activity_id NUMBER)
6584: IS
6585: SELECT batchstep_id, batch_id
6586: FROM gme_batch_step_activities
6587: WHERE batchstep_activity_id = v_activity_id;
6588:
6589: CURSOR cur_validate_batch_type (v_activity_id NUMBER)
6590: IS

Line 6592: FROM gme_batch_header a, gme_batch_step_activities b

6588:
6589: CURSOR cur_validate_batch_type (v_activity_id NUMBER)
6590: IS
6591: SELECT 1
6592: FROM gme_batch_header a, gme_batch_step_activities b
6593: WHERE a.batch_id = b.batch_id
6594: AND b.batchstep_activity_id = v_activity_id
6595: AND a.batch_type = 10;
6596:

Line 8000: p_batchstep_activity_rec IN gme_batch_step_activities%ROWTYPE,

7996: DEFAULT fnd_api.g_false,
7997: p_commit IN VARCHAR2
7998: DEFAULT fnd_api.g_false,
7999: p_org_code IN VARCHAR2,
8000: p_batchstep_activity_rec IN gme_batch_step_activities%ROWTYPE,
8001: p_batchstep_resource_tbl IN gme_create_step_pvt.resources_tab,
8002: p_batch_no IN VARCHAR2 := NULL,
8003: p_batchstep_no IN NUMBER := NULL,
8004: p_ignore_qty_below_cap IN VARCHAR2

Line 8008: x_batchstep_activity_rec OUT NOCOPY gme_batch_step_activities%ROWTYPE,

8004: p_ignore_qty_below_cap IN VARCHAR2
8005: DEFAULT fnd_api.g_false,
8006: p_validate_flexfield IN VARCHAR2
8007: DEFAULT fnd_api.g_false,
8008: x_batchstep_activity_rec OUT NOCOPY gme_batch_step_activities%ROWTYPE,
8009: x_message_count OUT NOCOPY NUMBER,
8010: x_message_list OUT NOCOPY VARCHAR2,
8011: x_return_status OUT NOCOPY VARCHAR2
8012: )

Line 8152: p_batchstep_activity_rec IN gme_batch_step_activities%ROWTYPE,

8148: DEFAULT fnd_api.g_false,
8149: p_commit IN VARCHAR2
8150: DEFAULT fnd_api.g_false,
8151: p_org_code IN VARCHAR2,
8152: p_batchstep_activity_rec IN gme_batch_step_activities%ROWTYPE,
8153: p_batch_no IN VARCHAR2 := NULL,
8154: p_batchstep_no IN NUMBER := NULL,
8155: p_validate_flexfield IN VARCHAR2
8156: DEFAULT fnd_api.g_false,

Line 8157: x_batchstep_activity_rec OUT NOCOPY gme_batch_step_activities%ROWTYPE,

8153: p_batch_no IN VARCHAR2 := NULL,
8154: p_batchstep_no IN NUMBER := NULL,
8155: p_validate_flexfield IN VARCHAR2
8156: DEFAULT fnd_api.g_false,
8157: x_batchstep_activity_rec OUT NOCOPY gme_batch_step_activities%ROWTYPE,
8158: x_message_count OUT NOCOPY NUMBER,
8159: x_message_list OUT NOCOPY VARCHAR2,
8160: x_return_status OUT NOCOPY VARCHAR2
8161: )