173: -- retrieving concurrent program information
174: ------------------------------------------------------------------
175: l_stmt_num := 5;
176:
177: l_request_id := FND_GLOBAL.conc_request_id;
178: l_user_id := FND_GLOBAL.user_id;
179: l_prog_id := FND_GLOBAL.conc_program_id;
180: l_prog_app_id := FND_GLOBAL.prog_appl_id;
181: l_login_id := FND_GLOBAL.conc_login_id;
174: ------------------------------------------------------------------
175: l_stmt_num := 5;
176:
177: l_request_id := FND_GLOBAL.conc_request_id;
178: l_user_id := FND_GLOBAL.user_id;
179: l_prog_id := FND_GLOBAL.conc_program_id;
180: l_prog_app_id := FND_GLOBAL.prog_appl_id;
181: l_login_id := FND_GLOBAL.conc_login_id;
182: l_conc_program_id := FND_GLOBAL.conc_program_id;
175: l_stmt_num := 5;
176:
177: l_request_id := FND_GLOBAL.conc_request_id;
178: l_user_id := FND_GLOBAL.user_id;
179: l_prog_id := FND_GLOBAL.conc_program_id;
180: l_prog_app_id := FND_GLOBAL.prog_appl_id;
181: l_login_id := FND_GLOBAL.conc_login_id;
182: l_conc_program_id := FND_GLOBAL.conc_program_id;
183:
176:
177: l_request_id := FND_GLOBAL.conc_request_id;
178: l_user_id := FND_GLOBAL.user_id;
179: l_prog_id := FND_GLOBAL.conc_program_id;
180: l_prog_app_id := FND_GLOBAL.prog_appl_id;
181: l_login_id := FND_GLOBAL.conc_login_id;
182: l_conc_program_id := FND_GLOBAL.conc_program_id;
183:
184: l_stmt_num := 10;
177: l_request_id := FND_GLOBAL.conc_request_id;
178: l_user_id := FND_GLOBAL.user_id;
179: l_prog_id := FND_GLOBAL.conc_program_id;
180: l_prog_app_id := FND_GLOBAL.prog_appl_id;
181: l_login_id := FND_GLOBAL.conc_login_id;
182: l_conc_program_id := FND_GLOBAL.conc_program_id;
183:
184: l_stmt_num := 10;
185:
178: l_user_id := FND_GLOBAL.user_id;
179: l_prog_id := FND_GLOBAL.conc_program_id;
180: l_prog_app_id := FND_GLOBAL.prog_appl_id;
181: l_login_id := FND_GLOBAL.conc_login_id;
182: l_conc_program_id := FND_GLOBAL.conc_program_id;
183:
184: l_stmt_num := 10;
185:
186: FND_FILE.PUT_LINE(FND_FILE.LOG, 'request_id: '
803: p_downtime_row.instance_id,
804: p_downtime_row.eqp_serial_number,
805: 2, --reduce capacity
806: sysdate, --standard who
807: fnd_global.user_id,
808: sysdate,
809: fnd_global.user_id,
810: fnd_global.login_id,
811: null, null, --descp flex
805: 2, --reduce capacity
806: sysdate, --standard who
807: fnd_global.user_id,
808: sysdate,
809: fnd_global.user_id,
810: fnd_global.login_id,
811: null, null, --descp flex
812: null, null,
813: null, null,
806: sysdate, --standard who
807: fnd_global.user_id,
808: sysdate,
809: fnd_global.user_id,
810: fnd_global.login_id,
811: null, null, --descp flex
812: null, null,
813: null, null,
814: null, null,
1214: DEPARTMENT_ID,
1215: RESOURCE_ID,
1216: SHIFT_NUM,
1217: sysdate,
1218: fnd_global.user_id,
1219: sysdate,
1220: fnd_global.user_id,
1221: fnd_global.login_id,
1222: FROM_DATE,
1216: SHIFT_NUM,
1217: sysdate,
1218: fnd_global.user_id,
1219: sysdate,
1220: fnd_global.user_id,
1221: fnd_global.login_id,
1222: FROM_DATE,
1223: TO_DATE,
1224: FROM_TIME,
1217: sysdate,
1218: fnd_global.user_id,
1219: sysdate,
1220: fnd_global.user_id,
1221: fnd_global.login_id,
1222: FROM_DATE,
1223: TO_DATE,
1224: FROM_TIME,
1225: TO_TIME,