[Home] [Help]
PACKAGE: APPS.JMF_SHIKYU_RPT_SPR_PVT
Source
1 PACKAGE jmf_shikyu_rpt_spr_pvt AS
2 --$Header: JMFVSPRS.pls 120.1 2005/10/19 18:16:30 vchu noship $
3 --+===========================================================================+
4 --| Copyright (c) 2005 Oracle Corporation |
5 --| Redwood Shores, California, USA |
6 --| All rights reserved. |
7 --+===========================================================================+
8 --| |
9 --| FILENAME : JMFVSPRS.pls |
10 --| |
11 --| DESCRIPTION: Specification file of the package for creating |
12 --| temporary data for the SHIKYU Subcontracting |
13 --| Order Report. |
14 --| |
15 --| HISTORY: |
16 --| 28-MAY-2005 fwang Created. |
17 --+===========================================================================+
18 --========================================================================
19 -- PROCEDURE : spr_load_subcontracting_po PUBLIC
20 -- PARAMETERS: p_ou_id operating unit id
21 -- : p_report_type print selection
22 -- : p_po_num_from po number from
23 -- : p_po_num_to po number to
24 -- : p_agent_name_num agent number
25 -- : p_cancel_line print cancel line
26 -- : p_approved_flag approved
27 -- COMMENT : get shikyu subcontracting data and insert into temp table
28 -- PRE-COND :
29 -- EXCEPTIONS:
30 --========================================================================
31 PROCEDURE spr_load_subcontracting_po
32 (
33 p_ou_id IN NUMBER
34 ,p_report_type IN VARCHAR2
35 ,p_po_num_from IN VARCHAR2
36 ,p_po_num_to IN VARCHAR2
37 ,p_agent_name_num IN NUMBER
38 ,p_cancel_line IN VARCHAR2
39 ,p_approved_flag IN VARCHAR2
40 );
41 END jmf_shikyu_rpt_spr_pvt;
42