APPS.FUN_INITIATOR_WF_PKG dependencies on FUN_TRX_HEADERS

Line 52: l_trx_number fun_trx_headers.trx_number%TYPE;

48: l_trx_amt NUMBER;
49: l_currency Varchar2(15);
50:
51: l_initiator_name VARCHAR2(360);
52: l_trx_number fun_trx_headers.trx_number%TYPE;
53:
54: BEGIN
55: l_status_code :='Test';
56: IF (funcmode = 'RUN') THEN

Line 105: fun_trx_headers fth,

101: l_recipient_name,
102: l_trx_number,
103: l_initiator_name
104: FROM fun_trx_batches ftb,
105: fun_trx_headers fth,
106: hz_parties hzp,
107: hz_parties ini
108: WHERE ftb.batch_id = l_batch_id
109: AND ftb.batch_id=fth.batch_id

Line 484: FUN_TRX_HEADERS fth

480: fth.trx_id,
481: ftb.from_ledger_id,
482: ftb.batch_date
483: FROM FUN_TRX_BATCHES ftb,
484: FUN_TRX_HEADERS fth
485: WHERE fth.trx_id=p_trx_id
486: AND fth.batch_id=ftb.batch_id
487: AND fth.status='APPROVED';
488:

Line 510: FROM FUN_TRX_HEADERS fth,

506: fdl.ccid,
507: fth.batch_id,
508: fth.trx_id,
509: ftl.line_id
510: FROM FUN_TRX_HEADERS fth,
511: FUN_TRX_LINES ftl,
512: FUN_DIST_LINES fdl
513: WHERE fth.trx_id=p_trx_id
514: AND ftl.trx_id=fth.trx_id

Line 994: --from fun_trx_headers h, fun_trx_batches b

990: -- Also since the fun_trx_batches table is not used in the query removing a reference to the same
991:
992: --select ltrim(to_char(decode(nvl(h.reci_amount_cr,0),0,h.reci_amount_dr,h.reci_amount_cr),'999999999.99'))
993: --into l_trx_amt
994: --from fun_trx_headers h, fun_trx_batches b
995: --where h.trx_id = l_trx_id
996: --and b.batch_id = l_batch_id;
997:
998: SELECT LTRIM(TO_CHAR(DECODE(NVL(H.RECI_AMOUNT_CR,0),0,H.RECI_AMOUNT_DR,

Line 1002: FROM FUN_TRX_HEADERS H

998: SELECT LTRIM(TO_CHAR(DECODE(NVL(H.RECI_AMOUNT_CR,0),0,H.RECI_AMOUNT_DR,
999: H.RECI_AMOUNT_CR),
1000: '999999999D99'))
1001: INTO l_trx_amt
1002: FROM FUN_TRX_HEADERS H
1003: WHERE H.TRX_ID = l_trx_id;
1004:
1005: -- Bug: 7319371 END
1006:

Line 1120: UPDATE FUN_TRX_HEADERS

1116: FOR l_trans IN c_trans(l_request_id)
1117: LOOP
1118: -- Update the AR invoice number
1119:
1120: UPDATE FUN_TRX_HEADERS
1121: SET ar_invoice_number = l_trans.invoice_number
1122: WHERE trx_id = l_trans.trx_id
1123: AND batch_id = l_trans.batch_id
1124: AND ar_invoice_number IS NULL;

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

1219: -------------------------------------------------------------------------------
1220: --Start of Comments
1221: --Function:
1222: -- After transactions are interfaced to AR and invoices have been created,
1223: -- FUN_TRX_HEADERS.ar_invoice_number will be updated with the corresonding
1224: -- AR_CUSTOMER_TRX_ALL.trx_number
1225:
1226: -- THIS PROCESS IS NOT USED ANYMORE
1227: -- INSTEAD GET_INVOICE IS USED

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

1258: IF SQL%NOTFOUND THEN
1259: RETURN;
1260: END IF;
1261:
1262: -- update FUN_TRX_HEADERS with the corresponding invoice number
1263: FORALL i IN 1..l_trx_header_type.attribute1.COUNT
1264: UPDATE FUN_TRX_HEADERS
1265: SET ar_invoice_number = l_trx_header_type.invoice_number(i)
1266: WHERE batch_id = l_trx_header_type.attribute1(i)

Line 1264: UPDATE FUN_TRX_HEADERS

1260: END IF;
1261:
1262: -- update FUN_TRX_HEADERS with the corresponding invoice number
1263: FORALL i IN 1..l_trx_header_type.attribute1.COUNT
1264: UPDATE FUN_TRX_HEADERS
1265: SET ar_invoice_number = l_trx_header_type.invoice_number(i)
1266: WHERE batch_id = l_trx_header_type.attribute1(i)
1267: AND trx_id = l_trx_header_type.attribute2(i);
1268:

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

1279: --Start of Comments
1280: --Function:
1281: -- After transactions are interfaced to AR and invoices have been created,
1282: -- it will get AR invoice number based on autoinvice conc. program
1283: -- request_id, and then FUN_TRX_HEADERS.ar_invoice_number will be updated
1284: -- with the corresonding AR invoice number
1285:
1286: -- THIS PROCESS IS NOT USED ANYMORE
1287: -- INSTEAD, GET_INVOICE IS CALLED FROM AR BUSINESS EVENT