PACKAGE: APPS.IBY_MERGE

Source

1 PACKAGE IBY_MERGE AUTHID CURRENT_USER AS
2 /*$Header: IBYMERGS.pls 120.2 2010/07/29 07:18:17 sgogula noship $ */
3 
4 PROCEDURE  MERGE
5 ( req_id                       NUMBER,
6   set_num                      NUMBER,
7   process_mode                 VARCHAR2
8 );
9 
10 CURSOR CUR_GET_EXT_PAYER_ID
11 	(account_id iby_external_payers_all.cust_account_id%TYPE,
12 	 account_site_use_id iby_external_payers_all.acct_site_use_id%TYPE ) IS
13 	 SELECT ext_payer_id
14 	 FROM iby_external_payers_all
15 	 WHERE cust_account_id = account_id
16 	 AND  NVL(acct_site_use_id,0) = NVL(account_site_use_id,0);
17 
18   TYPE ext_payer_id_list_type IS TABLE OF
19          iby_external_payers_all.ext_payer_id%TYPE
20         INDEX BY BINARY_INTEGER;
21 
22 END IBY_MERGE;