eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HZ_EMPLOYMENT_HISTORY_PKG dependencies on FND_API

Line 80: decode( x_EMPLOYMENT_HISTORY_ID, FND_API.G_MISS_NUM, HZ_EMPLOYMENT_HISTORY_S.NEXTVAL, NULL, HZ_EMPLOYMENT_HISTORY_S.NEXTVAL, x_EMPLOYMENT_HISTORY_ID ),

76: EMPLOYED_AS_TITLE_CODE,
77: WEEKLY_WORK_HOURS,
78: COMMENTS
79: ) VALUES (
80: decode( x_EMPLOYMENT_HISTORY_ID, FND_API.G_MISS_NUM, HZ_EMPLOYMENT_HISTORY_S.NEXTVAL, NULL, HZ_EMPLOYMENT_HISTORY_S.NEXTVAL, x_EMPLOYMENT_HISTORY_ID ),
81: decode( x_BEGIN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_BEGIN_DATE),
82: decode( x_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_PARTY_ID),
83: decode( x_EMPLOYED_AS_TITLE, FND_API.G_MISS_CHAR, NULL,x_EMPLOYED_AS_TITLE),
84: decode( x_EMPLOYED_BY_DIVISION_NAME, FND_API.G_MISS_CHAR, NULL,x_EMPLOYED_BY_DIVISION_NAME),

Line 81: decode( x_BEGIN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_BEGIN_DATE),

77: WEEKLY_WORK_HOURS,
78: COMMENTS
79: ) VALUES (
80: decode( x_EMPLOYMENT_HISTORY_ID, FND_API.G_MISS_NUM, HZ_EMPLOYMENT_HISTORY_S.NEXTVAL, NULL, HZ_EMPLOYMENT_HISTORY_S.NEXTVAL, x_EMPLOYMENT_HISTORY_ID ),
81: decode( x_BEGIN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_BEGIN_DATE),
82: decode( x_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_PARTY_ID),
83: decode( x_EMPLOYED_AS_TITLE, FND_API.G_MISS_CHAR, NULL,x_EMPLOYED_AS_TITLE),
84: decode( x_EMPLOYED_BY_DIVISION_NAME, FND_API.G_MISS_CHAR, NULL,x_EMPLOYED_BY_DIVISION_NAME),
85: decode( x_EMPLOYED_BY_NAME_COMPANY, FND_API.G_MISS_CHAR, NULL,x_EMPLOYED_BY_NAME_COMPANY),

Line 82: decode( x_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_PARTY_ID),

78: COMMENTS
79: ) VALUES (
80: decode( x_EMPLOYMENT_HISTORY_ID, FND_API.G_MISS_NUM, HZ_EMPLOYMENT_HISTORY_S.NEXTVAL, NULL, HZ_EMPLOYMENT_HISTORY_S.NEXTVAL, x_EMPLOYMENT_HISTORY_ID ),
81: decode( x_BEGIN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_BEGIN_DATE),
82: decode( x_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_PARTY_ID),
83: decode( x_EMPLOYED_AS_TITLE, FND_API.G_MISS_CHAR, NULL,x_EMPLOYED_AS_TITLE),
84: decode( x_EMPLOYED_BY_DIVISION_NAME, FND_API.G_MISS_CHAR, NULL,x_EMPLOYED_BY_DIVISION_NAME),
85: decode( x_EMPLOYED_BY_NAME_COMPANY, FND_API.G_MISS_CHAR, NULL,x_EMPLOYED_BY_NAME_COMPANY),
86: decode( x_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_END_DATE),

Line 83: decode( x_EMPLOYED_AS_TITLE, FND_API.G_MISS_CHAR, NULL,x_EMPLOYED_AS_TITLE),

79: ) VALUES (
80: decode( x_EMPLOYMENT_HISTORY_ID, FND_API.G_MISS_NUM, HZ_EMPLOYMENT_HISTORY_S.NEXTVAL, NULL, HZ_EMPLOYMENT_HISTORY_S.NEXTVAL, x_EMPLOYMENT_HISTORY_ID ),
81: decode( x_BEGIN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_BEGIN_DATE),
82: decode( x_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_PARTY_ID),
83: decode( x_EMPLOYED_AS_TITLE, FND_API.G_MISS_CHAR, NULL,x_EMPLOYED_AS_TITLE),
84: decode( x_EMPLOYED_BY_DIVISION_NAME, FND_API.G_MISS_CHAR, NULL,x_EMPLOYED_BY_DIVISION_NAME),
85: decode( x_EMPLOYED_BY_NAME_COMPANY, FND_API.G_MISS_CHAR, NULL,x_EMPLOYED_BY_NAME_COMPANY),
86: decode( x_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_END_DATE),
87: decode( x_SUPERVISOR_NAME, FND_API.G_MISS_CHAR, NULL,x_SUPERVISOR_NAME),

Line 84: decode( x_EMPLOYED_BY_DIVISION_NAME, FND_API.G_MISS_CHAR, NULL,x_EMPLOYED_BY_DIVISION_NAME),

80: decode( x_EMPLOYMENT_HISTORY_ID, FND_API.G_MISS_NUM, HZ_EMPLOYMENT_HISTORY_S.NEXTVAL, NULL, HZ_EMPLOYMENT_HISTORY_S.NEXTVAL, x_EMPLOYMENT_HISTORY_ID ),
81: decode( x_BEGIN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_BEGIN_DATE),
82: decode( x_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_PARTY_ID),
83: decode( x_EMPLOYED_AS_TITLE, FND_API.G_MISS_CHAR, NULL,x_EMPLOYED_AS_TITLE),
84: decode( x_EMPLOYED_BY_DIVISION_NAME, FND_API.G_MISS_CHAR, NULL,x_EMPLOYED_BY_DIVISION_NAME),
85: decode( x_EMPLOYED_BY_NAME_COMPANY, FND_API.G_MISS_CHAR, NULL,x_EMPLOYED_BY_NAME_COMPANY),
86: decode( x_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_END_DATE),
87: decode( x_SUPERVISOR_NAME, FND_API.G_MISS_CHAR, NULL,x_SUPERVISOR_NAME),
88: decode( x_BRANCH, FND_API.G_MISS_CHAR, NULL,x_BRANCH),

Line 85: decode( x_EMPLOYED_BY_NAME_COMPANY, FND_API.G_MISS_CHAR, NULL,x_EMPLOYED_BY_NAME_COMPANY),

81: decode( x_BEGIN_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_BEGIN_DATE),
82: decode( x_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_PARTY_ID),
83: decode( x_EMPLOYED_AS_TITLE, FND_API.G_MISS_CHAR, NULL,x_EMPLOYED_AS_TITLE),
84: decode( x_EMPLOYED_BY_DIVISION_NAME, FND_API.G_MISS_CHAR, NULL,x_EMPLOYED_BY_DIVISION_NAME),
85: decode( x_EMPLOYED_BY_NAME_COMPANY, FND_API.G_MISS_CHAR, NULL,x_EMPLOYED_BY_NAME_COMPANY),
86: decode( x_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_END_DATE),
87: decode( x_SUPERVISOR_NAME, FND_API.G_MISS_CHAR, NULL,x_SUPERVISOR_NAME),
88: decode( x_BRANCH, FND_API.G_MISS_CHAR, NULL,x_BRANCH),
89: decode( x_MILITARY_RANK, FND_API.G_MISS_CHAR, NULL,x_MILITARY_RANK),

Line 86: decode( x_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_END_DATE),

82: decode( x_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_PARTY_ID),
83: decode( x_EMPLOYED_AS_TITLE, FND_API.G_MISS_CHAR, NULL,x_EMPLOYED_AS_TITLE),
84: decode( x_EMPLOYED_BY_DIVISION_NAME, FND_API.G_MISS_CHAR, NULL,x_EMPLOYED_BY_DIVISION_NAME),
85: decode( x_EMPLOYED_BY_NAME_COMPANY, FND_API.G_MISS_CHAR, NULL,x_EMPLOYED_BY_NAME_COMPANY),
86: decode( x_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_END_DATE),
87: decode( x_SUPERVISOR_NAME, FND_API.G_MISS_CHAR, NULL,x_SUPERVISOR_NAME),
88: decode( x_BRANCH, FND_API.G_MISS_CHAR, NULL,x_BRANCH),
89: decode( x_MILITARY_RANK, FND_API.G_MISS_CHAR, NULL,x_MILITARY_RANK),
90: HZ_UTILITY_V2PUB.CREATED_BY,

Line 87: decode( x_SUPERVISOR_NAME, FND_API.G_MISS_CHAR, NULL,x_SUPERVISOR_NAME),

83: decode( x_EMPLOYED_AS_TITLE, FND_API.G_MISS_CHAR, NULL,x_EMPLOYED_AS_TITLE),
84: decode( x_EMPLOYED_BY_DIVISION_NAME, FND_API.G_MISS_CHAR, NULL,x_EMPLOYED_BY_DIVISION_NAME),
85: decode( x_EMPLOYED_BY_NAME_COMPANY, FND_API.G_MISS_CHAR, NULL,x_EMPLOYED_BY_NAME_COMPANY),
86: decode( x_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_END_DATE),
87: decode( x_SUPERVISOR_NAME, FND_API.G_MISS_CHAR, NULL,x_SUPERVISOR_NAME),
88: decode( x_BRANCH, FND_API.G_MISS_CHAR, NULL,x_BRANCH),
89: decode( x_MILITARY_RANK, FND_API.G_MISS_CHAR, NULL,x_MILITARY_RANK),
90: HZ_UTILITY_V2PUB.CREATED_BY,
91: HZ_UTILITY_V2PUB.CREATION_DATE,

Line 88: decode( x_BRANCH, FND_API.G_MISS_CHAR, NULL,x_BRANCH),

84: decode( x_EMPLOYED_BY_DIVISION_NAME, FND_API.G_MISS_CHAR, NULL,x_EMPLOYED_BY_DIVISION_NAME),
85: decode( x_EMPLOYED_BY_NAME_COMPANY, FND_API.G_MISS_CHAR, NULL,x_EMPLOYED_BY_NAME_COMPANY),
86: decode( x_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_END_DATE),
87: decode( x_SUPERVISOR_NAME, FND_API.G_MISS_CHAR, NULL,x_SUPERVISOR_NAME),
88: decode( x_BRANCH, FND_API.G_MISS_CHAR, NULL,x_BRANCH),
89: decode( x_MILITARY_RANK, FND_API.G_MISS_CHAR, NULL,x_MILITARY_RANK),
90: HZ_UTILITY_V2PUB.CREATED_BY,
91: HZ_UTILITY_V2PUB.CREATION_DATE,
92: decode( x_SERVED, FND_API.G_MISS_CHAR, NULL,x_SERVED),

Line 89: decode( x_MILITARY_RANK, FND_API.G_MISS_CHAR, NULL,x_MILITARY_RANK),

85: decode( x_EMPLOYED_BY_NAME_COMPANY, FND_API.G_MISS_CHAR, NULL,x_EMPLOYED_BY_NAME_COMPANY),
86: decode( x_END_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL),x_END_DATE),
87: decode( x_SUPERVISOR_NAME, FND_API.G_MISS_CHAR, NULL,x_SUPERVISOR_NAME),
88: decode( x_BRANCH, FND_API.G_MISS_CHAR, NULL,x_BRANCH),
89: decode( x_MILITARY_RANK, FND_API.G_MISS_CHAR, NULL,x_MILITARY_RANK),
90: HZ_UTILITY_V2PUB.CREATED_BY,
91: HZ_UTILITY_V2PUB.CREATION_DATE,
92: decode( x_SERVED, FND_API.G_MISS_CHAR, NULL,x_SERVED),
93: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

