APPS.PA_PWP_INVOICE_LINKS dependencies on PA_PWP_AP_INV_HDR

Line 58: UPDATE PA_PWP_AP_INV_HDR

54: l_draft_inv_link_type := l_draft_inv_link_type||','||DRAFTINV_REC.link_type;
55: END IF;
56: END LOOP;
57:
58: UPDATE PA_PWP_AP_INV_HDR
59: SET LINKED_DRAFT_INVOICE_NUM = l_draft_inv_number,
60: LINKED_DRFAT_INV_TYPE = l_draft_inv_link_type
61: WHERE INVOICE_ID = PA_LINK_TAB(i).AP_INVOICE_ID
62: AND PROJECT_ID = PA_LINK_TAB(i).PROJECT_ID;

Line 125: UPDATE PA_PWP_AP_INV_HDR

121: );
122: End Loop;
123:
124: FOR i in PA_LINK_TAB.first..PA_LINK_TAB.last Loop
125: UPDATE PA_PWP_AP_INV_HDR
126: SET LINKED_DRAFT_INVOICE_NUM = DECODE(LINKED_DRAFT_INVOICE_NUM, NULL,
127: to_char(PA_LINK_TAB(i).DRAFT_INVOICE_NUM),
128: LINKED_DRAFT_INVOICE_NUM|| ',' ||
129: to_char(PA_LINK_TAB(i).DRAFT_INVOICE_NUM)),