DBA Data[Home] [Help]

APPS.POS_SBD_IBY_PKG dependencies on IBY_EXT_BANKACCT_PUB

Line 799: l_ext_bank_rec IBY_EXT_BANKACCT_PUB.ExtBank_rec_type;

795: )
796:
797: IS
798:
799: l_ext_bank_rec IBY_EXT_BANKACCT_PUB.ExtBank_rec_type;
800: l_ext_bank_branch_rec IBY_EXT_BANKACCT_PUB.ExtBankBranch_rec_type;
801: l_ext_bank_acct_rec IBY_EXT_BANKACCT_PUB.ExtBankAcct_rec_type;
802: l_result_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;
803: l_msg_count number;

Line 800: l_ext_bank_branch_rec IBY_EXT_BANKACCT_PUB.ExtBankBranch_rec_type;

796:
797: IS
798:
799: l_ext_bank_rec IBY_EXT_BANKACCT_PUB.ExtBank_rec_type;
800: l_ext_bank_branch_rec IBY_EXT_BANKACCT_PUB.ExtBankBranch_rec_type;
801: l_ext_bank_acct_rec IBY_EXT_BANKACCT_PUB.ExtBankAcct_rec_type;
802: l_result_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;
803: l_msg_count number;
804: l_step number;

Line 801: l_ext_bank_acct_rec IBY_EXT_BANKACCT_PUB.ExtBankAcct_rec_type;

797: IS
798:
799: l_ext_bank_rec IBY_EXT_BANKACCT_PUB.ExtBank_rec_type;
800: l_ext_bank_branch_rec IBY_EXT_BANKACCT_PUB.ExtBankBranch_rec_type;
801: l_ext_bank_acct_rec IBY_EXT_BANKACCT_PUB.ExtBankAcct_rec_type;
802: l_result_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;
803: l_msg_count number;
804: l_step number;
805: l_temp_bank_account_num IBY_EXT_BANK_ACCOUNTS.BANK_ACCOUNT_NUM%TYPE;

Line 1275: l_ext_bank_rec IBY_EXT_BANKACCT_PUB.ExtBank_rec_type;

1271: where temp.temp_ext_bank_acct_id = p_temp_ext_bank_account_id
1272: and req.temp_ext_bank_acct_id = temp.temp_ext_bank_acct_id;
1273: l_temp_account_rec l_temp_account_cur%ROWTYPE;
1274:
1275: l_ext_bank_rec IBY_EXT_BANKACCT_PUB.ExtBank_rec_type;
1276: l_ext_bank_branch_rec IBY_EXT_BANKACCT_PUB.ExtBankBranch_rec_type;
1277: l_ext_bank_acct_rec IBY_EXT_BANKACCT_PUB.ExtBankAcct_rec_type;
1278: l_result_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;
1279: l_primary_owner_id HZ_PARTIES.party_id%TYPE;

Line 1276: l_ext_bank_branch_rec IBY_EXT_BANKACCT_PUB.ExtBankBranch_rec_type;

1272: and req.temp_ext_bank_acct_id = temp.temp_ext_bank_acct_id;
1273: l_temp_account_rec l_temp_account_cur%ROWTYPE;
1274:
1275: l_ext_bank_rec IBY_EXT_BANKACCT_PUB.ExtBank_rec_type;
1276: l_ext_bank_branch_rec IBY_EXT_BANKACCT_PUB.ExtBankBranch_rec_type;
1277: l_ext_bank_acct_rec IBY_EXT_BANKACCT_PUB.ExtBankAcct_rec_type;
1278: l_result_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;
1279: l_primary_owner_id HZ_PARTIES.party_id%TYPE;
1280: l_non_primary_owner_id HZ_PARTIES.party_id%TYPE;

Line 1277: l_ext_bank_acct_rec IBY_EXT_BANKACCT_PUB.ExtBankAcct_rec_type;

