354: x_err_code := 0;
355: old_stack := x_err_stack;
356: x_err_stack := x_err_stack || '->baseline';
357:
358: x_created_by := FND_GLOBAL.USER_ID;
359: --x_created_by := ( to_number(fnd_profile.value('USER_ID')));
360: x_last_update_login := FND_GLOBAL.LOGIN_ID;
361:
362: -- This call is repeated in PA_BUDGET_UTILS.Verify_Budget_Rules
356: x_err_stack := x_err_stack || '->baseline';
357:
358: x_created_by := FND_GLOBAL.USER_ID;
359: --x_created_by := ( to_number(fnd_profile.value('USER_ID')));
360: x_last_update_login := FND_GLOBAL.LOGIN_ID;
361:
362: -- This call is repeated in PA_BUDGET_UTILS.Verify_Budget_Rules
363: -- as the APIs call that procedure. Using v_emp_id eliminates join
364: -- to fnd_user while inserting record in pa_budget_versions
880: null,null,null,null,
881: 'PA_BUDGET_VERSIONS',
882: x_dest_version_id,
883: null,null,null,null,
884: FND_GLOBAL.USER_ID,
885: FND_GLOBAL.LOGIN_ID,
886: 275, null, null) ;
887: print_msg('End of copy_attachments');
888: -- End copying attachments
881: 'PA_BUDGET_VERSIONS',
882: x_dest_version_id,
883: null,null,null,null,
884: FND_GLOBAL.USER_ID,
885: FND_GLOBAL.LOGIN_ID,
886: 275, null, null) ;
887: print_msg('End of copy_attachments');
888: -- End copying attachments
889: EXCEPTION
968: x_err_code := 0;
969: old_stack := x_err_stack;
970: x_err_stack := x_err_stack || '->copy_without_delete';
971:
972: l_created_by := FND_GLOBAL.USER_ID;
973: l_last_update_login := FND_GLOBAL.LOGIN_ID;
974:
975: savepoint before_copy1;
976:
969: old_stack := x_err_stack;
970: x_err_stack := x_err_stack || '->copy_without_delete';
971:
972: l_created_by := FND_GLOBAL.USER_ID;
973: l_last_update_login := FND_GLOBAL.LOGIN_ID;
974:
975: savepoint before_copy1;
976:
977:
1508: null,null,null,null,
1509: 'PA_BUDGET_VERSIONS',
1510: l_dest_version_id,
1511: null,null,null,null,
1512: FND_GLOBAL.USER_ID,
1513: FND_GLOBAL.LOGIN_ID,
1514: 275, null, null) ;
1515:
1516: -- End copying attachments
1509: 'PA_BUDGET_VERSIONS',
1510: l_dest_version_id,
1511: null,null,null,null,
1512: FND_GLOBAL.USER_ID,
1513: FND_GLOBAL.LOGIN_ID,
1514: 275, null, null) ;
1515:
1516: -- End copying attachments
1517:
1586: x_err_code := 0;
1587: old_stack := x_err_stack;
1588: x_err_stack := x_err_stack || '->copy';
1589:
1590: x_created_by := FND_GLOBAL.USER_ID;
1591: x_last_update_login := FND_GLOBAL.LOGIN_ID;
1592:
1593: x_err_stage := 'get project start date <'
1594: || to_char(x_src_version_id) || '>';
1587: old_stack := x_err_stack;
1588: x_err_stack := x_err_stack || '->copy';
1589:
1590: x_created_by := FND_GLOBAL.USER_ID;
1591: x_last_update_login := FND_GLOBAL.LOGIN_ID;
1592:
1593: x_err_stage := 'get project start date <'
1594: || to_char(x_src_version_id) || '>';
1595:
1916: null,null,null,null,
1917: 'PA_BUDGET_VERSIONS',
1918: x_dest_version_id,
1919: null,null,null,null,
1920: FND_GLOBAL.USER_ID,
1921: FND_GLOBAL.LOGIN_ID,
1922: 275, null, null) ;
1923:
1924: -- End copying attachments
1917: 'PA_BUDGET_VERSIONS',
1918: x_dest_version_id,
1919: null,null,null,null,
1920: FND_GLOBAL.USER_ID,
1921: FND_GLOBAL.LOGIN_ID,
1922: 275, null, null) ;
1923:
1924: -- End copying attachments
1925:
2071: x_err_code := 0;
2072: old_stack := x_err_stack;
2073: x_err_stack := x_err_stack || '->copy_lines';
2074:
2075: x_created_by := FND_GLOBAL.USER_ID;
2076: x_last_update_login := FND_GLOBAL.LOGIN_ID;
2077:
2078: begin
2079: select 'Y'
2072: old_stack := x_err_stack;
2073: x_err_stack := x_err_stack || '->copy_lines';
2074:
2075: x_created_by := FND_GLOBAL.USER_ID;
2076: x_last_update_login := FND_GLOBAL.LOGIN_ID;
2077:
2078: begin
2079: select 'Y'
2080: into l_version_is_baselined