DBA Data[Home] [Help]

APPS.CS_CHARGE_DETAILS_PVT dependencies on CS_ESTIMATE_DETAILS_PKG

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

1978: SELECT cs_estimate_details_s.nextval
1979: INTO l_ed_id
1980: FROM DUAL ;
1981:
1982: --DBMS_OUTPUT.PUT_LINE('Calling CS_ESTIMATE_DETAILS_PKG.INSERT_ROW');
1983: --DBMS_OUTPUT.PUT_LINE('l_org_id = '||l_est_detail_rec.org_id);
1984: --DBMS_OUTPUT.PUT_LINE('l_est_detail_rec.incident_id = '||l_est_detail_rec.incident_id);
1985: --DBMS_OUTPUT.PUT_LINE('l_est_detail_rec.original_source_id = '||l_est_detail_rec.original_source_id);
1986: --DBMS_OUTPUT.PUT_LINE('l_est_detail_rec.original_source_code = '||l_est_detail_rec.original_source_code);

Line 2054: CS_ESTIMATE_DETAILS_PKG.Insert_Row(

2050: , 'The Value of l_est_detail_rec.arrival_date_time :' || l_est_detail_rec.arrival_date_time
2051: );
2052: END IF;
2053:
2054: CS_ESTIMATE_DETAILS_PKG.Insert_Row(
2055: p_org_id => l_est_detail_rec.org_id,
2056: p_incident_id => l_est_detail_rec.incident_id,
2057: p_original_source_id => l_est_detail_rec.original_source_id,
2058: p_original_source_code => l_est_detail_rec.original_source_code,

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

2253: p_project_task_id => l_est_detail_rec.project_task_id,
2254: p_expenditure_org_id => l_est_detail_rec.expenditure_org_id,
2255: x_object_version_number => x_object_version_number );
2256:
2257: --DBMS_OUTPUT.PUT_LINE('Back from CS_ESTIMATE_DETAILS_PKG.INSERT_ROW. OVN '||x_object_version_number);
2258:
2259: -- hint: primary key should be returned.
2260: -- x_estimate_detail_id := x_estimate_detail_id;
2261:

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

2620: l_est_detail_rec := p_est_detail_rec;
2621: END IF;
2622: END IF ;
2623:
2624: --DBMS_OUTPUT.PUT_LINE('Calling CS_ESTIMATE_DETAILS_PKG.UPDATE_ROW');
2625: --DBMS_OUTPUT.PUT_LINE('l_est_detail_rec.org_id = '||l_est_detail_rec.org_id);
2626: --DBMS_OUTPUT.PUT_LINE('l_est_detail_rec.incident_id = '||l_est_detail_rec.incident_id);
2627: --DBMS_OUTPUT.PUT_LINE('l_est_detail_rec.original_source_id = '||l_est_detail_rec.original_source_id);
2628: --DBMS_OUTPUT.PUT_LINE('l_est_detail_rec.original_source_code = '||l_est_detail_rec.original_source_code);

Line 2686: CS_ESTIMATE_DETAILS_PKG.Update_Row(

2682: --DBMS_OUTPUT.PUT_LINE('p_user_id = '||p_user_id);
2683: --DBMS_OUTPUT.PUT_LINE('l_ed_id = '||l_ed_id);
2684: --DBMS_OUTPUT.PUT_LINE('Before Update '||l_est_detail_rec.CONTRACT_ID);
2685:
2686: CS_ESTIMATE_DETAILS_PKG.Update_Row(
2687: x_object_version_number => x_object_version_number,
2688: p_ESTIMATE_DETAIL_ID => l_est_detail_rec.ESTIMATE_DETAIL_ID,
2689: p_ORG_ID => l_est_detail_rec.org_id,
2690: p_INCIDENT_ID => l_est_detail_rec.INCIDENT_ID,