Line 92: decode( x_SERVED, FND_API.G_MISS_CHAR, NULL,x_SERVED),

88: decode( x_BRANCH, FND_API.G_MISS_CHAR, NULL,x_BRANCH),
89: decode( x_MILITARY_RANK, FND_API.G_MISS_CHAR, NULL,x_MILITARY_RANK),
90: HZ_UTILITY_V2PUB.CREATED_BY,
91: HZ_UTILITY_V2PUB.CREATION_DATE,
92: decode( x_SERVED, FND_API.G_MISS_CHAR, NULL,x_SERVED),
93: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
94: decode( x_STATION, FND_API.G_MISS_CHAR, NULL,x_STATION),
95: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
96: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

Line 94: decode( x_STATION, FND_API.G_MISS_CHAR, NULL,x_STATION),

90: HZ_UTILITY_V2PUB.CREATED_BY,
91: HZ_UTILITY_V2PUB.CREATION_DATE,
92: decode( x_SERVED, FND_API.G_MISS_CHAR, NULL,x_SERVED),
93: HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,
94: decode( x_STATION, FND_API.G_MISS_CHAR, NULL,x_STATION),
95: HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
96: HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
97: HZ_UTILITY_V2PUB.REQUEST_ID,
98: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,

Line 101: decode( x_RESPONSIBILITY, FND_API.G_MISS_CHAR, NULL, x_RESPONSIBILITY),

97: HZ_UTILITY_V2PUB.REQUEST_ID,
98: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
99: HZ_UTILITY_V2PUB.PROGRAM_ID,
100: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
101: decode( x_RESPONSIBILITY, FND_API.G_MISS_CHAR, NULL, x_RESPONSIBILITY),
102: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
103: DECODE( x_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, x_OBJECT_VERSION_NUMBER ),
104: DECODE( x_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, x_CREATED_BY_MODULE ),
105: HZ_UTILITY_V2PUB.APPLICATION_ID,

Line 102: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),

98: HZ_UTILITY_V2PUB.PROGRAM_APPLICATION_ID,
99: HZ_UTILITY_V2PUB.PROGRAM_ID,
100: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
101: decode( x_RESPONSIBILITY, FND_API.G_MISS_CHAR, NULL, x_RESPONSIBILITY),
102: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
103: DECODE( x_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, x_OBJECT_VERSION_NUMBER ),
104: DECODE( x_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, x_CREATED_BY_MODULE ),
105: HZ_UTILITY_V2PUB.APPLICATION_ID,
106: decode( x_EMPLOYED_BY_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_EMPLOYED_BY_PARTY_ID),

Line 103: DECODE( x_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, x_OBJECT_VERSION_NUMBER ),

99: HZ_UTILITY_V2PUB.PROGRAM_ID,
100: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
101: decode( x_RESPONSIBILITY, FND_API.G_MISS_CHAR, NULL, x_RESPONSIBILITY),
102: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
103: DECODE( x_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, x_OBJECT_VERSION_NUMBER ),
104: DECODE( x_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, x_CREATED_BY_MODULE ),
105: HZ_UTILITY_V2PUB.APPLICATION_ID,
106: decode( x_EMPLOYED_BY_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_EMPLOYED_BY_PARTY_ID),
107: decode( x_REASON_FOR_LEAVING, FND_API.G_MISS_CHAR, NULL, x_REASON_FOR_LEAVING ),

Line 104: DECODE( x_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, x_CREATED_BY_MODULE ),

100: HZ_UTILITY_V2PUB.PROGRAM_UPDATE_DATE,
101: decode( x_RESPONSIBILITY, FND_API.G_MISS_CHAR, NULL, x_RESPONSIBILITY),
102: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
103: DECODE( x_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, x_OBJECT_VERSION_NUMBER ),
104: DECODE( x_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, x_CREATED_BY_MODULE ),
105: HZ_UTILITY_V2PUB.APPLICATION_ID,
106: decode( x_EMPLOYED_BY_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_EMPLOYED_BY_PARTY_ID),
107: decode( x_REASON_FOR_LEAVING, FND_API.G_MISS_CHAR, NULL, x_REASON_FOR_LEAVING ),
108: decode( x_FACULTY_POSITION_FLAG, FND_API.G_MISS_CHAR, NULL, x_FACULTY_POSITION_FLAG ),

Line 106: decode( x_EMPLOYED_BY_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_EMPLOYED_BY_PARTY_ID),

102: DECODE( X_STATUS, FND_API.G_MISS_CHAR, 'A', NULL, 'A', X_STATUS ),
103: DECODE( x_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, x_OBJECT_VERSION_NUMBER ),
104: DECODE( x_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, x_CREATED_BY_MODULE ),
105: HZ_UTILITY_V2PUB.APPLICATION_ID,
106: decode( x_EMPLOYED_BY_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_EMPLOYED_BY_PARTY_ID),
107: decode( x_REASON_FOR_LEAVING, FND_API.G_MISS_CHAR, NULL, x_REASON_FOR_LEAVING ),
108: decode( x_FACULTY_POSITION_FLAG, FND_API.G_MISS_CHAR, NULL, x_FACULTY_POSITION_FLAG ),
109: decode( x_TENURE_CODE, FND_API.G_MISS_CHAR, NULL, X_TENURE_CODE ),
110: decode( x_FRACTION_OF_TENURE, FND_API.G_MISS_NUM, NULL,x_FRACTION_OF_TENURE),

Line 107: decode( x_REASON_FOR_LEAVING, FND_API.G_MISS_CHAR, NULL, x_REASON_FOR_LEAVING ),

103: DECODE( x_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, x_OBJECT_VERSION_NUMBER ),
104: DECODE( x_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, x_CREATED_BY_MODULE ),
105: HZ_UTILITY_V2PUB.APPLICATION_ID,
106: decode( x_EMPLOYED_BY_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_EMPLOYED_BY_PARTY_ID),
107: decode( x_REASON_FOR_LEAVING, FND_API.G_MISS_CHAR, NULL, x_REASON_FOR_LEAVING ),
108: decode( x_FACULTY_POSITION_FLAG, FND_API.G_MISS_CHAR, NULL, x_FACULTY_POSITION_FLAG ),
109: decode( x_TENURE_CODE, FND_API.G_MISS_CHAR, NULL, X_TENURE_CODE ),
110: decode( x_FRACTION_OF_TENURE, FND_API.G_MISS_NUM, NULL,x_FRACTION_OF_TENURE),
111: decode( x_EMPLOYMENT_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, x_EMPLOYMENT_TYPE_CODE ),

Line 108: decode( x_FACULTY_POSITION_FLAG, FND_API.G_MISS_CHAR, NULL, x_FACULTY_POSITION_FLAG ),

104: DECODE( x_CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, x_CREATED_BY_MODULE ),
105: HZ_UTILITY_V2PUB.APPLICATION_ID,
106: decode( x_EMPLOYED_BY_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_EMPLOYED_BY_PARTY_ID),
107: decode( x_REASON_FOR_LEAVING, FND_API.G_MISS_CHAR, NULL, x_REASON_FOR_LEAVING ),
108: decode( x_FACULTY_POSITION_FLAG, FND_API.G_MISS_CHAR, NULL, x_FACULTY_POSITION_FLAG ),
109: decode( x_TENURE_CODE, FND_API.G_MISS_CHAR, NULL, X_TENURE_CODE ),
110: decode( x_FRACTION_OF_TENURE, FND_API.G_MISS_NUM, NULL,x_FRACTION_OF_TENURE),
111: decode( x_EMPLOYMENT_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, x_EMPLOYMENT_TYPE_CODE ),
112: decode( x_EMPLOYED_AS_TITLE_CODE, FND_API.G_MISS_CHAR, NULL, x_EMPLOYED_AS_TITLE_CODE ),

Line 109: decode( x_TENURE_CODE, FND_API.G_MISS_CHAR, NULL, X_TENURE_CODE ),

105: HZ_UTILITY_V2PUB.APPLICATION_ID,
106: decode( x_EMPLOYED_BY_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_EMPLOYED_BY_PARTY_ID),
107: decode( x_REASON_FOR_LEAVING, FND_API.G_MISS_CHAR, NULL, x_REASON_FOR_LEAVING ),
108: decode( x_FACULTY_POSITION_FLAG, FND_API.G_MISS_CHAR, NULL, x_FACULTY_POSITION_FLAG ),
109: decode( x_TENURE_CODE, FND_API.G_MISS_CHAR, NULL, X_TENURE_CODE ),
110: decode( x_FRACTION_OF_TENURE, FND_API.G_MISS_NUM, NULL,x_FRACTION_OF_TENURE),
111: decode( x_EMPLOYMENT_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, x_EMPLOYMENT_TYPE_CODE ),
112: decode( x_EMPLOYED_AS_TITLE_CODE, FND_API.G_MISS_CHAR, NULL, x_EMPLOYED_AS_TITLE_CODE ),
113: decode( x_WEEKLY_WORK_HOURS, FND_API.G_MISS_NUM, NULL,x_WEEKLY_WORK_HOURS),

Line 110: decode( x_FRACTION_OF_TENURE, FND_API.G_MISS_NUM, NULL,x_FRACTION_OF_TENURE),

106: decode( x_EMPLOYED_BY_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_EMPLOYED_BY_PARTY_ID),
107: decode( x_REASON_FOR_LEAVING, FND_API.G_MISS_CHAR, NULL, x_REASON_FOR_LEAVING ),
108: decode( x_FACULTY_POSITION_FLAG, FND_API.G_MISS_CHAR, NULL, x_FACULTY_POSITION_FLAG ),
109: decode( x_TENURE_CODE, FND_API.G_MISS_CHAR, NULL, X_TENURE_CODE ),
110: decode( x_FRACTION_OF_TENURE, FND_API.G_MISS_NUM, NULL,x_FRACTION_OF_TENURE),
111: decode( x_EMPLOYMENT_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, x_EMPLOYMENT_TYPE_CODE ),
112: decode( x_EMPLOYED_AS_TITLE_CODE, FND_API.G_MISS_CHAR, NULL, x_EMPLOYED_AS_TITLE_CODE ),
113: decode( x_WEEKLY_WORK_HOURS, FND_API.G_MISS_NUM, NULL,x_WEEKLY_WORK_HOURS),
114: decode( x_COMMENTS, FND_API.G_MISS_CHAR, NULL, x_COMMENTS )

Line 111: decode( x_EMPLOYMENT_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, x_EMPLOYMENT_TYPE_CODE ),

107: decode( x_REASON_FOR_LEAVING, FND_API.G_MISS_CHAR, NULL, x_REASON_FOR_LEAVING ),
108: decode( x_FACULTY_POSITION_FLAG, FND_API.G_MISS_CHAR, NULL, x_FACULTY_POSITION_FLAG ),
109: decode( x_TENURE_CODE, FND_API.G_MISS_CHAR, NULL, X_TENURE_CODE ),
110: decode( x_FRACTION_OF_TENURE, FND_API.G_MISS_NUM, NULL,x_FRACTION_OF_TENURE),
111: decode( x_EMPLOYMENT_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, x_EMPLOYMENT_TYPE_CODE ),
112: decode( x_EMPLOYED_AS_TITLE_CODE, FND_API.G_MISS_CHAR, NULL, x_EMPLOYED_AS_TITLE_CODE ),
113: decode( x_WEEKLY_WORK_HOURS, FND_API.G_MISS_NUM, NULL,x_WEEKLY_WORK_HOURS),
114: decode( x_COMMENTS, FND_API.G_MISS_CHAR, NULL, x_COMMENTS )
115: )

Line 112: decode( x_EMPLOYED_AS_TITLE_CODE, FND_API.G_MISS_CHAR, NULL, x_EMPLOYED_AS_TITLE_CODE ),

108: decode( x_FACULTY_POSITION_FLAG, FND_API.G_MISS_CHAR, NULL, x_FACULTY_POSITION_FLAG ),
109: decode( x_TENURE_CODE, FND_API.G_MISS_CHAR, NULL, X_TENURE_CODE ),
110: decode( x_FRACTION_OF_TENURE, FND_API.G_MISS_NUM, NULL,x_FRACTION_OF_TENURE),
111: decode( x_EMPLOYMENT_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, x_EMPLOYMENT_TYPE_CODE ),
112: decode( x_EMPLOYED_AS_TITLE_CODE, FND_API.G_MISS_CHAR, NULL, x_EMPLOYED_AS_TITLE_CODE ),
113: decode( x_WEEKLY_WORK_HOURS, FND_API.G_MISS_NUM, NULL,x_WEEKLY_WORK_HOURS),
114: decode( x_COMMENTS, FND_API.G_MISS_CHAR, NULL, x_COMMENTS )
115: )
116:

Line 113: decode( x_WEEKLY_WORK_HOURS, FND_API.G_MISS_NUM, NULL,x_WEEKLY_WORK_HOURS),

109: decode( x_TENURE_CODE, FND_API.G_MISS_CHAR, NULL, X_TENURE_CODE ),
110: decode( x_FRACTION_OF_TENURE, FND_API.G_MISS_NUM, NULL,x_FRACTION_OF_TENURE),
111: decode( x_EMPLOYMENT_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, x_EMPLOYMENT_TYPE_CODE ),
112: decode( x_EMPLOYED_AS_TITLE_CODE, FND_API.G_MISS_CHAR, NULL, x_EMPLOYED_AS_TITLE_CODE ),
113: decode( x_WEEKLY_WORK_HOURS, FND_API.G_MISS_NUM, NULL,x_WEEKLY_WORK_HOURS),
114: decode( x_COMMENTS, FND_API.G_MISS_CHAR, NULL, x_COMMENTS )
115: )
116:
117: RETURNING

Line 114: decode( x_COMMENTS, FND_API.G_MISS_CHAR, NULL, x_COMMENTS )

110: decode( x_FRACTION_OF_TENURE, FND_API.G_MISS_NUM, NULL,x_FRACTION_OF_TENURE),
111: decode( x_EMPLOYMENT_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, x_EMPLOYMENT_TYPE_CODE ),
112: decode( x_EMPLOYED_AS_TITLE_CODE, FND_API.G_MISS_CHAR, NULL, x_EMPLOYED_AS_TITLE_CODE ),
113: decode( x_WEEKLY_WORK_HOURS, FND_API.G_MISS_NUM, NULL,x_WEEKLY_WORK_HOURS),
114: decode( x_COMMENTS, FND_API.G_MISS_CHAR, NULL, x_COMMENTS )
115: )
116:
117: RETURNING
118: EMPLOYMENT_HISTORY_ID

Line 204: EMPLOYMENT_HISTORY_ID = decode( x_EMPLOYMENT_HISTORY_ID, NULL, EMPLOYMENT_HISTORY_ID, FND_API.G_MISS_NUM,NULL, X_EMPLOYMENT_HISTORY_ID,x_EMPLOYMENT_HISTORY_ID),

200: ) IS
201: BEGIN
202: Update HZ_EMPLOYMENT_HISTORY
203: SET
204: EMPLOYMENT_HISTORY_ID = decode( x_EMPLOYMENT_HISTORY_ID, NULL, EMPLOYMENT_HISTORY_ID, FND_API.G_MISS_NUM,NULL, X_EMPLOYMENT_HISTORY_ID,x_EMPLOYMENT_HISTORY_ID),
205: BEGIN_DATE = decode( x_BEGIN_DATE, NULL,BEGIN_DATE,FND_API.G_MISS_DATE,NULL,x_BEGIN_DATE),
206: PARTY_ID = decode( x_PARTY_ID, NULL,PARTY_ID,FND_API.G_MISS_NUM,NULL,x_PARTY_ID),
207: EMPLOYED_AS_TITLE = decode( x_EMPLOYED_AS_TITLE, NULL,EMPLOYED_AS_TITLE, FND_API.G_MISS_CHAR,NULL,x_EMPLOYED_AS_TITLE),
208: EMPLOYED_BY_DIVISION_NAME = decode( x_EMPLOYED_BY_DIVISION_NAME, NULL,EMPLOYED_BY_DIVISION_NAME, FND_API.G_MISS_CHAR,NULL,x_EMPLOYED_BY_DIVISION_NAME),

Line 205: BEGIN_DATE = decode( x_BEGIN_DATE, NULL,BEGIN_DATE,FND_API.G_MISS_DATE,NULL,x_BEGIN_DATE),

201: BEGIN
202: Update HZ_EMPLOYMENT_HISTORY
203: SET
204: EMPLOYMENT_HISTORY_ID = decode( x_EMPLOYMENT_HISTORY_ID, NULL, EMPLOYMENT_HISTORY_ID, FND_API.G_MISS_NUM,NULL, X_EMPLOYMENT_HISTORY_ID,x_EMPLOYMENT_HISTORY_ID),
205: BEGIN_DATE = decode( x_BEGIN_DATE, NULL,BEGIN_DATE,FND_API.G_MISS_DATE,NULL,x_BEGIN_DATE),
206: PARTY_ID = decode( x_PARTY_ID, NULL,PARTY_ID,FND_API.G_MISS_NUM,NULL,x_PARTY_ID),
207: EMPLOYED_AS_TITLE = decode( x_EMPLOYED_AS_TITLE, NULL,EMPLOYED_AS_TITLE, FND_API.G_MISS_CHAR,NULL,x_EMPLOYED_AS_TITLE),
208: EMPLOYED_BY_DIVISION_NAME = decode( x_EMPLOYED_BY_DIVISION_NAME, NULL,EMPLOYED_BY_DIVISION_NAME, FND_API.G_MISS_CHAR,NULL,x_EMPLOYED_BY_DIVISION_NAME),
209: EMPLOYED_BY_NAME_COMPANY = decode( x_EMPLOYED_BY_NAME_COMPANY, NULL,EMPLOYED_BY_NAME_COMPANY,FND_API.G_MISS_CHAR,NULL,x_EMPLOYED_BY_NAME_COMPANY),

Line 206: PARTY_ID = decode( x_PARTY_ID, NULL,PARTY_ID,FND_API.G_MISS_NUM,NULL,x_PARTY_ID),

202: Update HZ_EMPLOYMENT_HISTORY
203: SET
204: EMPLOYMENT_HISTORY_ID = decode( x_EMPLOYMENT_HISTORY_ID, NULL, EMPLOYMENT_HISTORY_ID, FND_API.G_MISS_NUM,NULL, X_EMPLOYMENT_HISTORY_ID,x_EMPLOYMENT_HISTORY_ID),
205: BEGIN_DATE = decode( x_BEGIN_DATE, NULL,BEGIN_DATE,FND_API.G_MISS_DATE,NULL,x_BEGIN_DATE),
206: PARTY_ID = decode( x_PARTY_ID, NULL,PARTY_ID,FND_API.G_MISS_NUM,NULL,x_PARTY_ID),
207: EMPLOYED_AS_TITLE = decode( x_EMPLOYED_AS_TITLE, NULL,EMPLOYED_AS_TITLE, FND_API.G_MISS_CHAR,NULL,x_EMPLOYED_AS_TITLE),
208: EMPLOYED_BY_DIVISION_NAME = decode( x_EMPLOYED_BY_DIVISION_NAME, NULL,EMPLOYED_BY_DIVISION_NAME, FND_API.G_MISS_CHAR,NULL,x_EMPLOYED_BY_DIVISION_NAME),
209: EMPLOYED_BY_NAME_COMPANY = decode( x_EMPLOYED_BY_NAME_COMPANY, NULL,EMPLOYED_BY_NAME_COMPANY,FND_API.G_MISS_CHAR,NULL,x_EMPLOYED_BY_NAME_COMPANY),
210: END_DATE = decode( x_END_DATE, NULL,END_DATE,FND_API.G_MISS_DATE,NULL,x_END_DATE),

Line 207: EMPLOYED_AS_TITLE = decode( x_EMPLOYED_AS_TITLE, NULL,EMPLOYED_AS_TITLE, FND_API.G_MISS_CHAR,NULL,x_EMPLOYED_AS_TITLE),

203: SET
204: EMPLOYMENT_HISTORY_ID = decode( x_EMPLOYMENT_HISTORY_ID, NULL, EMPLOYMENT_HISTORY_ID, FND_API.G_MISS_NUM,NULL, X_EMPLOYMENT_HISTORY_ID,x_EMPLOYMENT_HISTORY_ID),
205: BEGIN_DATE = decode( x_BEGIN_DATE, NULL,BEGIN_DATE,FND_API.G_MISS_DATE,NULL,x_BEGIN_DATE),
206: PARTY_ID = decode( x_PARTY_ID, NULL,PARTY_ID,FND_API.G_MISS_NUM,NULL,x_PARTY_ID),
207: EMPLOYED_AS_TITLE = decode( x_EMPLOYED_AS_TITLE, NULL,EMPLOYED_AS_TITLE, FND_API.G_MISS_CHAR,NULL,x_EMPLOYED_AS_TITLE),
208: EMPLOYED_BY_DIVISION_NAME = decode( x_EMPLOYED_BY_DIVISION_NAME, NULL,EMPLOYED_BY_DIVISION_NAME, FND_API.G_MISS_CHAR,NULL,x_EMPLOYED_BY_DIVISION_NAME),
209: EMPLOYED_BY_NAME_COMPANY = decode( x_EMPLOYED_BY_NAME_COMPANY, NULL,EMPLOYED_BY_NAME_COMPANY,FND_API.G_MISS_CHAR,NULL,x_EMPLOYED_BY_NAME_COMPANY),
210: END_DATE = decode( x_END_DATE, NULL,END_DATE,FND_API.G_MISS_DATE,NULL,x_END_DATE),
211: SUPERVISOR_NAME = decode( x_SUPERVISOR_NAME, NULL,SUPERVISOR_NAME,FND_API.G_MISS_CHAR,NULL,x_SUPERVISOR_NAME),

