APPS.PO_APPROVAL_REMINDER_SV dependencies on PO_RELEASES

Line 455: - Open cursor PO_RELEASES table to select

451: PROCEDURE NAME: Process_unapprove_releases
452:
453: DESCRIPTION:
454: This procedure does the following:
455: - Open cursor PO_RELEASES table to select
456: Incomplete or Requires_reapproval documents.
457:
458: - For each unapprove document, initiate the
459: PO Approval Reminder workflow notification.

Line 474: FROM PO_RELEASES_ALL PORH, --

470:
471: CURSOR unapprove_REL IS
472: SELECT PORH.PO_release_ID, POH.Segment1, PORH.release_num,
473: POH.Type_Lookup_Code, PORH.Agent_ID
474: FROM PO_RELEASES_ALL PORH, --
475: PO_HEADERS POH
476: WHERE NVL(PORH.authorization_status,'INCOMPLETE') IN
477: ('INCOMPLETE','REJECTED','REQUIRES REAPPROVAL')
478: -- AND WF_ITEM_TYPE = NULL

Line 1012: FROM PO_RELEASES_ALL PORH, --

1008: CURSOR REL_acceptance IS
1009: SELECT PORH.PO_release_ID, POH.Segment1, PORH.release_num,
1010: POH.Type_Lookup_Code, PORH.Agent_ID,
1011: NVL(PORH.Acceptance_Due_Date, SYSDATE)
1012: FROM PO_RELEASES_ALL PORH, --
1013: PO_HEADERS POH
1014: WHERE NVL(PORH.authorization_status,'INCOMPLETE') = 'APPROVED'
1015: AND NVL(PORH.acceptance_required_flag,'N')= 'Y'
1016: AND NVL(PORH.cancel_flag,'N') = 'N'

Line 1967: FROM PO_RELEASES

1963: ELSE
1964:
1965: SELECT NVL(acceptance_due_date, SYSDATE)
1966: INTO l_acceptance_due_date
1967: FROM PO_RELEASES
1968: WHERE po_release_id = l_doc_header_id;
1969: END IF;
1970:
1971: IF l_acceptance_due_date is not NULL AND

Line 2850: from po_releases_all /*Bug6632095: using base table instead of view */

2846: l_doc_type := 'RELEASE';
2847:
2848: select agent_id
2849: into l_agent_id
2850: from po_releases_all /*Bug6632095: using base table instead of view */
2851: where po_release_id = p_DocumentID;
2852:
2853: --bug#3709971 modified the structure of item key from
2854: --doc_type||doc_subtype||doc_num||agent_id(old structure) to

Line 2917: from po_releases_all /*Bug6632095: using base table instead of view */

2913: l_doc_type := 'RELEASE';
2914:
2915: select agent_id
2916: into l_agent_id
2917: from po_releases_all /*Bug6632095: using base table instead of view */
2918: where po_release_id = p_DocumentID;
2919: --bug#3709971 modified the structure of item key from
2920: --doc_type||doc_subtype||doc_num||agent_id(old structure) to
2921: --doc_type||'-'||doc_subtype||'-'||doc_num||'-'||agent_id

Line 2973: po_releases_all por /*Bug6632095: using base table instead of view */

2969:
2970: select poh.type_lookup_code
2971: into l_doc_subtype
2972: from po_headers_all poh, --
2973: po_releases_all por /*Bug6632095: using base table instead of view */
2974: where por.po_header_id = poh.po_header_id and
2975: por.po_release_id = p_DocumentId;
2976:
2977: if (l_doc_subtype = 'PLANNED') then