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 565: NOT EXISTS (SELECT 1 FROM AP_INVOICES ai

561: */
562: l_delete_sql_string:=
563: 'DELETE from ZX_REP_TRX_DETAIL_T DET
564: WHERE DET.REQUEST_ID = '||P_TRL_GLOBAL_VARIABLES_REC.REQUEST_ID||' and
565: NOT EXISTS (SELECT 1 FROM AP_INVOICES ai
566: WHERE DET.EXTRACT_SOURCE_LEDGER = ''AP'' and
567: DET.TRX_LINE_CLASS IN (''STANDARD INVOICES'',''AP_CREDIT_MEMO'', ''AP_DEBIT_MEMO'') and
568: (DET.APPLIED_TO_TRX_NUMBER = ai.invoice_num OR DET.TRX_NUMBER = ai.invoice_num) and
569: DET.BILLING_TRADING_PARTNER_ID = ai.vendor_id and

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

1363: TYPE BASE_AMOUNT_TBL is TABLE OF
1364: ZX_REP_TRX_JX_EXT_T.NUMERIC13%TYPE INDEX BY BINARY_INTEGER;
1365:
1366: TYPE PRINT_DATE_TBL is TABLE OF
1367: ZX_REP_TRX_JX_EXT_T.GDF_AP_INVOICES_ATT4%TYPE INDEX BY BINARY_INTEGER;
1368:
1369: TYPE INHOUSE_INV_AMT_TBL is TABLE OF
1370: ZX_REP_TRX_JX_EXT_T.NUMERIC1%TYPE INDEX BY BINARY_INTEGER;
1371:

Line 1667: gdf_ap_invoices_att4, -- print date

1663:
1664: INSERT INTO ZX_REP_TRX_JX_EXT_T
1665: (detail_tax_line_ext_id,
1666: detail_tax_line_id,
1667: gdf_ap_invoices_att4, -- print date
1668: numeric12, -- document amount
1669: numeric13, -- document base amount
1670: created_by,
1671: creation_date,

Line 2199: | from AP_INVOICES table |

2195: | Type : Private |
2196: | Pre-req : None |
2197: | Function : |
2198: | This plug-in is used to fetch invoce_amount and base amount |
2199: | from AP_INVOICES table |
2200: | |
2201: | Called from ZX_JA_EXTRACT_PKG.POPULATE |
2202: | |
2203: | Parameters : |

Line 2220: X_PRINT_DATE OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_AP_INVOICES_ATT4%TYPE

2216: P_VENDOR_ID IN NUMBER,
2217: P_INVOICE_NUM IN VARCHAR2,
2218: X_INVOICE_AMT OUT NOCOPY ZX_REP_TRX_JX_EXT_T.NUMERIC12%TYPE,
2219: X_BASE_AMT OUT NOCOPY ZX_REP_TRX_JX_EXT_T.NUMERIC13%TYPE,
2220: X_PRINT_DATE OUT NOCOPY ZX_REP_TRX_JX_EXT_T.GDF_AP_INVOICES_ATT4%TYPE
2221: )
2222:
2223: IS
2224: BEGIN

Line 2240: FROM AP_INVOICES AI

2236: END IF;
2237:
2238: SELECT AI.GLOBAL_ATTRIBUTE4, AI.INVOICE_AMOUNT, AI.BASE_AMOUNT
2239: INTO X_PRINT_DATE, X_INVOICE_AMT, X_BASE_AMT
2240: FROM AP_INVOICES AI
2241: WHERE AI.VENDOR_ID = P_VENDOR_ID and
2242: AI.INVOICE_NUM = P_INVOICE_NUM;
2243:
2244: IF ( g_level_statement>= g_current_runtime_level ) THEN

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

2363: | UPDATE_PRINT_DATE |
2364: | Type : Private |
2365: | Pre-req : None |
2366: | Function : |
2367: | This plug-in updates print date stored in ap_invoices table for |
2368: | ZXTWPSPC |
2369: | |
2370: | Called from ZX_JA_EXTRACT_PKG.POPULATE |
2371: | |

Line 2393: FROM ap_invoices ai

2389: l_dummy varchar2(150);
2390:
2391: CURSOR c_invoice (l_invoice_id NUMBER)
2392: IS SELECT ai.global_attribute4
2393: FROM ap_invoices ai
2394: WHERE ai.invoice_id = l_invoice_id
2395: FOR UPDATE NOWAIT;
2396:
2397: BEGIN

Line 2425: ap_invoices

2421: FETCH c_invoice INTO l_dummy;
2422: EXIT WHEN c_invoice%NOTFOUND;
2423:
2424: UPDATE
2425: ap_invoices
2426: SET
2427: global_attribute4 = fnd_date.date_to_canonical(sysdate)
2428: WHERE
2429: invoice_id = p_invoice_id;