DBA Data[Home] [Help]

APPS.PA_BILLING_SETUP_PVT dependencies on FND_GLOBAL

Line 261: LAST_UPDATED_BY = FND_GLOBAL.USER_ID ,

257: RETENTION_INVOICE_FORMAT_ID = p_retention_inv_format_id,
258: RETENTION_PERCENTAGE = l_retention_percent,
259: RETENTION_TAX_CODE = l_retention_output_tax_code,
260: LAST_UPDATE_DATE = SYSDATE ,
261: LAST_UPDATED_BY = FND_GLOBAL.USER_ID ,
262: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
263:
264: /* If job group bill id is changed then update
265: the JOB_BILL_RATE_SCHEDULE_ID to null */

Line 262: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

258: RETENTION_PERCENTAGE = l_retention_percent,
259: RETENTION_TAX_CODE = l_retention_output_tax_code,
260: LAST_UPDATE_DATE = SYSDATE ,
261: LAST_UPDATED_BY = FND_GLOBAL.USER_ID ,
262: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
263:
264: /* If job group bill id is changed then update
265: the JOB_BILL_RATE_SCHEDULE_ID to null */
266:

Line 474: FND_GLOBAL.USER_ID,

470: p_person_id,
471: p_credit_type,
472: p_project_id,
473: sysdate,
474: FND_GLOBAL.USER_ID,
475: sysdate,
476: FND_GLOBAL.USER_ID,
477: FND_GLOBAL.LOGIN_ID,
478: p_effective_from_date,

Line 476: FND_GLOBAL.USER_ID,

472: p_project_id,
473: sysdate,
474: FND_GLOBAL.USER_ID,
475: sysdate,
476: FND_GLOBAL.USER_ID,
477: FND_GLOBAL.LOGIN_ID,
478: p_effective_from_date,
479: p_credit_percentage,
480: l_task_id,

Line 477: FND_GLOBAL.LOGIN_ID,

473: sysdate,
474: FND_GLOBAL.USER_ID,
475: sysdate,
476: FND_GLOBAL.USER_ID,
477: FND_GLOBAL.LOGIN_ID,
478: p_effective_from_date,
479: p_credit_percentage,
480: l_task_id,
481: p_effective_to_date,

Line 762: LAST_UPDATED_BY = FND_GLOBAL.USER_ID ,

758: end_date_active = l_effective_to_date,
759: credit_type_code = p_credit_type,
760: person_id = p_person_id,
761: LAST_UPDATE_DATE = SYSDATE ,
762: LAST_UPDATED_BY = FND_GLOBAL.USER_ID ,
763: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
764: RECORD_VERSION_NUMBER = NVL( RECORD_VERSION_NUMBER, 0 ) + 1
765: WHERE credit_receiver_id = p_credit_receiver_id
766: AND RECORD_VERSION_NUMBER = p_RECORD_VERSION_NUMBER;

Line 763: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

759: credit_type_code = p_credit_type,
760: person_id = p_person_id,
761: LAST_UPDATE_DATE = SYSDATE ,
762: LAST_UPDATED_BY = FND_GLOBAL.USER_ID ,
763: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
764: RECORD_VERSION_NUMBER = NVL( RECORD_VERSION_NUMBER, 0 ) + 1
765: WHERE credit_receiver_id = p_credit_receiver_id
766: AND RECORD_VERSION_NUMBER = p_RECORD_VERSION_NUMBER;
767: ELSE

Line 1161: FND_GLOBAL.USER_ID ,

1157: l_amount ,
1158: l_percent ,
1159: p_active ,
1160: sysdate ,
1161: FND_GLOBAL.USER_ID ,
1162: sysdate ,
1163: FND_GLOBAL.USER_ID ,
1164: FND_GLOBAL.LOGIN_ID ,
1165: null ,

Line 1163: FND_GLOBAL.USER_ID ,

1159: p_active ,
1160: sysdate ,
1161: FND_GLOBAL.USER_ID ,
1162: sysdate ,
1163: FND_GLOBAL.USER_ID ,
1164: FND_GLOBAL.LOGIN_ID ,
1165: null ,
1166: l_rec_proj_all.distribution_rule ,
1167: l_rec_proj_all.org_id ,

Line 1164: FND_GLOBAL.LOGIN_ID ,

1160: sysdate ,
1161: FND_GLOBAL.USER_ID ,
1162: sysdate ,
1163: FND_GLOBAL.USER_ID ,
1164: FND_GLOBAL.LOGIN_ID ,
1165: null ,
1166: l_rec_proj_all.distribution_rule ,
1167: l_rec_proj_all.org_id ,
1168: 1

Line 1419: LAST_UPDATED_BY = FND_GLOBAL.USER_ID ,

1415: AMOUNT = l_amount ,
1416: PERCENTAGE = l_percent ,
1417: ACTIVE_FLAG = p_active ,
1418: LAST_UPDATE_DATE = SYSDATE ,
1419: LAST_UPDATED_BY = FND_GLOBAL.USER_ID ,
1420: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1421: RECORD_VERSION_NUMBER = NVL( RECORD_VERSION_NUMBER, 0 ) + 1
1422: WHERE billing_assignment_id = p_billing_assignment_id
1423: AND RECORD_VERSION_NUMBER = p_record_version_number;

Line 1420: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,

1416: PERCENTAGE = l_percent ,
1417: ACTIVE_FLAG = p_active ,
1418: LAST_UPDATE_DATE = SYSDATE ,
1419: LAST_UPDATED_BY = FND_GLOBAL.USER_ID ,
1420: LAST_UPDATE_LOGIN = FND_GLOBAL.LOGIN_ID,
1421: RECORD_VERSION_NUMBER = NVL( RECORD_VERSION_NUMBER, 0 ) + 1
1422: WHERE billing_assignment_id = p_billing_assignment_id
1423: AND RECORD_VERSION_NUMBER = p_record_version_number;
1424: ELSE