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 */
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:
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,
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,
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,
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;
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
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 ,
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 ,
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
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;
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