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 212: x_CHARGE_DETAIL_REC OUT NOCOPY CS_ESTIMATE_DETAILS%ROWTYPE ,

208:
209: PROCEDURE GET_CHARGE_DETAIL_REC(
210: P_API_NAME IN VARCHAR2,
211: P_ESTIMATE_DETAIL_ID IN NUMBER,
212: x_CHARGE_DETAIL_REC OUT NOCOPY CS_ESTIMATE_DETAILS%ROWTYPE ,
213: x_MSG_DATA OUT NOCOPY VARCHAR2,
214: x_MSG_COUNT OUT NOCOPY NUMBER,
215: x_RETURN_STATUS OUT NOCOPY VARCHAR2);
216:

Line 1473: FROM CS_ESTIMATE_DETAILS

1469: x_return_status OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
1470:
1471: Cursor c_estimate_detail_id IS
1472: SELECT 1
1473: FROM CS_ESTIMATE_DETAILS
1474: WHERE estimate_detail_id = p_estimate_detail_id;
1475:
1476: lv_exists_flag VARCHAR2(1) := 'N';
1477:

Line 1562: FROM CS_ESTIMATE_DETAILS

1558: x_return_status OUT NOCOPY VARCHAR2) RETURN VARCHAR2 IS
1559:
1560: Cursor c_line_number IS
1561: SELECT line_number
1562: FROM CS_ESTIMATE_DETAILS
1563: WHERE incident_id = p_incident_id and
1564: line_number = p_line_number;
1565:
1566: lv_exists_flag VARCHAR2(1) := 'N';

Line 1860: FROM CS_ESTIMATE_DETAILS

1856: ELSE
1857:
1858: SELECT max(line_number) + 1
1859: INTO l_line_num
1860: FROM CS_ESTIMATE_DETAILS
1861: WHERE incident_id = p_est_detail_rec.incident_id;
1862:
1863: END IF;
1864:

Line 1868: SELECT cs_estimate_details_s.nextval

1864:
1865: l_line_num := NVL(l_line_num,1);
1866:
1867:
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');

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

2260: END Create_Charge_Details;
2261:
2262:
2263: --=====================================================
2264: --API to Update Charge Details into CS_ESTIMATE_DETAILS
2265: --=====================================================
2266:
2267: PROCEDURE Update_Charge_Details(
2268: p_api_version IN NUMBER,

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,

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

2877:
2878: --==========================================================
2879: -- API Delete Charge Details
2880: -- Purpose: Delete a given a charge detail line
2881: -- from CS_ESTIMATE_DETAILS based on the unique id
2882: -- estimate_detail_id
2883: --==========================================================
2884:
2885: Procedure Delete_Charge_Details(

Line 3017: CS_ESTIMATE_DETAILS

3013: END IF ;
3014: -- END IF;
3015:
3016: DELETE FROM
3017: CS_ESTIMATE_DETAILS
3018: WHERE ESTIMATE_DETAIL_ID = p_estimate_detail_id ;
3019:
3020: --End of API Body
3021: --Standard Check of p_commit

Line 3100: from cs_estimate_details

3096: l_est_detail_rec CS_Charge_Details_PUB.Charges_Rec_Type;
3097:
3098: cursor c_charges_rec(p_estimate_detail_id NUMBER) IS
3099: select *
3100: from cs_estimate_details
3101: where estimate_detail_id = p_estimate_detail_id;
3102:
3103: v_charges_rec c_charges_rec%ROWTYPE;
3104: x_cost_id number;

Line 3574: l_db_rec CS_ESTIMATE_DETAILS%ROWTYPE;

3570: l_numerator NUMBER;
3571: l_denominator NUMBER;
3572: l_list_price NUMBER;
3573: l_contract_discount NUMBER;
3574: l_db_rec CS_ESTIMATE_DETAILS%ROWTYPE;
3575:
3576: l_transaction_type_changed VARCHAR2(1);
3577: l_item_changed VARCHAR2(1);
3578:

Line 3585: l_db_det_rec CS_ESTIMATE_DETAILS%ROWTYPE;

3581: l_request_date DATE;
3582: l_contract_line_id NUMBER;
3583:
3584: --RF
3585: l_db_det_rec CS_ESTIMATE_DETAILS%ROWTYPE;
3586: l_calc_sp VARCHAR2(1);
3587:
3588: --Fix for Bug # 3362130
3589: l_comms_trackable_flag VARCHAR2(1);

Line 14653: x_CHARGE_DETAIL_REC OUT NOCOPY CS_ESTIMATE_DETAILS%ROWTYPE ,

14649:
14650: PROCEDURE GET_CHARGE_DETAIL_REC(
14651: P_API_NAME IN VARCHAR2,
14652: P_ESTIMATE_DETAIL_ID IN NUMBER,
14653: x_CHARGE_DETAIL_REC OUT NOCOPY CS_ESTIMATE_DETAILS%ROWTYPE ,
14654: x_MSG_DATA OUT NOCOPY VARCHAR2,
14655: x_MSG_COUNT OUT NOCOPY NUMBER,
14656: x_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
14657: BEGIN

Line 14667: FROM CS_ESTIMATE_DETAILS

14663: x_return_status := FND_API.G_RET_STS_SUCCESS ;
14664:
14665: SELECT *
14666: INTO x_charge_detail_rec
14667: FROM CS_ESTIMATE_DETAILS
14668: WHERE ESTIMATE_DETAIL_ID = p_estimate_detail_id
14669: FOR UPDATE OF ESTIMATE_DETAIL_ID NOWAIT ;
14670:
14671: EXCEPTION

Line 14719: FROM CS_ESTIMATE_DETAILS

14715: Charge_line_type
14716: INTO x_order_line_id,
14717: x_gen_bca_flag,
14718: x_charge_line_type
14719: FROM CS_ESTIMATE_DETAILS
14720: WHERE estimate_detail_id = p_estimate_detail_id
14721: FOR UPDATE OF ESTIMATE_DETAIL_ID NOWAIT ;
14722:
14723:

Line 15363: cs_estimate_details e

15359: (
15360: SELECT
15361: t.object_id
15362: FROM
15363: cs_estimate_details e
15364: , jtf_object_purge_param_tmp t
15365: WHERE
15366: e.incident_id = t.object_id
15367: AND e.charge_line_type = 'ACTUAL'

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

15612:
15613: -- Delete all the estimate lines that correspond to the
15614: -- SRs that are available for purge after validations.
15615:
15616: DELETE /*+ index(e) */ cs_estimate_details e
15617: WHERE
15618: incident_id IN
15619: (
15620: SELECT /*+ no_unnest no_semijoin cardinality(10) */