487: VALUES (
488: p_instance_id,
489: 2, /* used partition */
490: sysdate,
491: FND_GLOBAL.USER_ID,
492: sysdate,
493: FND_GLOBAL.USER_ID,
494: FND_GLOBAL.LOGIN_ID
495: );
489: 2, /* used partition */
490: sysdate,
491: FND_GLOBAL.USER_ID,
492: sysdate,
493: FND_GLOBAL.USER_ID,
494: FND_GLOBAL.LOGIN_ID
495: );
496:
497: COMMIT;
490: sysdate,
491: FND_GLOBAL.USER_ID,
492: sysdate,
493: FND_GLOBAL.USER_ID,
494: FND_GLOBAL.LOGIN_ID
495: );
496:
497: COMMIT;
498:
641: l_plan_id := -1;
642: return l_plan_id;
643: end if;
644:
645: X_user_id := to_number(FND_GLOBAL.User_Id);
646: X_Login_Id := to_number(FND_GLOBAL.Login_Id);
647:
648: begin
649: INSERT INTO MSC_PLAN_PARTITIONS (
642: return l_plan_id;
643: end if;
644:
645: X_user_id := to_number(FND_GLOBAL.User_Id);
646: X_Login_Id := to_number(FND_GLOBAL.Login_Id);
647:
648: begin
649: INSERT INTO MSC_PLAN_PARTITIONS (
650: PLAN_ID,
1595: end if;
1596:
1597:
1598:
1599: X_user_id := to_number(FND_GLOBAL.User_Id);
1600: X_Login_Id := to_number(FND_GLOBAL.Login_Id);
1601:
1602:
1603: begin
1596:
1597:
1598:
1599: X_user_id := to_number(FND_GLOBAL.User_Id);
1600: X_Login_Id := to_number(FND_GLOBAL.Login_Id);
1601:
1602:
1603: begin
1604: INSERT INTO MSC_PLAN_PARTITIONS (