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 7012: ,p_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE

7008: ,p_validation_level IN NUMBER
7009: := gme_common_pvt.g_max_errors
7010: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
7011: ,p_commit IN VARCHAR2 := fnd_api.g_false
7012: ,p_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE
7013: ,p_org_code IN VARCHAR2 := NULL
7014: ,p_batch_no IN VARCHAR2 := NULL
7015: ,p_batchstep_no IN NUMBER := NULL
7016: ,p_activity IN VARCHAR2 := NULL

Line 7019: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE

7015: ,p_batchstep_no IN NUMBER := NULL
7016: ,p_activity IN VARCHAR2 := NULL
7017: ,p_ignore_qty_below_cap IN VARCHAR2 := fnd_api.g_false
7018: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
7019: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
7020: ,x_message_count OUT NOCOPY NUMBER
7021: ,x_message_list OUT NOCOPY VARCHAR2
7022: ,x_return_status OUT NOCOPY VARCHAR2)
7023: IS

Line 7027: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;

7023: IS
7024: l_api_name CONSTANT VARCHAR2 (30)
7025: := 'INSERT_BATCHSTEP_RESOURCE';
7026: l_batch_header gme_batch_header%ROWTYPE;
7027: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;
7028: l_batchstep_resource_rec_out gme_batch_step_resources%ROWTYPE;
7029: l_table NUMBER;
7030: l_step_status NUMBER;
7031: l_dummy NUMBER;

Line 7028: l_batchstep_resource_rec_out gme_batch_step_resources%ROWTYPE;

7024: l_api_name CONSTANT VARCHAR2 (30)
7025: := 'INSERT_BATCHSTEP_RESOURCE';
7026: l_batch_header gme_batch_header%ROWTYPE;
7027: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;
7028: l_batchstep_resource_rec_out gme_batch_step_resources%ROWTYPE;
7029: l_table NUMBER;
7030: l_step_status NUMBER;
7031: l_dummy NUMBER;
7032: l_batch_id NUMBER;

Line 7461: ,p_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE

7457: p_api_version IN NUMBER
7458: ,p_validation_level IN NUMBER := gme_common_pvt.g_max_errors
7459: ,p_init_msg_list IN VARCHAR2 := fnd_api.g_false
7460: ,p_commit IN VARCHAR2 := fnd_api.g_false
7461: ,p_batchstep_resource_rec IN gme_batch_step_resources%ROWTYPE
7462: ,p_org_code IN VARCHAR2 := NULL
7463: ,p_batch_no IN VARCHAR2 := NULL
7464: ,p_batchstep_no IN NUMBER := NULL
7465: ,p_activity IN VARCHAR2 := NULL

Line 7468: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE

7464: ,p_batchstep_no IN NUMBER := NULL
7465: ,p_activity IN VARCHAR2 := NULL
7466: ,p_ignore_qty_below_cap IN VARCHAR2 := fnd_api.g_false
7467: ,p_validate_flexfields IN VARCHAR2 := fnd_api.g_false
7468: ,x_batchstep_resource_rec OUT NOCOPY gme_batch_step_resources%ROWTYPE
7469: ,x_message_count OUT NOCOPY NUMBER
7470: ,x_message_list OUT NOCOPY VARCHAR2
7471: ,x_return_status OUT NOCOPY VARCHAR2)
7472: IS

Line 7476: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;

7472: IS
7473: l_api_name CONSTANT VARCHAR2 (30)
7474: := 'UPDATE_BATCHSTEP_RESOURCE';
7475: l_batch_header gme_batch_header%ROWTYPE;
7476: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;
7477: l_batchstep_resource_rec_out gme_batch_step_resources%ROWTYPE;
7478: l_cons_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;
7479: l_return_status VARCHAR2 (2);
7480: l_step_status NUMBER;

Line 7477: l_batchstep_resource_rec_out gme_batch_step_resources%ROWTYPE;

7473: l_api_name CONSTANT VARCHAR2 (30)
7474: := 'UPDATE_BATCHSTEP_RESOURCE';
7475: l_batch_header gme_batch_header%ROWTYPE;
7476: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;
7477: l_batchstep_resource_rec_out gme_batch_step_resources%ROWTYPE;
7478: l_cons_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;
7479: l_return_status VARCHAR2 (2);
7480: l_step_status NUMBER;
7481:

Line 7478: l_cons_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;

7474: := 'UPDATE_BATCHSTEP_RESOURCE';
7475: l_batch_header gme_batch_header%ROWTYPE;
7476: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;
7477: l_batchstep_resource_rec_out gme_batch_step_resources%ROWTYPE;
7478: l_cons_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;
7479: l_return_status VARCHAR2 (2);
7480: l_step_status NUMBER;
7481:
7482: CURSOR cur_get_batchstep_status (

Line 7776: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;

7772: l_dummy NUMBER;
7773: l_batch_id NUMBER;
7774: l_batchstep_id NUMBER;
7775: l_return_status VARCHAR2 (2);
7776: l_batchstep_resource_rec gme_batch_step_resources%ROWTYPE;
7777:
7778: CURSOR cur_get_step_dtl (v_batchstep_rsrc_id NUMBER)
7779: IS
7780: SELECT c.organization_id, a.step_status, a.batch_id, a.batchstep_id

Line 7783: ,gme_batch_step_resources b

7779: IS
7780: SELECT c.organization_id, a.step_status, a.batch_id, a.batchstep_id
7781: ,b.batchstep_activity_id, c.batch_status
7782: FROM gme_batch_steps a
7783: ,gme_batch_step_resources b
7784: ,gme_batch_header c
7785: WHERE a.batch_id = b.batch_id
7786: AND a.batchstep_id = b.batchstep_id
7787: AND b.batchstep_resource_id = v_batchstep_rsrc_id

Line 7793: FROM gme_batch_header a, gme_batch_step_resources b

7789:
7790: CURSOR cur_validate_batch_type (v_rsrc_id NUMBER)
7791: IS
7792: SELECT 1
7793: FROM gme_batch_header a, gme_batch_step_resources b
7794: WHERE a.batch_id = b.batch_id
7795: AND b.batchstep_resource_id = v_rsrc_id
7796: AND a.batch_type = 10;
7797: