DBA Data[Home] [Help]

APPS.CSC_PROFILE_ENGINE_PKG dependencies on CSC_PROF_PARTY_SQL_CUHK

Line 100: CSC_PROF_PARTY_SQL_CUHK will be invoked to get the select statement for fetching party

96: table_delete;
97:
98: /*************************************************************************************
99: START OF CUSTOM HOOK ENHANCEMENT
100: CSC_PROF_PARTY_SQL_CUHK will be invoked to get the select statement for fetching party
101: records by the profile engine.
102: *************************************************************************************/
103: l_custom_hook_enabled := 'N';
104:

Line 107: IF JTF_USR_HKS.ok_to_execute('CSC_PROF_PARTY_SQL_CUHK','GET_PARTY_SQL_PRE','B','C') THEN

103: l_custom_hook_enabled := 'N';
104:
105:
106: IF p_party_id IS NULL THEN
107: IF JTF_USR_HKS.ok_to_execute('CSC_PROF_PARTY_SQL_CUHK','GET_PARTY_SQL_PRE','B','C') THEN
108:
109: l_custom_hook_enabled := 'Y';
110:
111:

Line 112: CSC_PROF_PARTY_SQL_CUHK.Get_Party_Sql_Pre(l_ref_cursor);

108:
109: l_custom_hook_enabled := 'Y';
110:
111:
112: CSC_PROF_PARTY_SQL_CUHK.Get_Party_Sql_Pre(l_ref_cursor);
113: LOOP
114: FETCH l_ref_cursor INTO l_party_id;
115: EXIT WHEN l_ref_cursor%NOTFOUND;
116: IF l_party_id is not NULL then