APPS.FUN_INITIATOR_WF_PKG dependencies on FUN_TRX_HEADERS

Line 53: l_trx_number fun_trx_headers.trx_number%TYPE;

49: l_currency Varchar2(15);
50:
51: l_initiator_name VARCHAR2(360);
52: l_initiator_person VARCHAR2(360);
53: l_trx_number fun_trx_headers.trx_number%TYPE;
54: l_user_env_lang varchar2(5);
55:
56: BEGIN
57: l_status_code :='Test';

Line 111: fun_trx_headers fth,

107: l_recipient_name,
108: l_trx_number,
109: l_initiator_name
110: FROM fun_trx_batches ftb,
111: fun_trx_headers fth,
112: hz_parties hzp,
113: hz_parties ini
114: WHERE ftb.batch_id = l_batch_id
115: AND ftb.batch_id=fth.batch_id

Line 518: FUN_TRX_HEADERS fth

514: fth.trx_id,
515: ftb.from_ledger_id,
516: ftb.batch_date
517: FROM FUN_TRX_BATCHES ftb,
518: FUN_TRX_HEADERS fth
519: WHERE fth.trx_id=p_trx_id
520: AND fth.batch_id=ftb.batch_id
521: AND fth.status='APPROVED';
522:

Line 544: FROM FUN_TRX_HEADERS fth,

540: fdl.ccid,
541: fth.batch_id,
542: fth.trx_id,
543: ftl.line_id
544: FROM FUN_TRX_HEADERS fth,
545: FUN_TRX_LINES ftl,
546: FUN_DIST_LINES fdl
547: WHERE fth.trx_id=p_trx_id
548: AND ftl.trx_id=fth.trx_id

Line 1073: --from fun_trx_headers h, fun_trx_batches b

1069: -- Also since the fun_trx_batches table is not used in the query removing a reference to the same
1070:
1071: --select ltrim(to_char(decode(nvl(h.reci_amount_cr,0),0,h.reci_amount_dr,h.reci_amount_cr),'999999999.99'))
1072: --into l_trx_amt
1073: --from fun_trx_headers h, fun_trx_batches b
1074: --where h.trx_id = l_trx_id
1075: --and b.batch_id = l_batch_id;
1076:
1077: SELECT LTRIM(TO_CHAR(DECODE(NVL(H.RECI_AMOUNT_CR,0),0,H.RECI_AMOUNT_DR,

Line 1081: FROM FUN_TRX_HEADERS H

1077: SELECT LTRIM(TO_CHAR(DECODE(NVL(H.RECI_AMOUNT_CR,0),0,H.RECI_AMOUNT_DR,
1078: H.RECI_AMOUNT_CR),
1079: '999999999D99'))
1080: INTO l_trx_amt
1081: FROM FUN_TRX_HEADERS H
1082: WHERE H.TRX_ID = l_trx_id;
1083:
1084: -- Bug: 7319371 END
1085:

Line 1200: UPDATE FUN_TRX_HEADERS

1196: FOR l_trans IN c_trans(l_request_id)
1197: LOOP
1198: -- Update the AR invoice number
1199:
1200: UPDATE FUN_TRX_HEADERS
1201: SET ar_invoice_number = l_trans.invoice_number
1202: WHERE trx_id = l_trans.trx_id
1203: AND batch_id = l_trans.batch_id
1204: AND ar_invoice_number IS NULL;

Line 1303: -- FUN_TRX_HEADERS.ar_invoice_number will be updated with the corresonding

1299: -------------------------------------------------------------------------------
1300: --Start of Comments
1301: --Function:
1302: -- After transactions are interfaced to AR and invoices have been created,
1303: -- FUN_TRX_HEADERS.ar_invoice_number will be updated with the corresonding
1304: -- AR_CUSTOMER_TRX_ALL.trx_number
1305:
1306: -- THIS PROCESS IS NOT USED ANYMORE
1307: -- INSTEAD GET_INVOICE IS USED

Line 1343: -- update FUN_TRX_HEADERS with the corresponding invoice number

1339: IF SQL%NOTFOUND THEN
1340: RETURN;
1341: END IF;
1342:
1343: -- update FUN_TRX_HEADERS with the corresponding invoice number
1344: FORALL i IN 1..l_trx_header_type.attribute1.COUNT
1345: UPDATE FUN_TRX_HEADERS
1346: SET ar_invoice_number = l_trx_header_type.invoice_number(i)
1347: WHERE batch_id = l_trx_header_type.attribute1(i)

Line 1345: UPDATE FUN_TRX_HEADERS

1341: END IF;
1342:
1343: -- update FUN_TRX_HEADERS with the corresponding invoice number
1344: FORALL i IN 1..l_trx_header_type.attribute1.COUNT
1345: UPDATE FUN_TRX_HEADERS
1346: SET ar_invoice_number = l_trx_header_type.invoice_number(i)
1347: WHERE batch_id = l_trx_header_type.attribute1(i)
1348: AND trx_id = l_trx_header_type.attribute2(i);
1349:

Line 1364: -- request_id, and then FUN_TRX_HEADERS.ar_invoice_number will be updated

1360: --Start of Comments
1361: --Function:
1362: -- After transactions are interfaced to AR and invoices have been created,
1363: -- it will get AR invoice number based on autoinvice conc. program
1364: -- request_id, and then FUN_TRX_HEADERS.ar_invoice_number will be updated
1365: -- with the corresonding AR invoice number
1366:
1367: -- THIS PROCESS IS NOT USED ANYMORE
1368: -- INSTEAD, GET_INVOICE IS CALLED FROM AR BUSINESS EVENT