eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMS_AWARDS_BOUNDARY_DATES_CHK dependencies on PA_TASKS

Line 542: P_TASK_ID IN PA_TASKS.TASK_ID%TYPE DEFAULT NULL) IS /* Bug# 4138033 */

538:
539: Procedure validate_proj_start_date( P_PROJECT_ID IN NUMBER,
540: P_START_DATE IN DATE,
541: X_MESSAGE OUT NOCOPY VARCHAR2,
542: P_TASK_ID IN PA_TASKS.TASK_ID%TYPE DEFAULT NULL) IS /* Bug# 4138033 */
543:
544:
545: CURSOR budget_lines_csr IS
546: SELECT 1

Line 568: /* pa_tasks tsk 4138033 */

564: FROM DUAL
565: WHERE EXISTS
566: (SELECT 'X'
567: FROM pa_expenditure_items_all exp
568: /* pa_tasks tsk 4138033 */
569: WHERE /*exp.task_id = tsk.task_id
570: AND */ exp.project_id = P_PROJECT_ID
571: and exp.task_id = nvl(P_TASK_ID, exp.task_id)
572: AND exp.expenditure_item_date < P_START_DATE) ;

Line 580: pa_tasks tsk

576: FROM DUAL
577: WHERE EXISTS
578: (SELECT 'X'
579: FROM gms_encumbrance_items_all enc,
580: pa_tasks tsk
581: WHERE enc.task_id = tsk.task_id
582: AND tsk.project_id = P_PROJECT_ID
583: AND tsk.task_id = nvl(P_TASK_ID, tsk.task_id)
584: -- ==============================================================

Line 605: pa_tasks tsk

601: WHERE EXISTS
602: (SELECT 'X'
603: FROM gms_encumbrance_items_all enc1,
604: gms_encumbrance_items_all enc2,
605: pa_tasks tsk
606: WHERE enc1.task_id = tsk.task_id
607: AND enc2.adjusted_encumbrance_item_id = enc1.encumbrance_item_id
608: AND NVL(enc1.net_zero_adjustment_flag,'N') = 'Y'
609: AND NVL(enc2.net_zero_adjustment_flag,'N') = 'Y'

Line 624: pa_tasks tsk

620: WHERE EXISTS
621: (SELECT 'X'
622: FROM gms_encumbrance_items_all enc1,
623: -- gms_encumbrance_items_all enc2,
624: pa_tasks tsk
625: WHERE enc1.task_id = tsk.task_id
626: -- AND enc2.adjusted_encumbrance_item_id =enc1.encumbrance_item_id
627: AND NVL(enc1.net_zero_adjustment_flag,'N') = 'Y'
628: -- AND NVL(enc2.net_zero_adjustment_flag,'N') = 'Y'

Line 648: --Bug 3985177 : Removed pa_tasks join in po_items_csr

644: AND po.expenditure_item_date < P_START_DATE
645: AND po.po_line_id = pol.po_line_id --Bug 8431879
646: AND nvl(cancel_flag,'N') <> 'Y' ) ;
647:
648: --Bug 3985177 : Removed pa_tasks join in po_items_csr
649:
650: CURSOR ap_items_csr IS
651: SELECT 1
652: FROM DUAL

Line 663: --Bug 3985177 : Removed pa_tasks join in ap_items_csr

659: AND ap.expenditure_item_date < P_START_DATE
660: AND ap.invoice_id = ai.invoice_id --Bug 8431879
661: AND ai.cancelled_date is null ) ;
662:
663: --Bug 3985177 : Removed pa_tasks join in ap_items_csr
664:
665: CURSOR req_items_csr IS
666: SELECT 1
667: FROM DUAL

Line 678: --Bug 3985177 : Removed pa_tasks join in req_items_csr

674: AND req.expenditure_item_date < P_START_DATE
675: AND req.requisition_line_id = pol.requisition_line_id --Bug 8431879
676: AND nvl(pol.cancel_flag,'N') <> 'Y') ;
677:
678: --Bug 3985177 : Removed pa_tasks join in req_items_csr
679:
680: CURSOR budget_lines_exist_csr IS
681: SELECT 1
682: FROM DUAL

