DBA Data[Home] [Help]

APPS.PA_BILLING_CORE dependencies on FND_GLOBAL

Line 581: x_created_by := FND_GLOBAL.USER_ID;

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 <'

Line 582: x_last_update_login := FND_GLOBAL.LOGIN_ID;

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) || '>';

Line 1154: fnd_global.user_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,

Line 1156: fnd_global.user_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,

Line 1157: fnd_global.login_id,

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 */

Line 1301: sysdate last_update_date, fnd_global.user_id last_updated_by,

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,

Line 1302: sysdate creation_date, fnd_global.user_id created_by,

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 */

Line 1303: fnd_global.login_id last_update_login,

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 */

Line 1336: sysdate last_update_date, fnd_global.user_id last_updated_by,

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,

Line 1337: sysdate creation_date, fnd_global.user_id created_by,

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,

Line 1338: fnd_global.login_id last_update_login,

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,

Line 1736: fnd_global.login_id,

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,

Line 1738: 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,

Line 1740: fnd_global.user_id,

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),