PACKAGE: APPS.PO_PDOI_POSTPROC_PVT

Source

1 PACKAGE PO_PDOI_POSTPROC_PVT AS
2 /* $Header: PO_PDOI_POSTPROC_PVT.pls 120.4 2006/02/17 13:13 bao noship $ */
3 
4 
5 CURSOR c_doc IS
6   SELECT PHI.interface_header_id                   INTERFACE_HEADER_ID,
7          DFT.document_id                           PO_HEADER_ID,
8          PHI.action                                ACTION,
9          PHI.draft_id                              DRAFT_ID,
10          PHI.approval_status                       INTF_AUTH_STATUS,
11          PHI.effective_date                        INTF_START_DATE,
12          PHI.load_sourcing_rules_flag              LOAD_SOURCING_RULES_FLAG,
13          DECODE(POH.type_lookup_code,
14                 'QUOTATION', POH.status_lookup_code,
15                 POH.authorization_status)          ORIG_AUTH_STATUS,
16          POH.conterms_exist_flag                   ORIG_CONTERMS_EXIST_FLAG,
17          POH.user_hold_flag                        ORIG_USER_HOLD_FLAG,
18          PHI.original_po_header_id                 ORIG_PO_HEADER_ID,
19          COALESCE(PHDA.global_agreement_flag,
20                   POH.global_agreement_flag, 'N')  GA_FLAG,
21          NVL(PHDA.agent_id,
22              POH.agent_id)                         AGENT_ID,
23          NVL(PHDA.encumbrance_required_flag,
24              POH.encumbrance_required_flag)        ENCUMBRANCE_REQUIRED_FLAG,
25          NVL(PHDA.conterms_exist_flag,
26              POH.conterms_exist_flag)              CONTERMS_EXIST_FLAG,
27          NVL(PHDA.type_lookup_code,
28              POH.type_lookup_code)                 DOCUMENT_TYPE,
29          NVL(PHDA.quote_type_lookup_code,
30              POH.quote_type_lookup_code)           DOCUMENT_SUBTYPE,
31          NVL(PHDA.segment1,
32              POH.segment1)                         DOCUMENT_NUM,
33          NVL(PHDA.vendor_id,
34              POH.vendor_id)                        VENDOR_ID,
35          NVL(PV1.vendor_name,
36              PV2.vendor_name)                      VENDOR_NAME,
37          NVL2(PHI.document_num, 'Y', 'N')          DOC_NUM_PROVIDED  --bug5028275
38   FROM po_headers_interface PHI,
39        po_headers_draft_all PHDA,
40        po_headers_all       POH,
41        po_drafts            DFT,
42        po_vendors           PV1,
43        po_vendors           PV2
44   WHERE  PHI.draft_id     = DFT.draft_id
45   AND    DFT.draft_id     = PHDA.draft_id(+)
46   AND    DFT.document_id  = PHDA.po_header_id(+)
47   AND    PHDA.vendor_id   = PV1.vendor_id(+)
48   AND    DFT.document_id  = POH.po_header_id(+)
49   AND    POH.vendor_id    = PV2.vendor_id(+)
50   AND    PHI.processing_id = PO_PDOI_PARAMS.g_processing_id
51   AND    PHI.processing_round_num = PO_PDOI_PARAMS.g_current_round_num;
52 
53 SUBTYPE doc_row_type IS c_doc%ROWTYPE;
54 
55 TYPE src_rule_lines_rec_type IS RECORD
56 ( po_line_id_tbl         PO_TBL_NUMBER,
57   item_id_tbl            PO_TBL_NUMBER,
58   category_id_tbl        PO_TBL_NUMBER,
59   interface_line_id_tbl  PO_TBL_NUMBER,
60   sourcing_rule_name_tbl PO_TBL_VARCHAR60,
61   effective_date_tbl     PO_TBL_DATE,
62   expiration_date_tbl    PO_TBL_DATE
63 );
64 
65 PROCEDURE process;
66 
67 END PO_PDOI_POSTPROC_PVT;