APPS.CSC_PROFILE_ENGINE_PKG dependencies on CSC_PROF_PARTY_SQL_CUHK

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

103: table_delete;
104:
105: /*************************************************************************************
106: START OF CUSTOM HOOK ENHANCEMENT
107: CSC_PROF_PARTY_SQL_CUHK will be invoked to get the select statement for fetching party
108: records by the profile engine.
109: *************************************************************************************/
110: l_custom_hook_enabled := 'N';
111: IF p_party_id IS NULL THEN

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

108: records by the profile engine.
109: *************************************************************************************/
110: l_custom_hook_enabled := 'N';
111: IF p_party_id IS NULL THEN
112: IF JTF_USR_HKS.ok_to_execute('CSC_PROF_PARTY_SQL_CUHK','GET_PARTY_SQL_PRE','B','C') THEN
113: l_custom_hook_enabled := 'Y';
114: CSC_PROF_PARTY_SQL_CUHK.Get_Party_Sql_Pre(l_ref_cursor);
115: LOOP
116: FETCH l_ref_cursor INTO l_party_id;

Line 114: CSC_PROF_PARTY_SQL_CUHK.Get_Party_Sql_Pre(l_ref_cursor);

110: l_custom_hook_enabled := 'N';
111: IF p_party_id IS NULL THEN
112: IF JTF_USR_HKS.ok_to_execute('CSC_PROF_PARTY_SQL_CUHK','GET_PARTY_SQL_PRE','B','C') THEN
113: l_custom_hook_enabled := 'Y';
114: CSC_PROF_PARTY_SQL_CUHK.Get_Party_Sql_Pre(l_ref_cursor);
115: LOOP
116: FETCH l_ref_cursor INTO l_party_id;
117: EXIT WHEN l_ref_cursor%NOTFOUND;
118: IF l_party_id is not NULL then