DBA Data[Home] [Help]

APPS.HZ_ORG_CUST_BO_PUB dependencies on DUAL

Line 105: FROM DUAL;

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
108: SELECT HZ_BUS_OBJ_TRACKING_S.nextval
109: INTO l_oc_event_id

Line 110: 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
113: l_raise_event := FALSE;
114: END IF;

Line 445: FROM DUAL;

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:
448: IF(l_oc_raise_event) THEN
449: -- Get event_id for org customer

Line 452: FROM DUAL;

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:
455: -- acknowledge update_organization_bo not to raise event
456: HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := 'Y';

Line 2066: FROM DUAL;

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
2069: SELECT HZ_BUS_OBJ_TRACKING_S.nextval
2070: INTO l_oc_event_id

Line 2071: 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
2074: l_raise_event := FALSE;
2075: END IF;

Line 2381: FROM DUAL;

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:
2384: IF(l_oc_raise_event) THEN
2385: -- Get event_id for org customer

Line 2388: FROM DUAL;

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:
2391: -- acknowledge update_organization_bo not to raise event
2392: HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := 'Y';