1 PACKAGE ECE_SPSO_TRANS1 AS
2 -- $Header: ECSPSOS.pls 120.2 2005/09/30 05:38:53 arsriniv ship $
3
4 /*===========================================================================
5
6 PROCEDURE NAME: Extract_SPSO_Outbound
7
8 PURPOSE: This procedure initiates the concurrent process to
9 extract the eligible deliveires on a dparture.
10
11 ===========================================================================*/
12 /* Bug 1854866
13 Assigned default values to the parameter
14 v_debug_mode of the procedures
15 extract_spso_outbound and
16 extract_ssso_outbound since the default
17 values are assigned to these parameters
18 in the package body
19 */
20 /* Bug 2064311
21 The parameter batch_id has been added to the
22 procedure specs populate_supplier_sched_api1
23 and api3, update_chv_schedule_headers,Extract_SPSO_Outbound
24 and Extract_SSSO_Outbound to improve performance
25 */
26
27
28 PROCEDURE Extract_SPSO_Outbound (errbuf OUT NOCOPY VARCHAR2,
29 retcode OUT NOCOPY VARCHAR2,
30 cOutput_Path IN VARCHAR2,
31 cOutput_Filename IN VARCHAR2,
32 p_schedule_id IN VARCHAR2 default 0, --2499414
33 v_debug_mode IN NUMBER DEFAULT 0,
34 p_batch_id IN NUMBER default 0); -- Bug 2063617
35 /*===========================================================================
36
37 PROCEDURE NAME: Extract_SSSO_Outbound
38
39 PURPOSE: This procedure initiates the concurrent process to
40 extract the eligible deliveires on a dparture.
41
42 ===========================================================================*/
43
44 PROCEDURE Extract_SSSO_Outbound (errbuf OUT NOCOPY VARCHAR2,
45 retcode OUT NOCOPY VARCHAR2,
46 cOutput_Path IN VARCHAR2,
47 cOutput_Filename IN VARCHAR2,
48 p_schedule_id IN VARCHAR2 default 0, --2499414
49 v_debug_mode IN NUMBER DEFAULT 0,
50 p_batch_id IN NUMBER default 0); -- Bug 2063617
51
52
53 PROCEDURE PUT_DATA_TO_OUTPUT_TABLE(
54 p_communication_method IN VARCHAR2,
55 p_transaction_type IN VARCHAR2, -- plan SPSO, ship SSSO
56 p_output_width IN INTEGER,
57 p_run_id IN INTEGER,
58 p_header_interface IN VARCHAR2 := 'ECE_SPSO_HEADERS',
59 p_item_interface IN VARCHAR2 := 'ECE_SPSO_ITEMS',
60 p_item_d_interface IN VARCHAR2 := 'ECE_SPSO_ITEM_DET',
61 p_ship_d_interface IN VARCHAR2 := 'ECE_SPSO_SHIP_DET'
62 );
63
64
65 /* --------------------------------------------------------------------------*/
66
67 -- PROCEDURE POPULATE_POCO_TRX
68 -- This procedure has the following functionalities:
69 -- 1. Build SQL statement dynamically to extract data from
70 -- Base Application Tables.
71 -- 2. Execute the dynamic SQL statement.
72 -- 3. Assign data into 2-dim PL/SQL table
73 -- 4. Pass data to the code conversion mechanism
74 -- 5. Populate the Interface tables with the extracted data.
75 -- --------------------------------------------------------------------------
76
77 PROCEDURE populate_supplier_sched_api1 (
78 cCommunication_Method IN VARCHAR2,
79 cTransaction_Type IN VARCHAR2,
80 dTransaction_date IN DATE,
81 iRun_id IN INTEGER,
82 p_document_type IN VARCHAR2 := 'SPS', -- plan SPS, ship SSS
83 p_schedule_id IN INTEGER := 0,
84 p_batch_id IN NUMBER default 0, --2499414
85 cHeader_Interface IN VARCHAR2,
86 cItem_Interface IN VARCHAR2,
87 cItem_D_Interface IN VARCHAR2
88 );
89
90 PROCEDURE POPULATE_SUPPLIER_SCHED_API3
91 (
92 p_communication_method IN VARCHAR2, -- EDI
93 p_transaction_type IN VARCHAR2, -- plan SPSO, ship SSSO
94 p_document_type IN VARCHAR2, -- plan SPS, ship SSS
95 p_run_id IN NUMBER,
96 p_schedule_id IN INTEGER default 0, --2499414
97 p_batch_id IN NUMBER default 0 --2499414
98 );
99
100
101 PROCEDURE UPDATE_CHV_SCHEDULE_HEADERS (
102 p_transaction_type IN VARCHAR2,
103 p_schedule_id IN INTEGER := 0,
104 p_batch_id IN NUMBER default 0, --2499414
105 p_edi_count IN NUMBER :=0
106 );
107
108
109 END ECE_SPSO_TRANS1;
110