APPS.GMP_APS_WRITER dependencies on GME_RESOURCE_TXNS

Line 1480: DELETE gme_resource_txns

1476: v_in_step_res_row.batchstep_resource_id := -1;
1477: temp_calc := 0;
1478:
1479: -- Delete resource transactions for current batchstep resource */
1480: DELETE gme_resource_txns
1481: WHERE doc_id = v_batch_id
1482: AND resource_usage > 0
1483: AND line_id= v_step_resource_id ;
1484:

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

1675: puser_id IN NUMBER,
1676: plogin_id IN NUMBER,
1677: return_status OUT NOCOPY NUMBER ) IS
1678:
1679: v_in_trans_row gme_resource_txns%ROWTYPE; /* Added for NOCOPY */
1680: v_trans_row gme_resource_txns%ROWTYPE;
1681: l_doc_type VARCHAR2(5);
1682: BEGIN
1683: return_status := 0;

Line 1680: v_trans_row gme_resource_txns%ROWTYPE;

1676: plogin_id IN NUMBER,
1677: return_status OUT NOCOPY NUMBER ) IS
1678:
1679: v_in_trans_row gme_resource_txns%ROWTYPE; /* Added for NOCOPY */
1680: v_trans_row gme_resource_txns%ROWTYPE;
1681: l_doc_type VARCHAR2(5);
1682: BEGIN
1683: return_status := 0;
1684: /* B5470072, Resource Transaction should have doc_type of FPO */

Line 1723: IF NOT gme_resource_txns_dbl.insert_row

1719: gme_common_pvt.g_user_ident := puser_id;
1720: gme_common_pvt.g_login_id := plogin_id;
1721:
1722: -- This is not going to change For R12.0
1723: IF NOT gme_resource_txns_dbl.insert_row
1724: (v_in_trans_row, v_trans_row) THEN
1725: return_status := -1;
1726: ELSE
1727: return_status := 0;

Line 1774: v_trans_row gme_resource_txns%ROWTYPE;

1770: v_zero_res_id NUMBER ;
1771: v_offset_interval NUMBER ;
1772: temp_date DATE ;
1773:
1774: v_trans_row gme_resource_txns%ROWTYPE;
1775:
1776: -- Activities, its resources and resource transactions with ZERO usage
1777: -- or not convertible UOM
1778: -- Bug 13944581 vkinduri Modified cursor to restrict UOM conversion for DoNot Plan Resources.

Line 1860: DELETE gme_resource_txns

1856: found := 1;
1857: END IF;
1858: ELSIF v_zero.plan_rsrc_usage < 0 THEN
1859: -- Delete resource transactions for sequence depedent Usage */
1860: DELETE gme_resource_txns
1861: WHERE doc_id = v_batch_id
1862: AND nvl(sequence_dependent_ind,0) > 0
1863: AND line_id= v_zero_res_id ;
1864: v_trn_start_date := v_start_date;

Line 1891: DELETE gme_resource_txns

1887: /* temp_date := v_start_date +
1888: ( (v_zero.plan_rsrc_usage / v_zero.plan_rsrc_count) / 24 ) ; */
1889: temp_date := v_start_date ;
1890: -- Delete resource transactions for sequence depedent Usage */
1891: DELETE gme_resource_txns
1892: WHERE doc_id = v_batch_id
1893: AND nvl(sequence_dependent_ind,0) > 0
1894: AND line_id= v_zero_res_id ;
1895:

Line 1917: gme_resource_txns

1913: END IF;
1914:
1915: IF found = 1 THEN
1916: UPDATE
1917: gme_resource_txns
1918: SET
1919: start_date = v_trn_start_date,
1920: end_date = v_trn_end_date,
1921: trans_date = v_trn_start_date,