577: x_err_code := 0;
578: old_stack := x_err_stack;
579: x_err_stack := 'pa_billing_core->update_funding';
580:
581: x_created_by := FND_GLOBAL.USER_ID;
582: x_last_update_login := FND_GLOBAL.LOGIN_ID;
583:
584: -- set project level funding flag
585: x_err_stage := 'set project level funding flag <'
578: old_stack := x_err_stack;
579: x_err_stack := 'pa_billing_core->update_funding';
580:
581: x_created_by := FND_GLOBAL.USER_ID;
582: x_last_update_login := FND_GLOBAL.LOGIN_ID;
583:
584: -- set project level funding flag
585: x_err_stage := 'set project level funding flag <'
586: || to_char(x_project_id) || '>';
1150: nvl(x_customer_id, a.customer_id),
1151: p.segment1,
1152: a.agreement_type,
1153: sysdate,
1154: fnd_global.user_id,
1155: sysdate,
1156: fnd_global.user_id,
1157: fnd_global.login_id,
1158: a.owned_by_person_id,
1152: a.agreement_type,
1153: sysdate,
1154: fnd_global.user_id,
1155: sysdate,
1156: fnd_global.user_id,
1157: fnd_global.login_id,
1158: a.owned_by_person_id,
1159: a.term_id,
1160: a.revenue_limit_flag,
1153: sysdate,
1154: fnd_global.user_id,
1155: sysdate,
1156: fnd_global.user_id,
1157: fnd_global.login_id,
1158: a.owned_by_person_id,
1159: a.term_id,
1160: a.revenue_limit_flag,
1161: nvl(l_amount, a.amount), /* MCB2 change */
1297:
1298: /* MCB2 code begins */
1299: cursor tmp_proj_funding is
1300: SELECT pa_project_fundings_s.nextval project_funding_id ,
1301: sysdate last_update_date, fnd_global.user_id last_updated_by,
1302: sysdate creation_date, fnd_global.user_id created_by,
1303: fnd_global.login_id last_update_login,
1304: x_agreement_id agreement_id, x_new_project_id project_id,
1305: NULL task_id, 'DRAFT' budget_type_code,
1298: /* MCB2 code begins */
1299: cursor tmp_proj_funding is
1300: SELECT pa_project_fundings_s.nextval project_funding_id ,
1301: sysdate last_update_date, fnd_global.user_id last_updated_by,
1302: sysdate creation_date, fnd_global.user_id created_by,
1303: fnd_global.login_id last_update_login,
1304: x_agreement_id agreement_id, x_new_project_id project_id,
1305: NULL task_id, 'DRAFT' budget_type_code,
1306: /* l_allocated_amount allocated_amount, Commented code for bug 2793120 */
1299: cursor tmp_proj_funding is
1300: SELECT pa_project_fundings_s.nextval project_funding_id ,
1301: sysdate last_update_date, fnd_global.user_id last_updated_by,
1302: sysdate creation_date, fnd_global.user_id created_by,
1303: fnd_global.login_id last_update_login,
1304: x_agreement_id agreement_id, x_new_project_id project_id,
1305: NULL task_id, 'DRAFT' budget_type_code,
1306: /* l_allocated_amount allocated_amount, Commented code for bug 2793120 */
1307: NVL(r_amount,f.allocated_amount) allocated_amount, /* Added for bug 2793120 */ /* Modified for bug 2913524 */
1332: proj_rec tmp_proj_funding%ROWTYPE;
1333:
1334: cursor tmp_task_funding is
1335: SELECT pa_project_fundings_s.nextval project_funding_id ,
1336: sysdate last_update_date, fnd_global.user_id last_updated_by,
1337: sysdate creation_date, fnd_global.user_id created_by,
1338: fnd_global.login_id last_update_login,
1339: x_agreement_id agreement_id, x_new_project_id project_id,
1340: t2.task_id task_id, 'DRAFT' budget_type_code,
1333:
1334: cursor tmp_task_funding is
1335: SELECT pa_project_fundings_s.nextval project_funding_id ,
1336: sysdate last_update_date, fnd_global.user_id last_updated_by,
1337: sysdate creation_date, fnd_global.user_id created_by,
1338: fnd_global.login_id last_update_login,
1339: x_agreement_id agreement_id, x_new_project_id project_id,
1340: t2.task_id task_id, 'DRAFT' budget_type_code,
1341: f.allocated_amount allocated_amount,
1334: cursor tmp_task_funding is
1335: SELECT pa_project_fundings_s.nextval project_funding_id ,
1336: sysdate last_update_date, fnd_global.user_id last_updated_by,
1337: sysdate creation_date, fnd_global.user_id created_by,
1338: fnd_global.login_id last_update_login,
1339: x_agreement_id agreement_id, x_new_project_id project_id,
1340: t2.task_id task_id, 'DRAFT' budget_type_code,
1341: f.allocated_amount allocated_amount,
1342: f.date_allocated + nvl(x_delta, 0) date_allocated,
1732: task_id,
1733: 0,
1734: nvl(sum(nvl(allocated_amount, 0)), 0),
1735: 0, 0,
1736: fnd_global.login_id,
1737: sysdate,
1738: fnd_global.user_id,
1739: sysdate,
1740: fnd_global.user_id,
1734: nvl(sum(nvl(allocated_amount, 0)), 0),
1735: 0, 0,
1736: fnd_global.login_id,
1737: sysdate,
1738: fnd_global.user_id,
1739: sysdate,
1740: fnd_global.user_id,
1741: funding_currency_code,
1742: project_currency_code,
1736: fnd_global.login_id,
1737: sysdate,
1738: fnd_global.user_id,
1739: sysdate,
1740: fnd_global.user_id,
1741: funding_currency_code,
1742: project_currency_code,
1743: 0,
1744: nvl(sum(nvl(project_allocated_amount, 0)), 0),