DBA Data[Home] [Help]

APPS.HZ_PERSON_CUST_BO_PUB dependencies on DUAL

Line 105: FROM DUAL;

101: IF(l_raise_event) THEN
102: -- Get event_id for person
103: SELECT HZ_BUS_OBJ_TRACKING_S.nextval
104: INTO l_per_event_id
105: FROM DUAL;
106:
107: -- Get event_id for person customer
108: SELECT HZ_BUS_OBJ_TRACKING_S.nextval
109: INTO l_pc_event_id

Line 110: FROM DUAL;

106:
107: -- Get event_id for person customer
108: SELECT HZ_BUS_OBJ_TRACKING_S.nextval
109: INTO l_pc_event_id
110: FROM DUAL;
111: END IF;
112: ELSE
113: l_raise_event := FALSE;
114: END IF;

Line 446: FROM DUAL;

442: IF(l_per_raise_event) THEN
443: -- Get event_id for person
444: SELECT HZ_BUS_OBJ_TRACKING_S.nextval
445: INTO l_per_event_id
446: FROM DUAL;
447: END IF;
448:
449: IF(l_pc_raise_event) THEN
450: -- Get event_id for person customer

Line 453: FROM DUAL;

449: IF(l_pc_raise_event) THEN
450: -- Get event_id for person customer
451: SELECT HZ_BUS_OBJ_TRACKING_S.nextval
452: INTO l_pc_event_id
453: FROM DUAL;
454: END IF;
455:
456: -- acknowledge update_organization_bo not to raise event
457: HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := 'Y';

Line 2088: FROM DUAL;

2084: IF(l_raise_event) THEN
2085: -- Get event_id for person
2086: SELECT HZ_BUS_OBJ_TRACKING_S.nextval
2087: INTO l_per_event_id
2088: FROM DUAL;
2089:
2090: -- Get event_id for person customer
2091: SELECT HZ_BUS_OBJ_TRACKING_S.nextval
2092: INTO l_pc_event_id

Line 2093: FROM DUAL;

2089:
2090: -- Get event_id for person customer
2091: SELECT HZ_BUS_OBJ_TRACKING_S.nextval
2092: INTO l_pc_event_id
2093: FROM DUAL;
2094: END IF;
2095: ELSE
2096: l_raise_event := FALSE;
2097: END IF;

Line 2404: FROM DUAL;

2400: IF(l_per_raise_event) THEN
2401: -- Get event_id for person
2402: SELECT HZ_BUS_OBJ_TRACKING_S.nextval
2403: INTO l_per_event_id
2404: FROM DUAL;
2405: END IF;
2406:
2407: IF(l_pc_raise_event) THEN
2408: -- Get event_id for person customer

Line 2411: FROM DUAL;

2407: IF(l_pc_raise_event) THEN
2408: -- Get event_id for person customer
2409: SELECT HZ_BUS_OBJ_TRACKING_S.nextval
2410: INTO l_pc_event_id
2411: FROM DUAL;
2412: END IF;
2413:
2414: -- acknowledge update_organization_bo not to raise event
2415: HZ_PARTY_BO_PVT.G_CALL_UPDATE_CUST_BO := 'Y';