DBA Data[Home] [Help]

APPS.PA_MCB_INVOICE_PKG dependencies on PA_CUST_EVENT_RDL_ALL

Line 2055: UPDATE pa_cust_event_rdl_all

2051:
2052: ELSIF TmpInvLines(k).revenue_amount <> 0 THEN
2053: -- Update only if the event is revenue event
2054:
2055: UPDATE pa_cust_event_rdl_all
2056: SET draft_invoice_item_line_num = TmpInvLines(k).current_line_num+1000000
2057: WHERE project_id = p_project_id
2058: AND request_id = p_request_id
2059: AND draft_invoice_num = TmpInvLines(k).current_draft_invoice_num

Line 2107: UPDATE pa_cust_event_rdl_all

2103: /*For bug 3144517*/
2104: ELSIF TmpInvLines(k).revenue_amount <> 0 THEN
2105: -- Update only if the event is revenue event
2106:
2107: UPDATE pa_cust_event_rdl_all
2108: SET draft_invoice_num = TmpInvLines(k).new_draft_invoice_num,
2109: draft_invoice_item_line_num = TmpInvLines(k).new_line_num
2110: WHERE project_id = p_project_id
2111: AND request_id = p_request_id