Line 830: P_TASK_ID IN PA_TASKS.TASK_ID%TYPE DEFAULT NULL) IS /* Bug# 4138033 */

826:
827: Procedure validate_proj_completion_date( P_PROJECT_ID IN NUMBER,
828: P_COMPLETION_DATE IN DATE,
829: X_MESSAGE OUT NOCOPY VARCHAR2,
830: P_TASK_ID IN PA_TASKS.TASK_ID%TYPE DEFAULT NULL) IS /* Bug# 4138033 */
831:
832: CURSOR budget_lines_csr IS
833: SELECT 1
834: FROM gms_budget_versions pbv,

Line 850: /* pa_tasks tsk */

846: FROM DUAL
847: WHERE EXISTS
848: (SELECT 'X'
849: FROM pa_expenditure_items_all exp
850: /* pa_tasks tsk */
851: WHERE /* exp.task_id = tsk.task_id
852: AND */ exp.project_id = P_PROJECT_ID
853: AND exp.task_id = nvl(P_TASK_ID, exp.task_id)
854: AND exp.expenditure_item_date > P_COMPLETION_DATE) ;

Line 862: pa_tasks tsk

858: FROM DUAL
859: WHERE EXISTS
860: (SELECT 'X'
861: FROM gms_encumbrance_items_all enc,
862: pa_tasks tsk
863: WHERE enc.task_id = tsk.task_id
864: AND tsk.project_id = P_PROJECT_ID
865: AND tsk.task_id = nvl(P_TASK_ID, tsk.task_id)
866: -- ==============================================================

Line 886: pa_tasks tsk

882: WHERE EXISTS
883: (SELECT 'X'
884: FROM gms_encumbrance_items_all enc1,
885: gms_encumbrance_items_all enc2,
886: pa_tasks tsk
887: WHERE enc1.task_id = tsk.task_id
888: AND enc2.adjusted_encumbrance_item_id = enc1.encumbrance_item_id
889: AND NVL(enc1.net_zero_adjustment_flag,'N') = 'Y'
890: AND NVL(enc2.net_zero_adjustment_flag,'N') = 'Y'

Line 907: pa_tasks tsk

903: WHERE EXISTS
904: (SELECT 'X'
905: FROM gms_encumbrance_items_all enc1,
906: -- gms_encumbrance_items_all enc2,
907: pa_tasks tsk
908: WHERE enc1.task_id = tsk.task_id
909: -- AND enc2.adjusted_encumbrance_item_id =enc1.encumbrance_item_id
910: AND NVL(enc1.net_zero_adjustment_flag,'N') = 'Y'
911: -- AND NVL(enc2.net_zero_adjustment_flag,'N') = 'Y'

Line 931: --Bug 3985177 : Removed pa_tasks join in po_items_csr

927: AND po.expenditure_item_date > P_COMPLETION_DATE
928: AND po.po_line_id = pol.po_line_id --Bug 8431879
929: AND nvl(cancel_flag,'N') <> 'Y') ;
930:
931: --Bug 3985177 : Removed pa_tasks join in po_items_csr
932:
933: CURSOR ap_items_csr IS
934: SELECT 1
935: FROM DUAL

Line 947: --Bug 3985177 : Removed pa_tasks join in ap_items_csr

943: AND ap.invoice_id = ai.invoice_id --Bug 8431879
944: AND ai.cancelled_date is null) ;
945:
946:
947: --Bug 3985177 : Removed pa_tasks join in ap_items_csr
948:
949: CURSOR req_items_csr IS
950: SELECT 1
951: FROM DUAL

Line 962: --Bug 3985177 : Removed pa_tasks join in req_items_csr

958: AND req.expenditure_item_date > P_COMPLETION_DATE
959: AND req.requisition_line_id = pol.requisition_line_id --Bug 8431879
960: AND nvl(pol.cancel_flag,'N') <> 'Y') ;
961:
962: --Bug 3985177 : Removed pa_tasks join in req_items_csr
963:
964: l_budget_lines NUMBER ;
965: l_exp_items NUMBER ;
966: l_enc_items NUMBER ;