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.16 2011/01/07 08:52:30 puppulur ship $ */
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 862: POS_SBD_IBY_PKG.check_for_duplicates (

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

Line 1209: POS_SBD_IBY_PKG.approve_iby_temp_account (

1205: ' p_temp_ext_bank_account_id ' || p_temp_ext_bank_account_id);
1206: END IF;
1207:
1208: -- Create/Update the account
1209: POS_SBD_IBY_PKG.approve_iby_temp_account (
1210: p_temp_ext_bank_account_id => p_temp_ext_bank_account_id
1211: , x_status => x_status
1212: , x_exception_msg => x_exception_msg
1213: );

Line 1217: POS_SBD_IBY_PKG.assign_site_to_account (

1213: );
1214:
1215: l_step := 1;
1216:
1217: POS_SBD_IBY_PKG.assign_site_to_account (
1218: p_temp_ext_bank_account_id => p_temp_ext_bank_account_id
1219: , p_vendor_site_id => p_vendor_site_id
1220: , x_status => x_status
1221: , x_exception_msg => x_exception_msg

Line 1702: POS_SBD_IBY_PKG.update_req_with_account (

1698: END IF;
1699:
1700: end if;
1701:
1702: POS_SBD_IBY_PKG.update_req_with_account (
1703: p_temp_ext_bank_account_id => p_temp_ext_bank_account_id
1704: , p_ext_bank_account_id => l_ext_bank_account_id
1705: , p_account_request_id => l_account_request_id
1706: , p_bank_id => l_bank_id

Line 1989: END POS_SBD_IBY_PKG;

1985: raise_application_error(-20085, x_exception_msg, true);
1986: END check_for_duplicates;
1987:
1988:
1989: END POS_SBD_IBY_PKG;