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 671: IF (CE_AUTO_BANK_REC.G_sequence_numbering IN ('A','P')) THEN

667: BEGIN
668: IF l_DEBUG in ('Y', 'C') THEN
669: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.get_sequence_info' );
670: END IF;
671: IF (CE_AUTO_BANK_REC.G_sequence_numbering IN ('A','P')) THEN
672: --
673: -- bug# 1062247
674: -- Change FND_SEQNUM.get_next_sequence call to FND_SEQNUM.get_seq_val call
675: --

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

688: 'get_sequence_info: ' || '>>CE_AUTO_BANK_IMPORT.doc_seq_value: '|| TO_CHAR( seq_value ) );
689: END IF;
690: END IF;
691: IF (((NVL(seq_value,0) = 0) OR l_return_code <> 0)
692: AND (CE_AUTO_BANK_REC.G_sequence_numbering = 'A' )) THEN
693: RETURN FALSE;
694: ELSE
695: RETURN TRUE;
696: END IF;

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

698: cep_standard.debug('< 699: END IF;
700: EXCEPTION
701: WHEN OTHERS THEN
702: IF (CE_AUTO_BANK_REC.G_sequence_numbering= 'A') THEN
703: RETURN FALSE;
704: ELSE
705: RETURN TRUE;
706: END IF;

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

808:
809: BEGIN
810: IF l_DEBUG in ('Y', 'C') THEN
811: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.transfer_lines');
812: cep_standard.debug('func: '||CE_AUTO_BANK_REC.G_functional_currency);
813: END IF;
814:
815: IF (G_cshi_intra_day_flag = 'Y' AND CE_AUTO_BANK_REC.G_intra_day_flag = 'Y') THEN
816: INSERT INTO ce_intra_stmt_lines

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

811: cep_standard.debug('>>CE_AUTO_BANK_IMPORT.transfer_lines');
812: cep_standard.debug('func: '||CE_AUTO_BANK_REC.G_functional_currency);
813: END IF;
814:
815: IF (G_cshi_intra_day_flag = 'Y' AND CE_AUTO_BANK_REC.G_intra_day_flag = 'Y') THEN
816: INSERT INTO ce_intra_stmt_lines
817: (statement_line_id,
818: statement_header_id,
819: line_number,

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

902: aba.bank_account_id
903: AND csli.statement_number = G_cshi_statement_number
904: AND csli.bank_account_num = aba.bank_account_num
905: AND aba.bank_account_id = G_bank_account_id;
906: ELSIF (nvl(G_cshi_intra_day_flag,'N') <> 'Y' AND CE_AUTO_BANK_REC.G_intra_day_flag <> 'Y') THEN
907: --Bug 6710502: Added an nvl to subsisdiary flag to handle records upgraded from 11i to R12
908: IF ( nvl(G_cshi_subsidiary_flag,'N') = 'N' ) THEN
909: INSERT INTO ce_statement_lines
910: (statement_line_id,

Line 972: CE_AUTO_BANK_REC.G_functional_currency,

968: csli.charges_amount,
969: 'UNRECONCILED',
970: csli.currency_code,
971: decode(gl_currency_api.is_fixed_rate(
972: CE_AUTO_BANK_REC.G_functional_currency,
973: nvl(csli.currency_code,aba.currency_code),
974: nvl(csli.exchange_rate_date,csli.trx_date)),
975: 'Y', decode(gdct.conversion_type, NULL,NULL,
976: decode(nvl(csli.currency_code,aba.currency_code),

Line 977: CE_AUTO_BANK_REC.G_functional_currency,

973: nvl(csli.currency_code,aba.currency_code),
974: nvl(csli.exchange_rate_date,csli.trx_date)),
975: 'Y', decode(gdct.conversion_type, NULL,NULL,
976: decode(nvl(csli.currency_code,aba.currency_code),
977: CE_AUTO_BANK_REC.G_functional_currency,
978: gdct.conversion_type,'EMU FIXED')),
979: gdct.conversion_type),
980: csli.exchange_rate_date,
981: csli.exchange_rate,

Line 1067: CE_AUTO_BANK_REC.G_set_of_books_id,

1063: -- Call the AOL sequence numbering routine to get Seq. number
1064: --
1065: l_valid_seq := CE_AUTO_BANK_IMPORT.get_sequence_info(260,
1066: aba_bank_account_name,
1067: CE_AUTO_BANK_REC.G_set_of_books_id,
1068: 'A',
1069: CE_AUTO_BANK_IMPORT.G_cshi_statement_date,
1070: l_dbseqname,
1071: l_doc_seq_id,

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

1085: ELSE
1086: CE_AUTO_BANK_IMPORT.G_cshi_statement_header_id := NULL;
1087: IF l_DEBUG in ('Y', 'C') THEN
1088: cep_standard.debug('G_cshi_intra_day_flag '|| G_cshi_intra_day_flag ||
1089: ', CE_AUTO_BANK_REC.G_intra_day_flag '|| CE_AUTO_BANK_REC.G_intra_day_flag);
1090: END IF;
1091:
1092: IF (G_cshi_intra_day_flag = 'Y' AND CE_AUTO_BANK_REC.G_intra_day_flag = 'Y') THEN
1093: DELETE FROM CE_INTRA_STMT_LINES

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

1088: cep_standard.debug('G_cshi_intra_day_flag '|| G_cshi_intra_day_flag ||
1089: ', CE_AUTO_BANK_REC.G_intra_day_flag '|| CE_AUTO_BANK_REC.G_intra_day_flag);
1090: END IF;
1091:
1092: IF (G_cshi_intra_day_flag = 'Y' AND CE_AUTO_BANK_REC.G_intra_day_flag = 'Y') THEN
1093: DELETE FROM CE_INTRA_STMT_LINES
1094: WHERE statement_header_id in
1095: (select statement_header_id
1096: from ce_intra_stmt_headers

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

1192: null);
1193: --G_cshi_org_id);
1194: update_header_status('T');
1195: RETURN TRUE;
1196: ELSIF ( nvl(G_cshi_intra_day_flag,'N') <> 'Y' AND CE_AUTO_BANK_REC.G_intra_day_flag <> 'Y') THEN
1197:
1198: --check if statement date is less than sysdate
1199: -- cannot import statements with date greater than or equal to sysdate
1200: if (trunc(CE_AUTO_BANK_IMPORT.G_cshi_statement_date) >= trunc(sysdate)) then

Line 1265: X_gl_date => CE_AUTO_BANK_REC.G_gl_date,

1261: X_attribute14 => CE_AUTO_BANK_IMPORT.G_cshi_attribute14,
1262: X_attribute15 => CE_AUTO_BANK_IMPORT.G_cshi_attribute15,
1263: X_auto_loaded_flag => 'Y',
1264: X_statement_complete_flag => 'N',
1265: X_gl_date => CE_AUTO_BANK_REC.G_gl_date,
1266: X_balance_flag => x_flag,
1267: X_average_close_ledger_mtd => CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_mtd,
1268: X_average_close_ledger_ytd => CE_AUTO_BANK_IMPORT.G_cshi_close_ledger_ytd,
1269: X_average_close_available_mtd => CE_AUTO_BANK_IMPORT.G_cshi_close_available_mtd,

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

1597: -- 2. The GL date (Must be Open or Future Enterable in AP OR AR)
1598: -- bug 3676745 MO/BA uptake
1599: -- If the bank account is also used for xtr or payroll, do not check GL DATE
1600:
1601: IF (CE_AUTO_BANK_REC.G_intra_day_flag <> 'Y') THEN
1602: --IF (account_type <> 'PAYROLL') THEN
1603: IF (CE_AUTO_BANK_IMPORT.G_xtr_use_allowed_flag = 'N' and
1604: CE_AUTO_BANK_IMPORT.G_pay_use_allowed_flag = 'N') THEN
1605: gl_date_found :=

Line 1606: (CE_AUTO_BANK_REC.find_gl_period(CE_AUTO_BANK_REC.G_gl_date, 222)

1602: --IF (account_type <> 'PAYROLL') THEN
1603: IF (CE_AUTO_BANK_IMPORT.G_xtr_use_allowed_flag = 'N' and
1604: CE_AUTO_BANK_IMPORT.G_pay_use_allowed_flag = 'N') THEN
1605: gl_date_found :=
1606: (CE_AUTO_BANK_REC.find_gl_period(CE_AUTO_BANK_REC.G_gl_date, 222)
1607: OR CE_AUTO_BANK_REC.find_gl_period(CE_AUTO_BANK_REC.G_gl_date, 200));
1608: IF (NOT gl_date_found) THEN
1609: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_INVALID_PERIOD');
1610: END IF;

Line 1607: OR CE_AUTO_BANK_REC.find_gl_period(CE_AUTO_BANK_REC.G_gl_date, 200));

1603: IF (CE_AUTO_BANK_IMPORT.G_xtr_use_allowed_flag = 'N' and
1604: CE_AUTO_BANK_IMPORT.G_pay_use_allowed_flag = 'N') THEN
1605: gl_date_found :=
1606: (CE_AUTO_BANK_REC.find_gl_period(CE_AUTO_BANK_REC.G_gl_date, 222)
1607: OR CE_AUTO_BANK_REC.find_gl_period(CE_AUTO_BANK_REC.G_gl_date, 200));
1608: IF (NOT gl_date_found) THEN
1609: error_found := CE_AUTO_BANK_IMPORT.header_error('CE_INVALID_PERIOD');
1610: END IF;
1611: END IF;

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

1612: END IF;
1613: --
1614: -- 3. Already existing in the CE_STATEMENT_HEADERS
1615: --
1616: IF (CE_AUTO_BANK_REC.G_intra_day_flag <> 'Y') THEN
1617: IF (r_statement_number IS NOT NULL) THEN
1618: duplicate_found := CE_AUTO_BANK_IMPORT.header_error('CE_PREV_IMPORT');
1619: END IF;
1620: END IF;

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

1621:
1622: IF (bank_error) THEN
1623: error_found := TRUE;
1624: END IF;
1625: IF (CE_AUTO_BANK_REC.G_intra_day_flag <> 'Y') THEN
1626: IF (duplicate_found OR NOT gl_date_found) THEN
1627: error_found := TRUE;
1628: END IF;
1629: END IF;

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

1738: -- 5. EMU Fixed type is only for valid curr and xdate
1739: --
1740: BEGIN
1741:
1742: /* -- bug 3676745, if p_option = 'IMPORT', no org information to get CE_AUTO_BANK_REC.G_functional_currency
1743:
1744: IF l_DEBUG in ('Y', 'C') THEN
1745: cep_standard.debug('CE_AUTO_BANK_REC.G_functional_currency = '|| CE_AUTO_BANK_REC.G_functional_currency ||
1746: ',CE_AUTO_BANK_REC.G_interface_purge_flag = ' ||CE_AUTO_BANK_REC.G_interface_purge_flag ||

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

1741:
1742: /* -- bug 3676745, if p_option = 'IMPORT', no org information to get CE_AUTO_BANK_REC.G_functional_currency
1743:
1744: IF l_DEBUG in ('Y', 'C') THEN
1745: cep_standard.debug('CE_AUTO_BANK_REC.G_functional_currency = '|| CE_AUTO_BANK_REC.G_functional_currency ||
1746: ',CE_AUTO_BANK_REC.G_interface_purge_flag = ' ||CE_AUTO_BANK_REC.G_interface_purge_flag ||
1747: ',CE_AUTO_BANK_REC.G_interface_archive_flag = '|| CE_AUTO_BANK_REC.G_interface_archive_flag );
1748: END IF;
1749: IF (CE_AUTO_BANK_REC.G_org_id is null and

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

1742: /* -- bug 3676745, if p_option = 'IMPORT', no org information to get CE_AUTO_BANK_REC.G_functional_currency
1743:
1744: IF l_DEBUG in ('Y', 'C') THEN
1745: cep_standard.debug('CE_AUTO_BANK_REC.G_functional_currency = '|| CE_AUTO_BANK_REC.G_functional_currency ||
1746: ',CE_AUTO_BANK_REC.G_interface_purge_flag = ' ||CE_AUTO_BANK_REC.G_interface_purge_flag ||
1747: ',CE_AUTO_BANK_REC.G_interface_archive_flag = '|| CE_AUTO_BANK_REC.G_interface_archive_flag );
1748: END IF;
1749: IF (CE_AUTO_BANK_REC.G_org_id is null and
1750: CE_AUTO_BANK_REC.G_legal_entity_id is null and

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

1743:
1744: IF l_DEBUG in ('Y', 'C') THEN
1745: cep_standard.debug('CE_AUTO_BANK_REC.G_functional_currency = '|| CE_AUTO_BANK_REC.G_functional_currency ||
1746: ',CE_AUTO_BANK_REC.G_interface_purge_flag = ' ||CE_AUTO_BANK_REC.G_interface_purge_flag ||
1747: ',CE_AUTO_BANK_REC.G_interface_archive_flag = '|| CE_AUTO_BANK_REC.G_interface_archive_flag );
1748: END IF;
1749: IF (CE_AUTO_BANK_REC.G_org_id is null and
1750: CE_AUTO_BANK_REC.G_legal_entity_id is null and
1751: CE_AUTO_BANK_REC.G_functional_currency is null ) THEN

Line 1749: IF (CE_AUTO_BANK_REC.G_org_id is null and

1745: cep_standard.debug('CE_AUTO_BANK_REC.G_functional_currency = '|| CE_AUTO_BANK_REC.G_functional_currency ||
1746: ',CE_AUTO_BANK_REC.G_interface_purge_flag = ' ||CE_AUTO_BANK_REC.G_interface_purge_flag ||
1747: ',CE_AUTO_BANK_REC.G_interface_archive_flag = '|| CE_AUTO_BANK_REC.G_interface_archive_flag );
1748: END IF;
1749: IF (CE_AUTO_BANK_REC.G_org_id is null and
1750: CE_AUTO_BANK_REC.G_legal_entity_id is null and
1751: CE_AUTO_BANK_REC.G_functional_currency is null ) THEN
1752: SELECT g.currency_code,
1753: NVL(s.interface_purge_flag,'N'),

Line 1750: CE_AUTO_BANK_REC.G_legal_entity_id is null and

1746: ',CE_AUTO_BANK_REC.G_interface_purge_flag = ' ||CE_AUTO_BANK_REC.G_interface_purge_flag ||
1747: ',CE_AUTO_BANK_REC.G_interface_archive_flag = '|| CE_AUTO_BANK_REC.G_interface_archive_flag );
1748: END IF;
1749: IF (CE_AUTO_BANK_REC.G_org_id is null and
1750: CE_AUTO_BANK_REC.G_legal_entity_id is null and
1751: CE_AUTO_BANK_REC.G_functional_currency is null ) THEN
1752: SELECT g.currency_code,
1753: NVL(s.interface_purge_flag,'N'),
1754: NVL(s.interface_archive_flag,'N')

Line 1751: CE_AUTO_BANK_REC.G_functional_currency is null ) THEN

1747: ',CE_AUTO_BANK_REC.G_interface_archive_flag = '|| CE_AUTO_BANK_REC.G_interface_archive_flag );
1748: END IF;
1749: IF (CE_AUTO_BANK_REC.G_org_id is null and
1750: CE_AUTO_BANK_REC.G_legal_entity_id is null and
1751: CE_AUTO_BANK_REC.G_functional_currency is null ) THEN
1752: SELECT g.currency_code,
1753: NVL(s.interface_purge_flag,'N'),
1754: NVL(s.interface_archive_flag,'N')
1755: INTO CE_AUTO_BANK_REC.G_functional_currency,

Line 1755: INTO CE_AUTO_BANK_REC.G_functional_currency,

1751: CE_AUTO_BANK_REC.G_functional_currency is null ) THEN
1752: SELECT g.currency_code,
1753: NVL(s.interface_purge_flag,'N'),
1754: NVL(s.interface_archive_flag,'N')
1755: INTO CE_AUTO_BANK_REC.G_functional_currency,
1756: CE_AUTO_BANK_REC.G_interface_purge_flag ,
1757: CE_AUTO_BANK_REC.G_interface_archive_flag
1758: FROM CE_SYSTEM_PARAMETERS_ALL s,
1759: GL_SETS_OF_BOOKS g,

Line 1756: CE_AUTO_BANK_REC.G_interface_purge_flag ,

1752: SELECT g.currency_code,
1753: NVL(s.interface_purge_flag,'N'),
1754: NVL(s.interface_archive_flag,'N')
1755: INTO CE_AUTO_BANK_REC.G_functional_currency,
1756: CE_AUTO_BANK_REC.G_interface_purge_flag ,
1757: CE_AUTO_BANK_REC.G_interface_archive_flag
1758: FROM CE_SYSTEM_PARAMETERS_ALL s,
1759: GL_SETS_OF_BOOKS g,
1760: ce_bank_accts_gt_v ba --ce_bank_accounts_v ba

Line 1757: CE_AUTO_BANK_REC.G_interface_archive_flag

1753: NVL(s.interface_purge_flag,'N'),
1754: NVL(s.interface_archive_flag,'N')
1755: INTO CE_AUTO_BANK_REC.G_functional_currency,
1756: CE_AUTO_BANK_REC.G_interface_purge_flag ,
1757: CE_AUTO_BANK_REC.G_interface_archive_flag
1758: FROM CE_SYSTEM_PARAMETERS_ALL s,
1759: GL_SETS_OF_BOOKS g,
1760: ce_bank_accts_gt_v ba --ce_bank_accounts_v ba
1761: WHERE ba.bank_account_id = CE_AUTO_BANK_IMPORT.G_bank_account_id

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

1764:
1765: END IF;
1766: */
1767: IF l_DEBUG in ('Y', 'C') THEN
1768: cep_standard.debug('CE_AUTO_BANK_REC.G_functional_currency = '|| CE_AUTO_BANK_REC.G_functional_currency ||
1769: ',CE_AUTO_BANK_REC.G_interface_purge_flag = ' ||CE_AUTO_BANK_REC.G_interface_purge_flag ||
1770: ',CE_AUTO_BANK_REC.G_interface_archive_flag = '|| CE_AUTO_BANK_REC.G_interface_archive_flag );
1771: END IF;
1772:

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

1765: END IF;
1766: */
1767: IF l_DEBUG in ('Y', 'C') THEN
1768: cep_standard.debug('CE_AUTO_BANK_REC.G_functional_currency = '|| CE_AUTO_BANK_REC.G_functional_currency ||
1769: ',CE_AUTO_BANK_REC.G_interface_purge_flag = ' ||CE_AUTO_BANK_REC.G_interface_purge_flag ||
1770: ',CE_AUTO_BANK_REC.G_interface_archive_flag = '|| CE_AUTO_BANK_REC.G_interface_archive_flag );
1771: END IF;
1772:
1773: fixed_rate_yn := gl_currency_api.is_fixed_rate(

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

1766: */
1767: IF l_DEBUG in ('Y', 'C') THEN
1768: cep_standard.debug('CE_AUTO_BANK_REC.G_functional_currency = '|| CE_AUTO_BANK_REC.G_functional_currency ||
1769: ',CE_AUTO_BANK_REC.G_interface_purge_flag = ' ||CE_AUTO_BANK_REC.G_interface_purge_flag ||
1770: ',CE_AUTO_BANK_REC.G_interface_archive_flag = '|| CE_AUTO_BANK_REC.G_interface_archive_flag );
1771: END IF;
1772:
1773: fixed_rate_yn := gl_currency_api.is_fixed_rate(
1774: CE_AUTO_BANK_REC.G_functional_currency,

Line 1774: CE_AUTO_BANK_REC.G_functional_currency,

1770: ',CE_AUTO_BANK_REC.G_interface_archive_flag = '|| CE_AUTO_BANK_REC.G_interface_archive_flag );
1771: END IF;
1772:
1773: fixed_rate_yn := gl_currency_api.is_fixed_rate(
1774: CE_AUTO_BANK_REC.G_functional_currency,
1775: nvl(csli_currency_code,aba_bank_currency),
1776: nvl(csli_exchange_rate_date,csli_trx_date));
1777: EXCEPTION
1778: WHEN OTHERS THEN cep_standard.debug('cannot get relationship for the give curr');

Line 1811: | CE_AUTO_BANK_REC.statement |

1807: | CALLS |
1808: | statement_import |
1809: | |
1810: | CALLED BY |
1811: | CE_AUTO_BANK_REC.statement |
1812: --------------------------------------------------------------------- */
1813: PROCEDURE import_process IS
1814: aba_bank_account_id CE_BANK_ACCOUNTS.bank_account_id%TYPE;
1815: aba_bank_currency CE_BANK_ACCOUNTS.currency_code%TYPE;

Line 1858: OPEN branch_cursor( CE_AUTO_BANK_REC.G_bank_branch_id,

1854:
1855: -- populate ce_security_profiles_tmp table with ce_security_procfiles_v
1856: CEP_STANDARD.init_security;
1857:
1858: OPEN branch_cursor( CE_AUTO_BANK_REC.G_bank_branch_id,
1859: CE_AUTO_BANK_REC.G_bank_account_id );
1860: LOOP
1861: FETCH branch_cursor INTO CE_AUTO_BANK_IMPORT.G_bank_account_id,
1862: CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID,

Line 1859: CE_AUTO_BANK_REC.G_bank_account_id );

1855: -- populate ce_security_profiles_tmp table with ce_security_procfiles_v
1856: CEP_STANDARD.init_security;
1857:
1858: OPEN branch_cursor( CE_AUTO_BANK_REC.G_bank_branch_id,
1859: CE_AUTO_BANK_REC.G_bank_account_id );
1860: LOOP
1861: FETCH branch_cursor INTO CE_AUTO_BANK_IMPORT.G_bank_account_id,
1862: CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID,
1863: CE_AUTO_BANK_IMPORT.G_xtr_use_allowed_flag,

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

1865: aba_bank_account_id := CE_AUTO_BANK_IMPORT.G_bank_account_id;
1866:
1867: -- 1/20/05 Did not enter organization (le_id and org_id missing)
1868: -- BUG 4914608
1869: /* IF (CE_AUTO_BANK_REC.G_legal_entity_id is null and CE_AUTO_BANK_REC.G_org_id is null) THEN
1870: select ACCOUNT_OWNER_ORG_ID
1871: into X_le_id
1872: from ce_BANK_ACCOUNTS
1873: where BANK_ACCOUNT_ID = aba_bank_account_id; */

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

1870: select ACCOUNT_OWNER_ORG_ID
1871: into X_le_id
1872: from ce_BANK_ACCOUNTS
1873: where BANK_ACCOUNT_ID = aba_bank_account_id; */
1874: --IF (CE_AUTO_BANK_REC.G_legal_entity_id is null and CE_AUTO_BANK_REC.G_org_id is null) THEN
1875: IF (CE_AUTO_BANK_REC.G_legal_entity_id is null) and
1876: (CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID is not null) THEN
1877:
1878: CE_SYSTEM_PARAMETERS1_PKG.select_columns(CE_AUTO_BANK_REC.G_rowid,

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

1871: into X_le_id
1872: from ce_BANK_ACCOUNTS
1873: where BANK_ACCOUNT_ID = aba_bank_account_id; */
1874: --IF (CE_AUTO_BANK_REC.G_legal_entity_id is null and CE_AUTO_BANK_REC.G_org_id is null) THEN
1875: IF (CE_AUTO_BANK_REC.G_legal_entity_id is null) and
1876: (CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID is not null) THEN
1877:
1878: CE_SYSTEM_PARAMETERS1_PKG.select_columns(CE_AUTO_BANK_REC.G_rowid,
1879: CE_AUTO_BANK_REC.G_set_of_books_id,

Line 1878: CE_SYSTEM_PARAMETERS1_PKG.select_columns(CE_AUTO_BANK_REC.G_rowid,

1874: --IF (CE_AUTO_BANK_REC.G_legal_entity_id is null and CE_AUTO_BANK_REC.G_org_id is null) THEN
1875: IF (CE_AUTO_BANK_REC.G_legal_entity_id is null) and
1876: (CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID is not null) THEN
1877:
1878: CE_SYSTEM_PARAMETERS1_PKG.select_columns(CE_AUTO_BANK_REC.G_rowid,
1879: CE_AUTO_BANK_REC.G_set_of_books_id,
1880: CE_AUTO_BANK_REC.G_cashbook_begin_date,
1881: CE_AUTO_BANK_REC.G_show_cleared_flag,
1882: CE_AUTO_BANK_REC.G_show_void_payment_flag,

Line 1879: CE_AUTO_BANK_REC.G_set_of_books_id,

1875: IF (CE_AUTO_BANK_REC.G_legal_entity_id is null) and
1876: (CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID is not null) THEN
1877:
1878: CE_SYSTEM_PARAMETERS1_PKG.select_columns(CE_AUTO_BANK_REC.G_rowid,
1879: CE_AUTO_BANK_REC.G_set_of_books_id,
1880: CE_AUTO_BANK_REC.G_cashbook_begin_date,
1881: CE_AUTO_BANK_REC.G_show_cleared_flag,
1882: CE_AUTO_BANK_REC.G_show_void_payment_flag,
1883: CE_AUTO_BANK_REC.G_line_autocreation_flag,

Line 1880: CE_AUTO_BANK_REC.G_cashbook_begin_date,

1876: (CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID is not null) THEN
1877:
1878: CE_SYSTEM_PARAMETERS1_PKG.select_columns(CE_AUTO_BANK_REC.G_rowid,
1879: CE_AUTO_BANK_REC.G_set_of_books_id,
1880: CE_AUTO_BANK_REC.G_cashbook_begin_date,
1881: CE_AUTO_BANK_REC.G_show_cleared_flag,
1882: CE_AUTO_BANK_REC.G_show_void_payment_flag,
1883: CE_AUTO_BANK_REC.G_line_autocreation_flag,
1884: CE_AUTO_BANK_REC.G_interface_purge_flag,

Line 1881: CE_AUTO_BANK_REC.G_show_cleared_flag,

1877:
1878: CE_SYSTEM_PARAMETERS1_PKG.select_columns(CE_AUTO_BANK_REC.G_rowid,
1879: CE_AUTO_BANK_REC.G_set_of_books_id,
1880: CE_AUTO_BANK_REC.G_cashbook_begin_date,
1881: CE_AUTO_BANK_REC.G_show_cleared_flag,
1882: CE_AUTO_BANK_REC.G_show_void_payment_flag,
1883: CE_AUTO_BANK_REC.G_line_autocreation_flag,
1884: CE_AUTO_BANK_REC.G_interface_purge_flag,
1885: CE_AUTO_BANK_REC.G_interface_archive_flag,

Line 1882: CE_AUTO_BANK_REC.G_show_void_payment_flag,

1878: CE_SYSTEM_PARAMETERS1_PKG.select_columns(CE_AUTO_BANK_REC.G_rowid,
1879: CE_AUTO_BANK_REC.G_set_of_books_id,
1880: CE_AUTO_BANK_REC.G_cashbook_begin_date,
1881: CE_AUTO_BANK_REC.G_show_cleared_flag,
1882: CE_AUTO_BANK_REC.G_show_void_payment_flag,
1883: CE_AUTO_BANK_REC.G_line_autocreation_flag,
1884: CE_AUTO_BANK_REC.G_interface_purge_flag,
1885: CE_AUTO_BANK_REC.G_interface_archive_flag,
1886: CE_AUTO_BANK_REC.G_lines_per_commit,

Line 1883: CE_AUTO_BANK_REC.G_line_autocreation_flag,

1879: CE_AUTO_BANK_REC.G_set_of_books_id,
1880: CE_AUTO_BANK_REC.G_cashbook_begin_date,
1881: CE_AUTO_BANK_REC.G_show_cleared_flag,
1882: CE_AUTO_BANK_REC.G_show_void_payment_flag,
1883: CE_AUTO_BANK_REC.G_line_autocreation_flag,
1884: CE_AUTO_BANK_REC.G_interface_purge_flag,
1885: CE_AUTO_BANK_REC.G_interface_archive_flag,
1886: CE_AUTO_BANK_REC.G_lines_per_commit,
1887: CE_AUTO_BANK_REC.G_functional_currency,

Line 1884: CE_AUTO_BANK_REC.G_interface_purge_flag,

1880: CE_AUTO_BANK_REC.G_cashbook_begin_date,
1881: CE_AUTO_BANK_REC.G_show_cleared_flag,
1882: CE_AUTO_BANK_REC.G_show_void_payment_flag,
1883: CE_AUTO_BANK_REC.G_line_autocreation_flag,
1884: CE_AUTO_BANK_REC.G_interface_purge_flag,
1885: CE_AUTO_BANK_REC.G_interface_archive_flag,
1886: CE_AUTO_BANK_REC.G_lines_per_commit,
1887: CE_AUTO_BANK_REC.G_functional_currency,
1888: CE_AUTO_BANK_REC.G_sob_short_name,

Line 1885: CE_AUTO_BANK_REC.G_interface_archive_flag,

1881: CE_AUTO_BANK_REC.G_show_cleared_flag,
1882: CE_AUTO_BANK_REC.G_show_void_payment_flag,
1883: CE_AUTO_BANK_REC.G_line_autocreation_flag,
1884: CE_AUTO_BANK_REC.G_interface_purge_flag,
1885: CE_AUTO_BANK_REC.G_interface_archive_flag,
1886: CE_AUTO_BANK_REC.G_lines_per_commit,
1887: CE_AUTO_BANK_REC.G_functional_currency,
1888: CE_AUTO_BANK_REC.G_sob_short_name,
1889: CE_AUTO_BANK_REC.G_account_period_type,

Line 1886: CE_AUTO_BANK_REC.G_lines_per_commit,

1882: CE_AUTO_BANK_REC.G_show_void_payment_flag,
1883: CE_AUTO_BANK_REC.G_line_autocreation_flag,
1884: CE_AUTO_BANK_REC.G_interface_purge_flag,
1885: CE_AUTO_BANK_REC.G_interface_archive_flag,
1886: CE_AUTO_BANK_REC.G_lines_per_commit,
1887: CE_AUTO_BANK_REC.G_functional_currency,
1888: CE_AUTO_BANK_REC.G_sob_short_name,
1889: CE_AUTO_BANK_REC.G_account_period_type,
1890: CE_AUTO_BANK_REC.G_user_exchange_rate_type,

Line 1887: CE_AUTO_BANK_REC.G_functional_currency,

1883: CE_AUTO_BANK_REC.G_line_autocreation_flag,
1884: CE_AUTO_BANK_REC.G_interface_purge_flag,
1885: CE_AUTO_BANK_REC.G_interface_archive_flag,
1886: CE_AUTO_BANK_REC.G_lines_per_commit,
1887: CE_AUTO_BANK_REC.G_functional_currency,
1888: CE_AUTO_BANK_REC.G_sob_short_name,
1889: CE_AUTO_BANK_REC.G_account_period_type,
1890: CE_AUTO_BANK_REC.G_user_exchange_rate_type,
1891: CE_AUTO_BANK_REC.G_chart_of_accounts_id,

Line 1888: CE_AUTO_BANK_REC.G_sob_short_name,

1884: CE_AUTO_BANK_REC.G_interface_purge_flag,
1885: CE_AUTO_BANK_REC.G_interface_archive_flag,
1886: CE_AUTO_BANK_REC.G_lines_per_commit,
1887: CE_AUTO_BANK_REC.G_functional_currency,
1888: CE_AUTO_BANK_REC.G_sob_short_name,
1889: CE_AUTO_BANK_REC.G_account_period_type,
1890: CE_AUTO_BANK_REC.G_user_exchange_rate_type,
1891: CE_AUTO_BANK_REC.G_chart_of_accounts_id,
1892: CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE,

Line 1889: CE_AUTO_BANK_REC.G_account_period_type,

1885: CE_AUTO_BANK_REC.G_interface_archive_flag,
1886: CE_AUTO_BANK_REC.G_lines_per_commit,
1887: CE_AUTO_BANK_REC.G_functional_currency,
1888: CE_AUTO_BANK_REC.G_sob_short_name,
1889: CE_AUTO_BANK_REC.G_account_period_type,
1890: CE_AUTO_BANK_REC.G_user_exchange_rate_type,
1891: CE_AUTO_BANK_REC.G_chart_of_accounts_id,
1892: CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE,
1893: CE_AUTO_BANK_REC.G_AUTHORIZATION_BAT,

Line 1890: CE_AUTO_BANK_REC.G_user_exchange_rate_type,

1886: CE_AUTO_BANK_REC.G_lines_per_commit,
1887: CE_AUTO_BANK_REC.G_functional_currency,
1888: CE_AUTO_BANK_REC.G_sob_short_name,
1889: CE_AUTO_BANK_REC.G_account_period_type,
1890: CE_AUTO_BANK_REC.G_user_exchange_rate_type,
1891: CE_AUTO_BANK_REC.G_chart_of_accounts_id,
1892: CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE,
1893: CE_AUTO_BANK_REC.G_AUTHORIZATION_BAT,
1894: CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE,

Line 1891: CE_AUTO_BANK_REC.G_chart_of_accounts_id,

1887: CE_AUTO_BANK_REC.G_functional_currency,
1888: CE_AUTO_BANK_REC.G_sob_short_name,
1889: CE_AUTO_BANK_REC.G_account_period_type,
1890: CE_AUTO_BANK_REC.G_user_exchange_rate_type,
1891: CE_AUTO_BANK_REC.G_chart_of_accounts_id,
1892: CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE,
1893: CE_AUTO_BANK_REC.G_AUTHORIZATION_BAT,
1894: CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE,
1895: CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE,

Line 1892: CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE,

1888: CE_AUTO_BANK_REC.G_sob_short_name,
1889: CE_AUTO_BANK_REC.G_account_period_type,
1890: CE_AUTO_BANK_REC.G_user_exchange_rate_type,
1891: CE_AUTO_BANK_REC.G_chart_of_accounts_id,
1892: CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE,
1893: CE_AUTO_BANK_REC.G_AUTHORIZATION_BAT,
1894: CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE,
1895: CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE,
1896: CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID

Line 1893: CE_AUTO_BANK_REC.G_AUTHORIZATION_BAT,

1889: CE_AUTO_BANK_REC.G_account_period_type,
1890: CE_AUTO_BANK_REC.G_user_exchange_rate_type,
1891: CE_AUTO_BANK_REC.G_chart_of_accounts_id,
1892: CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE,
1893: CE_AUTO_BANK_REC.G_AUTHORIZATION_BAT,
1894: CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE,
1895: CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE,
1896: CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID
1897: );

Line 1894: CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE,

1890: CE_AUTO_BANK_REC.G_user_exchange_rate_type,
1891: CE_AUTO_BANK_REC.G_chart_of_accounts_id,
1892: CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE,
1893: CE_AUTO_BANK_REC.G_AUTHORIZATION_BAT,
1894: CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE,
1895: CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE,
1896: CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID
1897: );
1898: END IF;

Line 1895: CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE,

1891: CE_AUTO_BANK_REC.G_chart_of_accounts_id,
1892: CE_AUTO_BANK_REC.G_CASHFLOW_EXCHANGE_RATE_TYPE,
1893: CE_AUTO_BANK_REC.G_AUTHORIZATION_BAT,
1894: CE_AUTO_BANK_REC.G_BSC_EXCHANGE_DATE_TYPE,
1895: CE_AUTO_BANK_REC.G_BAT_EXCHANGE_DATE_TYPE,
1896: CE_AUTO_BANK_IMPORT.BA_OWNER_LE_ID
1897: );
1898: END IF;
1899:

Line 1906: OPEN bank_cursor(CE_AUTO_BANK_REC.G_statement_number_from,

1902: END IF;
1903:
1904: EXIT WHEN branch_cursor%NOTFOUND OR branch_cursor%NOTFOUND IS NULL;
1905:
1906: OPEN bank_cursor(CE_AUTO_BANK_REC.G_statement_number_from,
1907: CE_AUTO_BANK_REC.G_statement_number_to,
1908: CE_AUTO_BANK_REC.G_statement_date_from,
1909: CE_AUTO_BANK_REC.G_statement_date_to,
1910: CE_AUTO_BANK_IMPORT.G_bank_account_id);

Line 1907: CE_AUTO_BANK_REC.G_statement_number_to,

1903:
1904: EXIT WHEN branch_cursor%NOTFOUND OR branch_cursor%NOTFOUND IS NULL;
1905:
1906: OPEN bank_cursor(CE_AUTO_BANK_REC.G_statement_number_from,
1907: CE_AUTO_BANK_REC.G_statement_number_to,
1908: CE_AUTO_BANK_REC.G_statement_date_from,
1909: CE_AUTO_BANK_REC.G_statement_date_to,
1910: CE_AUTO_BANK_IMPORT.G_bank_account_id);
1911: LOOP

Line 1908: CE_AUTO_BANK_REC.G_statement_date_from,

1904: EXIT WHEN branch_cursor%NOTFOUND OR branch_cursor%NOTFOUND IS NULL;
1905:
1906: OPEN bank_cursor(CE_AUTO_BANK_REC.G_statement_number_from,
1907: CE_AUTO_BANK_REC.G_statement_number_to,
1908: CE_AUTO_BANK_REC.G_statement_date_from,
1909: CE_AUTO_BANK_REC.G_statement_date_to,
1910: CE_AUTO_BANK_IMPORT.G_bank_account_id);
1911: LOOP
1912: FETCH bank_cursor INTO CE_AUTO_BANK_IMPORT.G_cshi_rowid,

Line 1909: CE_AUTO_BANK_REC.G_statement_date_to,

1905:
1906: OPEN bank_cursor(CE_AUTO_BANK_REC.G_statement_number_from,
1907: CE_AUTO_BANK_REC.G_statement_number_to,
1908: CE_AUTO_BANK_REC.G_statement_date_from,
1909: CE_AUTO_BANK_REC.G_statement_date_to,
1910: CE_AUTO_BANK_IMPORT.G_bank_account_id);
1911: LOOP
1912: FETCH bank_cursor INTO CE_AUTO_BANK_IMPORT.G_cshi_rowid,
1913: CE_AUTO_BANK_IMPORT.G_cshi_statement_number,

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

2062: (CE_AUTO_BANK_IMPORT.G_xtr_use_allowed_flag = 'Y' AND nvl(G_cshi_intra_day_flag,'N') <> 'Y')) THEN
2063: IF (transfer_bank_balances) THEN
2064: IF (transfer_header(aba_bank_account_id,aba_bank_account_name)) THEN
2065: transfer_lines;
2066: IF (CE_AUTO_BANK_REC.G_interface_archive_flag = 'Y') THEN
2067: archive_header;
2068: archive_lines;
2069: END IF;
2070: IF (CE_AUTO_BANK_REC.G_interface_purge_flag = 'Y') THEN

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

2066: IF (CE_AUTO_BANK_REC.G_interface_archive_flag = 'Y') THEN
2067: archive_header;
2068: archive_lines;
2069: END IF;
2070: IF (CE_AUTO_BANK_REC.G_interface_purge_flag = 'Y') THEN
2071: purge_data;
2072: END IF;
2073: END IF;
2074: END IF;

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

2075: --ELSIF (x_account_result = 'XTR1_AP' OR nvl(G_cshi_intra_day_flag,'N') = 'Y') THEN
2076: ELSIF (CE_AUTO_BANK_IMPORT.G_xtr_use_allowed_flag = 'N' OR nvl(G_cshi_intra_day_flag,'N') = 'Y') THEN
2077: IF (transfer_header(aba_bank_account_id,aba_bank_account_name)) THEN
2078: transfer_lines;
2079: IF (CE_AUTO_BANK_REC.G_interface_archive_flag = 'Y') THEN
2080: archive_header;
2081: archive_lines;
2082: END IF;
2083: IF (CE_AUTO_BANK_REC.G_interface_purge_flag = 'Y') THEN

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

2079: IF (CE_AUTO_BANK_REC.G_interface_archive_flag = 'Y') THEN
2080: archive_header;
2081: archive_lines;
2082: END IF;
2083: IF (CE_AUTO_BANK_REC.G_interface_purge_flag = 'Y') THEN
2084: purge_data;
2085: END IF;
2086: END IF;
2087: END IF; -- xtr_shared_account