DBA Data[Home] [Help]

APPS.CS_CHARGE_DETAILS_PVT dependencies on CS_ESTIMATE_DETAILS_PKG

Line 1872: --DBMS_OUTPUT.PUT_LINE('Calling CS_ESTIMATE_DETAILS_PKG.INSERT_ROW');

1868: SELECT cs_estimate_details_s.nextval
1869: INTO l_ed_id
1870: FROM DUAL ;
1871:
1872: --DBMS_OUTPUT.PUT_LINE('Calling CS_ESTIMATE_DETAILS_PKG.INSERT_ROW');
1873: --DBMS_OUTPUT.PUT_LINE('l_org_id = '||l_est_detail_rec.org_id);
1874: --DBMS_OUTPUT.PUT_LINE('l_est_detail_rec.incident_id = '||l_est_detail_rec.incident_id);
1875: --DBMS_OUTPUT.PUT_LINE('l_est_detail_rec.original_source_id = '||l_est_detail_rec.original_source_id);
1876: --DBMS_OUTPUT.PUT_LINE('l_est_detail_rec.original_source_code = '||l_est_detail_rec.original_source_code);

Line 1933: CS_ESTIMATE_DETAILS_PKG.Insert_Row(

1929: --DBMS_OUTPUT.PUT_LINE('p_user_id = '||p_user_id);
1930: --DBMS_OUTPUT.PUT_LINE('p_user_id = '||p_user_id);
1931: --DBMS_OUTPUT.PUT_LINE('l_ed_id = '||l_ed_id);
1932:
1933: CS_ESTIMATE_DETAILS_PKG.Insert_Row(
1934: p_org_id => l_est_detail_rec.org_id,
1935: p_incident_id => l_est_detail_rec.incident_id,
1936: p_original_source_id => l_est_detail_rec.original_source_id,
1937: p_original_source_code => l_est_detail_rec.original_source_code,

Line 2122: --DBMS_OUTPUT.PUT_LINE('Back from CS_ESTIMATE_DETAILS_PKG.INSERT_ROW. OVN '||x_object_version_number);

2118: p_created_by => p_user_id,
2119: p_estimate_detail_id => l_ed_id,
2120: x_object_version_number => x_object_version_number );
2121:
2122: --DBMS_OUTPUT.PUT_LINE('Back from CS_ESTIMATE_DETAILS_PKG.INSERT_ROW. OVN '||x_object_version_number);
2123:
2124: -- hint: primary key should be returned.
2125: -- x_estimate_detail_id := x_estimate_detail_id;
2126:

Line 2489: --DBMS_OUTPUT.PUT_LINE('Calling CS_ESTIMATE_DETAILS_PKG.UPDATE_ROW');

2485: l_est_detail_rec := p_est_detail_rec;
2486: END IF;
2487: END IF ;
2488:
2489: --DBMS_OUTPUT.PUT_LINE('Calling CS_ESTIMATE_DETAILS_PKG.UPDATE_ROW');
2490: --DBMS_OUTPUT.PUT_LINE('l_est_detail_rec.org_id = '||l_est_detail_rec.org_id);
2491: --DBMS_OUTPUT.PUT_LINE('l_est_detail_rec.incident_id = '||l_est_detail_rec.incident_id);
2492: --DBMS_OUTPUT.PUT_LINE('l_est_detail_rec.original_source_id = '||l_est_detail_rec.original_source_id);
2493: --DBMS_OUTPUT.PUT_LINE('l_est_detail_rec.original_source_code = '||l_est_detail_rec.original_source_code);

Line 2551: CS_ESTIMATE_DETAILS_PKG.Update_Row(

2547: --DBMS_OUTPUT.PUT_LINE('p_user_id = '||p_user_id);
2548: --DBMS_OUTPUT.PUT_LINE('l_ed_id = '||l_ed_id);
2549: --DBMS_OUTPUT.PUT_LINE('Before Update '||l_est_detail_rec.CONTRACT_ID);
2550:
2551: CS_ESTIMATE_DETAILS_PKG.Update_Row(
2552: x_object_version_number => x_object_version_number,
2553: p_ESTIMATE_DETAIL_ID => l_est_detail_rec.ESTIMATE_DETAIL_ID,
2554: p_ORG_ID => l_est_detail_rec.org_id,
2555: p_INCIDENT_ID => l_est_detail_rec.INCIDENT_ID,