APPS.CS_SR_COST_CP dependencies on CS_COST_STAGING

Line 270: DELETE cs_cost_staging

266: -- execution of this concurrent program.
267: ----------------------------------------------------------------------------
268:
269:
270: DELETE cs_cost_staging
271: WHERE
272: concurrent_request_id IN
273: (
274: SELECT

Line 701: /*DELETE cs_cost_staging

697:
698:
699: -- Cleaning up the staging table
700:
701: /*DELETE cs_cost_staging
702: WHERE
703: concurrent_request_id = l_request_id;
704:
705: l_row_count := SQL%ROWCOUNT;*/

Line 737: /* DELETE cs_cost_staging

733: -- commented now
734:
735: -- Cleaning up the staging table
736:
737: /* DELETE cs_cost_staging
738: WHERE
739: concurrent_request_id = l_request_id;
740:
741: l_row_count := SQL%ROWCOUNT;*/

Line 1511: INSERT INTO cs_cost_staging

1507: LOOP
1508: FETCH get_estimate_id INTO l_estimate_detail_id;
1509: EXIT WHEN get_estimate_id%NOTFOUND;
1510:
1511: INSERT INTO cs_cost_staging
1512: (
1513: estimate_detail_id,
1514: worker_id,
1515: concurrent_request_id

Line 1564: UPDATE cs_cost_staging

1560:
1561: p_number_of_workers := l_number_of_workers;
1562:
1563:
1564: UPDATE cs_cost_staging
1565: SET
1566: worker_id = MOD
1567: (
1568: ROWNUM - 1

Line 1664: cs_cost_staging

1660: CURSOR c_staging IS
1661: SELECT
1662: estimate_detail_id
1663: FROM
1664: cs_cost_staging
1665: WHERE
1666: worker_id = p_worker_id
1667: AND concurrent_request_id = p_cost_set_id
1668: AND status IS NULL;

Line 1797: UPDATE cs_cost_staging

1793:
1794: OPEN c_check_cost;
1795: FETCH c_check_cost into l_cost_id;
1796: if c_check_cost%notfound then
1797: UPDATE cs_cost_staging
1798: SET status = 'E'
1799: ,error_message = x_msg_data
1800: WHERE estimate_detail_id = l_temp_count ;
1801: else

Line 1802: UPDATE cs_cost_staging

1798: SET status = 'E'
1799: ,error_message = x_msg_data
1800: WHERE estimate_detail_id = l_temp_count ;
1801: else
1802: UPDATE cs_cost_staging
1803: SET status = 'S'
1804: WHERE estimate_detail_id = l_temp_count ;
1805: end if;
1806: CLOSE c_check_cost;

Line 1816: UPDATE cs_cost_staging

1812: -- while executing the SR delete API
1813:
1814: THEN
1815:
1816: UPDATE cs_cost_staging
1817: SET
1818: status = 'E'
1819: , error_message = x_msg_data
1820: WHERE

Line 1885: cs_cost_staging css

1881: --, i.segment1 item_number
1882: -- , t.summary summary
1883:
1884: FROM
1885: cs_cost_staging css
1886: , cs_estimate_Details ced
1887: , cs_incidents_all_b cia
1888: -- , mtl_system_items_b i
1889: -- , hz_parties p

Line 1965: cs_cost_staging s

1961: count(1)
1962: INTO
1963: l_row_count
1964: FROM
1965: cs_cost_staging s
1966: WHERE
1967: s.worker_id = NVL(p_worker_id, s.worker_id);
1968:
1969: fnd_file.put_line

Line 1993: cs_cost_staging s

1989: count(1)
1990: INTO
1991: l_row_count
1992: FROM
1993: cs_cost_staging s
1994: WHERE
1995: status = 'S'
1996: AND s.worker_id = NVL(p_worker_id, s.worker_id);
1997:

Line 2021: cs_cost_staging s

2017: count(1)
2018: INTO
2019: l_row_count
2020: FROM
2021: cs_cost_staging s
2022: WHERE
2023: status IS NULL
2024: AND s.worker_id = NVL(p_worker_id, s.worker_id);
2025:

Line 2070: cs_cost_staging s

2066: count(1)
2067: INTO
2068: l_row_count
2069: FROM
2070: cs_cost_staging s
2071: WHERE
2072: status = 'E'
2073: AND s.worker_id = NVL(p_worker_id, s.worker_id);
2074: