APPS.AP_APXINUPD_XMLP_PKG dependencies on AP_HISTORY_INVOICES_ALL

Line 296: AP_HISTORY_INVOICES_ALL

292: OR EXISTS (
293: SELECT
294: 'Duplicates exist in ap_history_invoices'
295: FROM
296: AP_HISTORY_INVOICES_ALL
297: WHERE INVOICE_NUM = C_INVOICE_NUM
298: AND VENDOR_ID = C_VENDOR_ID
299: AND INVOICE_ID <> C_INVOICE_ID );
300: RETURN (C_NLS_YES);

Line 594: AP_HISTORY_INVOICES_ALL AHI1

590: CURSOR C_DUP_HISTORY IS
591: SELECT
592: AHI1.INVOICE_NUM
593: FROM
594: AP_HISTORY_INVOICES_ALL AHI1
595: WHERE VENDOR_ID = V_OLD_VENDOR_ID
596: AND EXISTS (
597: SELECT
598: 'The merge-to supplier already has this invoice num'

Line 600: AP_HISTORY_INVOICES_ALL AHI2

596: AND EXISTS (
597: SELECT
598: 'The merge-to supplier already has this invoice num'
599: FROM
600: AP_HISTORY_INVOICES_ALL AHI2
601: WHERE AHI2.VENDOR_ID = V_NEW_VENDOR_ID
602: AND AHI2.INVOICE_NUM = AHI1.INVOICE_NUM );
603: pragma autonomous_transaction;
604:

Line 691: AP_HISTORY_INVOICES_ALL

687: NULL;
688: ELSE
689: IF V_OLD_COMB_LENGTH <= 50 THEN
690: UPDATE
691: AP_HISTORY_INVOICES_ALL
692: SET
693: INVOICE_NUM = V_DUP_HIST_INVOICE || '*' || V_OLD_VENDOR_NUM
694: WHERE VENDOR_ID = V_OLD_VENDOR_ID
695: AND INVOICE_NUM = V_DUP_HIST_INVOICE;

Line 702: AP_HISTORY_INVOICES_ALL

698: V_OLD_VENDOR_NUM := SUBSTR(V_OLD_VENDOR_NUM
699: ,1
700: ,V_OLD_VENDOR_NUM_LENGTH - V_DIFF);
701: UPDATE
702: AP_HISTORY_INVOICES_ALL
703: SET
704: INVOICE_NUM = V_DUP_HIST_INVOICE || '*' || V_OLD_VENDOR_NUM
705: WHERE VENDOR_ID = V_OLD_VENDOR_ID
706: AND INVOICE_NUM = V_DUP_HIST_INVOICE;

Line 710: AP_HISTORY_INVOICES_ALL

706: AND INVOICE_NUM = V_DUP_HIST_INVOICE;
707: END IF;
708: IF V_OLD_COMB_LENGTH <= 50 THEN
709: UPDATE
710: AP_HISTORY_INVOICES_ALL
711: SET
712: INVOICE_NUM = V_DUP_HIST_INVOICE || '-' || V_NEW_VENDOR_NUM
713: WHERE VENDOR_ID = V_NEW_VENDOR_ID
714: AND INVOICE_NUM = V_DUP_HIST_INVOICE;

Line 721: AP_HISTORY_INVOICES_ALL

717: V_NEW_VENDOR_NUM := SUBSTR(V_NEW_VENDOR_NUM
718: ,1
719: ,V_NEW_VENDOR_NUM_LENGTH - V_DIFF);
720: UPDATE
721: AP_HISTORY_INVOICES_ALL
722: SET
723: INVOICE_NUM = V_DUP_HIST_INVOICE || '-' || V_NEW_VENDOR_NUM
724: WHERE VENDOR_ID = V_NEW_VENDOR_ID
725: AND INVOICE_NUM = V_DUP_HIST_INVOICE;

Line 730: AP_HISTORY_INVOICES_ALL ahi

726: END IF;
727: END IF;
728: END LOOP;
729: UPDATE
730: AP_HISTORY_INVOICES_ALL ahi
731: SET
732: VENDOR_ID = V_NEW_VENDOR_ID
733: WHERE VENDOR_ID = V_OLD_VENDOR_ID
734: AND NOT EXISTS (

Line 1156: 'UPDATE ap_history_invoices_all ahi

1152: ,ORG_PARTY_SITE_ID = C_PARTY_SITE_ID_PO
1153: WHERE ORG_PARTY_SITE_ID = C_DUP_PARTY_SITE_ID_PO;
1154: END IF;
1155: EXECUTE IMMEDIATE
1156: 'UPDATE ap_history_invoices_all ahi
1157: SET vendor_id = :C_VENDOR_ID_PO
1158: WHERE vendor_id = :C_DUP_VENDOR_ID_PO
1159: and not exists (select null
1160: from ap_invoices ai