APPS.CS_CHARGE_CREATE_ORDER_PVT dependencies on CS_ESTIMATE_DETAILS

Line 362: UPDATE CS_ESTIMATE_DETAILS

358: -- Standard Start of API Savepoint
359: -- SAVEPOINT Update_Errors;
360:
361: IF p_estimate_detail_id IS NOT NULL THEN
362: UPDATE CS_ESTIMATE_DETAILS
363: SET line_submitted = p_line_submitted,
364: submit_restriction_message = p_submit_restriction_message,
365: submit_error_message = p_submit_error_message,
366: submit_from_system = p_submit_from_system,

Line 549: FROM CS_ESTIMATE_DETAILS edt,

545: cbtc.rollup_item_id,
546: cbtc.billing_category,
547: edt.list_price , -- 4870210
548: i.item_type item_type_code --6523849
549: FROM CS_ESTIMATE_DETAILS edt,
550: CS_TXN_BILLING_OETXN_ALL tb,
551: CS_TXN_BILLING_TYPES tbt,
552: MTL_SYSTEM_ITEMS_KFV i,
553: CS_INCIDENTS_ALL_B sr,

Line 599: FROM CS_ESTIMATE_DETAILS edt,

595: p_invoice_to_org_id number,p_ship_to_org_id number ,
596: p_purchase_order_num varchar2,p_txn_billing_type_id number,
597: p_org_id number,p_order_type_id number,p_book_order_flag varchar2) IS
598: SELECT nvl(max(edt.order_header_id),-999)
599: FROM CS_ESTIMATE_DETAILS edt,
600: CS_TXN_BILLING_OETXN_ALL tb,
601: OE_ORDER_HEADERS_ALL oe
602: WHERE edt.incident_id = p_incident_id AND
603: edt.currency_code = p_currency_code AND

Line 3205: UPDATE CS_ESTIMATE_DETAILS

3201: , 'p_submit_from_system:' || p_submit_from_system
3202: );
3203: END IF;
3204:
3205: UPDATE CS_ESTIMATE_DETAILS
3206: SET Order_Header_Id = p_order_header_Id,
3207: Order_Line_Id = p_order_line_Id,
3208: line_submitted = p_line_submitted,
3209: submit_restriction_message = p_submit_restriction_message,