DBA Data[Home] [Help]

APPS.PA_MCB_INVOICE_PKG dependencies on PA_CUST_EVENT_RDL_ALL

Line 2063: UPDATE pa_cust_event_rdl_all

2059:
2060: ELSIF TmpInvLines(k).revenue_amount <> 0 THEN
2061: -- Update only if the event is revenue event
2062:
2063: UPDATE pa_cust_event_rdl_all
2064: SET draft_invoice_item_line_num = TmpInvLines(k).current_line_num+1000000
2065: WHERE project_id = p_project_id
2066: AND request_id = p_request_id
2067: AND draft_invoice_num = TmpInvLines(k).current_draft_invoice_num

Line 2115: UPDATE pa_cust_event_rdl_all

2111: /*For bug 3144517*/
2112: ELSIF TmpInvLines(k).revenue_amount <> 0 THEN
2113: -- Update only if the event is revenue event
2114:
2115: UPDATE pa_cust_event_rdl_all
2116: SET draft_invoice_num = TmpInvLines(k).new_draft_invoice_num,
2117: draft_invoice_item_line_num = TmpInvLines(k).new_line_num
2118: WHERE project_id = p_project_id
2119: AND request_id = p_request_id