eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CS_CHARGE_DETAILS_PVT dependencies on CS_ESTIMATE_DETAILS

Line 222: x_CHARGE_DETAIL_REC OUT NOCOPY CS_ESTIMATE_DETAILS%ROWTYPE ,

218:
219: PROCEDURE GET_CHARGE_DETAIL_REC(
220: P_API_NAME IN VARCHAR2,
221: P_ESTIMATE_DETAIL_ID IN NUMBER,
222: x_CHARGE_DETAIL_REC OUT NOCOPY CS_ESTIMATE_DETAILS%ROWTYPE ,
223: x_MSG_DATA OUT NOCOPY VARCHAR2,
224: x_MSG_COUNT OUT NOCOPY NUMBER,
225: x_RETURN_STATUS OUT NOCOPY VARCHAR2);
226:

Line 1573: FROM CS_ESTIMATE_DETAILS

1569: x_return_status OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
1570:
1571: Cursor c_estimate_detail_id IS
1572: SELECT 1
1573: FROM CS_ESTIMATE_DETAILS
1574: WHERE estimate_detail_id = p_estimate_detail_id;
1575:
1576: lv_exists_flag VARCHAR2(1) := 'N';
1577:

Line 1662: FROM CS_ESTIMATE_DETAILS

1658: x_return_status OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
1659:
1660: Cursor c_line_number IS
1661: SELECT line_number
1662: FROM CS_ESTIMATE_DETAILS
1663: WHERE incident_id = p_incident_id and
1664: line_number = p_line_number;
1665:
1666: lv_exists_flag VARCHAR2(1) := 'N';

Line 1970: FROM CS_ESTIMATE_DETAILS

1966: ELSE
1967:
1968: SELECT max(line_number) + 1
1969: INTO l_line_num
1970: FROM CS_ESTIMATE_DETAILS
1971: WHERE incident_id = p_est_detail_rec.incident_id;
1972:
1973: END IF;
1974:

Line 1978: SELECT cs_estimate_details_s.nextval

1974:
1975: l_line_num := NVL(l_line_num,1);
1976:
1977:
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');

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 2399: --API to Update Charge Details into CS_ESTIMATE_DETAILS

2395: END Create_Charge_Details;
2396:
2397:
2398: --=====================================================
2399: --API to Update Charge Details into CS_ESTIMATE_DETAILS
2400: --=====================================================
2401:
2402: PROCEDURE Update_Charge_Details(
2403: p_api_version IN NUMBER,

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,

Line 3029: -- from CS_ESTIMATE_DETAILS based on the unique id

3025:
3026: --==========================================================
3027: -- API Delete Charge Details
3028: -- Purpose: Delete a given a charge detail line
3029: -- from CS_ESTIMATE_DETAILS based on the unique id
3030: -- estimate_detail_id
3031: --==========================================================
3032:
3033: Procedure Delete_Charge_Details(

Line 3165: CS_ESTIMATE_DETAILS

3161: END IF ;
3162: -- END IF;
3163:
3164: DELETE FROM
3165: CS_ESTIMATE_DETAILS
3166: WHERE ESTIMATE_DETAIL_ID = p_estimate_detail_id ;
3167:
3168: --End of API Body
3169: --Standard Check of p_commit

Line 3248: from cs_estimate_details

3244: l_est_detail_rec CS_Charge_Details_PUB.Charges_Rec_Type;
3245:
3246: cursor c_charges_rec(p_estimate_detail_id NUMBER) IS
3247: select *
3248: from cs_estimate_details
3249: where estimate_detail_id = p_estimate_detail_id;
3250:
3251: v_charges_rec c_charges_rec%ROWTYPE;
3252: x_cost_id number;

Line 3776: l_db_rec CS_ESTIMATE_DETAILS%ROWTYPE;

3772: l_numerator NUMBER;
3773: l_denominator NUMBER;
3774: l_list_price NUMBER;
3775: l_contract_discount NUMBER;
3776: l_db_rec CS_ESTIMATE_DETAILS%ROWTYPE;
3777:
3778: l_transaction_type_changed VARCHAR2(1);
3779: l_item_changed VARCHAR2(1);
3780:

Line 3787: l_db_det_rec CS_ESTIMATE_DETAILS%ROWTYPE;

3783: l_request_date DATE;
3784: l_contract_line_id NUMBER;
3785:
3786: --RF
3787: l_db_det_rec CS_ESTIMATE_DETAILS%ROWTYPE;
3788: l_calc_sp VARCHAR2(1);
3789:
3790: --Fix for Bug # 3362130
3791: l_comms_trackable_flag VARCHAR2(1);

Line 16190: x_CHARGE_DETAIL_REC OUT NOCOPY CS_ESTIMATE_DETAILS%ROWTYPE ,

16186:
16187: PROCEDURE GET_CHARGE_DETAIL_REC(
16188: P_API_NAME IN VARCHAR2,
16189: P_ESTIMATE_DETAIL_ID IN NUMBER,
16190: x_CHARGE_DETAIL_REC OUT NOCOPY CS_ESTIMATE_DETAILS%ROWTYPE ,
16191: x_MSG_DATA OUT NOCOPY VARCHAR2,
16192: x_MSG_COUNT OUT NOCOPY NUMBER,
16193: x_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
16194: BEGIN

Line 16204: FROM CS_ESTIMATE_DETAILS

16200: x_return_status := FND_API.G_RET_STS_SUCCESS ;
16201:
16202: SELECT *
16203: INTO x_charge_detail_rec
16204: FROM CS_ESTIMATE_DETAILS
16205: WHERE ESTIMATE_DETAIL_ID = p_estimate_detail_id
16206: FOR UPDATE OF ESTIMATE_DETAIL_ID NOWAIT ;
16207:
16208: EXCEPTION

Line 16256: FROM CS_ESTIMATE_DETAILS

16252: Charge_line_type
16253: INTO x_order_line_id,
16254: x_gen_bca_flag,
16255: x_charge_line_type
16256: FROM CS_ESTIMATE_DETAILS
16257: WHERE estimate_detail_id = p_estimate_detail_id
16258: FOR UPDATE OF ESTIMATE_DETAIL_ID NOWAIT ;
16259:
16260:

Line 16934: cs_estimate_details e

16930: (
16931: SELECT
16932: t.object_id
16933: FROM
16934: cs_estimate_details e
16935: , jtf_object_purge_param_tmp t
16936: WHERE
16937: e.incident_id = t.object_id
16938: AND e.charge_line_type = 'ACTUAL'

Line 17188: DELETE /+ index(e) / cs_estimate_details e

17184: -- Delete all the estimate lines that correspond to the
17185: -- SRs that are available for purge after validations.
17186: -- bug 12681409 Change the hint to cardinality(jtf_object_purge_param_tmp, 10)
17187:
17188: DELETE /*+ index(e) */ cs_estimate_details e
17189: WHERE
17190: incident_id IN
17191: (
17192: SELECT /*+ cardinality(jtf_object_purge_param_tmp, 10) */