Line 208: EMPLOYED_BY_DIVISION_NAME = decode( x_EMPLOYED_BY_DIVISION_NAME, NULL,EMPLOYED_BY_DIVISION_NAME, FND_API.G_MISS_CHAR,NULL,x_EMPLOYED_BY_DIVISION_NAME),

204: EMPLOYMENT_HISTORY_ID = decode( x_EMPLOYMENT_HISTORY_ID, NULL, EMPLOYMENT_HISTORY_ID, FND_API.G_MISS_NUM,NULL, X_EMPLOYMENT_HISTORY_ID,x_EMPLOYMENT_HISTORY_ID),
205: BEGIN_DATE = decode( x_BEGIN_DATE, NULL,BEGIN_DATE,FND_API.G_MISS_DATE,NULL,x_BEGIN_DATE),
206: PARTY_ID = decode( x_PARTY_ID, NULL,PARTY_ID,FND_API.G_MISS_NUM,NULL,x_PARTY_ID),
207: EMPLOYED_AS_TITLE = decode( x_EMPLOYED_AS_TITLE, NULL,EMPLOYED_AS_TITLE, FND_API.G_MISS_CHAR,NULL,x_EMPLOYED_AS_TITLE),
208: EMPLOYED_BY_DIVISION_NAME = decode( x_EMPLOYED_BY_DIVISION_NAME, NULL,EMPLOYED_BY_DIVISION_NAME, FND_API.G_MISS_CHAR,NULL,x_EMPLOYED_BY_DIVISION_NAME),
209: EMPLOYED_BY_NAME_COMPANY = decode( x_EMPLOYED_BY_NAME_COMPANY, NULL,EMPLOYED_BY_NAME_COMPANY,FND_API.G_MISS_CHAR,NULL,x_EMPLOYED_BY_NAME_COMPANY),
210: END_DATE = decode( x_END_DATE, NULL,END_DATE,FND_API.G_MISS_DATE,NULL,x_END_DATE),
211: SUPERVISOR_NAME = decode( x_SUPERVISOR_NAME, NULL,SUPERVISOR_NAME,FND_API.G_MISS_CHAR,NULL,x_SUPERVISOR_NAME),
212: BRANCH = decode( x_BRANCH,NULL,BRANCH, FND_API.G_MISS_CHAR,NULL, x_BRANCH),

Line 209: EMPLOYED_BY_NAME_COMPANY = decode( x_EMPLOYED_BY_NAME_COMPANY, NULL,EMPLOYED_BY_NAME_COMPANY,FND_API.G_MISS_CHAR,NULL,x_EMPLOYED_BY_NAME_COMPANY),

205: BEGIN_DATE = decode( x_BEGIN_DATE, NULL,BEGIN_DATE,FND_API.G_MISS_DATE,NULL,x_BEGIN_DATE),
206: PARTY_ID = decode( x_PARTY_ID, NULL,PARTY_ID,FND_API.G_MISS_NUM,NULL,x_PARTY_ID),
207: EMPLOYED_AS_TITLE = decode( x_EMPLOYED_AS_TITLE, NULL,EMPLOYED_AS_TITLE, FND_API.G_MISS_CHAR,NULL,x_EMPLOYED_AS_TITLE),
208: EMPLOYED_BY_DIVISION_NAME = decode( x_EMPLOYED_BY_DIVISION_NAME, NULL,EMPLOYED_BY_DIVISION_NAME, FND_API.G_MISS_CHAR,NULL,x_EMPLOYED_BY_DIVISION_NAME),
209: EMPLOYED_BY_NAME_COMPANY = decode( x_EMPLOYED_BY_NAME_COMPANY, NULL,EMPLOYED_BY_NAME_COMPANY,FND_API.G_MISS_CHAR,NULL,x_EMPLOYED_BY_NAME_COMPANY),
210: END_DATE = decode( x_END_DATE, NULL,END_DATE,FND_API.G_MISS_DATE,NULL,x_END_DATE),
211: SUPERVISOR_NAME = decode( x_SUPERVISOR_NAME, NULL,SUPERVISOR_NAME,FND_API.G_MISS_CHAR,NULL,x_SUPERVISOR_NAME),
212: BRANCH = decode( x_BRANCH,NULL,BRANCH, FND_API.G_MISS_CHAR,NULL, x_BRANCH),
213: MILITARY_RANK = decode( x_MILITARY_RANK, NULL,MILITARY_RANK,FND_API.G_MISS_CHAR,NULL,x_MILITARY_RANK),

Line 210: END_DATE = decode( x_END_DATE, NULL,END_DATE,FND_API.G_MISS_DATE,NULL,x_END_DATE),

206: PARTY_ID = decode( x_PARTY_ID, NULL,PARTY_ID,FND_API.G_MISS_NUM,NULL,x_PARTY_ID),
207: EMPLOYED_AS_TITLE = decode( x_EMPLOYED_AS_TITLE, NULL,EMPLOYED_AS_TITLE, FND_API.G_MISS_CHAR,NULL,x_EMPLOYED_AS_TITLE),
208: EMPLOYED_BY_DIVISION_NAME = decode( x_EMPLOYED_BY_DIVISION_NAME, NULL,EMPLOYED_BY_DIVISION_NAME, FND_API.G_MISS_CHAR,NULL,x_EMPLOYED_BY_DIVISION_NAME),
209: EMPLOYED_BY_NAME_COMPANY = decode( x_EMPLOYED_BY_NAME_COMPANY, NULL,EMPLOYED_BY_NAME_COMPANY,FND_API.G_MISS_CHAR,NULL,x_EMPLOYED_BY_NAME_COMPANY),
210: END_DATE = decode( x_END_DATE, NULL,END_DATE,FND_API.G_MISS_DATE,NULL,x_END_DATE),
211: SUPERVISOR_NAME = decode( x_SUPERVISOR_NAME, NULL,SUPERVISOR_NAME,FND_API.G_MISS_CHAR,NULL,x_SUPERVISOR_NAME),
212: BRANCH = decode( x_BRANCH,NULL,BRANCH, FND_API.G_MISS_CHAR,NULL, x_BRANCH),
213: MILITARY_RANK = decode( x_MILITARY_RANK, NULL,MILITARY_RANK,FND_API.G_MISS_CHAR,NULL,x_MILITARY_RANK),
214: SERVED = decode( x_SERVED, NULL,SERVED,FND_API.G_MISS_CHAR,NULL,x_SERVED),

Line 211: SUPERVISOR_NAME = decode( x_SUPERVISOR_NAME, NULL,SUPERVISOR_NAME,FND_API.G_MISS_CHAR,NULL,x_SUPERVISOR_NAME),

207: EMPLOYED_AS_TITLE = decode( x_EMPLOYED_AS_TITLE, NULL,EMPLOYED_AS_TITLE, FND_API.G_MISS_CHAR,NULL,x_EMPLOYED_AS_TITLE),
208: EMPLOYED_BY_DIVISION_NAME = decode( x_EMPLOYED_BY_DIVISION_NAME, NULL,EMPLOYED_BY_DIVISION_NAME, FND_API.G_MISS_CHAR,NULL,x_EMPLOYED_BY_DIVISION_NAME),
209: EMPLOYED_BY_NAME_COMPANY = decode( x_EMPLOYED_BY_NAME_COMPANY, NULL,EMPLOYED_BY_NAME_COMPANY,FND_API.G_MISS_CHAR,NULL,x_EMPLOYED_BY_NAME_COMPANY),
210: END_DATE = decode( x_END_DATE, NULL,END_DATE,FND_API.G_MISS_DATE,NULL,x_END_DATE),
211: SUPERVISOR_NAME = decode( x_SUPERVISOR_NAME, NULL,SUPERVISOR_NAME,FND_API.G_MISS_CHAR,NULL,x_SUPERVISOR_NAME),
212: BRANCH = decode( x_BRANCH,NULL,BRANCH, FND_API.G_MISS_CHAR,NULL, x_BRANCH),
213: MILITARY_RANK = decode( x_MILITARY_RANK, NULL,MILITARY_RANK,FND_API.G_MISS_CHAR,NULL,x_MILITARY_RANK),
214: SERVED = decode( x_SERVED, NULL,SERVED,FND_API.G_MISS_CHAR,NULL,x_SERVED),
215: STATION = decode( x_STATION, NULL,STATION,FND_API.G_MISS_CHAR,NULL,x_STATION),

Line 212: BRANCH = decode( x_BRANCH,NULL,BRANCH, FND_API.G_MISS_CHAR,NULL, x_BRANCH),

208: EMPLOYED_BY_DIVISION_NAME = decode( x_EMPLOYED_BY_DIVISION_NAME, NULL,EMPLOYED_BY_DIVISION_NAME, FND_API.G_MISS_CHAR,NULL,x_EMPLOYED_BY_DIVISION_NAME),
209: EMPLOYED_BY_NAME_COMPANY = decode( x_EMPLOYED_BY_NAME_COMPANY, NULL,EMPLOYED_BY_NAME_COMPANY,FND_API.G_MISS_CHAR,NULL,x_EMPLOYED_BY_NAME_COMPANY),
210: END_DATE = decode( x_END_DATE, NULL,END_DATE,FND_API.G_MISS_DATE,NULL,x_END_DATE),
211: SUPERVISOR_NAME = decode( x_SUPERVISOR_NAME, NULL,SUPERVISOR_NAME,FND_API.G_MISS_CHAR,NULL,x_SUPERVISOR_NAME),
212: BRANCH = decode( x_BRANCH,NULL,BRANCH, FND_API.G_MISS_CHAR,NULL, x_BRANCH),
213: MILITARY_RANK = decode( x_MILITARY_RANK, NULL,MILITARY_RANK,FND_API.G_MISS_CHAR,NULL,x_MILITARY_RANK),
214: SERVED = decode( x_SERVED, NULL,SERVED,FND_API.G_MISS_CHAR,NULL,x_SERVED),
215: STATION = decode( x_STATION, NULL,STATION,FND_API.G_MISS_CHAR,NULL,x_STATION),
216: RESPONSIBILITY = decode( x_RESPONSIBILITY, NULL,RESPONSIBILITY, FND_API.G_MISS_CHAR,NULL,x_RESPONSIBILITY),

Line 213: MILITARY_RANK = decode( x_MILITARY_RANK, NULL,MILITARY_RANK,FND_API.G_MISS_CHAR,NULL,x_MILITARY_RANK),

