eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CE_AUTO_BANK_IMPORT dependencies on CE_AUTO_BANK_REC

Line 679: IF (CE_AUTO_BANK_REC.G_sequence_numbering IN ('A','P')) THEN

675: BEGIN
676: IF l_DEBUG in ('Y', 'C') THEN
677: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.get_sequence_info' );
678: END IF;
679: IF (CE_AUTO_BANK_REC.G_sequence_numbering IN ('A','P')) THEN
680: --
681: -- bug# 1062247
682: -- Change FND_SEQNUM.get_next_sequence call to FND_SEQNUM.get_seq_val call
683: --

Line 700: AND (CE_AUTO_BANK_REC.G_sequence_numbering = 'A' )) THEN

696: 'get_sequence_info: ' || '>>CE_AUTO_BANK_IMPORT.doc_seq_value: '|| TO_CHAR( seq_value ) );
697: END IF;
698: END IF;
699: IF (((NVL(seq_value,0) = 0) OR l_return_code <> 0)
700: AND (CE_AUTO_BANK_REC.G_sequence_numbering = 'A' )) THEN
701: RETURN FALSE;
702: ELSE
703: RETURN TRUE;
704: END IF;

Line 710: IF (CE_AUTO_BANK_REC.G_sequence_numbering= 'A') THEN

