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:

Line 1256: l_ext_bank_rec IBY_EXT_BANKACCT_PUB.ExtBank_rec_type;

1252: where temp.temp_ext_bank_acct_id = p_temp_ext_bank_account_id
1253: and req.temp_ext_bank_acct_id = temp.temp_ext_bank_acct_id;
1254: l_temp_account_rec l_temp_account_cur%ROWTYPE;
1255:
1256: l_ext_bank_rec IBY_EXT_BANKACCT_PUB.ExtBank_rec_type;
1257: l_ext_bank_branch_rec IBY_EXT_BANKACCT_PUB.ExtBankBranch_rec_type;
1258: l_ext_bank_acct_rec IBY_EXT_BANKACCT_PUB.ExtBankAcct_rec_type;
1259: l_result_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;
1260: l_primary_owner_id HZ_PARTIES.party_id%TYPE;

Line 1257: l_ext_bank_branch_rec IBY_EXT_BANKACCT_PUB.ExtBankBranch_rec_type;

1253: and req.temp_ext_bank_acct_id = temp.temp_ext_bank_acct_id;
1254: l_temp_account_rec l_temp_account_cur%ROWTYPE;
1255:
1256: l_ext_bank_rec IBY_EXT_BANKACCT_PUB.ExtBank_rec_type;
1257: l_ext_bank_branch_rec IBY_EXT_BANKACCT_PUB.ExtBankBranch_rec_type;
1258: l_ext_bank_acct_rec IBY_EXT_BANKACCT_PUB.ExtBankAcct_rec_type;
1259: l_result_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;
1260: l_primary_owner_id HZ_PARTIES.party_id%TYPE;
1261: l_non_primary_owner_id HZ_PARTIES.party_id%TYPE;

Line 1258: l_ext_bank_acct_rec IBY_EXT_BANKACCT_PUB.ExtBankAcct_rec_type;

1254: l_temp_account_rec l_temp_account_cur%ROWTYPE;
1255:
1256: l_ext_bank_rec IBY_EXT_BANKACCT_PUB.ExtBank_rec_type;
1257: l_ext_bank_branch_rec IBY_EXT_BANKACCT_PUB.ExtBankBranch_rec_type;
1258: l_ext_bank_acct_rec IBY_EXT_BANKACCT_PUB.ExtBankAcct_rec_type;
1259: l_result_rec IBY_FNDCPT_COMMON_PUB.Result_rec_type;
1260: l_primary_owner_id HZ_PARTIES.party_id%TYPE;
1261: l_non_primary_owner_id HZ_PARTIES.party_id%TYPE;
1262: l_joint_acct_owner_id NUMBER;

Line 1319: ' Calling IBY_EXT_BANKACCT_PUB.create_ext_bank');

1315: l_ext_bank_rec.bank_alt_name := l_temp_account_rec.bank_name_alt;
1316:
1317: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1318: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1319: ' Calling IBY_EXT_BANKACCT_PUB.create_ext_bank');
1320: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1321: ' l_ext_bank_rec.bank_name ' || l_ext_bank_rec.bank_name);
1322: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1323: ' l_ext_bank_rec.bank_number ' || l_ext_bank_rec.bank_number);

Line 1333: IBY_EXT_BANKACCT_PUB.create_ext_bank (

1329: ' l_ext_bank_rec.bank_alt_name ' || l_ext_bank_rec.bank_alt_name);
1330: END IF;
1331:
1332: -- Create a bank
1333: IBY_EXT_BANKACCT_PUB.create_ext_bank (
1334: p_api_version => 1.0,
1335: p_init_msg_list => FND_API.G_TRUE,
1336: p_ext_bank_rec => l_ext_bank_rec,
1337: x_bank_id => l_bank_id,

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

1342: );
1343:
1344: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1345: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1346: ' After Calling IBY_EXT_BANKACCT_PUB.create_ext_bank');
1347: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1348: ' x_return_status ' || x_status);
1349: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1350: ' x_msg_count ' || l_msg_count);

Line 1396: ' Calling IBY_EXT_BANKACCT_PUB.create_ext_bank_branch');

1392: l_ext_bank_branch_rec.rfc_identifier := l_temp_account_rec.rfc_identifier;
1393:
1394: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1395: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1396: ' Calling IBY_EXT_BANKACCT_PUB.create_ext_bank_branch');
1397: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1398: ' l_ext_bank_branch_rec.bank_party_id ' || l_ext_bank_branch_rec.bank_party_id);
1399: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1400: ' l_ext_bank_branch_rec.branch_name ' || l_ext_bank_branch_rec.branch_name);

