99: p_obj_complete_flag => l_valid_obj );
100:
101: IF(l_raise_event) THEN
102: -- Get event_id for org
103: SELECT HZ_BUS_OBJ_TRACKING_S.nextval
104: INTO l_org_event_id
105: FROM DUAL;
106:
107: -- Get event_id for org customer
104: INTO l_org_event_id
105: FROM DUAL;
106:
107: -- Get event_id for org customer
108: SELECT HZ_BUS_OBJ_TRACKING_S.nextval
109: INTO l_oc_event_id
110: FROM DUAL;
111: END IF;
112: ELSE
439: );
440:
441: IF(l_org_raise_event) THEN
442: -- Get event_id for org
443: SELECT HZ_BUS_OBJ_TRACKING_S.nextval
444: INTO l_org_event_id
445: FROM DUAL;
446: END IF;
447:
446: END IF;
447:
448: IF(l_oc_raise_event) THEN
449: -- Get event_id for org customer
450: SELECT HZ_BUS_OBJ_TRACKING_S.nextval
451: INTO l_oc_event_id
452: FROM DUAL;
453: END IF;
454:
2060: p_obj_complete_flag => l_valid_obj );
2061:
2062: IF(l_raise_event) THEN
2063: -- Get event_id for org
2064: SELECT HZ_BUS_OBJ_TRACKING_S.nextval
2065: INTO l_org_event_id
2066: FROM DUAL;
2067:
2068: -- Get event_id for org customer
2065: INTO l_org_event_id
2066: FROM DUAL;
2067:
2068: -- Get event_id for org customer
2069: SELECT HZ_BUS_OBJ_TRACKING_S.nextval
2070: INTO l_oc_event_id
2071: FROM DUAL;
2072: END IF;
2073: ELSE
2375: );
2376:
2377: IF(l_org_raise_event) THEN
2378: -- Get event_id for org
2379: SELECT HZ_BUS_OBJ_TRACKING_S.nextval
2380: INTO l_org_event_id
2381: FROM DUAL;
2382: END IF;
2383:
2382: END IF;
2383:
2384: IF(l_oc_raise_event) THEN
2385: -- Get event_id for org customer
2386: SELECT HZ_BUS_OBJ_TRACKING_S.nextval
2387: INTO l_oc_event_id
2388: FROM DUAL;
2389: END IF;
2390: