DBA Data[Home] [Help]

APPS.FTE_MOVES_PVT dependencies on FND_GLOBAL

Line 87: decode(p_move_info.created_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_move_info.created_by),

83: p_move_info.PLANNED_FLAG,
84: decode(p_move_info.TP_PLAN_NAME,FND_API.G_MISS_CHAR,NULL,p_move_info.TP_PLAN_NAME),
85: decode(p_move_info.CM_TRIP_NUMBER,FND_API.G_MISS_NUM,NULL,p_move_info.CM_TRIP_NUMBER),
86: decode(p_move_info.creation_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE,p_move_info.creation_date),
87: decode(p_move_info.created_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_move_info.created_by),
88: decode(p_move_info.last_update_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE, p_move_info.last_update_date),
89: decode(p_move_info.last_updated_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_move_info.last_updated_by),
90: decode(p_move_info.last_update_login,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.LOGIN_ID,p_move_info.last_update_login),
91: decode(p_move_info.program_application_id,NULL,FND_GLOBAL.PROG_APPL_ID,FND_API.G_MISS_NUM,FND_GLOBAL.PROG_APPL_ID,p_move_info.program_application_id),

Line 89: decode(p_move_info.last_updated_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_move_info.last_updated_by),

85: decode(p_move_info.CM_TRIP_NUMBER,FND_API.G_MISS_NUM,NULL,p_move_info.CM_TRIP_NUMBER),
86: decode(p_move_info.creation_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE,p_move_info.creation_date),
87: decode(p_move_info.created_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_move_info.created_by),
88: decode(p_move_info.last_update_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE, p_move_info.last_update_date),
89: decode(p_move_info.last_updated_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_move_info.last_updated_by),
90: decode(p_move_info.last_update_login,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.LOGIN_ID,p_move_info.last_update_login),
91: decode(p_move_info.program_application_id,NULL,FND_GLOBAL.PROG_APPL_ID,FND_API.G_MISS_NUM,FND_GLOBAL.PROG_APPL_ID,p_move_info.program_application_id),
92: decode(p_move_info.program_id,NULL,FND_GLOBAL.CONC_PROGRAM_ID,FND_API.G_MISS_NUM, FND_GLOBAL.CONC_PROGRAM_ID,p_move_info.program_id),
93: decode(p_move_info.program_update_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE,p_move_info.program_update_date),

Line 90: decode(p_move_info.last_update_login,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.LOGIN_ID,p_move_info.last_update_login),

86: decode(p_move_info.creation_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE,p_move_info.creation_date),
87: decode(p_move_info.created_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_move_info.created_by),
88: decode(p_move_info.last_update_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE, p_move_info.last_update_date),
89: decode(p_move_info.last_updated_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_move_info.last_updated_by),
90: decode(p_move_info.last_update_login,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.LOGIN_ID,p_move_info.last_update_login),
91: decode(p_move_info.program_application_id,NULL,FND_GLOBAL.PROG_APPL_ID,FND_API.G_MISS_NUM,FND_GLOBAL.PROG_APPL_ID,p_move_info.program_application_id),
92: decode(p_move_info.program_id,NULL,FND_GLOBAL.CONC_PROGRAM_ID,FND_API.G_MISS_NUM, FND_GLOBAL.CONC_PROGRAM_ID,p_move_info.program_id),
93: decode(p_move_info.program_update_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE,p_move_info.program_update_date),
94: decode(p_move_info.request_id,NULL,FND_GLOBAL.CONC_REQUEST_ID,FND_API.G_MISS_NUM,FND_GLOBAL.CONC_REQUEST_ID, p_move_info.request_id)

Line 91: decode(p_move_info.program_application_id,NULL,FND_GLOBAL.PROG_APPL_ID,FND_API.G_MISS_NUM,FND_GLOBAL.PROG_APPL_ID,p_move_info.program_application_id),

87: decode(p_move_info.created_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_move_info.created_by),
88: decode(p_move_info.last_update_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE, p_move_info.last_update_date),
89: decode(p_move_info.last_updated_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_move_info.last_updated_by),
90: decode(p_move_info.last_update_login,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.LOGIN_ID,p_move_info.last_update_login),
91: decode(p_move_info.program_application_id,NULL,FND_GLOBAL.PROG_APPL_ID,FND_API.G_MISS_NUM,FND_GLOBAL.PROG_APPL_ID,p_move_info.program_application_id),
92: decode(p_move_info.program_id,NULL,FND_GLOBAL.CONC_PROGRAM_ID,FND_API.G_MISS_NUM, FND_GLOBAL.CONC_PROGRAM_ID,p_move_info.program_id),
93: decode(p_move_info.program_update_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE,p_move_info.program_update_date),
94: decode(p_move_info.request_id,NULL,FND_GLOBAL.CONC_REQUEST_ID,FND_API.G_MISS_NUM,FND_GLOBAL.CONC_REQUEST_ID, p_move_info.request_id)
95: );

Line 92: decode(p_move_info.program_id,NULL,FND_GLOBAL.CONC_PROGRAM_ID,FND_API.G_MISS_NUM, FND_GLOBAL.CONC_PROGRAM_ID,p_move_info.program_id),

88: decode(p_move_info.last_update_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE, p_move_info.last_update_date),
89: decode(p_move_info.last_updated_by,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,p_move_info.last_updated_by),
90: decode(p_move_info.last_update_login,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.LOGIN_ID,p_move_info.last_update_login),
91: decode(p_move_info.program_application_id,NULL,FND_GLOBAL.PROG_APPL_ID,FND_API.G_MISS_NUM,FND_GLOBAL.PROG_APPL_ID,p_move_info.program_application_id),
92: decode(p_move_info.program_id,NULL,FND_GLOBAL.CONC_PROGRAM_ID,FND_API.G_MISS_NUM, FND_GLOBAL.CONC_PROGRAM_ID,p_move_info.program_id),
93: decode(p_move_info.program_update_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE,p_move_info.program_update_date),
94: decode(p_move_info.request_id,NULL,FND_GLOBAL.CONC_REQUEST_ID,FND_API.G_MISS_NUM,FND_GLOBAL.CONC_REQUEST_ID, p_move_info.request_id)
95: );
96:

Line 94: decode(p_move_info.request_id,NULL,FND_GLOBAL.CONC_REQUEST_ID,FND_API.G_MISS_NUM,FND_GLOBAL.CONC_REQUEST_ID, p_move_info.request_id)

90: decode(p_move_info.last_update_login,NULL,FND_GLOBAL.USER_ID,FND_API.G_MISS_NUM,FND_GLOBAL.LOGIN_ID,p_move_info.last_update_login),
91: decode(p_move_info.program_application_id,NULL,FND_GLOBAL.PROG_APPL_ID,FND_API.G_MISS_NUM,FND_GLOBAL.PROG_APPL_ID,p_move_info.program_application_id),
92: decode(p_move_info.program_id,NULL,FND_GLOBAL.CONC_PROGRAM_ID,FND_API.G_MISS_NUM, FND_GLOBAL.CONC_PROGRAM_ID,p_move_info.program_id),
93: decode(p_move_info.program_update_date,NULL,SYSDATE,FND_API.G_MISS_DATE,SYSDATE,p_move_info.program_update_date),
94: decode(p_move_info.request_id,NULL,FND_GLOBAL.CONC_REQUEST_ID,FND_API.G_MISS_NUM,FND_GLOBAL.CONC_REQUEST_ID, p_move_info.request_id)
95: );
96:
97:
98:

Line 169: NULL,FND_GLOBAL.USER_ID,

165: NULL,SYSDATE,
166: FND_API.G_MISS_DATE,SYSDATE,
167: p_move_info.last_update_date),
168: last_updated_by = decode(p_move_info.last_updated_by,
169: NULL,FND_GLOBAL.USER_ID,
170: FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,
171: p_move_info.last_updated_by),
172: last_update_login = decode(p_move_info.last_update_login,
173: NULL,FND_GLOBAL.LOGIN_ID,

Line 170: FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,

166: FND_API.G_MISS_DATE,SYSDATE,
167: p_move_info.last_update_date),
168: last_updated_by = decode(p_move_info.last_updated_by,
169: NULL,FND_GLOBAL.USER_ID,
170: FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,
171: p_move_info.last_updated_by),
172: last_update_login = decode(p_move_info.last_update_login,
173: NULL,FND_GLOBAL.LOGIN_ID,
174: FND_API.G_MISS_NUM, FND_GLOBAL.LOGIN_ID,

Line 173: NULL,FND_GLOBAL.LOGIN_ID,

169: NULL,FND_GLOBAL.USER_ID,
170: FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,
171: p_move_info.last_updated_by),
172: last_update_login = decode(p_move_info.last_update_login,
173: NULL,FND_GLOBAL.LOGIN_ID,
174: FND_API.G_MISS_NUM, FND_GLOBAL.LOGIN_ID,
175: p_move_info.last_update_login),
176: program_application_id = decode(p_move_info.program_application_id,
177: NULL,program_application_id,

Line 174: FND_API.G_MISS_NUM, FND_GLOBAL.LOGIN_ID,

170: FND_API.G_MISS_NUM,FND_GLOBAL.USER_ID,
171: p_move_info.last_updated_by),
172: last_update_login = decode(p_move_info.last_update_login,
173: NULL,FND_GLOBAL.LOGIN_ID,
174: FND_API.G_MISS_NUM, FND_GLOBAL.LOGIN_ID,
175: p_move_info.last_update_login),
176: program_application_id = decode(p_move_info.program_application_id,
177: NULL,program_application_id,
178: FND_API.G_MISS_NUM,FND_GLOBAL.PROG_APPL_ID,

Line 178: FND_API.G_MISS_NUM,FND_GLOBAL.PROG_APPL_ID,

174: FND_API.G_MISS_NUM, FND_GLOBAL.LOGIN_ID,
175: p_move_info.last_update_login),
176: program_application_id = decode(p_move_info.program_application_id,
177: NULL,program_application_id,
178: FND_API.G_MISS_NUM,FND_GLOBAL.PROG_APPL_ID,
179: p_move_info.program_application_id),
180: program_id = decode(p_move_info.program_id,
181: NULL,program_id,FND_API.G_MISS_NUM,
182: FND_GLOBAL.CONC_PROGRAM_ID,

Line 182: FND_GLOBAL.CONC_PROGRAM_ID,

178: FND_API.G_MISS_NUM,FND_GLOBAL.PROG_APPL_ID,
179: p_move_info.program_application_id),
180: program_id = decode(p_move_info.program_id,
181: NULL,program_id,FND_API.G_MISS_NUM,
182: FND_GLOBAL.CONC_PROGRAM_ID,
183: p_move_info.program_id),
184: program_update_date = decode(p_move_info.program_update_date,
185: NULL,program_update_date,
186: FND_API.G_MISS_DATE,SYSDATE,

Line 190: FND_GLOBAL.CONC_REQUEST_ID,p_move_info.request_id)

186: FND_API.G_MISS_DATE,SYSDATE,
187: p_move_info.program_update_date),
188: request_id = decode(p_move_info.request_id,
189: NULL,request_id,FND_API.G_MISS_NUM,
190: FND_GLOBAL.CONC_REQUEST_ID,p_move_info.request_id)
191: WHERE move_id = p_move_info.move_id;
192:
193: IF (SQL%NOTFOUND) THEN
194: RAISE no_data_found;