PACKAGE BODY: APPS.CSC_PROF_PARTY_SQL_CUHK

Source

1 PACKAGE BODY CSC_PROF_PARTY_SQL_CUHK AS
2 /* $Header: cscpphkb.pls 120.4 2005/09/02 05:24 mmadhavi noship $ */
3 
4   procedure Get_Party_Sql_Pre( p_ref_cur    OUT NOCOPY csc_utils.Party_Ref_Cur_Type) IS
5 
6   l_sql varchar2(2000);
7   l_filter_condition varchar2(100);
8 
9   BEGIN
10 
11   NULL;
12 
13 /*
14 REM	 Add your business rules here to fetch the party_id and party_type
15 REM      Following is a sample code
16 REM
17 REM	l_sql := 'SELECT party_id FROM hz_parties'
18 REM
19 REM	  OPEN p_ref_cur FOR l_sql;
20 */
21 
22   EXCEPTION
23   WHEN OTHERS THEN
24     NULL;
25 
26   END Get_Party_Sql_Pre;
27 
28 END CSC_PROF_PARTY_SQL_CUHK;