DBA Data[Home] [Help]

APPS.HZ_ORG_CUST_BO_PUB dependencies on HZ_BUS_OBJ_TRACKING_S

Line 103: SELECT HZ_BUS_OBJ_TRACKING_S.nextval

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

Line 108: SELECT HZ_BUS_OBJ_TRACKING_S.nextval

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

Line 443: SELECT HZ_BUS_OBJ_TRACKING_S.nextval

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:

Line 450: SELECT HZ_BUS_OBJ_TRACKING_S.nextval

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:

Line 2064: SELECT HZ_BUS_OBJ_TRACKING_S.nextval

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

Line 2069: SELECT HZ_BUS_OBJ_TRACKING_S.nextval

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

Line 2379: SELECT HZ_BUS_OBJ_TRACKING_S.nextval

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:

Line 2386: SELECT HZ_BUS_OBJ_TRACKING_S.nextval

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: