191: l_ret_val := 0;
192: -- Select Classification type
193: SELECT nvl(bis_common_parameters.GET_BIS_CUST_CLASS_TYPE, -1)
194: INTO g_class_type
195: FROM DUAL;
196:
197: -- Check if the classification type is non_hierarchical.
198: g_phase := 'Check if the classification type is non_hierarchical';
199:
279: g_user_id, --CREATED_BY,
280: sysdate, --LAST_UPDATE_DATE,
281: g_user_id, --LAST_UPDATED_BY,
282: g_login_id --LAST_UPDATE_LOGIN
283: FROM DUAL
284: WHERE NOT EXISTS
285: (select 1 from fii_change_log
286: where log_item = 'IND_MAX_BATCH_PARTY_ID'));
287:
450: g_user_id, --CREATED_BY,
451: sysdate, --LAST_UPDATE_DATE,
452: g_user_id, --LAST_UPDATED_BY,
453: g_login_id --LAST_UPDATE_LOGIN
454: FROM DUAL
455: WHERE NOT EXISTS
456: (select 1 from fii_change_log
457: where log_item = 'IND_MAX_BATCH_PARTY_ID'));
458: