APPS.PATC dependencies on PA_TRANSACTION_CONTROLS

Line 233: pa_transaction_controls tc

229: , tc.SCHEDULED_EXP_ONLY
230: , tc.employees_only_flag -- PA.M/CWK changes
231: , tc.workplan_res_only_flag -- PA.M/Task Assignment changes
232: FROM
233: pa_transaction_controls tc
234: WHERE
235: tc.project_id = X_project_id
236: AND ( tc.task_id is null
237: OR

Line 466: FROM pa_transaction_controls

462: INTO dummy
463: FROM dual
464: WHERE EXISTS
465: ( SELECT 1
466: FROM pa_transaction_controls
467: WHERE project_id = X_project_id
468: AND task_id = l_task_id ) ; -- Replaced X_task_id with l_task_id for bug 16220146
469:
470: IF ( dummy = 0 ) THEN

Line 646: From pa_transaction_controls

642:
643: If p_task_id is not null then
644:
645: SELECT count(1) INTO l_tc_count
646: From pa_transaction_controls
647: WHERE project_id = p_project_id
648: AND task_id = p_task_id;
649:
650: Else

Line 653: From pa_transaction_controls

649:
650: Else
651:
652: SELECT count(1) INTO l_tc_count
653: From pa_transaction_controls
654: WHERE project_id = p_project_id
655: AND task_id is NULL; --Added for the bug 12915555
656:
657: End If;

Line 668: From pa_transaction_controls

664:
665: print_message(' p '||p_project_id||' t '||p_task_id);
666:
667: SELECT 1 INTO TC_EXISTS
668: From pa_transaction_controls
669: WHERE project_id = p_project_id
670: AND task_id = p_task_id
671: AND (expenditure_category IS NOT NULL OR expenditure_type IS NOT NULL)
672: AND person_id IS NULL

Line 679: FROM pa_transaction_controls

675:
676: ELSE
677:
678: SELECT 1 INTO TC_EXISTS
679: FROM pa_transaction_controls
680: WHERE project_id = p_project_id
681: AND task_id is NULL
682: AND (expenditure_category IS NOT NULL OR expenditure_type IS NOT NULL)
683: AND person_id IS NULL

Line 699: FROM pa_transaction_controls

695:
696: print_message(' p '||p_project_id||' t '||p_task_id);
697:
698: SELECT 1 INTO TC_EXISTS
699: FROM pa_transaction_controls
700: WHERE project_id = p_project_id
701: AND task_id = p_task_id
702: -- Commented for bug 4585740
703: -- AND (expenditure_category IS NOT NULL OR expenditure_type IS NOT NULL)

Line 710: FROM pa_transaction_controls

706:
707: ELSE
708:
709: SELECT 1 INTO TC_EXISTS
710: FROM pa_transaction_controls
711: WHERE project_id = p_project_id
712: AND task_id is NULL
713: -- Commented for bug 4585740
714: -- AND (expenditure_category IS NOT NULL OR expenditure_type IS NOT NULL)