APPS.ZX_JA_EXTRACT_PKG dependencies on AP_INVOICES

Line 35: X_PRINT_DATE OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_AP_INVOICES_ATT4%TYPE

31: P_VENDOR_ID IN NUMBER,
32: P_INVOICE_NUM IN VARCHAR2,
33: X_INVOICE_AMT OUT NOCOPY ZX_REP_TRX_JX_EXT_T.NUMERIC12%TYPE,
34: X_BASE_AMT OUT NOCOPY ZX_REP_TRX_JX_EXT_T.NUMERIC13%TYPE,
35: X_PRINT_DATE OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_AP_INVOICES_ATT4%TYPE
36: );
37:
38: PROCEDURE UPDATE_PRINT_DATE
39: (

Line 553: NOT EXISTS (SELECT 1 FROM AP_INVOICES ai

549: */
550: l_delete_sql_string:=
551: 'DELETE from ZX_REP_TRX_DETAIL_T DET
552: WHERE DET.REQUEST_ID = '||P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID||' and
553: NOT EXISTS (SELECT 1 FROM AP_INVOICES ai
554: WHERE DET.EXTRACT_SOURCE_LEDGER = ''AP'' and
555: DET.TRX_LINE_CLASS IN (''STANDARD INVOICES'',''AP_CREDIT_MEMO'', ''AP_DEBIT_MEMO'') and
556: (DET.APPLIED_TO_TRX_NUMBER = ai.invoice_num OR DET.TRX_NUMBER = ai.invoice_num) and
557: DET.BILLING_TRADING_PARTNER_ID = ai.vendor_id and

Line 1362: ZX_REP_TRX_JX_EXT_T.GDF_AP_INVOICES_ATT4%TYPE INDEX BY BINARY_INTEGER;

1358: TYPE BASE_AMOUNT_TBL is TABLE OF
1359: ZX_REP_TRX_JX_EXT_T.NUMERIC13%TYPE INDEX BY BINARY_INTEGER;
1360:
1361: TYPE PRINT_DATE_TBL is TABLE OF
1362: ZX_REP_TRX_JX_EXT_T.GDF_AP_INVOICES_ATT4%TYPE INDEX BY BINARY_INTEGER;
1363:
1364: TYPE INHOUSE_INV_AMT_TBL is TABLE OF
1365: ZX_REP_TRX_JX_EXT_T.NUMERIC1%TYPE INDEX BY BINARY_INTEGER;
1366:

Line 1658: gdf_ap_invoices_att4, -- print date

1654:
1655: INSERT INTO ZX_REP_TRX_JX_EXT_T
1656: (detail_tax_line_ext_id,
1657: detail_tax_line_id,
1658: gdf_ap_invoices_att4, -- print date
1659: numeric12, -- document amount
1660: numeric13, -- document base amount
1661: created_by,
1662: creation_date,

Line 2126: | from AP_INVOICES table |

2122: | Type : Private |
2123: | Pre-req : None |
2124: | Function : |
2125: | This plug-in is used to fetch invoce_amount and base amount |
2126: | from AP_INVOICES table |
2127: | |
2128: | Called from ZX_JA_EXTRACT_PKG.POPULATE |
2129: | |
2130: | Parameters : |

Line 2147: X_PRINT_DATE OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_AP_INVOICES_ATT4%TYPE

2143: P_VENDOR_ID IN NUMBER,
2144: P_INVOICE_NUM IN VARCHAR2,
2145: X_INVOICE_AMT OUT NOCOPY ZX_REP_TRX_JX_EXT_T.NUMERIC12%TYPE,
2146: X_BASE_AMT OUT NOCOPY ZX_REP_TRX_JX_EXT_T.NUMERIC13%TYPE,
2147: X_PRINT_DATE OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_AP_INVOICES_ATT4%TYPE
2148: )
2149:
2150: IS
2151: BEGIN

Line 2167: FROM AP_INVOICES AI

2163: END IF;
2164:
2165: SELECT AI.GLOBAL_ATTRIBUTE4, AI.INVOICE_AMOUNT, AI.BASE_AMOUNT
2166: INTO X_PRINT_DATE, X_INVOICE_AMT, X_BASE_AMT
2167: FROM AP_INVOICES AI
2168: WHERE AI.VENDOR_ID = P_VENDOR_ID and
2169: AI.INVOICE_NUM = P_INVOICE_NUM;
2170:
2171: IF ( g_level_statement>= g_current_runtime_level ) THEN

Line 2294: | This plug-in updates print date stored in ap_invoices table for |

2290: | UPDATE_PRINT_DATE |
2291: | Type : Private |
2292: | Pre-req : None |
2293: | Function : |
2294: | This plug-in updates print date stored in ap_invoices table for |
2295: | ZXTWPSPC |
2296: | |
2297: | Called from ZX_JA_EXTRACT_PKG.POPULATE |
2298: | |

Line 2320: FROM ap_invoices ai

2316: l_dummy varchar2(150);
2317:
2318: CURSOR c_invoice (l_invoice_id NUMBER)
2319: IS SELECT ai.global_attribute4
2320: FROM ap_invoices ai
2321: WHERE ai.invoice_id = l_invoice_id
2322: FOR UPDATE NOWAIT;
2323:
2324: BEGIN

Line 2352: ap_invoices

2348: FETCH c_invoice INTO l_dummy;
2349: EXIT WHEN c_invoice%NOTFOUND;
2350:
2351: UPDATE
2352: ap_invoices
2353: SET
2354: global_attribute4 = fnd_date.date_to_canonical(sysdate)
2355: WHERE
2356: invoice_id = p_invoice_id;