1273: l_temp_account_rec l_temp_account_cur%ROWTYPE;
1274:
1275: l_ext_bank_rec IBY_EXT_BANKACCT_PUB.ExtBank_rec_type;
1276: l_ext_bank_branch_rec IBY_EXT_BANKACCT_PUB.ExtBankBranch_rec_type;
1277: l_ext_bank_acct_rec IBY_EXT_BANKACCT_PUB.ExtBankAcct_rec_type;
1278: l_result_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;
1279: l_primary_owner_id HZ_PARTIES.party_id%TYPE;
1280: l_non_primary_owner_id HZ_PARTIES.party_id%TYPE;
1281: l_joint_acct_owner_id NUMBER;

Line 1338: ' Calling IBY_EXT_BANKACCT_PUB.create_ext_bank');

1334: l_ext_bank_rec.bank_alt_name := l_temp_account_rec.bank_name_alt;
1335:
1336: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1337: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1338: ' Calling IBY_EXT_BANKACCT_PUB.create_ext_bank');
1339: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1340: ' l_ext_bank_rec.bank_name ' || l_ext_bank_rec.bank_name);
1341: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1342: ' l_ext_bank_rec.bank_number ' || l_ext_bank_rec.bank_number);

Line 1352: IBY_EXT_BANKACCT_PUB.create_ext_bank (

1348: ' l_ext_bank_rec.bank_alt_name ' || l_ext_bank_rec.bank_alt_name);
1349: END IF;
1350:
1351: -- Create a bank
1352: IBY_EXT_BANKACCT_PUB.create_ext_bank (
1353: p_api_version => 1.0,
1354: p_init_msg_list => FND_API.G_TRUE,
1355: p_ext_bank_rec => l_ext_bank_rec,
1356: x_bank_id => l_bank_id,

Line 1365: ' After Calling IBY_EXT_BANKACCT_PUB.create_ext_bank');

1361: );
1362:
1363: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1364: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1365: ' After Calling IBY_EXT_BANKACCT_PUB.create_ext_bank');
1366: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1367: ' x_return_status ' || x_status);
1368: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1369: ' x_msg_count ' || l_msg_count);

Line 1415: ' Calling IBY_EXT_BANKACCT_PUB.create_ext_bank_branch');

1411: l_ext_bank_branch_rec.rfc_identifier := l_temp_account_rec.rfc_identifier;
1412:
1413: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1414: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1415: ' Calling IBY_EXT_BANKACCT_PUB.create_ext_bank_branch');
1416: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1417: ' l_ext_bank_branch_rec.bank_party_id ' || l_ext_bank_branch_rec.bank_party_id);
1418: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1419: ' l_ext_bank_branch_rec.branch_name ' || l_ext_bank_branch_rec.branch_name);

Line 1433: IBY_EXT_BANKACCT_PUB.create_ext_bank_branch (

1429: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1430: ' l_ext_bank_branch_rec.rfc_identifier ' || l_ext_bank_branch_rec.rfc_identifier);
1431: END IF;
1432:
1433: IBY_EXT_BANKACCT_PUB.create_ext_bank_branch (
1434: p_api_version => 1.0,
1435: p_init_msg_list => FND_API.G_TRUE,
1436: p_ext_bank_branch_rec => l_ext_bank_branch_rec,
1437: x_branch_id => l_branch_id,

Line 1446: ' After Calling IBY_EXT_BANKACCT_PUB.create_ext_bank_branch');

1442: );
1443:
1444: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1445: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1446: ' After Calling IBY_EXT_BANKACCT_PUB.create_ext_bank_branch');
1447: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1448: ' x_return_status ' || x_status);
1449: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1450: ' x_msg_count ' || l_msg_count);

