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.PA_AP_INTEGRATION dependencies on PATC

Line 836: /* The cursor for getting all the variables to be passed to the patc.get_status proc. The use of ap_invoices_all is not done here as we dont have the invoice id being passed by AP */

832: from po_distributions_all
833: where po_distribution_id = p_po_distribution_id ;
834:
835:
836: /* The cursor for getting all the variables to be passed to the patc.get_status proc. The use of ap_invoices_all is not done here as we dont have the invoice id being passed by AP */
837: cursor patc_cursor is
838: select
839: POD.project_id PROJECT_ID,
840: POD.task_id TASK_ID,

Line 837: cursor patc_cursor is

833: where po_distribution_id = p_po_distribution_id ;
834:
835:
836: /* The cursor for getting all the variables to be passed to the patc.get_status proc. The use of ap_invoices_all is not done here as we dont have the invoice id being passed by AP */
837: cursor patc_cursor is
838: select
839: POD.project_id PROJECT_ID,
840: POD.task_id TASK_ID,
841: decode(NVL(FND_PROFILE.VALUE('PA_AP_EI_DATE_DEFAULT'),'POTRNSDT'),

Line 970: /* Open and fetch the cursor into the local variables defined. We pass these variables into patc.get_status */

966:
967: END IF;
968:
969:
970: /* Open and fetch the cursor into the local variables defined. We pass these variables into patc.get_status */
971:
972: OPEN patc_cursor;
973: FETCH patc_cursor INTO
974: V_PROJECT_ID,

Line 972: OPEN patc_cursor;

968:
969:
970: /* Open and fetch the cursor into the local variables defined. We pass these variables into patc.get_status */
971:
972: OPEN patc_cursor;
973: FETCH patc_cursor INTO
974: V_PROJECT_ID,
975: V_TASK_ID,
976: V_PROFILE_DATE,

Line 973: FETCH patc_cursor INTO

969:
970: /* Open and fetch the cursor into the local variables defined. We pass these variables into patc.get_status */
971:
972: OPEN patc_cursor;
973: FETCH patc_cursor INTO
974: V_PROJECT_ID,
975: V_TASK_ID,
976: V_PROFILE_DATE,
977: V_EXPENDITURE_TYPE,

Line 1010: CLOSE patc_cursor;

1006: V_ATTRIBUTE12,
1007: V_ATTRIBUTE13,
1008: V_ATTRIBUTE14,
1009: V_ATTRIBUTE15;
1010: CLOSE patc_cursor;
1011:
1012: /* Call the standard proc patc.get_status and collect the output 14057813*/
1013: PATC.GET_STATUS(
1014: X_PROJECT_ID => V_PROJECT_ID,

Line 1012: /* Call the standard proc patc.get_status and collect the output 14057813*/

1008: V_ATTRIBUTE14,
1009: V_ATTRIBUTE15;
1010: CLOSE patc_cursor;
1011:
1012: /* Call the standard proc patc.get_status and collect the output 14057813*/
1013: PATC.GET_STATUS(
1014: X_PROJECT_ID => V_PROJECT_ID,
1015: X_TASK_ID => V_TASK_ID,
1016: X_EI_DATE => V_PROFILE_DATE,

Line 1013: PATC.GET_STATUS(

1009: V_ATTRIBUTE15;
1010: CLOSE patc_cursor;
1011:
1012: /* Call the standard proc patc.get_status and collect the output 14057813*/
1013: PATC.GET_STATUS(
1014: X_PROJECT_ID => V_PROJECT_ID,
1015: X_TASK_ID => V_TASK_ID,
1016: X_EI_DATE => V_PROFILE_DATE,
1017: X_EXPENDITURE_TYPE => V_EXPENDITURE_TYPE,