APPS.GMP_APS_WRITER dependencies on GME_RESOURCE_TXNS

Line 1401: DELETE gme_resource_txns

1397: temp_date := NULL;
1398: v_in_step_res_row.batchstep_resource_id := -1;
1399:
1400: -- Delete resource transactions for current batchstep resource */
1401: DELETE gme_resource_txns
1402: WHERE doc_id = v_batch_id
1403: AND resource_usage > 0
1404: AND line_id= v_step_resource_id ;
1405:

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

1570: puser_id IN NUMBER,
1571: plogin_id IN NUMBER,
1572: return_status OUT NOCOPY NUMBER ) IS
1573:
1574: v_in_trans_row gme_resource_txns%ROWTYPE; /* Added for NOCOPY */
1575: v_trans_row gme_resource_txns%ROWTYPE;
1576: l_doc_type VARCHAR2(5);
1577: BEGIN
1578: return_status := 0;

Line 1575: v_trans_row gme_resource_txns%ROWTYPE;

1571: plogin_id IN NUMBER,
1572: return_status OUT NOCOPY NUMBER ) IS
1573:
1574: v_in_trans_row gme_resource_txns%ROWTYPE; /* Added for NOCOPY */
1575: v_trans_row gme_resource_txns%ROWTYPE;
1576: l_doc_type VARCHAR2(5);
1577: BEGIN
1578: return_status := 0;
1579: /* B5470072, Resource Transaction should have doc_type of FPO */

Line 1618: IF NOT gme_resource_txns_dbl.insert_row

1614: gme_common_pvt.g_user_ident := puser_id;
1615: gme_common_pvt.g_login_id := plogin_id;
1616:
1617: -- This is not going to change For R12.0
1618: IF NOT gme_resource_txns_dbl.insert_row
1619: (v_in_trans_row, v_trans_row) THEN
1620: return_status := -1;
1621: ELSE
1622: return_status := 0;

Line 1669: v_trans_row gme_resource_txns%ROWTYPE;

1665: v_zero_res_id NUMBER ;
1666: v_offset_interval NUMBER ;
1667: temp_date DATE ;
1668:
1669: v_trans_row gme_resource_txns%ROWTYPE;
1670:
1671: -- Activities, its resources and resource transactions with ZERO usage
1672: -- or not convertible UOM
1673: CURSOR get_zero_non_usage IS

Line 1759: DELETE gme_resource_txns

1755: END IF;
1756: ELSIF v_zero.plan_rsrc_usage < 0 THEN
1757:
1758: -- Delete resource transactions for sequence depedent Usage */
1759: DELETE gme_resource_txns
1760: WHERE doc_id = v_batch_id
1761: AND nvl(sequence_dependent_ind,0) > 0
1762: AND line_id= v_zero_res_id ;
1763:

Line 1796: DELETE gme_resource_txns

1792: e_msg := e_msg || ' User must maintain the DO NOT PLAN resource dates. ' || v_zero.resources;
1793: ELSE
1794:
1795: -- Delete resource transactions for sequence depedent Usage */
1796: DELETE gme_resource_txns
1797: WHERE doc_id = v_batch_id
1798: AND nvl(sequence_dependent_ind,0) > 0
1799: AND line_id= v_zero_res_id ;
1800:

Line 1825: gme_resource_txns

1821: END IF;
1822:
1823: IF found = 1 THEN
1824: UPDATE
1825: gme_resource_txns
1826: SET
1827: start_date = v_trn_start_date,
1828: end_date = v_trn_end_date,
1829: trans_date = v_trn_start_date,