Line 1485: IBY_EXT_BANKACCT_PUB.check_ext_acct_exist(

1481: l_step := 3;
1482:
1483: -- Find out if it exists
1484: if l_ext_bank_account_id is null then
1485: IBY_EXT_BANKACCT_PUB.check_ext_acct_exist(
1486: p_api_version => 1.0,
1487: p_init_msg_list => FND_API.G_FALSE,
1488: p_bank_id => l_bank_id,
1489: p_branch_id => l_branch_id,

Line 1514: IBY_EXT_BANKACCT_PUB.add_joint_account_owner (

1510: l_primary_owner_id := l_cur_act_rec.account_owner_party_id;
1511: l_non_primary_owner_id := l_temp_account_rec.ACCOUNT_OWNER_PARTY_ID;
1512:
1513: if l_primary_owner_id <> l_temp_account_rec.ACCOUNT_OWNER_PARTY_ID then
1514: IBY_EXT_BANKACCT_PUB.add_joint_account_owner (
1515: p_api_version => 1.0,
1516: p_init_msg_list => FND_API.G_FALSE,
1517: p_bank_account_id => l_ext_bank_account_id,
1518: p_acct_owner_party_id => l_non_primary_owner_id,

Line 1554: ' Calling IBY_EXT_BANKACCT_PUB.create/update_ext_bank_acct');

1550:
1551:
1552: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1553: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1554: ' Calling IBY_EXT_BANKACCT_PUB.create/update_ext_bank_acct');
1555: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1556: ' l_ext_bank_acct_rec.bank_account_id ' || l_ext_bank_acct_rec.bank_account_id);
1557: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1558: ' l_ext_bank_acct_rec.country_code ' || l_ext_bank_acct_rec.country_code);

Line 1614: ' Now Calling IBY_EXT_BANKACCT_PUB.create_ext_bank_acct');

1610: END IF;
1611:
1612: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1613: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1614: ' Now Calling IBY_EXT_BANKACCT_PUB.create_ext_bank_acct');
1615: END IF;
1616:
1617: IBY_EXT_BANKACCT_PUB.create_ext_bank_acct (
1618: p_api_version => 1.0,

Line 1617: IBY_EXT_BANKACCT_PUB.create_ext_bank_acct (

1613: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1614: ' Now Calling IBY_EXT_BANKACCT_PUB.create_ext_bank_acct');
1615: END IF;
1616:
1617: IBY_EXT_BANKACCT_PUB.create_ext_bank_acct (
1618: p_api_version => 1.0,
1619: p_init_msg_list => FND_API.G_TRUE,
1620: p_ext_bank_acct_rec => l_ext_bank_acct_rec,
1621: x_acct_id => l_ext_bank_account_id,

Line 1630: ' After Calling IBY_EXT_BANKACCT_PUB.create_ext_bank_acct');

1626: );
1627:
1628: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1629: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1630: ' After Calling IBY_EXT_BANKACCT_PUB.create_ext_bank_acct');
1631: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1632: ' x_return_status ' || x_status);
1633: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1634: ' x_msg_count ' || l_msg_count);

Line 1650: ' Now Calling IBY_EXT_BANKACCT_PUB.update_ext_bank_acct');

1646: else
1647:
1648: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1649: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1650: ' Now Calling IBY_EXT_BANKACCT_PUB.update_ext_bank_acct');
1651: END IF;
1652:
1653: open l_cur_act_cur;
1654: fetch l_cur_act_cur into l_cur_act_rec;

Line 1675: IBY_EXT_BANKACCT_PUB.update_ext_bank_acct (

1671: END IF;
1672:
1673: /* BUG 10384712 END */
1674:
1675: IBY_EXT_BANKACCT_PUB.update_ext_bank_acct (
1676: p_api_version => 1.0,
1677: p_init_msg_list => FND_API.G_TRUE,
1678: p_ext_bank_acct_rec => l_ext_bank_acct_rec,
1679: x_return_status => x_status,

Line 1687: ' After Calling IBY_EXT_BANKACCT_PUB.update_ext_bank_acct');

1683: );
1684:
1685: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1686: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1687: ' After Calling IBY_EXT_BANKACCT_PUB.update_ext_bank_acct');
1688: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1689: ' x_return_status ' || x_status);
1690: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1691: ' x_msg_count ' || l_msg_count);

Line 1954: IBY_EXT_BANKACCT_PUB.check_ext_acct_exist(

1950: end if;
1951:
1952: if l_bank_id is not null and l_branch_id is not null and
1953: p_EXT_BANK_ACCOUNT_ID is null and x_status = 'S' then
1954: IBY_EXT_BANKACCT_PUB.check_ext_acct_exist(
1955: p_api_version => 1.0,
1956: p_init_msg_list => FND_API.G_FALSE,
1957: p_bank_id => l_bank_id,
1958: p_branch_id => l_branch_id,