209: EMPLOYED_BY_NAME_COMPANY = decode( x_EMPLOYED_BY_NAME_COMPANY, NULL,EMPLOYED_BY_NAME_COMPANY,FND_API.G_MISS_CHAR,NULL,x_EMPLOYED_BY_NAME_COMPANY),
210: END_DATE = decode( x_END_DATE, NULL,END_DATE,FND_API.G_MISS_DATE,NULL,x_END_DATE),
211: SUPERVISOR_NAME = decode( x_SUPERVISOR_NAME, NULL,SUPERVISOR_NAME,FND_API.G_MISS_CHAR,NULL,x_SUPERVISOR_NAME),
212: BRANCH = decode( x_BRANCH,NULL,BRANCH, FND_API.G_MISS_CHAR,NULL, x_BRANCH),
213: MILITARY_RANK = decode( x_MILITARY_RANK, NULL,MILITARY_RANK,FND_API.G_MISS_CHAR,NULL,x_MILITARY_RANK),
214: SERVED = decode( x_SERVED, NULL,SERVED,FND_API.G_MISS_CHAR,NULL,x_SERVED),
215: STATION = decode( x_STATION, NULL,STATION,FND_API.G_MISS_CHAR,NULL,x_STATION),
216: RESPONSIBILITY = decode( x_RESPONSIBILITY, NULL,RESPONSIBILITY, FND_API.G_MISS_CHAR,NULL,x_RESPONSIBILITY),
217: STATUS = decode( x_STATUS,NULL,STATUS, FND_API.G_MISS_CHAR,NULL,x_STATUS),

Line 214: SERVED = decode( x_SERVED, NULL,SERVED,FND_API.G_MISS_CHAR,NULL,x_SERVED),

210: END_DATE = decode( x_END_DATE, NULL,END_DATE,FND_API.G_MISS_DATE,NULL,x_END_DATE),
211: SUPERVISOR_NAME = decode( x_SUPERVISOR_NAME, NULL,SUPERVISOR_NAME,FND_API.G_MISS_CHAR,NULL,x_SUPERVISOR_NAME),
212: BRANCH = decode( x_BRANCH,NULL,BRANCH, FND_API.G_MISS_CHAR,NULL, x_BRANCH),
213: MILITARY_RANK = decode( x_MILITARY_RANK, NULL,MILITARY_RANK,FND_API.G_MISS_CHAR,NULL,x_MILITARY_RANK),
214: SERVED = decode( x_SERVED, NULL,SERVED,FND_API.G_MISS_CHAR,NULL,x_SERVED),
215: STATION = decode( x_STATION, NULL,STATION,FND_API.G_MISS_CHAR,NULL,x_STATION),
216: RESPONSIBILITY = decode( x_RESPONSIBILITY, NULL,RESPONSIBILITY, FND_API.G_MISS_CHAR,NULL,x_RESPONSIBILITY),
217: STATUS = decode( x_STATUS,NULL,STATUS, FND_API.G_MISS_CHAR,NULL,x_STATUS),
218: OBJECT_VERSION_NUMBER = DECODE( x_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),

Line 215: STATION = decode( x_STATION, NULL,STATION,FND_API.G_MISS_CHAR,NULL,x_STATION),