Line 1414: IBY_EXT_BANKACCT_PUB.create_ext_bank_branch (

1410: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1411: ' l_ext_bank_branch_rec.rfc_identifier ' || l_ext_bank_branch_rec.rfc_identifier);
1412: END IF;
1413:
1414: IBY_EXT_BANKACCT_PUB.create_ext_bank_branch (
1415: p_api_version => 1.0,
1416: p_init_msg_list => FND_API.G_TRUE,
1417: p_ext_bank_branch_rec => l_ext_bank_branch_rec,
1418: x_branch_id => l_branch_id,

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

1423: );
1424:
1425: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1426: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1427: ' After Calling IBY_EXT_BANKACCT_PUB.create_ext_bank_branch');
1428: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1429: ' x_return_status ' || x_status);
1430: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1431: ' x_msg_count ' || l_msg_count);

Line 1466: IBY_EXT_BANKACCT_PUB.check_ext_acct_exist(

1462: l_step := 3;
1463:
1464: -- Find out if it exists
1465: if l_ext_bank_account_id is null then
1466: IBY_EXT_BANKACCT_PUB.check_ext_acct_exist(
1467: p_api_version => 1.0,
1468: p_init_msg_list => FND_API.G_FALSE,
1469: p_bank_id => l_bank_id,
1470: p_branch_id => l_branch_id,

Line 1495: IBY_EXT_BANKACCT_PUB.add_joint_account_owner (

1491: l_primary_owner_id := l_cur_act_rec.account_owner_party_id;
1492: l_non_primary_owner_id := l_temp_account_rec.ACCOUNT_OWNER_PARTY_ID;
1493:
1494: if l_primary_owner_id <> l_temp_account_rec.ACCOUNT_OWNER_PARTY_ID then
1495: IBY_EXT_BANKACCT_PUB.add_joint_account_owner (
1496: p_api_version => 1.0,
1497: p_init_msg_list => FND_API.G_FALSE,
1498: p_bank_account_id => l_ext_bank_account_id,
1499: p_acct_owner_party_id => l_non_primary_owner_id,

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

1531:
1532:
1533: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1534: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1535: ' Calling IBY_EXT_BANKACCT_PUB.create/update_ext_bank_acct');
1536: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1537: ' l_ext_bank_acct_rec.bank_account_id ' || l_ext_bank_acct_rec.bank_account_id);
1538: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1539: ' l_ext_bank_acct_rec.country_code ' || l_ext_bank_acct_rec.country_code);

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

1591: END IF;
1592:
1593: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1594: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1595: ' Now Calling IBY_EXT_BANKACCT_PUB.create_ext_bank_acct');
1596: END IF;
1597:
1598: IBY_EXT_BANKACCT_PUB.create_ext_bank_acct (
1599: p_api_version => 1.0,

Line 1598: IBY_EXT_BANKACCT_PUB.create_ext_bank_acct (

1594: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1595: ' Now Calling IBY_EXT_BANKACCT_PUB.create_ext_bank_acct');
1596: END IF;
1597:
1598: IBY_EXT_BANKACCT_PUB.create_ext_bank_acct (
1599: p_api_version => 1.0,
1600: p_init_msg_list => FND_API.G_TRUE,
1601: p_ext_bank_acct_rec => l_ext_bank_acct_rec,
1602: x_acct_id => l_ext_bank_account_id,

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

1607: );
1608:
1609: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1610: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1611: ' After Calling IBY_EXT_BANKACCT_PUB.create_ext_bank_acct');
1612: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1613: ' x_return_status ' || x_status);
1614: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1615: ' x_msg_count ' || l_msg_count);

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

1627: else
1628:
1629: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1630: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1631: ' Now Calling IBY_EXT_BANKACCT_PUB.update_ext_bank_acct');
1632: END IF;
1633:
1634: open l_cur_act_cur;
1635: fetch l_cur_act_cur into l_cur_act_rec;

Line 1640: IBY_EXT_BANKACCT_PUB.update_ext_bank_acct (

1636: close l_cur_act_cur;
1637:
1638: l_ext_bank_acct_rec.object_version_number := l_cur_act_rec.object_version_number;
1639:
1640: IBY_EXT_BANKACCT_PUB.update_ext_bank_acct (
1641: p_api_version => 1.0,
1642: p_init_msg_list => FND_API.G_TRUE,
1643: p_ext_bank_acct_rec => l_ext_bank_acct_rec,
1644: x_return_status => x_status,

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

1648: );
1649:
1650: IF ( fnd_log.level_statement >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) THEN
1651: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1652: ' After Calling IBY_EXT_BANKACCT_PUB.update_ext_bank_acct');
1653: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1654: ' x_return_status ' || x_status);
1655: FND_LOG.string(fnd_log.level_statement, g_log_module_name,
1656: ' x_msg_count ' || l_msg_count);

Line 1919: IBY_EXT_BANKACCT_PUB.check_ext_acct_exist(

1915: end if;
1916:
1917: if l_bank_id is not null and l_branch_id is not null and
1918: p_EXT_BANK_ACCOUNT_ID is null and x_status = 'S' then
1919: IBY_EXT_BANKACCT_PUB.check_ext_acct_exist(
1920: p_api_version => 1.0,
1921: p_init_msg_list => FND_API.G_FALSE,
1922: p_bank_id => l_bank_id,
1923: p_branch_id => l_branch_id,