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_API_PUB dependencies on GME_BATCH_STEP_RESOURCES

Line 6547: ,p_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE

6543: ,p_validation_level IN NUMBER
6544: := gme_common_pvt.g_max_errors
6545: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
6546: ,p_commit IN VARCHAR2 := fnd_api.g_false
6547: ,p_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE
6548: ,p_org_code IN VARCHAR2 := NULL
6549: ,p_batch_no IN VARCHAR2 := NULL
6550: ,p_batchstep_no IN NUMBER := NULL
6551: ,p_activity IN VARCHAR2 := NULL

Line 6554: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE

6550: ,p_batchstep_no IN NUMBER := NULL
6551: ,p_activity IN VARCHAR2 := NULL
6552: ,p_ignore_qty_below_cap IN VARCHAR2 := fnd_api.g_false
6553: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
6554: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
6555: ,x_message_count OUT NOCOPY NUMBER
6556: ,x_message_list OUT NOCOPY VARCHAR2
6557: ,x_return_status OUT NOCOPY VARCHAR2)
6558: IS

Line 6562: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;

6558: IS
6559: l_api_name CONSTANT VARCHAR2 (30)
6560: := 'INSERT_BATCHSTEP_RESOURCE';
6561: l_batch_header gme_batch_header%ROWTYPE;
6562: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;
6563: l_batchstep_resource_rec_out gme_batch_step_resources%ROWTYPE;
6564: l_table NUMBER;
6565: l_step_status NUMBER;
6566: l_dummy NUMBER;

Line 6563: l_batchstep_resource_rec_out gme_batch_step_resources%ROWTYPE;

6559: l_api_name CONSTANT VARCHAR2 (30)
6560: := 'INSERT_BATCHSTEP_RESOURCE';
6561: l_batch_header gme_batch_header%ROWTYPE;
6562: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;
6563: l_batchstep_resource_rec_out gme_batch_step_resources%ROWTYPE;
6564: l_table NUMBER;
6565: l_step_status NUMBER;
6566: l_dummy NUMBER;
6567: l_batch_id NUMBER;

Line 6993: ,p_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE

6989: p_api_version IN NUMBER
6990: ,p_validation_level IN NUMBER := gme_common_pvt.g_max_errors
6991: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
6992: ,p_commit IN VARCHAR2 := fnd_api.g_false
6993: ,p_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE
6994: ,p_org_code IN VARCHAR2 := NULL
6995: ,p_batch_no IN VARCHAR2 := NULL
6996: ,p_batchstep_no IN NUMBER := NULL
6997: ,p_activity IN VARCHAR2 := NULL

Line 7000: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE

6996: ,p_batchstep_no IN NUMBER := NULL
6997: ,p_activity IN VARCHAR2 := NULL
6998: ,p_ignore_qty_below_cap IN VARCHAR2 := fnd_api.g_false
6999: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
7000: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
7001: ,x_message_count OUT NOCOPY NUMBER
7002: ,x_message_list OUT NOCOPY VARCHAR2
7003: ,x_return_status OUT NOCOPY VARCHAR2)
7004: IS

Line 7008: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;

7004: IS
7005: l_api_name CONSTANT VARCHAR2 (30)
7006: := 'UPDATE_BATCHSTEP_RESOURCE';
7007: l_batch_header gme_batch_header%ROWTYPE;
7008: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;
7009: l_batchstep_resource_rec_out gme_batch_step_resources%ROWTYPE;
7010: l_cons_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;
7011: l_return_status VARCHAR2 (2);
7012: l_step_status NUMBER;

Line 7009: l_batchstep_resource_rec_out gme_batch_step_resources%ROWTYPE;

7005: l_api_name CONSTANT VARCHAR2 (30)
7006: := 'UPDATE_BATCHSTEP_RESOURCE';
7007: l_batch_header gme_batch_header%ROWTYPE;
7008: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;
7009: l_batchstep_resource_rec_out gme_batch_step_resources%ROWTYPE;
7010: l_cons_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;
7011: l_return_status VARCHAR2 (2);
7012: l_step_status NUMBER;
7013:

Line 7010: l_cons_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;

7006: := 'UPDATE_BATCHSTEP_RESOURCE';
7007: l_batch_header gme_batch_header%ROWTYPE;
7008: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;
7009: l_batchstep_resource_rec_out gme_batch_step_resources%ROWTYPE;
7010: l_cons_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;
7011: l_return_status VARCHAR2 (2);
7012: l_step_status NUMBER;
7013:
7014: CURSOR cur_get_batchstep_status (

Line 7308: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;

7304: l_dummy NUMBER;
7305: l_batch_id NUMBER;
7306: l_batchstep_id NUMBER;
7307: l_return_status VARCHAR2 (2);
7308: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;
7309:
7310: CURSOR cur_get_step_dtl (v_batchstep_rsrc_id NUMBER)
7311: IS
7312: SELECT c.organization_id, a.step_status, a.batch_id, a.batchstep_id

Line 7315: ,gme_batch_step_resources b

7311: IS
7312: SELECT c.organization_id, a.step_status, a.batch_id, a.batchstep_id
7313: ,b.batchstep_activity_id, c.batch_status
7314: FROM gme_batch_steps a
7315: ,gme_batch_step_resources b
7316: ,gme_batch_header c
7317: WHERE a.batch_id = b.batch_id
7318: AND a.batchstep_id = b.batchstep_id
7319: AND b.batchstep_resource_id = v_batchstep_rsrc_id

Line 7325: FROM gme_batch_header a, gme_batch_step_resources b

7321:
7322: CURSOR cur_validate_batch_type (v_rsrc_id NUMBER)
7323: IS
7324: SELECT 1
7325: FROM gme_batch_header a, gme_batch_step_resources b
7326: WHERE a.batch_id = b.batch_id
7327: AND b.batchstep_resource_id = v_rsrc_id
7328: AND a.batch_type = 10;
7329: