353: x_err_code := 0;
354: old_stack := x_err_stack;
355: x_err_stack := x_err_stack || '->baseline';
356:
357: x_created_by := FND_GLOBAL.USER_ID;
358: --x_created_by := ( to_number(fnd_profile.value('USER_ID')));
359: x_last_update_login := FND_GLOBAL.LOGIN_ID;
360:
361: -- This call is repeated in PA_BUDGET_UTILS.Verify_Budget_Rules
355: x_err_stack := x_err_stack || '->baseline';
356:
357: x_created_by := FND_GLOBAL.USER_ID;
358: --x_created_by := ( to_number(fnd_profile.value('USER_ID')));
359: x_last_update_login := FND_GLOBAL.LOGIN_ID;
360:
361: -- This call is repeated in PA_BUDGET_UTILS.Verify_Budget_Rules
362: -- as the APIs call that procedure. Using v_emp_id eliminates join
363: -- to fnd_user while inserting record in pa_budget_versions
876: null,null,null,null,
877: 'PA_BUDGET_VERSIONS',
878: x_dest_version_id,
879: null,null,null,null,
880: FND_GLOBAL.USER_ID,
881: FND_GLOBAL.LOGIN_ID,
882: 275, null, null) ;
883: print_msg('End of copy_attachments');
884: -- End copying attachments
877: 'PA_BUDGET_VERSIONS',
878: x_dest_version_id,
879: null,null,null,null,
880: FND_GLOBAL.USER_ID,
881: FND_GLOBAL.LOGIN_ID,
882: 275, null, null) ;
883: print_msg('End of copy_attachments');
884: -- End copying attachments
885: EXCEPTION
964: x_err_code := 0;
965: old_stack := x_err_stack;
966: x_err_stack := x_err_stack || '->copy_without_delete';
967:
968: l_created_by := FND_GLOBAL.USER_ID;
969: l_last_update_login := FND_GLOBAL.LOGIN_ID;
970:
971: savepoint before_copy1;
972:
965: old_stack := x_err_stack;
966: x_err_stack := x_err_stack || '->copy_without_delete';
967:
968: l_created_by := FND_GLOBAL.USER_ID;
969: l_last_update_login := FND_GLOBAL.LOGIN_ID;
970:
971: savepoint before_copy1;
972:
973:
1504: null,null,null,null,
1505: 'PA_BUDGET_VERSIONS',
1506: l_dest_version_id,
1507: null,null,null,null,
1508: FND_GLOBAL.USER_ID,
1509: FND_GLOBAL.LOGIN_ID,
1510: 275, null, null) ;
1511:
1512: -- End copying attachments
1505: 'PA_BUDGET_VERSIONS',
1506: l_dest_version_id,
1507: null,null,null,null,
1508: FND_GLOBAL.USER_ID,
1509: FND_GLOBAL.LOGIN_ID,
1510: 275, null, null) ;
1511:
1512: -- End copying attachments
1513:
1582: x_err_code := 0;
1583: old_stack := x_err_stack;
1584: x_err_stack := x_err_stack || '->copy';
1585:
1586: x_created_by := FND_GLOBAL.USER_ID;
1587: x_last_update_login := FND_GLOBAL.LOGIN_ID;
1588:
1589: x_err_stage := 'get project start date <'
1590: || to_char(x_src_version_id) || '>';
1583: old_stack := x_err_stack;
1584: x_err_stack := x_err_stack || '->copy';
1585:
1586: x_created_by := FND_GLOBAL.USER_ID;
1587: x_last_update_login := FND_GLOBAL.LOGIN_ID;
1588:
1589: x_err_stage := 'get project start date <'
1590: || to_char(x_src_version_id) || '>';
1591:
1912: null,null,null,null,
1913: 'PA_BUDGET_VERSIONS',
1914: x_dest_version_id,
1915: null,null,null,null,
1916: FND_GLOBAL.USER_ID,
1917: FND_GLOBAL.LOGIN_ID,
1918: 275, null, null) ;
1919:
1920: -- End copying attachments
1913: 'PA_BUDGET_VERSIONS',
1914: x_dest_version_id,
1915: null,null,null,null,
1916: FND_GLOBAL.USER_ID,
1917: FND_GLOBAL.LOGIN_ID,
1918: 275, null, null) ;
1919:
1920: -- End copying attachments
1921:
2067: x_err_code := 0;
2068: old_stack := x_err_stack;
2069: x_err_stack := x_err_stack || '->copy_lines';
2070:
2071: x_created_by := FND_GLOBAL.USER_ID;
2072: x_last_update_login := FND_GLOBAL.LOGIN_ID;
2073:
2074: begin
2075: select 'Y'
2068: old_stack := x_err_stack;
2069: x_err_stack := x_err_stack || '->copy_lines';
2070:
2071: x_created_by := FND_GLOBAL.USER_ID;
2072: x_last_update_login := FND_GLOBAL.LOGIN_ID;
2073:
2074: begin
2075: select 'Y'
2076: into l_version_is_baselined