APPS.PA_BILLING_SCHEDULE_PVT dependencies on PA_TASKS

Line 357: --lock pa_tasks table

353: AND RECORD_VERSION_NUMBER = p_record_version_number;
354:
355: ELSE
356:
357: --lock pa_tasks table
358: IF p_validate_only <> FND_API.G_TRUE
359: THEN
360: BEGIN
361: SELECT 'x' INTO l_dummy_char

Line 362: FROM pa_tasks

358: IF p_validate_only <> FND_API.G_TRUE
359: THEN
360: BEGIN
361: SELECT 'x' INTO l_dummy_char
362: FROM pa_tasks
363: WHERE task_id = l_task_id
364: AND record_version_number = p_record_version_number
365: FOR UPDATE OF record_version_number NOWAIT;
366: EXCEPTION

Line 396: FROM pa_tasks

392: END;
393: ELSE
394: BEGIN
395: SELECT 'x' INTO l_dummy_char
396: FROM pa_tasks
397: WHERE task_id = l_task_id
398: AND record_version_number = p_record_version_number;
399: EXCEPTION
400: WHEN NO_DATA_FOUND THEN

Line 427: UPDATE pa_tasks

423: x_msg_count := l_msg_count;
424: x_return_status := 'E';
425: RAISE FND_API.G_EXC_ERROR;
426: END IF;
427: UPDATE pa_tasks
428: SET LABOR_SCH_TYPE = l_lbr_schedule_type,
429: NON_LABOR_SCH_TYPE = l_non_lbr_schedule_type,
430: EMP_BILL_RATE_SCHEDULE_ID = l_emp_bill_rate_sch_id ,
431: JOB_BILL_RATE_SCHEDULE_ID = l_job_bill_rate_sch_id ,

Line 623: --lock pa_tasks

619: END IF;
620: END;
621: END IF;
622: ELSE
623: --lock pa_tasks
624: IF p_validate_only <> FND_API.G_TRUE
625: THEN
626: BEGIN
627: SELECT 'x' INTO l_dummy_char

Line 628: FROM pa_tasks

624: IF p_validate_only <> FND_API.G_TRUE
625: THEN
626: BEGIN
627: SELECT 'x' INTO l_dummy_char
628: FROM pa_tasks
629: WHERE task_id = l_task_id
630: AND record_version_number = p_record_version_number
631: FOR UPDATE OF record_version_number NOWAIT;
632: EXCEPTION

Line 662: FROM pa_tasks

658: END;
659: ELSE
660: BEGIN
661: SELECT 'x' INTO l_dummy_char
662: FROM pa_tasks
663: WHERE task_id = l_task_id
664: AND record_version_number = p_record_version_number;
665: EXCEPTION
666: WHEN NO_DATA_FOUND THEN

Line 711: UPDATE pa_tasks

707: RECORD_VERSION_NUMBER = NVL( RECORD_VERSION_NUMBER, 0 ) + 1
708: WHERE project_id = p_project_id
709: AND RECORD_VERSION_NUMBER = p_record_version_number;
710: ELSE
711: UPDATE pa_tasks
712: SET LABOR_SCH_TYPE = p_lbr_schedule_type,
713: NON_LABOR_SCH_TYPE = p_non_lbr_schedule_type,
714: REV_IND_RATE_SCH_ID = null,
715: INV_IND_RATE_SCH_ID = null,

Line 737: UPDATE pa_tasks

733: RECORD_VERSION_NUMBER = NVL( RECORD_VERSION_NUMBER, 0 ) + 1
734: WHERE project_id = p_project_id
735: AND RECORD_VERSION_NUMBER = p_record_version_number;
736: ELSE
737: UPDATE pa_tasks
738: SET LABOR_SCH_TYPE = p_lbr_schedule_type,
739: NON_LABOR_SCH_TYPE = p_non_lbr_schedule_type,
740: NON_LABOR_BILL_RATE_ORG_ID = null,
741: NON_LABOR_STD_BILL_RATE_SCHDL = null,

Line 763: UPDATE pa_tasks

759: RECORD_VERSION_NUMBER = NVL( RECORD_VERSION_NUMBER, 0 ) + 1
760: WHERE project_id = p_project_id
761: AND RECORD_VERSION_NUMBER = p_record_version_number;
762: ELSE
763: UPDATE pa_tasks
764: SET LABOR_SCH_TYPE = p_lbr_schedule_type,
765: NON_LABOR_SCH_TYPE = p_non_lbr_schedule_type,
766: EMP_BILL_RATE_SCHEDULE_ID = null,
767: JOB_BILL_RATE_SCHEDULE_ID = null,

Line 793: UPDATE pa_tasks

789: RECORD_VERSION_NUMBER = NVL( RECORD_VERSION_NUMBER, 0 ) + 1
790: WHERE project_id = p_project_id
791: AND RECORD_VERSION_NUMBER = p_record_version_number;
792: ELSE
793: UPDATE pa_tasks
794: SET LABOR_SCH_TYPE = p_lbr_schedule_type,
795: NON_LABOR_SCH_TYPE = p_non_lbr_schedule_type,
796: EMP_BILL_RATE_SCHEDULE_ID = null,
797: JOB_BILL_RATE_SCHEDULE_ID = null,