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 582: FROM CS_ESTIMATE_DETAILS edt,

578: sr.system_id, -- Bug 11936035
579: edt.no_charge_flag, -- bug 12907768,
580: edt.project_id, --12.2.2 Service Projects Integration
581: edt.project_task_id --12.2.2 Service Projects Integration
582: FROM CS_ESTIMATE_DETAILS edt,
583: CS_TXN_BILLING_OETXN_ALL tb,
584: CS_TXN_BILLING_TYPES tbt,
585: MTL_SYSTEM_ITEMS_KFV i,
586: CS_INCIDENTS_ALL_B sr,

Line 633: FROM CS_ESTIMATE_DETAILS edt,

629: p_invoice_to_org_id number,p_ship_to_org_id number ,
630: p_purchase_order_num varchar2,p_txn_billing_type_id number,
631: p_org_id number,p_order_type_id number,p_book_order_flag varchar2) IS
632: SELECT nvl(max(edt.order_header_id),-999)
633: FROM CS_ESTIMATE_DETAILS edt,
634: CS_TXN_BILLING_OETXN_ALL tb,
635: OE_ORDER_HEADERS_ALL oe
636: WHERE edt.incident_id = p_incident_id AND
637: edt.currency_code = p_currency_code AND

Line 3803: UPDATE CS_ESTIMATE_DETAILS

3799: , 'p_submit_from_system:' || p_submit_from_system
3800: );
3801: END IF;
3802:
3803: UPDATE CS_ESTIMATE_DETAILS
3804: SET Order_Header_Id = p_order_header_Id,
3805: Order_Line_Id = p_order_line_Id,
3806: line_submitted = p_line_submitted,
3807: submit_restriction_message = p_submit_restriction_message,