1259: l_last_update_login NUMBER;
1260:
1261: BEGIN
1262:
1263: l_created_by := FND_GLOBAL.USER_ID;
1264: l_creation_date := SYSDATE;
1265: l_last_updated_by := FND_GLOBAL.USER_ID;
1266: l_last_update_date := SYSDATE;
1267: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1261: BEGIN
1262:
1263: l_created_by := FND_GLOBAL.USER_ID;
1264: l_creation_date := SYSDATE;
1265: l_last_updated_by := FND_GLOBAL.USER_ID;
1266: l_last_update_date := SYSDATE;
1267: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1268:
1269: FOR i IN p_Schedule_Details.FIRST..p_Schedule_Details.LAST
1263: l_created_by := FND_GLOBAL.USER_ID;
1264: l_creation_date := SYSDATE;
1265: l_last_updated_by := FND_GLOBAL.USER_ID;
1266: l_last_update_date := SYSDATE;
1267: l_last_update_login := FND_GLOBAL.LOGIN_ID;
1268:
1269: FOR i IN p_Schedule_Details.FIRST..p_Schedule_Details.LAST
1270: LOOP
1271: INSERT INTO CAC_SR_SCHDL_DETAILS