706: cep_standard.debug('< 707: END IF;
708: EXCEPTION
709: WHEN OTHERS THEN
710: IF (CE_AUTO_BANK_REC.G_sequence_numbering= 'A') THEN
711: RETURN FALSE;
712: ELSE
713: RETURN TRUE;
714: END IF;

Line 820: cep_standard.debug('func: '||CE_AUTO_BANK_REC.G_functional_currency);

816:
817: BEGIN
818: IF l_DEBUG in ('Y', 'C') THEN
819: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.transfer_lines');
820: cep_standard.debug('func: '||CE_AUTO_BANK_REC.G_functional_currency);
821: END IF;
822:
823: IF (G_cshi_intra_day_flag = 'Y' AND CE_AUTO_BANK_REC.G_intra_day_flag = 'Y') THEN
824: INSERT INTO ce_intra_stmt_lines

Line 823: IF (G_cshi_intra_day_flag = 'Y' AND CE_AUTO_BANK_REC.G_intra_day_flag = 'Y') THEN

819: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.transfer_lines');
820: cep_standard.debug('func: '||CE_AUTO_BANK_REC.G_functional_currency);
821: END IF;
822:
823: IF (G_cshi_intra_day_flag = 'Y' AND CE_AUTO_BANK_REC.G_intra_day_flag = 'Y') THEN
824: INSERT INTO ce_intra_stmt_lines
825: (statement_line_id,
826: statement_header_id,
827: line_number,

Line 915: ELSIF (nvl(G_cshi_intra_day_flag,'N') <> 'Y' AND CE_AUTO_BANK_REC.G_intra_day_flag <> 'Y') THEN

911: AND csli.statement_number = G_cshi_statement_number
912: AND csli.bank_account_num = aba.bank_account_num
913: AND aba.bank_account_id = G_bank_account_id
914: AND ctc.reconciliation_sequence = CE_AUTO_BANK_IMPORT.G_trx_recon_seq_id; -- Bug 8965556 Added condition
915: ELSIF (nvl(G_cshi_intra_day_flag,'N') <> 'Y' AND CE_AUTO_BANK_REC.G_intra_day_flag <> 'Y') THEN
916: --Bug 6710502: Added an nvl to subsisdiary flag to handle records upgraded from 11i to R12
917: IF ( nvl(G_cshi_subsidiary_flag,'N') = 'N' ) THEN
918: INSERT INTO ce_statement_lines
919: (statement_line_id,

Line 983: CE_AUTO_BANK_REC.G_functional_currency,

979: csli.charges_amount,
980: 'UNRECONCILED',
981: csli.currency_code,
982: decode(gl_currency_api.is_fixed_rate(
983: CE_AUTO_BANK_REC.G_functional_currency,
984: nvl(csli.currency_code,aba.currency_code),
985: nvl(csli.exchange_rate_date,csli.trx_date)),
986: 'Y', decode(gdct.conversion_type, NULL,NULL,
987: decode(nvl(csli.currency_code,aba.currency_code),

Line 988: CE_AUTO_BANK_REC.G_functional_currency,

984: nvl(csli.currency_code,aba.currency_code),
985: nvl(csli.exchange_rate_date,csli.trx_date)),
986: 'Y', decode(gdct.conversion_type, NULL,NULL,
987: decode(nvl(csli.currency_code,aba.currency_code),
988: CE_AUTO_BANK_REC.G_functional_currency,
989: gdct.conversion_type,'EMU FIXED')),
990: gdct.conversion_type),
991: csli.exchange_rate_date,
992: csli.exchange_rate,

Line 1078: CE_AUTO_BANK_REC.G_set_of_books_id,

1074: -- Call the AOL sequence numbering routine to get Seq. number
1075: --
1076: l_valid_seq := CE_AUTO_BANK_IMPORT.get_sequence_info(260,
1077: aba_bank_account_name,
1078: CE_AUTO_BANK_REC.G_set_of_books_id,
1079: 'A',
1080: CE_AUTO_BANK_IMPORT.G_cshi_statement_date,
1081: l_dbseqname,
1082: l_doc_seq_id,

Line 1100: ', CE_AUTO_BANK_REC.G_intra_day_flag '|| CE_AUTO_BANK_REC.G_intra_day_flag);

1096: ELSE
1097: CE_AUTO_BANK_IMPORT.G_cshi_statement_header_id := NULL;
1098: IF l_DEBUG in ('Y', 'C') THEN
1099: cep_standard.debug('G_cshi_intra_day_flag '|| G_cshi_intra_day_flag ||
1100: ', CE_AUTO_BANK_REC.G_intra_day_flag '|| CE_AUTO_BANK_REC.G_intra_day_flag);
1101: END IF;
1102:
1103: IF (G_cshi_intra_day_flag = 'Y' AND CE_AUTO_BANK_REC.G_intra_day_flag = 'Y') THEN
1104: DELETE FROM CE_INTRA_STMT_LINES

Line 1103: IF (G_cshi_intra_day_flag = 'Y' AND CE_AUTO_BANK_REC.G_intra_day_flag = 'Y') THEN

1099: cep_standard.debug('G_cshi_intra_day_flag '|| G_cshi_intra_day_flag ||
1100: ', CE_AUTO_BANK_REC.G_intra_day_flag '|| CE_AUTO_BANK_REC.G_intra_day_flag);
1101: END IF;
1102:
1103: IF (G_cshi_intra_day_flag = 'Y' AND CE_AUTO_BANK_REC.G_intra_day_flag = 'Y') THEN
1104: DELETE FROM CE_INTRA_STMT_LINES
1105: WHERE statement_header_id in
1106: (select statement_header_id
1107: from ce_intra_stmt_headers

Line 1207: ELSIF ( nvl(G_cshi_intra_day_flag,'N') <> 'Y' AND CE_AUTO_BANK_REC.G_intra_day_flag <> 'Y') THEN

1203: null);
1204: --G_cshi_org_id);
1205: update_header_status('T');
1206: RETURN TRUE;
1207: ELSIF ( nvl(G_cshi_intra_day_flag,'N') <> 'Y' AND CE_AUTO_BANK_REC.G_intra_day_flag <> 'Y') THEN
1208:
1209: --check if statement date is less than sysdate
1210: -- cannot import statements with date greater than or equal to sysdate
1211: -- Bug 8726869

Line 1278: X_gl_date => nvl(CE_AUTO_BANK_REC.G_gl_date, G_cshi_statement_date), --Bug 16085695 added nvl clause to g_gl_parameter

1274: X_attribute14 => CE_AUTO_BANK_IMPORT.G_cshi_attribute14,
1275: X_attribute15 => CE_AUTO_BANK_IMPORT.G_cshi_attribute15,
1276: X_auto_loaded_flag => 'Y',
1277: X_statement_complete_flag => 'N',
1278: X_gl_date => nvl(CE_AUTO_BANK_REC.G_gl_date, G_cshi_statement_date), --Bug 16085695 added nvl clause to g_gl_parameter
1279: X_balance_flag => x_flag,
1280: X_average_close_ledger_mtd => CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd,
1281: X_average_close_ledger_ytd => CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd,
1282: X_average_close_available_mtd => CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd,

Line 1614: IF (CE_AUTO_BANK_REC.G_intra_day_flag <> 'Y') THEN

1610: -- 2. The GL date (Must be Open or Future Enterable in AP OR AR)
1611: -- bug 3676745 MO/BA uptake
1612: -- If the bank account is also used for xtr or payroll, do not check GL DATE
1613:
1614: IF (CE_AUTO_BANK_REC.G_intra_day_flag <> 'Y') THEN
1615: --IF (account_type <> 'PAYROLL') THEN
1616: IF (CE_AUTO_BANK_IMPORT.G_xtr_use_allowed_flag = 'N' and
1617: CE_AUTO_BANK_IMPORT.G_pay_use_allowed_flag = 'N') THEN
1618: gl_date_found :=

Line 1619: (CE_AUTO_BANK_REC.find_gl_period(nvl(CE_AUTO_BANK_REC.G_gl_date, G_cshi_statement_date), 222) --Bug 16085695 added nvl clause to g_gl_parameter

1615: --IF (account_type <> 'PAYROLL') THEN
1616: IF (CE_AUTO_BANK_IMPORT.G_xtr_use_allowed_flag = 'N' and
1617: CE_AUTO_BANK_IMPORT.G_pay_use_allowed_flag = 'N') THEN
1618: gl_date_found :=
1619: (CE_AUTO_BANK_REC.find_gl_period(nvl(CE_AUTO_BANK_REC.G_gl_date, G_cshi_statement_date), 222) --Bug 16085695 added nvl clause to g_gl_parameter
1620: OR CE_AUTO_BANK_REC.find_gl_period(nvl(CE_AUTO_BANK_REC.G_gl_date, G_cshi_statement_date), 200)); --Bug 16085695 added nvl clause to g_gl_parameter
1621: IF (NOT gl_date_found) THEN
1622: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_INVALID_PERIOD');
1623: END IF;

Line 1620: OR CE_AUTO_BANK_REC.find_gl_period(nvl(CE_AUTO_BANK_REC.G_gl_date, G_cshi_statement_date), 200)); --Bug 16085695 added nvl clause to g_gl_parameter

1616: IF (CE_AUTO_BANK_IMPORT.G_xtr_use_allowed_flag = 'N' and
1617: CE_AUTO_BANK_IMPORT.G_pay_use_allowed_flag = 'N') THEN
1618: gl_date_found :=
1619: (CE_AUTO_BANK_REC.find_gl_period(nvl(CE_AUTO_BANK_REC.G_gl_date, G_cshi_statement_date), 222) --Bug 16085695 added nvl clause to g_gl_parameter
1620: OR CE_AUTO_BANK_REC.find_gl_period(nvl(CE_AUTO_BANK_REC.G_gl_date, G_cshi_statement_date), 200)); --Bug 16085695 added nvl clause to g_gl_parameter
1621: IF (NOT gl_date_found) THEN
1622: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_INVALID_PERIOD');
1623: END IF;
1624: END IF;

Line 1629: IF (CE_AUTO_BANK_REC.G_intra_day_flag <> 'Y') THEN

1625: END IF;
1626: --
1627: -- 3. Already existing in the CE_STATEMENT_HEADERS
1628: --
1629: IF (CE_AUTO_BANK_REC.G_intra_day_flag <> 'Y') THEN
1630: IF (r_statement_number IS NOT NULL) THEN
1631: duplicate_found := CE_AUTO_BANK_IMPORT.header_error('CE_PREV_IMPORT');
1632: END IF;
1633: END IF;

Line 1638: IF (CE_AUTO_BANK_REC.G_intra_day_flag <> 'Y') THEN

1634:
1635: IF (bank_error) THEN
1636: error_found := TRUE;
1637: END IF;
1638: IF (CE_AUTO_BANK_REC.G_intra_day_flag <> 'Y') THEN
1639: IF (duplicate_found OR NOT gl_date_found) THEN
1640: error_found := TRUE;
1641: END IF;
1642: END IF;

Line 1757: /* -- bug 3676745, if p_option = 'IMPORT', no org information to get CE_AUTO_BANK_REC.G_functional_currency

1753: -- 5. EMU Fixed type is only for valid curr and xdate
1754: --
1755: BEGIN
1756:
1757: /* -- bug 3676745, if p_option = 'IMPORT', no org information to get CE_AUTO_BANK_REC.G_functional_currency
1758:
1759: IF l_DEBUG in ('Y', 'C') THEN
1760: cep_standard.debug('CE_AUTO_BANK_REC.G_functional_currency = '|| CE_AUTO_BANK_REC.G_functional_currency ||
1761: ',CE_AUTO_BANK_REC.G_interface_purge_flag = ' ||CE_AUTO_BANK_REC.G_interface_purge_flag ||

Line 1760: cep_standard.debug('CE_AUTO_BANK_REC.G_functional_currency = '|| CE_AUTO_BANK_REC.G_functional_currency ||

1756:
1757: /* -- bug 3676745, if p_option = 'IMPORT', no org information to get CE_AUTO_BANK_REC.G_functional_currency
1758:
1759: IF l_DEBUG in ('Y', 'C') THEN
1760: cep_standard.debug('CE_AUTO_BANK_REC.G_functional_currency = '|| CE_AUTO_BANK_REC.G_functional_currency ||
1761: ',CE_AUTO_BANK_REC.G_interface_purge_flag = ' ||CE_AUTO_BANK_REC.G_interface_purge_flag ||
1762: ',CE_AUTO_BANK_REC.G_interface_archive_flag = '|| CE_AUTO_BANK_REC.G_interface_archive_flag );
1763: END IF;
1764: IF (CE_AUTO_BANK_REC.G_org_id is null and

Line 1761: ',CE_AUTO_BANK_REC.G_interface_purge_flag = ' ||CE_AUTO_BANK_REC.G_interface_purge_flag ||

1757: /* -- bug 3676745, if p_option = 'IMPORT', no org information to get CE_AUTO_BANK_REC.G_functional_currency
1758:
1759: IF l_DEBUG in ('Y', 'C') THEN
1760: cep_standard.debug('CE_AUTO_BANK_REC.G_functional_currency = '|| CE_AUTO_BANK_REC.G_functional_currency ||
1761: ',CE_AUTO_BANK_REC.G_interface_purge_flag = ' ||CE_AUTO_BANK_REC.G_interface_purge_flag ||
1762: ',CE_AUTO_BANK_REC.G_interface_archive_flag = '|| CE_AUTO_BANK_REC.G_interface_archive_flag );
1763: END IF;
1764: IF (CE_AUTO_BANK_REC.G_org_id is null and
1765: CE_AUTO_BANK_REC.G_legal_entity_id is null and

Line 1762: ',CE_AUTO_BANK_REC.G_interface_archive_flag = '|| CE_AUTO_BANK_REC.G_interface_archive_flag );

1758:
1759: IF l_DEBUG in ('Y', 'C') THEN
1760: cep_standard.debug('CE_AUTO_BANK_REC.G_functional_currency = '|| CE_AUTO_BANK_REC.G_functional_currency ||
1761: ',CE_AUTO_BANK_REC.G_interface_purge_flag = ' ||CE_AUTO_BANK_REC.G_interface_purge_flag ||
1762: ',CE_AUTO_BANK_REC.G_interface_archive_flag = '|| CE_AUTO_BANK_REC.G_interface_archive_flag );
1763: END IF;
1764: IF (CE_AUTO_BANK_REC.G_org_id is null and
1765: CE_AUTO_BANK_REC.G_legal_entity_id is null and
1766: CE_AUTO_BANK_REC.G_functional_currency is null ) THEN

Line 1764: IF (CE_AUTO_BANK_REC.G_org_id is null and

1760: cep_standard.debug('CE_AUTO_BANK_REC.G_functional_currency = '|| CE_AUTO_BANK_REC.G_functional_currency ||
1761: ',CE_AUTO_BANK_REC.G_interface_purge_flag = ' ||CE_AUTO_BANK_REC.G_interface_purge_flag ||
1762: ',CE_AUTO_BANK_REC.G_interface_archive_flag = '|| CE_AUTO_BANK_REC.G_interface_archive_flag );
1763: END IF;
1764: IF (CE_AUTO_BANK_REC.G_org_id is null and
1765: CE_AUTO_BANK_REC.G_legal_entity_id is null and
1766: CE_AUTO_BANK_REC.G_functional_currency is null ) THEN
1767: SELECT g.currency_code,
1768: NVL(s.interface_purge_flag,'N'),

Line 1765: CE_AUTO_BANK_REC.G_legal_entity_id is null and

1761: ',CE_AUTO_BANK_REC.G_interface_purge_flag = ' ||CE_AUTO_BANK_REC.G_interface_purge_flag ||
1762: ',CE_AUTO_BANK_REC.G_interface_archive_flag = '|| CE_AUTO_BANK_REC.G_interface_archive_flag );
1763: END IF;
1764: IF (CE_AUTO_BANK_REC.G_org_id is null and
1765: CE_AUTO_BANK_REC.G_legal_entity_id is null and
1766: CE_AUTO_BANK_REC.G_functional_currency is null ) THEN
1767: SELECT g.currency_code,
1768: NVL(s.interface_purge_flag,'N'),
1769: NVL(s.interface_archive_flag,'N')

Line 1766: CE_AUTO_BANK_REC.G_functional_currency is null ) THEN

1762: ',CE_AUTO_BANK_REC.G_interface_archive_flag = '|| CE_AUTO_BANK_REC.G_interface_archive_flag );
1763: END IF;
1764: IF (CE_AUTO_BANK_REC.G_org_id is null and
1765: CE_AUTO_BANK_REC.G_legal_entity_id is null and
1766: CE_AUTO_BANK_REC.G_functional_currency is null ) THEN
1767: SELECT g.currency_code,
1768: NVL(s.interface_purge_flag,'N'),
1769: NVL(s.interface_archive_flag,'N')
1770: INTO CE_AUTO_BANK_REC.G_functional_currency,

Line 1770: INTO CE_AUTO_BANK_REC.G_functional_currency,

1766: CE_AUTO_BANK_REC.G_functional_currency is null ) THEN
1767: SELECT g.currency_code,
1768: NVL(s.interface_purge_flag,'N'),
1769: NVL(s.interface_archive_flag,'N')
1770: INTO CE_AUTO_BANK_REC.G_functional_currency,
1771: CE_AUTO_BANK_REC.G_interface_purge_flag ,
1772: CE_AUTO_BANK_REC.G_interface_archive_flag
1773: FROM CE_SYSTEM_PARAMETERS_ALL s,
1774: GL_SETS_OF_BOOKS g,

Line 1771: CE_AUTO_BANK_REC.G_interface_purge_flag ,

1767: SELECT g.currency_code,
1768: NVL(s.interface_purge_flag,'N'),
1769: NVL(s.interface_archive_flag,'N')
1770: INTO CE_AUTO_BANK_REC.G_functional_currency,
1771: CE_AUTO_BANK_REC.G_interface_purge_flag ,
1772: CE_AUTO_BANK_REC.G_interface_archive_flag
1773: FROM CE_SYSTEM_PARAMETERS_ALL s,
1774: GL_SETS_OF_BOOKS g,
1775: ce_bank_accts_gt_v ba --ce_bank_accounts_v ba

Line 1772: CE_AUTO_BANK_REC.G_interface_archive_flag

1768: NVL(s.interface_purge_flag,'N'),
1769: NVL(s.interface_archive_flag,'N')
1770: INTO CE_AUTO_BANK_REC.G_functional_currency,
1771: CE_AUTO_BANK_REC.G_interface_purge_flag ,
1772: CE_AUTO_BANK_REC.G_interface_archive_flag
1773: FROM CE_SYSTEM_PARAMETERS_ALL s,
1774: GL_SETS_OF_BOOKS g,
1775: ce_bank_accts_gt_v ba --ce_bank_accounts_v ba
1776: WHERE ba.bank_account_id = CE_AUTO_BANK_IMPORT.G_bank_account_id

Line 1783: cep_standard.debug('CE_AUTO_BANK_REC.G_functional_currency = '|| CE_AUTO_BANK_REC.G_functional_currency ||

1779:
1780: END IF;
1781: */
1782: IF l_DEBUG in ('Y', 'C') THEN
1783: cep_standard.debug('CE_AUTO_BANK_REC.G_functional_currency = '|| CE_AUTO_BANK_REC.G_functional_currency ||
1784: ',CE_AUTO_BANK_REC.G_interface_purge_flag = ' ||CE_AUTO_BANK_REC.G_interface_purge_flag ||
1785: ',CE_AUTO_BANK_REC.G_interface_archive_flag = '|| CE_AUTO_BANK_REC.G_interface_archive_flag );
1786: END IF;
1787:

Line 1784: ',CE_AUTO_BANK_REC.G_interface_purge_flag = ' ||CE_AUTO_BANK_REC.G_interface_purge_flag ||

1780: END IF;
1781: */
1782: IF l_DEBUG in ('Y', 'C') THEN
1783: cep_standard.debug('CE_AUTO_BANK_REC.G_functional_currency = '|| CE_AUTO_BANK_REC.G_functional_currency ||
1784: ',CE_AUTO_BANK_REC.G_interface_purge_flag = ' ||CE_AUTO_BANK_REC.G_interface_purge_flag ||
1785: ',CE_AUTO_BANK_REC.G_interface_archive_flag = '|| CE_AUTO_BANK_REC.G_interface_archive_flag );
1786: END IF;
1787:
1788: fixed_rate_yn := gl_currency_api.is_fixed_rate(

Line 1785: ',CE_AUTO_BANK_REC.G_interface_archive_flag = '|| CE_AUTO_BANK_REC.G_interface_archive_flag );

1781: */
1782: IF l_DEBUG in ('Y', 'C') THEN
1783: cep_standard.debug('CE_AUTO_BANK_REC.G_functional_currency = '|| CE_AUTO_BANK_REC.G_functional_currency ||
1784: ',CE_AUTO_BANK_REC.G_interface_purge_flag = ' ||CE_AUTO_BANK_REC.G_interface_purge_flag ||
1785: ',CE_AUTO_BANK_REC.G_interface_archive_flag = '|| CE_AUTO_BANK_REC.G_interface_archive_flag );
1786: END IF;
1787:
1788: fixed_rate_yn := gl_currency_api.is_fixed_rate(
1789: CE_AUTO_BANK_REC.G_functional_currency,

Line 1789: CE_AUTO_BANK_REC.G_functional_currency,

1785: ',CE_AUTO_BANK_REC.G_interface_archive_flag = '|| CE_AUTO_BANK_REC.G_interface_archive_flag );
1786: END IF;
1787:
1788: fixed_rate_yn := gl_currency_api.is_fixed_rate(
1789: CE_AUTO_BANK_REC.G_functional_currency,
1790: nvl(csli_currency_code,aba_bank_currency),
1791: nvl(csli_exchange_rate_date,csli_trx_date));
1792: EXCEPTION
1793: WHEN OTHERS THEN cep_standard.debug('cannot get relationship for the give curr');

Line 1826: | CE_AUTO_BANK_REC.statement |

1822: | CALLS |
1823: | statement_import |
1824: | |
1825: | CALLED BY |
1826: | CE_AUTO_BANK_REC.statement |
1827: --------------------------------------------------------------------- */
1828: PROCEDURE import_process IS
1829: aba_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;
1830: aba_bank_currency CE_BANK_ACCOUNTS.currency_code%TYPE;

Line 1881: OPEN branch_cursor( CE_AUTO_BANK_REC.G_bank_branch_id,

1877:
1878: -- populate ce_security_profiles_tmp table with ce_security_procfiles_v
1879: CEP_STANDARD.init_security;
1880:
1881: OPEN branch_cursor( CE_AUTO_BANK_REC.G_bank_branch_id,
1882: CE_AUTO_BANK_REC.G_bank_account_id );
1883: LOOP
1884: FETCH branch_cursor INTO CE_AUTO_BANK_IMPORT.G_bank_account_id,
1885: CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID,

Line 1882: CE_AUTO_BANK_REC.G_bank_account_id );

1878: -- populate ce_security_profiles_tmp table with ce_security_procfiles_v
1879: CEP_STANDARD.init_security;
1880:
1881: OPEN branch_cursor( CE_AUTO_BANK_REC.G_bank_branch_id,
1882: CE_AUTO_BANK_REC.G_bank_account_id );
1883: LOOP
1884: FETCH branch_cursor INTO CE_AUTO_BANK_IMPORT.G_bank_account_id,
1885: CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID,
1886: CE_AUTO_BANK_IMPORT.G_xtr_use_allowed_flag,

Line 1892: /* IF (CE_AUTO_BANK_REC.G_legal_entity_id is null and CE_AUTO_BANK_REC.G_org_id is null) THEN

1888: aba_bank_account_id := CE_AUTO_BANK_IMPORT.G_bank_account_id;
1889:
1890: -- 1/20/05 Did not enter organization (le_id and org_id missing)
1891: -- BUG 4914608
1892: /* IF (CE_AUTO_BANK_REC.G_legal_entity_id is null and CE_AUTO_BANK_REC.G_org_id is null) THEN
1893: select ACCOUNT_OWNER_ORG_ID
1894: into X_le_id
1895: from ce_BANK_ACCOUNTS
1896: where BANK_ACCOUNT_ID = aba_bank_account_id; */

Line 1897: --IF (CE_AUTO_BANK_REC.G_legal_entity_id is null and CE_AUTO_BANK_REC.G_org_id is null) THEN

1893: select ACCOUNT_OWNER_ORG_ID
1894: into X_le_id
1895: from ce_BANK_ACCOUNTS
1896: where BANK_ACCOUNT_ID = aba_bank_account_id; */
1897: --IF (CE_AUTO_BANK_REC.G_legal_entity_id is null and CE_AUTO_BANK_REC.G_org_id is null) THEN
1898: IF (CE_AUTO_BANK_REC.G_legal_entity_id is null) and
1899: (CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID is not null) THEN
1900:
1901: CE_SYSTEM_PARAMETERS1_PKG.select_columns(CE_AUTO_BANK_REC.G_rowid,

Line 1898: IF (CE_AUTO_BANK_REC.G_legal_entity_id is null) and

1894: into X_le_id
1895: from ce_BANK_ACCOUNTS
1896: where BANK_ACCOUNT_ID = aba_bank_account_id; */
1897: --IF (CE_AUTO_BANK_REC.G_legal_entity_id is null and CE_AUTO_BANK_REC.G_org_id is null) THEN
1898: IF (CE_AUTO_BANK_REC.G_legal_entity_id is null) and
1899: (CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID is not null) THEN
1900:
1901: CE_SYSTEM_PARAMETERS1_PKG.select_columns(CE_AUTO_BANK_REC.G_rowid,
1902: CE_AUTO_BANK_REC.G_set_of_books_id,

Line 1901: CE_SYSTEM_PARAMETERS1_PKG.select_columns(CE_AUTO_BANK_REC.G_rowid,

1897: --IF (CE_AUTO_BANK_REC.G_legal_entity_id is null and CE_AUTO_BANK_REC.G_org_id is null) THEN
1898: IF (CE_AUTO_BANK_REC.G_legal_entity_id is null) and
1899: (CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID is not null) THEN
1900:
1901: CE_SYSTEM_PARAMETERS1_PKG.select_columns(CE_AUTO_BANK_REC.G_rowid,
1902: CE_AUTO_BANK_REC.G_set_of_books_id,
1903: CE_AUTO_BANK_REC.G_cashbook_begin_date,
1904: CE_AUTO_BANK_REC.G_show_cleared_flag,
1905: CE_AUTO_BANK_REC.G_show_void_payment_flag,

Line 1902: CE_AUTO_BANK_REC.G_set_of_books_id,

1898: IF (CE_AUTO_BANK_REC.G_legal_entity_id is null) and
1899: (CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID is not null) THEN
1900:
1901: CE_SYSTEM_PARAMETERS1_PKG.select_columns(CE_AUTO_BANK_REC.G_rowid,
1902: CE_AUTO_BANK_REC.G_set_of_books_id,
1903: CE_AUTO_BANK_REC.G_cashbook_begin_date,
1904: CE_AUTO_BANK_REC.G_show_cleared_flag,
1905: CE_AUTO_BANK_REC.G_show_void_payment_flag,
1906: CE_AUTO_BANK_REC.G_line_autocreation_flag,

Line 1903: CE_AUTO_BANK_REC.G_cashbook_begin_date,

1899: (CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID is not null) THEN
1900:
1901: CE_SYSTEM_PARAMETERS1_PKG.select_columns(CE_AUTO_BANK_REC.G_rowid,
1902: CE_AUTO_BANK_REC.G_set_of_books_id,
1903: CE_AUTO_BANK_REC.G_cashbook_begin_date,
1904: CE_AUTO_BANK_REC.G_show_cleared_flag,
1905: CE_AUTO_BANK_REC.G_show_void_payment_flag,
1906: CE_AUTO_BANK_REC.G_line_autocreation_flag,
1907: CE_AUTO_BANK_REC.G_interface_purge_flag,

Line 1904: CE_AUTO_BANK_REC.G_show_cleared_flag,

1900:
1901: CE_SYSTEM_PARAMETERS1_PKG.select_columns(CE_AUTO_BANK_REC.G_rowid,
1902: CE_AUTO_BANK_REC.G_set_of_books_id,
1903: CE_AUTO_BANK_REC.G_cashbook_begin_date,
1904: CE_AUTO_BANK_REC.G_show_cleared_flag,
1905: CE_AUTO_BANK_REC.G_show_void_payment_flag,
1906: CE_AUTO_BANK_REC.G_line_autocreation_flag,
1907: CE_AUTO_BANK_REC.G_interface_purge_flag,
1908: CE_AUTO_BANK_REC.G_interface_archive_flag,

Line 1905: CE_AUTO_BANK_REC.G_show_void_payment_flag,

1901: CE_SYSTEM_PARAMETERS1_PKG.select_columns(CE_AUTO_BANK_REC.G_rowid,
1902: CE_AUTO_BANK_REC.G_set_of_books_id,
1903: CE_AUTO_BANK_REC.G_cashbook_begin_date,
1904: CE_AUTO_BANK_REC.G_show_cleared_flag,
1905: CE_AUTO_BANK_REC.G_show_void_payment_flag,
1906: CE_AUTO_BANK_REC.G_line_autocreation_flag,
1907: CE_AUTO_BANK_REC.G_interface_purge_flag,
1908: CE_AUTO_BANK_REC.G_interface_archive_flag,
1909: CE_AUTO_BANK_REC.G_lines_per_commit,

Line 1906: CE_AUTO_BANK_REC.G_line_autocreation_flag,

1902: CE_AUTO_BANK_REC.G_set_of_books_id,
1903: CE_AUTO_BANK_REC.G_cashbook_begin_date,
1904: CE_AUTO_BANK_REC.G_show_cleared_flag,
1905: CE_AUTO_BANK_REC.G_show_void_payment_flag,
1906: CE_AUTO_BANK_REC.G_line_autocreation_flag,
1907: CE_AUTO_BANK_REC.G_interface_purge_flag,
1908: CE_AUTO_BANK_REC.G_interface_archive_flag,
1909: CE_AUTO_BANK_REC.G_lines_per_commit,
1910: CE_AUTO_BANK_REC.G_functional_currency,

Line 1907: CE_AUTO_BANK_REC.G_interface_purge_flag,

1903: CE_AUTO_BANK_REC.G_cashbook_begin_date,
1904: CE_AUTO_BANK_REC.G_show_cleared_flag,
1905: CE_AUTO_BANK_REC.G_show_void_payment_flag,
1906: CE_AUTO_BANK_REC.G_line_autocreation_flag,
1907: CE_AUTO_BANK_REC.G_interface_purge_flag,
1908: CE_AUTO_BANK_REC.G_interface_archive_flag,
1909: CE_AUTO_BANK_REC.G_lines_per_commit,
1910: CE_AUTO_BANK_REC.G_functional_currency,
1911: CE_AUTO_BANK_REC.G_sob_short_name,

Line 1908: CE_AUTO_BANK_REC.G_interface_archive_flag,

1904: CE_AUTO_BANK_REC.G_show_cleared_flag,
1905: CE_AUTO_BANK_REC.G_show_void_payment_flag,
1906: CE_AUTO_BANK_REC.G_line_autocreation_flag,
1907: CE_AUTO_BANK_REC.G_interface_purge_flag,
1908: CE_AUTO_BANK_REC.G_interface_archive_flag,
1909: CE_AUTO_BANK_REC.G_lines_per_commit,
1910: CE_AUTO_BANK_REC.G_functional_currency,
1911: CE_AUTO_BANK_REC.G_sob_short_name,
1912: CE_AUTO_BANK_REC.G_account_period_type,

Line 1909: CE_AUTO_BANK_REC.G_lines_per_commit,

1905: CE_AUTO_BANK_REC.G_show_void_payment_flag,
1906: CE_AUTO_BANK_REC.G_line_autocreation_flag,
1907: CE_AUTO_BANK_REC.G_interface_purge_flag,
1908: CE_AUTO_BANK_REC.G_interface_archive_flag,
1909: CE_AUTO_BANK_REC.G_lines_per_commit,
1910: CE_AUTO_BANK_REC.G_functional_currency,
1911: CE_AUTO_BANK_REC.G_sob_short_name,
1912: CE_AUTO_BANK_REC.G_account_period_type,
1913: CE_AUTO_BANK_REC.G_user_exchange_rate_type,

Line 1910: CE_AUTO_BANK_REC.G_functional_currency,

1906: CE_AUTO_BANK_REC.G_line_autocreation_flag,
1907: CE_AUTO_BANK_REC.G_interface_purge_flag,
1908: CE_AUTO_BANK_REC.G_interface_archive_flag,
1909: CE_AUTO_BANK_REC.G_lines_per_commit,
1910: CE_AUTO_BANK_REC.G_functional_currency,
1911: CE_AUTO_BANK_REC.G_sob_short_name,
1912: CE_AUTO_BANK_REC.G_account_period_type,
1913: CE_AUTO_BANK_REC.G_user_exchange_rate_type,
1914: CE_AUTO_BANK_REC.G_chart_of_accounts_id,

Line 1911: CE_AUTO_BANK_REC.G_sob_short_name,

1907: CE_AUTO_BANK_REC.G_interface_purge_flag,
1908: CE_AUTO_BANK_REC.G_interface_archive_flag,
1909: CE_AUTO_BANK_REC.G_lines_per_commit,
1910: CE_AUTO_BANK_REC.G_functional_currency,
1911: CE_AUTO_BANK_REC.G_sob_short_name,
1912: CE_AUTO_BANK_REC.G_account_period_type,
1913: CE_AUTO_BANK_REC.G_user_exchange_rate_type,
1914: CE_AUTO_BANK_REC.G_chart_of_accounts_id,
1915: CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE,

Line 1912: CE_AUTO_BANK_REC.G_account_period_type,

1908: CE_AUTO_BANK_REC.G_interface_archive_flag,
1909: CE_AUTO_BANK_REC.G_lines_per_commit,
1910: CE_AUTO_BANK_REC.G_functional_currency,
1911: CE_AUTO_BANK_REC.G_sob_short_name,
1912: CE_AUTO_BANK_REC.G_account_period_type,
1913: CE_AUTO_BANK_REC.G_user_exchange_rate_type,
1914: CE_AUTO_BANK_REC.G_chart_of_accounts_id,
1915: CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE,
1916: CE_AUTO_BANK_REC.G_AUTHORIZATION_BAT,

Line 1913: CE_AUTO_BANK_REC.G_user_exchange_rate_type,

1909: CE_AUTO_BANK_REC.G_lines_per_commit,
1910: CE_AUTO_BANK_REC.G_functional_currency,
1911: CE_AUTO_BANK_REC.G_sob_short_name,
1912: CE_AUTO_BANK_REC.G_account_period_type,
1913: CE_AUTO_BANK_REC.G_user_exchange_rate_type,
1914: CE_AUTO_BANK_REC.G_chart_of_accounts_id,
1915: CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE,
1916: CE_AUTO_BANK_REC.G_AUTHORIZATION_BAT,
1917: CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE,

Line 1914: CE_AUTO_BANK_REC.G_chart_of_accounts_id,

1910: CE_AUTO_BANK_REC.G_functional_currency,
1911: CE_AUTO_BANK_REC.G_sob_short_name,
1912: CE_AUTO_BANK_REC.G_account_period_type,
1913: CE_AUTO_BANK_REC.G_user_exchange_rate_type,
1914: CE_AUTO_BANK_REC.G_chart_of_accounts_id,
1915: CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE,
1916: CE_AUTO_BANK_REC.G_AUTHORIZATION_BAT,
1917: CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE,
1918: CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE,

Line 1915: CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE,

1911: CE_AUTO_BANK_REC.G_sob_short_name,
1912: CE_AUTO_BANK_REC.G_account_period_type,
1913: CE_AUTO_BANK_REC.G_user_exchange_rate_type,
1914: CE_AUTO_BANK_REC.G_chart_of_accounts_id,
1915: CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE,
1916: CE_AUTO_BANK_REC.G_AUTHORIZATION_BAT,
1917: CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE,
1918: CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE,
1919: CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID

Line 1916: CE_AUTO_BANK_REC.G_AUTHORIZATION_BAT,

1912: CE_AUTO_BANK_REC.G_account_period_type,
1913: CE_AUTO_BANK_REC.G_user_exchange_rate_type,
1914: CE_AUTO_BANK_REC.G_chart_of_accounts_id,
1915: CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE,
1916: CE_AUTO_BANK_REC.G_AUTHORIZATION_BAT,
1917: CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE,
1918: CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE,
1919: CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID
1920: );

Line 1917: CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE,

1913: CE_AUTO_BANK_REC.G_user_exchange_rate_type,
1914: CE_AUTO_BANK_REC.G_chart_of_accounts_id,
1915: CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE,
1916: CE_AUTO_BANK_REC.G_AUTHORIZATION_BAT,
1917: CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE,
1918: CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE,
1919: CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID
1920: );
1921: END IF;

Line 1918: CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE,

1914: CE_AUTO_BANK_REC.G_chart_of_accounts_id,
1915: CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE,
1916: CE_AUTO_BANK_REC.G_AUTHORIZATION_BAT,
1917: CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE,
1918: CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE,
1919: CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID
1920: );
1921: END IF;
1922:

Line 1929: OPEN bank_cursor(CE_AUTO_BANK_REC.G_statement_number_from,

1925: END IF;
1926:
1927: EXIT WHEN branch_cursor%NOTFOUND OR branch_cursor%NOTFOUND IS NULL;
1928:
1929: OPEN bank_cursor(CE_AUTO_BANK_REC.G_statement_number_from,
1930: CE_AUTO_BANK_REC.G_statement_number_to,
1931: CE_AUTO_BANK_REC.G_statement_date_from,
1932: CE_AUTO_BANK_REC.G_statement_date_to,
1933: CE_AUTO_BANK_IMPORT.G_bank_account_id);

Line 1930: CE_AUTO_BANK_REC.G_statement_number_to,

1926:
1927: EXIT WHEN branch_cursor%NOTFOUND OR branch_cursor%NOTFOUND IS NULL;
1928:
1929: OPEN bank_cursor(CE_AUTO_BANK_REC.G_statement_number_from,
1930: CE_AUTO_BANK_REC.G_statement_number_to,
1931: CE_AUTO_BANK_REC.G_statement_date_from,
1932: CE_AUTO_BANK_REC.G_statement_date_to,
1933: CE_AUTO_BANK_IMPORT.G_bank_account_id);
1934: LOOP

Line 1931: CE_AUTO_BANK_REC.G_statement_date_from,

1927: EXIT WHEN branch_cursor%NOTFOUND OR branch_cursor%NOTFOUND IS NULL;
1928:
1929: OPEN bank_cursor(CE_AUTO_BANK_REC.G_statement_number_from,
1930: CE_AUTO_BANK_REC.G_statement_number_to,
1931: CE_AUTO_BANK_REC.G_statement_date_from,
1932: CE_AUTO_BANK_REC.G_statement_date_to,
1933: CE_AUTO_BANK_IMPORT.G_bank_account_id);
1934: LOOP
1935: FETCH bank_cursor INTO CE_AUTO_BANK_IMPORT.G_cshi_rowid,

Line 1932: CE_AUTO_BANK_REC.G_statement_date_to,

1928:
1929: OPEN bank_cursor(CE_AUTO_BANK_REC.G_statement_number_from,
1930: CE_AUTO_BANK_REC.G_statement_number_to,
1931: CE_AUTO_BANK_REC.G_statement_date_from,
1932: CE_AUTO_BANK_REC.G_statement_date_to,
1933: CE_AUTO_BANK_IMPORT.G_bank_account_id);
1934: LOOP
1935: FETCH bank_cursor INTO CE_AUTO_BANK_IMPORT.G_cshi_rowid,
1936: CE_AUTO_BANK_IMPORT.G_cshi_statement_number,

Line 2118: IF (CE_AUTO_BANK_REC.G_interface_archive_flag = 'Y') THEN

2114: FND_FILE.put_line(FND_FILE.LOG, x_msg_data);
2115: set_warning :=FND_CONCURRENT.SET_COMPLETION_STATUS('WARNING', 'Check log file for warning messages');
2116: bu_error_found :=CE_AUTO_BANK_IMPORT.header_error('CE_OD_LIMIT_FAIL_INFO');
2117: end if;
2118: IF (CE_AUTO_BANK_REC.G_interface_archive_flag = 'Y') THEN
2119: archive_header;
2120: archive_lines;
2121: END IF;
2122: IF (CE_AUTO_BANK_REC.G_interface_purge_flag = 'Y') THEN

Line 2122: IF (CE_AUTO_BANK_REC.G_interface_purge_flag = 'Y') THEN

2118: IF (CE_AUTO_BANK_REC.G_interface_archive_flag = 'Y') THEN
2119: archive_header;
2120: archive_lines;
2121: END IF;
2122: IF (CE_AUTO_BANK_REC.G_interface_purge_flag = 'Y') THEN
2123: purge_data;
2124: END IF;
2125: END IF;
2126: END IF;

Line 2131: IF (CE_AUTO_BANK_REC.G_interface_archive_flag = 'Y') THEN

2127: --ELSIF (x_account_result = 'XTR1_AP' OR nvl(G_cshi_intra_day_flag,'N') = 'Y') THEN
2128: ELSIF (CE_AUTO_BANK_IMPORT.G_xtr_use_allowed_flag = 'N' OR nvl(G_cshi_intra_day_flag,'N') = 'Y') THEN
2129: IF (transfer_header(aba_bank_account_id,aba_bank_account_name)) THEN
2130: transfer_lines;
2131: IF (CE_AUTO_BANK_REC.G_interface_archive_flag = 'Y') THEN
2132: archive_header;
2133: archive_lines;
2134: END IF;
2135: IF (CE_AUTO_BANK_REC.G_interface_purge_flag = 'Y') THEN

Line 2135: IF (CE_AUTO_BANK_REC.G_interface_purge_flag = 'Y') THEN

2131: IF (CE_AUTO_BANK_REC.G_interface_archive_flag = 'Y') THEN
2132: archive_header;
2133: archive_lines;
2134: END IF;
2135: IF (CE_AUTO_BANK_REC.G_interface_purge_flag = 'Y') THEN
2136: purge_data;
2137: END IF;
2138: END IF;
2139: END IF; -- xtr_shared_account