438: VALUES (
439: p_instance_id,
440: 2, /* used partition */
441: sysdate,
442: FND_GLOBAL.USER_ID,
443: sysdate,
444: FND_GLOBAL.USER_ID,
445: FND_GLOBAL.LOGIN_ID
446: );
440: 2, /* used partition */
441: sysdate,
442: FND_GLOBAL.USER_ID,
443: sysdate,
444: FND_GLOBAL.USER_ID,
445: FND_GLOBAL.LOGIN_ID
446: );
447:
448: COMMIT;
441: sysdate,
442: FND_GLOBAL.USER_ID,
443: sysdate,
444: FND_GLOBAL.USER_ID,
445: FND_GLOBAL.LOGIN_ID
446: );
447:
448: COMMIT;
449:
592: l_plan_id := -1;
593: return l_plan_id;
594: end if;
595:
596: X_user_id := to_number(FND_GLOBAL.User_Id);
597: X_Login_Id := to_number(FND_GLOBAL.Login_Id);
598:
599: begin
600: INSERT INTO MSC_PLAN_PARTITIONS (
593: return l_plan_id;
594: end if;
595:
596: X_user_id := to_number(FND_GLOBAL.User_Id);
597: X_Login_Id := to_number(FND_GLOBAL.Login_Id);
598:
599: begin
600: INSERT INTO MSC_PLAN_PARTITIONS (
601: PLAN_ID,
1541: end if;
1542:
1543:
1544:
1545: X_user_id := to_number(FND_GLOBAL.User_Id);
1546: X_Login_Id := to_number(FND_GLOBAL.Login_Id);
1547:
1548:
1549: begin
1542:
1543:
1544:
1545: X_user_id := to_number(FND_GLOBAL.User_Id);
1546: X_Login_Id := to_number(FND_GLOBAL.Login_Id);
1547:
1548:
1549: begin
1550: INSERT INTO MSC_PLAN_PARTITIONS (