DBA Data[Home] [Help]

APPS.PA_PJI_PROJ_EVENTS_LOG_PKG dependencies on PA_PJI_PROJ_EVENTS_LOG

Line 1: PACKAGE BODY PA_PJI_PROJ_EVENTS_LOG_PKG AS

1: PACKAGE BODY PA_PJI_PROJ_EVENTS_LOG_PKG AS
2: /* $Header: PAPJITHB.pls 120.1 2005/08/19 16:40:56 mwasowic noship $ */
3:
4: PROCEDURE Insert_Row(
5: X_ROW_ID OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895

Line 35: SELECT pa_pji_proj_events_log_s.nextval

31: X_ATTRIBUTE20 IN VARCHAR2
32: ) IS
33: CURSOR cur_PJI_PROJ_EVENTS_seq
34: IS
35: SELECT pa_pji_proj_events_log_s.nextval
36: FROM sys.dual;
37:
38: BEGIN
39: -- If product PJI installed, insert

Line 46: INSERT INTO pa_pji_proj_events_log(

42: OPEN cur_PJI_PROJ_EVENTS_seq;
43: FETCH cur_PJI_PROJ_EVENTS_seq INTO X_EVENT_ID;
44: CLOSE cur_PJI_PROJ_EVENTS_seq;
45:
46: INSERT INTO pa_pji_proj_events_log(
47: EVENT_TYPE
48: ,EVENT_ID
49: ,EVENT_OBJECT
50: ,OPERATION_TYPE

Line 114: END PA_PJI_PROJ_EVENTS_LOG_PKG;

110: END IF;
111: END Insert_Row;
112:
113:
114: END PA_PJI_PROJ_EVENTS_LOG_PKG;