DBA Data[Home] [Help]

APPS.POS_SBD_IBY_PKG dependencies on POS_SBD_IBY_PKG

Line 1: PACKAGE BODY POS_SBD_IBY_PKG as

1: PACKAGE BODY POS_SBD_IBY_PKG as
2: /*$Header: POSIBYB.pls 120.15 2006/07/25 21:19:58 gdwivedi noship $ */
3:
4: PROCEDURE remove_iby_temp_account (
5: p_iby_temp_ext_bank_account_id IN NUMBER

Line 131: POS_SBD_IBY_PKG.create_location (

127: END IF;
128:
129: if p_bank_id is null and p_bank_name is not null then
130:
131: POS_SBD_IBY_PKG.create_location (
132: p_ADDRESS1 => p_bank_address1
133: , p_ADDRESS2 => p_bank_address2
134: , p_ADDRESS3 => p_bank_address3
135: , p_ADDRESS4 => p_bank_address4

Line 152: POS_SBD_IBY_PKG.create_location (

148: l_step := 1;
149:
150: if p_branch_id is null and p_branch_name is not null then
151:
152: POS_SBD_IBY_PKG.create_location (
153: p_ADDRESS1 => p_branch_address1
154: , p_ADDRESS2 => p_branch_address2
155: , p_ADDRESS3 => p_branch_address3
156: , p_ADDRESS4 => p_branch_address4

Line 407: POS_SBD_IBY_PKG.update_location (

403: l_bank_location_id := null;
404:
405: else
406:
407: POS_SBD_IBY_PKG.update_location (
408: p_location_id => l_bank_location_id
409: , p_ADDRESS1 => p_bank_address1
410: , p_ADDRESS2 => p_bank_address2
411: , p_ADDRESS3 => p_bank_address3

Line 428: POS_SBD_IBY_PKG.create_location (

424:
425: if p_country_code is null OR p_bank_address1 is null then
426: l_bank_location_id := null;
427: else
428: POS_SBD_IBY_PKG.create_location (
429: p_ADDRESS1 => p_bank_address1
430: , p_ADDRESS2 => p_bank_address2
431: , p_ADDRESS3 => p_bank_address3
432: , p_ADDRESS4 => p_bank_address4

Line 459: POS_SBD_IBY_PKG.update_location (

455: l_branch_location_id := null;
456:
457: else
458:
459: POS_SBD_IBY_PKG.update_location (
460: p_location_id => l_branch_location_id
461: , p_ADDRESS1 => p_branch_address1
462: , p_ADDRESS2 => p_branch_address2
463: , p_ADDRESS3 => p_branch_address3

Line 483: POS_SBD_IBY_PKG.create_location (

479: l_branch_location_id := null;
480:
481: else
482:
483: POS_SBD_IBY_PKG.create_location (
484: p_ADDRESS1 => p_branch_address1
485: , p_ADDRESS2 => p_branch_address2
486: , p_ADDRESS3 => p_branch_address3
487: , p_ADDRESS4 => p_branch_address4

Line 861: POS_SBD_IBY_PKG.check_for_duplicates (

857: close l_party_id_cur;
858:
859: l_step := 1;
860:
861: POS_SBD_IBY_PKG.check_for_duplicates (
862: p_mapping_id => p_mapping_id
863: , p_BANK_ID => p_bank_id
864: , p_BANK_NAME => p_bank_name
865: , p_BANK_NUMBER => p_bank_number

Line 1191: POS_SBD_IBY_PKG.approve_iby_temp_account (

1187: ' p_temp_ext_bank_account_id ' || p_temp_ext_bank_account_id);
1188: END IF;
1189:
1190: -- Create/Update the account
1191: POS_SBD_IBY_PKG.approve_iby_temp_account (
1192: p_temp_ext_bank_account_id => p_temp_ext_bank_account_id
1193: , x_status => x_status
1194: , x_exception_msg => x_exception_msg
1195: );

Line 1199: POS_SBD_IBY_PKG.assign_site_to_account (

1195: );
1196:
1197: l_step := 1;
1198:
1199: POS_SBD_IBY_PKG.assign_site_to_account (
1200: p_temp_ext_bank_account_id => p_temp_ext_bank_account_id
1201: , p_vendor_site_id => p_vendor_site_id
1202: , x_status => x_status
1203: , x_exception_msg => x_exception_msg

Line 1667: POS_SBD_IBY_PKG.update_req_with_account (

1663: END IF;
1664:
1665: end if;
1666:
1667: POS_SBD_IBY_PKG.update_req_with_account (
1668: p_temp_ext_bank_account_id => p_temp_ext_bank_account_id
1669: , p_ext_bank_account_id => l_ext_bank_account_id
1670: , p_account_request_id => l_account_request_id
1671: , p_bank_id => l_bank_id

Line 1954: END POS_SBD_IBY_PKG;

1950: raise_application_error(-20085, x_exception_msg, true);
1951: END check_for_duplicates;
1952:
1953:
1954: END POS_SBD_IBY_PKG;