DBA Data[Home] [Help]

APPS.PA_FAXFACE dependencies on PA_XLA_INTERFACE_PKG

Line 1478: 'I', pa_xla_interface_pkg.get_post_acc_sla_ccid

1474: NULL, decode(nvl(pei.historical_flag, 'Y'),
1475: 'Y', decode(pcdl.line_type,
1476: 'R', pcdl.dr_code_combination_id,
1477: 'D', pcdl.dr_code_combination_id,
1478: 'I', pa_xla_interface_pkg.get_post_acc_sla_ccid
1479: (
1480: pcdl.acct_event_id,
1481: pcdl.transfer_status_code,
1482: pei.transaction_source,

Line 1493: 'R', decode(pa_xla_interface_pkg.get_source(pei.transaction_source,

1489: p_ledger_id
1490: )
1491: ),
1492: 'N', decode(pcdl.line_type,
1493: 'R', decode(pa_xla_interface_pkg.get_source(pei.transaction_source,
1494: pei.document_payment_id),
1495: 'EXT', pcdl.dr_code_combination_id,
1496: pa_xla_interface_pkg.get_post_acc_sla_ccid
1497: (

Line 1496: pa_xla_interface_pkg.get_post_acc_sla_ccid

1492: 'N', decode(pcdl.line_type,
1493: 'R', decode(pa_xla_interface_pkg.get_source(pei.transaction_source,
1494: pei.document_payment_id),
1495: 'EXT', pcdl.dr_code_combination_id,
1496: pa_xla_interface_pkg.get_post_acc_sla_ccid
1497: (
1498: pcdl.acct_event_id,
1499: pcdl.transfer_status_code,
1500: pei.transaction_source,

Line 1502: decode(pa_xla_interface_pkg.get_source(pei.Transaction_Source,

1498: pcdl.acct_event_id,
1499: pcdl.transfer_status_code,
1500: pei.transaction_source,
1501: nvl(pei.historical_flag, 'Y'),
1502: decode(pa_xla_interface_pkg.get_source(pei.Transaction_Source,
1503: pei.document_payment_id),
1504: 'PA', pcdl.expenditure_item_id,
1505: 'AP_PAY', pcdl.system_reference5,
1506: 'AP_INV', pei.document_distribution_id,

Line 1510: decode(pa_xla_interface_pkg.get_source(pei.Transaction_Source,

1506: 'AP_INV', pei.document_distribution_id,
1507: 'RCV', pcdl.system_reference5,
1508: 'INV', pcdl.system_reference5,
1509: 'WIP', pcdl.system_reference5), -- distribution_id1
1510: decode(pa_xla_interface_pkg.get_source(pei.Transaction_Source,
1511: pei.document_payment_id),
1512: 'PA', pcdl.line_num,
1513: 'AP_PAY', pei.document_distribution_id,
1514: 'AP_INV', NULL,

Line 1524: pa_xla_interface_pkg.get_post_acc_sla_ccid

1520: 'DEBIT',
1521: p_ledger_id
1522: )
1523: ),
1524: pa_xla_interface_pkg.get_post_acc_sla_ccid
1525: (
1526: pcdl.acct_event_id,
1527: pcdl.transfer_status_code,
1528: pei.transaction_source,

Line 1541: pa_xla_interface_pkg.get_post_acc_sla_ccid /* for all other acct source codes */

1537: p_ledger_id
1538: ) -- for I and D.
1539: )
1540: ), -- acct_source_code NULL
1541: pa_xla_interface_pkg.get_post_acc_sla_ccid /* for all other acct source codes */
1542: (
1543: pcdl.acct_event_id,
1544: pcdl.transfer_status_code,
1545: pei.transaction_source,

Line 1649: --pa_xla_interface_pkg.get_source(pei.transaction_source, pei.document_payment_id) transaction_source

1645: pei.capital_event_id,
1646: -- Added for bug : 4768332
1647: pcdl.acct_event_id,
1648: NVL(pei.transaction_source,'Projects') transaction_source
1649: --pa_xla_interface_pkg.get_source(pei.transaction_source, pei.document_payment_id) transaction_source
1650:
1651: FROM
1652: pa_cost_distribution_lines_all pcdl,
1653: pa_expenditure_items_all pei,