211: SUPERVISOR_NAME = decode( x_SUPERVISOR_NAME, NULL,SUPERVISOR_NAME,FND_API.G_MISS_CHAR,NULL,x_SUPERVISOR_NAME),
212: BRANCH = decode( x_BRANCH,NULL,BRANCH, FND_API.G_MISS_CHAR,NULL, x_BRANCH),
213: MILITARY_RANK = decode( x_MILITARY_RANK, NULL,MILITARY_RANK,FND_API.G_MISS_CHAR,NULL,x_MILITARY_RANK),
214: SERVED = decode( x_SERVED, NULL,SERVED,FND_API.G_MISS_CHAR,NULL,x_SERVED),
215: STATION = decode( x_STATION, NULL,STATION,FND_API.G_MISS_CHAR,NULL,x_STATION),
216: RESPONSIBILITY = decode( x_RESPONSIBILITY, NULL,RESPONSIBILITY, FND_API.G_MISS_CHAR,NULL,x_RESPONSIBILITY),
217: STATUS = decode( x_STATUS,NULL,STATUS, FND_API.G_MISS_CHAR,NULL,x_STATUS),
218: OBJECT_VERSION_NUMBER = DECODE( x_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
219: CREATED_BY_MODULE = DECODE( x_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),

Line 216: RESPONSIBILITY = decode( x_RESPONSIBILITY, NULL,RESPONSIBILITY, FND_API.G_MISS_CHAR,NULL,x_RESPONSIBILITY),

212: BRANCH = decode( x_BRANCH,NULL,BRANCH, FND_API.G_MISS_CHAR,NULL, x_BRANCH),
213: MILITARY_RANK = decode( x_MILITARY_RANK, NULL,MILITARY_RANK,FND_API.G_MISS_CHAR,NULL,x_MILITARY_RANK),
214: SERVED = decode( x_SERVED, NULL,SERVED,FND_API.G_MISS_CHAR,NULL,x_SERVED),
215: STATION = decode( x_STATION, NULL,STATION,FND_API.G_MISS_CHAR,NULL,x_STATION),
216: RESPONSIBILITY = decode( x_RESPONSIBILITY, NULL,RESPONSIBILITY, FND_API.G_MISS_CHAR,NULL,x_RESPONSIBILITY),
217: STATUS = decode( x_STATUS,NULL,STATUS, FND_API.G_MISS_CHAR,NULL,x_STATUS),
218: OBJECT_VERSION_NUMBER = DECODE( x_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
219: CREATED_BY_MODULE = DECODE( x_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
220: APPLICATION_ID = DECODE( x_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),

Line 217: STATUS = decode( x_STATUS,NULL,STATUS, FND_API.G_MISS_CHAR,NULL,x_STATUS),

213: MILITARY_RANK = decode( x_MILITARY_RANK, NULL,MILITARY_RANK,FND_API.G_MISS_CHAR,NULL,x_MILITARY_RANK),
214: SERVED = decode( x_SERVED, NULL,SERVED,FND_API.G_MISS_CHAR,NULL,x_SERVED),
215: STATION = decode( x_STATION, NULL,STATION,FND_API.G_MISS_CHAR,NULL,x_STATION),
216: RESPONSIBILITY = decode( x_RESPONSIBILITY, NULL,RESPONSIBILITY, FND_API.G_MISS_CHAR,NULL,x_RESPONSIBILITY),
217: STATUS = decode( x_STATUS,NULL,STATUS, FND_API.G_MISS_CHAR,NULL,x_STATUS),
218: OBJECT_VERSION_NUMBER = DECODE( x_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
219: CREATED_BY_MODULE = DECODE( x_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
220: APPLICATION_ID = DECODE( x_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
221: EMPLOYED_BY_PARTY_ID = decode( x_EMPLOYED_BY_PARTY_ID, NULL,EMPLOYED_BY_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_EMPLOYED_BY_PARTY_ID),

Line 218: OBJECT_VERSION_NUMBER = DECODE( x_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),

214: SERVED = decode( x_SERVED, NULL,SERVED,FND_API.G_MISS_CHAR,NULL,x_SERVED),
215: STATION = decode( x_STATION, NULL,STATION,FND_API.G_MISS_CHAR,NULL,x_STATION),
216: RESPONSIBILITY = decode( x_RESPONSIBILITY, NULL,RESPONSIBILITY, FND_API.G_MISS_CHAR,NULL,x_RESPONSIBILITY),
217: STATUS = decode( x_STATUS,NULL,STATUS, FND_API.G_MISS_CHAR,NULL,x_STATUS),
218: OBJECT_VERSION_NUMBER = DECODE( x_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
219: CREATED_BY_MODULE = DECODE( x_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
220: APPLICATION_ID = DECODE( x_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
221: EMPLOYED_BY_PARTY_ID = decode( x_EMPLOYED_BY_PARTY_ID, NULL,EMPLOYED_BY_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_EMPLOYED_BY_PARTY_ID),
222: REASON_FOR_LEAVING = decode( x_REASON_FOR_LEAVING, NULL,REASON_FOR_LEAVING, FND_API.G_MISS_CHAR, NULL, X_REASON_FOR_LEAVING ),

Line 219: CREATED_BY_MODULE = DECODE( x_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),

215: STATION = decode( x_STATION, NULL,STATION,FND_API.G_MISS_CHAR,NULL,x_STATION),
216: RESPONSIBILITY = decode( x_RESPONSIBILITY, NULL,RESPONSIBILITY, FND_API.G_MISS_CHAR,NULL,x_RESPONSIBILITY),
217: STATUS = decode( x_STATUS,NULL,STATUS, FND_API.G_MISS_CHAR,NULL,x_STATUS),
218: OBJECT_VERSION_NUMBER = DECODE( x_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
219: CREATED_BY_MODULE = DECODE( x_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
220: APPLICATION_ID = DECODE( x_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
221: EMPLOYED_BY_PARTY_ID = decode( x_EMPLOYED_BY_PARTY_ID, NULL,EMPLOYED_BY_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_EMPLOYED_BY_PARTY_ID),
222: REASON_FOR_LEAVING = decode( x_REASON_FOR_LEAVING, NULL,REASON_FOR_LEAVING, FND_API.G_MISS_CHAR, NULL, X_REASON_FOR_LEAVING ),
223: FACULTY_POSITION_FLAG = decode( x_FACULTY_POSITION_FLAG, NULL,FACULTY_POSITION_FLAG, FND_API.G_MISS_CHAR, NULL, X_FACULTY_POSITION_FLAG ),

Line 220: APPLICATION_ID = DECODE( x_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),

216: RESPONSIBILITY = decode( x_RESPONSIBILITY, NULL,RESPONSIBILITY, FND_API.G_MISS_CHAR,NULL,x_RESPONSIBILITY),
217: STATUS = decode( x_STATUS,NULL,STATUS, FND_API.G_MISS_CHAR,NULL,x_STATUS),
218: OBJECT_VERSION_NUMBER = DECODE( x_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
219: CREATED_BY_MODULE = DECODE( x_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
220: APPLICATION_ID = DECODE( x_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
221: EMPLOYED_BY_PARTY_ID = decode( x_EMPLOYED_BY_PARTY_ID, NULL,EMPLOYED_BY_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_EMPLOYED_BY_PARTY_ID),
222: REASON_FOR_LEAVING = decode( x_REASON_FOR_LEAVING, NULL,REASON_FOR_LEAVING, FND_API.G_MISS_CHAR, NULL, X_REASON_FOR_LEAVING ),
223: FACULTY_POSITION_FLAG = decode( x_FACULTY_POSITION_FLAG, NULL,FACULTY_POSITION_FLAG, FND_API.G_MISS_CHAR, NULL, X_FACULTY_POSITION_FLAG ),
224: TENURE_CODE = decode( x_TENURE_CODE, NULL,TENURE_CODE, FND_API.G_MISS_CHAR,NULL,X_TENURE_CODE ),

Line 221: EMPLOYED_BY_PARTY_ID = decode( x_EMPLOYED_BY_PARTY_ID, NULL,EMPLOYED_BY_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_EMPLOYED_BY_PARTY_ID),

217: STATUS = decode( x_STATUS,NULL,STATUS, FND_API.G_MISS_CHAR,NULL,x_STATUS),
218: OBJECT_VERSION_NUMBER = DECODE( x_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
219: CREATED_BY_MODULE = DECODE( x_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
220: APPLICATION_ID = DECODE( x_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
221: EMPLOYED_BY_PARTY_ID = decode( x_EMPLOYED_BY_PARTY_ID, NULL,EMPLOYED_BY_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_EMPLOYED_BY_PARTY_ID),
222: REASON_FOR_LEAVING = decode( x_REASON_FOR_LEAVING, NULL,REASON_FOR_LEAVING, FND_API.G_MISS_CHAR, NULL, X_REASON_FOR_LEAVING ),
223: FACULTY_POSITION_FLAG = decode( x_FACULTY_POSITION_FLAG, NULL,FACULTY_POSITION_FLAG, FND_API.G_MISS_CHAR, NULL, X_FACULTY_POSITION_FLAG ),
224: TENURE_CODE = decode( x_TENURE_CODE, NULL,TENURE_CODE, FND_API.G_MISS_CHAR,NULL,X_TENURE_CODE ),
225: FRACTION_OF_TENURE = decode( x_FRACTION_OF_TENURE, NULL,FRACTION_OF_TENURE, FND_API.G_MISS_NUM, NULL, x_FRACTION_OF_TENURE),

Line 222: REASON_FOR_LEAVING = decode( x_REASON_FOR_LEAVING, NULL,REASON_FOR_LEAVING, FND_API.G_MISS_CHAR, NULL, X_REASON_FOR_LEAVING ),

218: OBJECT_VERSION_NUMBER = DECODE( x_OBJECT_VERSION_NUMBER, NULL, OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, NULL, X_OBJECT_VERSION_NUMBER ),
219: CREATED_BY_MODULE = DECODE( x_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
220: APPLICATION_ID = DECODE( x_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
221: EMPLOYED_BY_PARTY_ID = decode( x_EMPLOYED_BY_PARTY_ID, NULL,EMPLOYED_BY_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_EMPLOYED_BY_PARTY_ID),
222: REASON_FOR_LEAVING = decode( x_REASON_FOR_LEAVING, NULL,REASON_FOR_LEAVING, FND_API.G_MISS_CHAR, NULL, X_REASON_FOR_LEAVING ),
223: FACULTY_POSITION_FLAG = decode( x_FACULTY_POSITION_FLAG, NULL,FACULTY_POSITION_FLAG, FND_API.G_MISS_CHAR, NULL, X_FACULTY_POSITION_FLAG ),
224: TENURE_CODE = decode( x_TENURE_CODE, NULL,TENURE_CODE, FND_API.G_MISS_CHAR,NULL,X_TENURE_CODE ),
225: FRACTION_OF_TENURE = decode( x_FRACTION_OF_TENURE, NULL,FRACTION_OF_TENURE, FND_API.G_MISS_NUM, NULL, x_FRACTION_OF_TENURE),
226: EMPLOYMENT_TYPE_CODE = decode( x_EMPLOYMENT_TYPE_CODE, NULL, EMPLOYMENT_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, X_EMPLOYMENT_TYPE_CODE ),

Line 223: FACULTY_POSITION_FLAG = decode( x_FACULTY_POSITION_FLAG, NULL,FACULTY_POSITION_FLAG, FND_API.G_MISS_CHAR, NULL, X_FACULTY_POSITION_FLAG ),

219: CREATED_BY_MODULE = DECODE( x_CREATED_BY_MODULE, NULL, CREATED_BY_MODULE, FND_API.G_MISS_CHAR, NULL, X_CREATED_BY_MODULE ),
220: APPLICATION_ID = DECODE( x_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
221: EMPLOYED_BY_PARTY_ID = decode( x_EMPLOYED_BY_PARTY_ID, NULL,EMPLOYED_BY_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_EMPLOYED_BY_PARTY_ID),
222: REASON_FOR_LEAVING = decode( x_REASON_FOR_LEAVING, NULL,REASON_FOR_LEAVING, FND_API.G_MISS_CHAR, NULL, X_REASON_FOR_LEAVING ),
223: FACULTY_POSITION_FLAG = decode( x_FACULTY_POSITION_FLAG, NULL,FACULTY_POSITION_FLAG, FND_API.G_MISS_CHAR, NULL, X_FACULTY_POSITION_FLAG ),
224: TENURE_CODE = decode( x_TENURE_CODE, NULL,TENURE_CODE, FND_API.G_MISS_CHAR,NULL,X_TENURE_CODE ),
225: FRACTION_OF_TENURE = decode( x_FRACTION_OF_TENURE, NULL,FRACTION_OF_TENURE, FND_API.G_MISS_NUM, NULL, x_FRACTION_OF_TENURE),
226: EMPLOYMENT_TYPE_CODE = decode( x_EMPLOYMENT_TYPE_CODE, NULL, EMPLOYMENT_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, X_EMPLOYMENT_TYPE_CODE ),
227: EMPLOYED_AS_TITLE_CODE = decode( x_EMPLOYED_AS_TITLE_CODE, NULL, EMPLOYED_AS_TITLE_CODE, FND_API.G_MISS_CHAR, NULL, X_EMPLOYED_AS_TITLE_CODE ),

Line 224: TENURE_CODE = decode( x_TENURE_CODE, NULL,TENURE_CODE, FND_API.G_MISS_CHAR,NULL,X_TENURE_CODE ),

220: APPLICATION_ID = DECODE( x_APPLICATION_ID, NULL, APPLICATION_ID, FND_API.G_MISS_NUM, NULL, X_APPLICATION_ID ),
221: EMPLOYED_BY_PARTY_ID = decode( x_EMPLOYED_BY_PARTY_ID, NULL,EMPLOYED_BY_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_EMPLOYED_BY_PARTY_ID),
222: REASON_FOR_LEAVING = decode( x_REASON_FOR_LEAVING, NULL,REASON_FOR_LEAVING, FND_API.G_MISS_CHAR, NULL, X_REASON_FOR_LEAVING ),
223: FACULTY_POSITION_FLAG = decode( x_FACULTY_POSITION_FLAG, NULL,FACULTY_POSITION_FLAG, FND_API.G_MISS_CHAR, NULL, X_FACULTY_POSITION_FLAG ),
224: TENURE_CODE = decode( x_TENURE_CODE, NULL,TENURE_CODE, FND_API.G_MISS_CHAR,NULL,X_TENURE_CODE ),
225: FRACTION_OF_TENURE = decode( x_FRACTION_OF_TENURE, NULL,FRACTION_OF_TENURE, FND_API.G_MISS_NUM, NULL, x_FRACTION_OF_TENURE),
226: EMPLOYMENT_TYPE_CODE = decode( x_EMPLOYMENT_TYPE_CODE, NULL, EMPLOYMENT_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, X_EMPLOYMENT_TYPE_CODE ),
227: EMPLOYED_AS_TITLE_CODE = decode( x_EMPLOYED_AS_TITLE_CODE, NULL, EMPLOYED_AS_TITLE_CODE, FND_API.G_MISS_CHAR, NULL, X_EMPLOYED_AS_TITLE_CODE ),
228: WEEKLY_WORK_HOURS = decode( x_WEEKLY_WORK_HOURS, NULL, WEEKLY_WORK_HOURS, FND_API.G_MISS_NUM, NULL, x_WEEKLY_WORK_HOURS),

Line 225: FRACTION_OF_TENURE = decode( x_FRACTION_OF_TENURE, NULL,FRACTION_OF_TENURE, FND_API.G_MISS_NUM, NULL, x_FRACTION_OF_TENURE),

221: EMPLOYED_BY_PARTY_ID = decode( x_EMPLOYED_BY_PARTY_ID, NULL,EMPLOYED_BY_PARTY_ID, FND_API.G_MISS_NUM, NULL,x_EMPLOYED_BY_PARTY_ID),
222: REASON_FOR_LEAVING = decode( x_REASON_FOR_LEAVING, NULL,REASON_FOR_LEAVING, FND_API.G_MISS_CHAR, NULL, X_REASON_FOR_LEAVING ),
223: FACULTY_POSITION_FLAG = decode( x_FACULTY_POSITION_FLAG, NULL,FACULTY_POSITION_FLAG, FND_API.G_MISS_CHAR, NULL, X_FACULTY_POSITION_FLAG ),
224: TENURE_CODE = decode( x_TENURE_CODE, NULL,TENURE_CODE, FND_API.G_MISS_CHAR,NULL,X_TENURE_CODE ),
225: FRACTION_OF_TENURE = decode( x_FRACTION_OF_TENURE, NULL,FRACTION_OF_TENURE, FND_API.G_MISS_NUM, NULL, x_FRACTION_OF_TENURE),
226: EMPLOYMENT_TYPE_CODE = decode( x_EMPLOYMENT_TYPE_CODE, NULL, EMPLOYMENT_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, X_EMPLOYMENT_TYPE_CODE ),
227: EMPLOYED_AS_TITLE_CODE = decode( x_EMPLOYED_AS_TITLE_CODE, NULL, EMPLOYED_AS_TITLE_CODE, FND_API.G_MISS_CHAR, NULL, X_EMPLOYED_AS_TITLE_CODE ),
228: WEEKLY_WORK_HOURS = decode( x_WEEKLY_WORK_HOURS, NULL, WEEKLY_WORK_HOURS, FND_API.G_MISS_NUM, NULL, x_WEEKLY_WORK_HOURS),
229: COMMENTS = decode( x_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),

Line 226: EMPLOYMENT_TYPE_CODE = decode( x_EMPLOYMENT_TYPE_CODE, NULL, EMPLOYMENT_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, X_EMPLOYMENT_TYPE_CODE ),

222: REASON_FOR_LEAVING = decode( x_REASON_FOR_LEAVING, NULL,REASON_FOR_LEAVING, FND_API.G_MISS_CHAR, NULL, X_REASON_FOR_LEAVING ),
223: FACULTY_POSITION_FLAG = decode( x_FACULTY_POSITION_FLAG, NULL,FACULTY_POSITION_FLAG, FND_API.G_MISS_CHAR, NULL, X_FACULTY_POSITION_FLAG ),
224: TENURE_CODE = decode( x_TENURE_CODE, NULL,TENURE_CODE, FND_API.G_MISS_CHAR,NULL,X_TENURE_CODE ),
225: FRACTION_OF_TENURE = decode( x_FRACTION_OF_TENURE, NULL,FRACTION_OF_TENURE, FND_API.G_MISS_NUM, NULL, x_FRACTION_OF_TENURE),
226: EMPLOYMENT_TYPE_CODE = decode( x_EMPLOYMENT_TYPE_CODE, NULL, EMPLOYMENT_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, X_EMPLOYMENT_TYPE_CODE ),
227: EMPLOYED_AS_TITLE_CODE = decode( x_EMPLOYED_AS_TITLE_CODE, NULL, EMPLOYED_AS_TITLE_CODE, FND_API.G_MISS_CHAR, NULL, X_EMPLOYED_AS_TITLE_CODE ),
228: WEEKLY_WORK_HOURS = decode( x_WEEKLY_WORK_HOURS, NULL, WEEKLY_WORK_HOURS, FND_API.G_MISS_NUM, NULL, x_WEEKLY_WORK_HOURS),
229: COMMENTS = decode( x_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
230: -- Bug 3032780

Line 227: EMPLOYED_AS_TITLE_CODE = decode( x_EMPLOYED_AS_TITLE_CODE, NULL, EMPLOYED_AS_TITLE_CODE, FND_API.G_MISS_CHAR, NULL, X_EMPLOYED_AS_TITLE_CODE ),

223: FACULTY_POSITION_FLAG = decode( x_FACULTY_POSITION_FLAG, NULL,FACULTY_POSITION_FLAG, FND_API.G_MISS_CHAR, NULL, X_FACULTY_POSITION_FLAG ),
224: TENURE_CODE = decode( x_TENURE_CODE, NULL,TENURE_CODE, FND_API.G_MISS_CHAR,NULL,X_TENURE_CODE ),
225: FRACTION_OF_TENURE = decode( x_FRACTION_OF_TENURE, NULL,FRACTION_OF_TENURE, FND_API.G_MISS_NUM, NULL, x_FRACTION_OF_TENURE),
226: EMPLOYMENT_TYPE_CODE = decode( x_EMPLOYMENT_TYPE_CODE, NULL, EMPLOYMENT_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, X_EMPLOYMENT_TYPE_CODE ),
227: EMPLOYED_AS_TITLE_CODE = decode( x_EMPLOYED_AS_TITLE_CODE, NULL, EMPLOYED_AS_TITLE_CODE, FND_API.G_MISS_CHAR, NULL, X_EMPLOYED_AS_TITLE_CODE ),
228: WEEKLY_WORK_HOURS = decode( x_WEEKLY_WORK_HOURS, NULL, WEEKLY_WORK_HOURS, FND_API.G_MISS_NUM, NULL, x_WEEKLY_WORK_HOURS),
229: COMMENTS = decode( x_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
230: -- Bug 3032780
231: -- CREATED_BY = HZ_UTILITY_V2PUB.CREATED_BY,

Line 228: WEEKLY_WORK_HOURS = decode( x_WEEKLY_WORK_HOURS, NULL, WEEKLY_WORK_HOURS, FND_API.G_MISS_NUM, NULL, x_WEEKLY_WORK_HOURS),

224: TENURE_CODE = decode( x_TENURE_CODE, NULL,TENURE_CODE, FND_API.G_MISS_CHAR,NULL,X_TENURE_CODE ),
225: FRACTION_OF_TENURE = decode( x_FRACTION_OF_TENURE, NULL,FRACTION_OF_TENURE, FND_API.G_MISS_NUM, NULL, x_FRACTION_OF_TENURE),
226: EMPLOYMENT_TYPE_CODE = decode( x_EMPLOYMENT_TYPE_CODE, NULL, EMPLOYMENT_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, X_EMPLOYMENT_TYPE_CODE ),
227: EMPLOYED_AS_TITLE_CODE = decode( x_EMPLOYED_AS_TITLE_CODE, NULL, EMPLOYED_AS_TITLE_CODE, FND_API.G_MISS_CHAR, NULL, X_EMPLOYED_AS_TITLE_CODE ),
228: WEEKLY_WORK_HOURS = decode( x_WEEKLY_WORK_HOURS, NULL, WEEKLY_WORK_HOURS, FND_API.G_MISS_NUM, NULL, x_WEEKLY_WORK_HOURS),
229: COMMENTS = decode( x_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
230: -- Bug 3032780
231: -- CREATED_BY = HZ_UTILITY_V2PUB.CREATED_BY,
232: -- CREATION_DATE = HZ_UTILITY_V2PUB.CREATION_DATE,

Line 229: COMMENTS = decode( x_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),

225: FRACTION_OF_TENURE = decode( x_FRACTION_OF_TENURE, NULL,FRACTION_OF_TENURE, FND_API.G_MISS_NUM, NULL, x_FRACTION_OF_TENURE),
226: EMPLOYMENT_TYPE_CODE = decode( x_EMPLOYMENT_TYPE_CODE, NULL, EMPLOYMENT_TYPE_CODE, FND_API.G_MISS_CHAR, NULL, X_EMPLOYMENT_TYPE_CODE ),
227: EMPLOYED_AS_TITLE_CODE = decode( x_EMPLOYED_AS_TITLE_CODE, NULL, EMPLOYED_AS_TITLE_CODE, FND_API.G_MISS_CHAR, NULL, X_EMPLOYED_AS_TITLE_CODE ),
228: WEEKLY_WORK_HOURS = decode( x_WEEKLY_WORK_HOURS, NULL, WEEKLY_WORK_HOURS, FND_API.G_MISS_NUM, NULL, x_WEEKLY_WORK_HOURS),
229: COMMENTS = decode( x_COMMENTS, NULL, COMMENTS, FND_API.G_MISS_CHAR, NULL, X_COMMENTS ),
230: -- Bug 3032780
231: -- CREATED_BY = HZ_UTILITY_V2PUB.CREATED_BY,
232: -- CREATION_DATE = HZ_UTILITY_V2PUB.CREATION_DATE,
233: LAST_UPDATE_LOGIN = HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN,

Line 447: NVL(employment_history_id, FND_API.G_MISS_NUM),

443: ) IS
444: BEGIN
445:
446: SELECT
447: NVL(employment_history_id, FND_API.G_MISS_NUM),
448: NVL(begin_date, FND_API.G_MISS_DATE),
449: NVL(party_id, FND_API.G_MISS_NUM),
450: NVL(employed_as_title, FND_API.G_MISS_CHAR),
451: NVL(employed_by_division_name, FND_API.G_MISS_CHAR),

Line 448: NVL(begin_date, FND_API.G_MISS_DATE),

444: BEGIN
445:
446: SELECT
447: NVL(employment_history_id, FND_API.G_MISS_NUM),
448: NVL(begin_date, FND_API.G_MISS_DATE),
449: NVL(party_id, FND_API.G_MISS_NUM),
450: NVL(employed_as_title, FND_API.G_MISS_CHAR),
451: NVL(employed_by_division_name, FND_API.G_MISS_CHAR),
452: NVL(employed_by_name_company, FND_API.G_MISS_CHAR),

Line 449: NVL(party_id, FND_API.G_MISS_NUM),

445:
446: SELECT
447: NVL(employment_history_id, FND_API.G_MISS_NUM),
448: NVL(begin_date, FND_API.G_MISS_DATE),
449: NVL(party_id, FND_API.G_MISS_NUM),
450: NVL(employed_as_title, FND_API.G_MISS_CHAR),
451: NVL(employed_by_division_name, FND_API.G_MISS_CHAR),
452: NVL(employed_by_name_company, FND_API.G_MISS_CHAR),
453: NVL(end_date, FND_API.G_MISS_DATE),

Line 450: NVL(employed_as_title, FND_API.G_MISS_CHAR),

446: SELECT
447: NVL(employment_history_id, FND_API.G_MISS_NUM),
448: NVL(begin_date, FND_API.G_MISS_DATE),
449: NVL(party_id, FND_API.G_MISS_NUM),
450: NVL(employed_as_title, FND_API.G_MISS_CHAR),
451: NVL(employed_by_division_name, FND_API.G_MISS_CHAR),
452: NVL(employed_by_name_company, FND_API.G_MISS_CHAR),
453: NVL(end_date, FND_API.G_MISS_DATE),
454: NVL(supervisor_name, FND_API.G_MISS_CHAR),

Line 451: NVL(employed_by_division_name, FND_API.G_MISS_CHAR),

447: NVL(employment_history_id, FND_API.G_MISS_NUM),
448: NVL(begin_date, FND_API.G_MISS_DATE),
449: NVL(party_id, FND_API.G_MISS_NUM),
450: NVL(employed_as_title, FND_API.G_MISS_CHAR),
451: NVL(employed_by_division_name, FND_API.G_MISS_CHAR),
452: NVL(employed_by_name_company, FND_API.G_MISS_CHAR),
453: NVL(end_date, FND_API.G_MISS_DATE),
454: NVL(supervisor_name, FND_API.G_MISS_CHAR),
455: NVL(branch, FND_API.G_MISS_CHAR),

Line 452: NVL(employed_by_name_company, FND_API.G_MISS_CHAR),

448: NVL(begin_date, FND_API.G_MISS_DATE),
449: NVL(party_id, FND_API.G_MISS_NUM),
450: NVL(employed_as_title, FND_API.G_MISS_CHAR),
451: NVL(employed_by_division_name, FND_API.G_MISS_CHAR),
452: NVL(employed_by_name_company, FND_API.G_MISS_CHAR),
453: NVL(end_date, FND_API.G_MISS_DATE),
454: NVL(supervisor_name, FND_API.G_MISS_CHAR),
455: NVL(branch, FND_API.G_MISS_CHAR),
456: NVL(military_rank, FND_API.G_MISS_CHAR),

Line 453: NVL(end_date, FND_API.G_MISS_DATE),

449: NVL(party_id, FND_API.G_MISS_NUM),
450: NVL(employed_as_title, FND_API.G_MISS_CHAR),
451: NVL(employed_by_division_name, FND_API.G_MISS_CHAR),
452: NVL(employed_by_name_company, FND_API.G_MISS_CHAR),
453: NVL(end_date, FND_API.G_MISS_DATE),
454: NVL(supervisor_name, FND_API.G_MISS_CHAR),
455: NVL(branch, FND_API.G_MISS_CHAR),
456: NVL(military_rank, FND_API.G_MISS_CHAR),
457: NVL(served, FND_API.G_MISS_CHAR),

Line 454: NVL(supervisor_name, FND_API.G_MISS_CHAR),

450: NVL(employed_as_title, FND_API.G_MISS_CHAR),
451: NVL(employed_by_division_name, FND_API.G_MISS_CHAR),
452: NVL(employed_by_name_company, FND_API.G_MISS_CHAR),
453: NVL(end_date, FND_API.G_MISS_DATE),
454: NVL(supervisor_name, FND_API.G_MISS_CHAR),
455: NVL(branch, FND_API.G_MISS_CHAR),
456: NVL(military_rank, FND_API.G_MISS_CHAR),
457: NVL(served, FND_API.G_MISS_CHAR),
458: NVL(station, FND_API.G_MISS_CHAR),

Line 455: NVL(branch, FND_API.G_MISS_CHAR),

451: NVL(employed_by_division_name, FND_API.G_MISS_CHAR),
452: NVL(employed_by_name_company, FND_API.G_MISS_CHAR),
453: NVL(end_date, FND_API.G_MISS_DATE),
454: NVL(supervisor_name, FND_API.G_MISS_CHAR),
455: NVL(branch, FND_API.G_MISS_CHAR),
456: NVL(military_rank, FND_API.G_MISS_CHAR),
457: NVL(served, FND_API.G_MISS_CHAR),
458: NVL(station, FND_API.G_MISS_CHAR),
459: NVL(responsibility, FND_API.G_MISS_CHAR),

Line 456: NVL(military_rank, FND_API.G_MISS_CHAR),

452: NVL(employed_by_name_company, FND_API.G_MISS_CHAR),
453: NVL(end_date, FND_API.G_MISS_DATE),
454: NVL(supervisor_name, FND_API.G_MISS_CHAR),
455: NVL(branch, FND_API.G_MISS_CHAR),
456: NVL(military_rank, FND_API.G_MISS_CHAR),
457: NVL(served, FND_API.G_MISS_CHAR),
458: NVL(station, FND_API.G_MISS_CHAR),
459: NVL(responsibility, FND_API.G_MISS_CHAR),
460: NVL(status, FND_API.G_MISS_CHAR),

Line 457: NVL(served, FND_API.G_MISS_CHAR),

453: NVL(end_date, FND_API.G_MISS_DATE),
454: NVL(supervisor_name, FND_API.G_MISS_CHAR),
455: NVL(branch, FND_API.G_MISS_CHAR),
456: NVL(military_rank, FND_API.G_MISS_CHAR),
457: NVL(served, FND_API.G_MISS_CHAR),
458: NVL(station, FND_API.G_MISS_CHAR),
459: NVL(responsibility, FND_API.G_MISS_CHAR),
460: NVL(status, FND_API.G_MISS_CHAR),
461: NVL(application_id, FND_API.G_MISS_NUM),

Line 458: NVL(station, FND_API.G_MISS_CHAR),

454: NVL(supervisor_name, FND_API.G_MISS_CHAR),
455: NVL(branch, FND_API.G_MISS_CHAR),
456: NVL(military_rank, FND_API.G_MISS_CHAR),
457: NVL(served, FND_API.G_MISS_CHAR),
458: NVL(station, FND_API.G_MISS_CHAR),
459: NVL(responsibility, FND_API.G_MISS_CHAR),
460: NVL(status, FND_API.G_MISS_CHAR),
461: NVL(application_id, FND_API.G_MISS_NUM),
462: NVL(created_by_module, FND_API.G_MISS_CHAR),

Line 459: NVL(responsibility, FND_API.G_MISS_CHAR),

455: NVL(branch, FND_API.G_MISS_CHAR),
456: NVL(military_rank, FND_API.G_MISS_CHAR),
457: NVL(served, FND_API.G_MISS_CHAR),
458: NVL(station, FND_API.G_MISS_CHAR),
459: NVL(responsibility, FND_API.G_MISS_CHAR),
460: NVL(status, FND_API.G_MISS_CHAR),
461: NVL(application_id, FND_API.G_MISS_NUM),
462: NVL(created_by_module, FND_API.G_MISS_CHAR),
463: NVL(reason_for_leaving, FND_API.G_MISS_CHAR),

Line 460: NVL(status, FND_API.G_MISS_CHAR),

456: NVL(military_rank, FND_API.G_MISS_CHAR),
457: NVL(served, FND_API.G_MISS_CHAR),
458: NVL(station, FND_API.G_MISS_CHAR),
459: NVL(responsibility, FND_API.G_MISS_CHAR),
460: NVL(status, FND_API.G_MISS_CHAR),
461: NVL(application_id, FND_API.G_MISS_NUM),
462: NVL(created_by_module, FND_API.G_MISS_CHAR),
463: NVL(reason_for_leaving, FND_API.G_MISS_CHAR),
464: NVL(faculty_position_flag, FND_API.G_MISS_CHAR),

Line 461: NVL(application_id, FND_API.G_MISS_NUM),

457: NVL(served, FND_API.G_MISS_CHAR),
458: NVL(station, FND_API.G_MISS_CHAR),
459: NVL(responsibility, FND_API.G_MISS_CHAR),
460: NVL(status, FND_API.G_MISS_CHAR),
461: NVL(application_id, FND_API.G_MISS_NUM),
462: NVL(created_by_module, FND_API.G_MISS_CHAR),
463: NVL(reason_for_leaving, FND_API.G_MISS_CHAR),
464: NVL(faculty_position_flag, FND_API.G_MISS_CHAR),
465: NVL(tenure_code, FND_API.G_MISS_CHAR),

Line 462: NVL(created_by_module, FND_API.G_MISS_CHAR),

458: NVL(station, FND_API.G_MISS_CHAR),
459: NVL(responsibility, FND_API.G_MISS_CHAR),
460: NVL(status, FND_API.G_MISS_CHAR),
461: NVL(application_id, FND_API.G_MISS_NUM),
462: NVL(created_by_module, FND_API.G_MISS_CHAR),
463: NVL(reason_for_leaving, FND_API.G_MISS_CHAR),
464: NVL(faculty_position_flag, FND_API.G_MISS_CHAR),
465: NVL(tenure_code, FND_API.G_MISS_CHAR),
466: NVL(fraction_of_tenure, FND_API.G_MISS_NUM),

Line 463: NVL(reason_for_leaving, FND_API.G_MISS_CHAR),

459: NVL(responsibility, FND_API.G_MISS_CHAR),
460: NVL(status, FND_API.G_MISS_CHAR),
461: NVL(application_id, FND_API.G_MISS_NUM),
462: NVL(created_by_module, FND_API.G_MISS_CHAR),
463: NVL(reason_for_leaving, FND_API.G_MISS_CHAR),
464: NVL(faculty_position_flag, FND_API.G_MISS_CHAR),
465: NVL(tenure_code, FND_API.G_MISS_CHAR),
466: NVL(fraction_of_tenure, FND_API.G_MISS_NUM),
467: NVL(employment_type_code, FND_API.G_MISS_CHAR),

Line 464: NVL(faculty_position_flag, FND_API.G_MISS_CHAR),

460: NVL(status, FND_API.G_MISS_CHAR),
461: NVL(application_id, FND_API.G_MISS_NUM),
462: NVL(created_by_module, FND_API.G_MISS_CHAR),
463: NVL(reason_for_leaving, FND_API.G_MISS_CHAR),
464: NVL(faculty_position_flag, FND_API.G_MISS_CHAR),
465: NVL(tenure_code, FND_API.G_MISS_CHAR),
466: NVL(fraction_of_tenure, FND_API.G_MISS_NUM),
467: NVL(employment_type_code, FND_API.G_MISS_CHAR),
468: NVL(employed_as_title_code, FND_API.G_MISS_CHAR),

Line 465: NVL(tenure_code, FND_API.G_MISS_CHAR),

461: NVL(application_id, FND_API.G_MISS_NUM),
462: NVL(created_by_module, FND_API.G_MISS_CHAR),
463: NVL(reason_for_leaving, FND_API.G_MISS_CHAR),
464: NVL(faculty_position_flag, FND_API.G_MISS_CHAR),
465: NVL(tenure_code, FND_API.G_MISS_CHAR),
466: NVL(fraction_of_tenure, FND_API.G_MISS_NUM),
467: NVL(employment_type_code, FND_API.G_MISS_CHAR),
468: NVL(employed_as_title_code, FND_API.G_MISS_CHAR),
469: NVL(weekly_work_hours, FND_API.G_MISS_NUM),

Line 466: NVL(fraction_of_tenure, FND_API.G_MISS_NUM),

462: NVL(created_by_module, FND_API.G_MISS_CHAR),
463: NVL(reason_for_leaving, FND_API.G_MISS_CHAR),
464: NVL(faculty_position_flag, FND_API.G_MISS_CHAR),
465: NVL(tenure_code, FND_API.G_MISS_CHAR),
466: NVL(fraction_of_tenure, FND_API.G_MISS_NUM),
467: NVL(employment_type_code, FND_API.G_MISS_CHAR),
468: NVL(employed_as_title_code, FND_API.G_MISS_CHAR),
469: NVL(weekly_work_hours, FND_API.G_MISS_NUM),
470: NVL(comments, FND_API.G_MISS_CHAR)

Line 467: NVL(employment_type_code, FND_API.G_MISS_CHAR),

463: NVL(reason_for_leaving, FND_API.G_MISS_CHAR),
464: NVL(faculty_position_flag, FND_API.G_MISS_CHAR),
465: NVL(tenure_code, FND_API.G_MISS_CHAR),
466: NVL(fraction_of_tenure, FND_API.G_MISS_NUM),
467: NVL(employment_type_code, FND_API.G_MISS_CHAR),
468: NVL(employed_as_title_code, FND_API.G_MISS_CHAR),
469: NVL(weekly_work_hours, FND_API.G_MISS_NUM),
470: NVL(comments, FND_API.G_MISS_CHAR)
471: INTO

Line 468: NVL(employed_as_title_code, FND_API.G_MISS_CHAR),

464: NVL(faculty_position_flag, FND_API.G_MISS_CHAR),
465: NVL(tenure_code, FND_API.G_MISS_CHAR),
466: NVL(fraction_of_tenure, FND_API.G_MISS_NUM),
467: NVL(employment_type_code, FND_API.G_MISS_CHAR),
468: NVL(employed_as_title_code, FND_API.G_MISS_CHAR),
469: NVL(weekly_work_hours, FND_API.G_MISS_NUM),
470: NVL(comments, FND_API.G_MISS_CHAR)
471: INTO
472: x_employment_history_id,

Line 469: NVL(weekly_work_hours, FND_API.G_MISS_NUM),

465: NVL(tenure_code, FND_API.G_MISS_CHAR),
466: NVL(fraction_of_tenure, FND_API.G_MISS_NUM),
467: NVL(employment_type_code, FND_API.G_MISS_CHAR),
468: NVL(employed_as_title_code, FND_API.G_MISS_CHAR),
469: NVL(weekly_work_hours, FND_API.G_MISS_NUM),
470: NVL(comments, FND_API.G_MISS_CHAR)
471: INTO
472: x_employment_history_id,
473: x_begin_date,

Line 470: NVL(comments, FND_API.G_MISS_CHAR)

466: NVL(fraction_of_tenure, FND_API.G_MISS_NUM),
467: NVL(employment_type_code, FND_API.G_MISS_CHAR),
468: NVL(employed_as_title_code, FND_API.G_MISS_CHAR),
469: NVL(weekly_work_hours, FND_API.G_MISS_NUM),
470: NVL(comments, FND_API.G_MISS_CHAR)
471: INTO
472: x_employment_history_id,
473: x_begin_date,
474: x_party_id,

Line 505: RAISE FND_API.G_EXC_ERROR;

501: FND_MESSAGE.SET_NAME('AR', 'HZ_API_NO_RECORD');
502: FND_MESSAGE.SET_TOKEN('RECORD', 'employment_history_rec');
503: FND_MESSAGE.SET_TOKEN('VALUE', TO_CHAR(x_employment_history_id));
504: FND_MSG_PUB.ADD;
505: RAISE FND_API.G_EXC_ERROR;
506:
507: END Select_Row;
508:
509: