DBA Data[Home] [Help]

APPS.PA_FAXFACE dependencies on PA_XLA_INTERFACE_PKG

Line 1664: 'I', pa_xla_interface_pkg.get_post_acc_sla_ccid

1660: NULL, decode(nvl(pei.historical_flag, 'Y'),
1661: 'Y', decode(pcdl.line_type,
1662: 'R', pcdl.dr_code_combination_id,
1663: 'D', pcdl.dr_code_combination_id,
1664: 'I', pa_xla_interface_pkg.get_post_acc_sla_ccid
1665: (
1666: pcdl.acct_event_id,
1667: pcdl.transfer_status_code,
1668: pei.transaction_source,

Line 1682: 'I', pa_xla_interface_pkg.get_post_acc_sla_ccid

1678: 'N', decode(pcdl.system_reference4,'PJM',
1679: decode(pcdl.line_type,
1680: 'R', pcdl.dr_code_combination_id,
1681: 'D', pcdl.dr_code_combination_id,
1682: 'I', pa_xla_interface_pkg.get_post_acc_sla_ccid
1683: (
1684: pcdl.acct_event_id,
1685: pcdl.transfer_status_code,
1686: pei.transaction_source,

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

1693: p_ledger_id
1694: )
1695: ), --Bug 8674676
1696: decode(pcdl.line_type,
1697: 'R', decode(pa_xla_interface_pkg.get_source(pei.transaction_source,
1698: pei.document_payment_id),
1699: 'EXT', pcdl.dr_code_combination_id,
1700: pa_xla_interface_pkg.get_post_acc_sla_ccid
1701: (

Line 1700: pa_xla_interface_pkg.get_post_acc_sla_ccid

1696: decode(pcdl.line_type,
1697: 'R', decode(pa_xla_interface_pkg.get_source(pei.transaction_source,
1698: pei.document_payment_id),
1699: 'EXT', pcdl.dr_code_combination_id,
1700: pa_xla_interface_pkg.get_post_acc_sla_ccid
1701: (
1702: pcdl.acct_event_id,
1703: pcdl.transfer_status_code,
1704: pei.transaction_source,

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

1702: pcdl.acct_event_id,
1703: pcdl.transfer_status_code,
1704: pei.transaction_source,
1705: nvl(pei.historical_flag, 'Y'),
1706: decode(pa_xla_interface_pkg.get_source(pei.Transaction_Source,
1707: pei.document_payment_id),
1708: 'PA', pcdl.expenditure_item_id,
1709: 'AP_PAY', pcdl.system_reference5,
1710: 'AP_INV', pei.document_distribution_id,

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

1710: 'AP_INV', pei.document_distribution_id,
1711: 'RCV', pcdl.system_reference5,
1712: 'INV', pcdl.system_reference5,
1713: 'WIP', pcdl.system_reference5), -- distribution_id1
1714: decode(pa_xla_interface_pkg.get_source(pei.Transaction_Source,
1715: pei.document_payment_id),
1716: 'PA', pcdl.line_num,
1717: 'AP_PAY', pei.document_distribution_id,
1718: 'AP_INV', NULL,

Line 1728: pa_xla_interface_pkg.get_post_acc_sla_ccid

1724: 'DEBIT',
1725: p_ledger_id
1726: )
1727: ),
1728: pa_xla_interface_pkg.get_post_acc_sla_ccid
1729: (
1730: pcdl.acct_event_id,
1731: pcdl.transfer_status_code,
1732: pei.transaction_source,

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

1741: p_ledger_id
1742: ) -- for I and D.
1743: ))
1744: ), -- acct_source_code NULL
1745: pa_xla_interface_pkg.get_post_acc_sla_ccid /* for all other acct source codes */
1746: (
1747: pcdl.acct_event_id,
1748: pcdl.transfer_status_code,
1749: pei.transaction_source,

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

1849: pei.capital_event_id,
1850: -- Added for bug : 4768332
1851: pcdl.acct_event_id,
1852: NVL(pei.transaction_source,'Projects') transaction_source
1853: --pa_xla_interface_pkg.get_source(pei.transaction_source, pei.document_payment_id) transaction_source
1854:
1855: FROM
1856: pa_cost_distribution_lines_all pcdl,
1857: pa_expenditure_items_all pei,