APPS.GMP_WPS_WRITER dependencies on GME_RESOURCE_TXNS

Line 329: v_trans_row gme_resource_txns%ROWTYPE;

325: v_trn_end_date DATE;
326: v_start_date DATE;
327: v_end_date DATE;
328: v_hour_uom VARCHAR2(3);
329: v_trans_row gme_resource_txns%ROWTYPE;
330:
331: last_update_date DATE;
332:
333: CURSOR validate_activity IS

Line 471: gme_resource_txns

467: END IF;
468:
469: IF found = 1 THEN
470: UPDATE
471: gme_resource_txns
472: SET
473: start_date = v_trn_start_date,
474: end_date = v_trn_end_date,
475: last_update_date = SYSDATE,

Line 720: gme_resource_txns

716: EXIT WHEN return_status < 0;
717:
718: /* delete all resource transactions for current step resource */
719: DELETE
720: gme_resource_txns
721: WHERE
722: doc_id = v_batch_id
723: AND line_id = v_act_resource_id
724: AND doc_type = v_doc_prod

Line 921: v_in_trans_row gme_resource_txns%ROWTYPE; /* Added for NOCOPY */

917: v_end_date DATE;
918: v_res_usage NUMBER;
919: temp_date NUMBER;
920: row_cnt NUMBER;
921: v_in_trans_row gme_resource_txns%ROWTYPE; /* Added for NOCOPY */
922: v_trans_row gme_resource_txns%ROWTYPE;
923:
924: CURSOR validate_resource IS
925: SELECT

Line 922: v_trans_row gme_resource_txns%ROWTYPE;

918: v_res_usage NUMBER;
919: temp_date NUMBER;
920: row_cnt NUMBER;
921: v_in_trans_row gme_resource_txns%ROWTYPE; /* Added for NOCOPY */
922: v_trans_row gme_resource_txns%ROWTYPE;
923:
924: CURSOR validate_resource IS
925: SELECT
926: crd.schedule_ind,

Line 1017: IF NOT gme_resource_txns_dbl.insert_row

1013: gme_common_pvt.g_login_id := plogin_id;
1014:
1015: FOR j IN 1..prsrc_count(i) LOOP
1016: -- This is not going to change For R12.0
1017: IF NOT gme_resource_txns_dbl.insert_row
1018: (v_in_trans_row, v_trans_row) THEN
1019: return_status := -2;
1020: EXIT;
1021: ELSE