[Home] [Help]
PACKAGE: APPS.CS_CHG_AUTO_SUB_CON_PKG
Source
1 PACKAGE CS_Chg_Auto_Sub_CON_PKG AUTHID CURRENT_USER as
2 /* $Header: csxvasus.pls 120.0.12010000.1 2008/07/24 18:46:33 appldev ship $ */
3 --
4 -- *******************************************************
5 -- Start of Comments
6 -- *******************************************************
7 -- Procedure Name: Auto_Submit_Chg_Lines
8 -- Type : Private
9 -- Purpose : This procedure is for identifying lines for Autosubmission.
10 -- It is intended for use by the owning module only.
11 -- Pre-Req :
12 -- Parameters:
13 -- p_api_version IN NUMBER Required
14 -- p_init_msg_list IN VARCHAR2 Optional
15 -- p_commit IN VARCHAR2 Optional
16 -- p_validation_level IN NUMBER Optional
17 -- x_return_status OUT VARCHAR2
18 -- x_msg_count OUT NUMBER
19 -- x_msg_data OUT VARCHAR2
20 --
21 PROCEDURE Auto_Submit_Chg_Lines (
22 p_api_version IN NUMBER,
23 p_init_msg_list IN VARCHAR2,
24 p_commit IN VARCHAR2,
25 x_return_status OUT NOCOPY VARCHAR2,
26 x_msg_count OUT NOCOPY NUMBER,
27 x_msg_data OUT NOCOPY VARCHAR2);
28
29 --
30 -- *******************************************************
31 -- Start of Comments
32 -- *******************************************************
33 -- Procedure Name: MAIN_PROCEDURE
34 -- Type : Private
35 -- Purpose : This is the main procedure to the concurrent program.
36 -- Parameters:
37 -- ERRBUF OUT VARCHAR2
38 -- RETCODE OUT NUMBER
39 --
40 PROCEDURE Main_Procedure(ERRBUF OUT NOCOPY VARCHAR2,
41 RETCODE OUT NOCOPY NUMBER);
42 --
43 --
44 -- *******************************************************
45 -- Start of Comments
46 -- *******************************************************
47 -- Procedure Name: Update_Charge_Lines
48 -- Type : Private
49 -- Purpose : This procedure is for updating charge lines with appropriate
50 -- restriction message.
51 -- Pre-Req :
52 -- Parameters:
53 -- IN
54 -- p_incident_id IN NUMBER
55 -- p_estimate_detail_id IN NUMBER
56 -- p_currency_code IN VARCHAR2
57 -- p_submit_restriction_message IN VARCHAR2
58 -- p_line_submitted IN VARCHAR2
59 -- p_restriction_type IN VARCHAR2
60 -- x_return_status OUT VARCHAR2
61 -- x_msg_data OUT VARCHAR2
62
63
64 PROCEDURE Update_Charge_Lines(p_incident_id NUMBER,
65 p_incident_number VARCHAR2,
66 p_estimate_detail_id NUMBER,
67 p_currency_code VARCHAR2,
68 p_submit_restriction_message VARCHAR2,
69 p_line_submitted VARCHAR2,
70 p_restriction_type VARCHAR2,
71 x_return_status OUT NOCOPY VARCHAR2,
72 x_msg_data OUT NOCOPY VARCHAR2);
73
74 --
75 -- *******************************************************
76 -- Start of Comments
77 -- *******************************************************
78 -- Procedure Name: Submit_Charge_Lines
79 -- Type : Private
80 -- Purpose : This procedure is a wrapper on top of submit order API.
81 -- Pre-Req :
82 -- Parameters:
83 -- p_incident_id IN NUMBER Required
84 -- p_submit_source IN VARCHAR2 Optional
85 -- p_submit_from_system IN VARCHAR2 Optional
86 -- OUT:
87 -- x_return_status OUT NOCOPY VARCHAR2
88 -- x_msg_count OUT NOCOPY NUMBER
89 -- x_msg_data OUT NOCOPY VARCHAR2
90
91
92 PROCEDURE Submit_Charge_Lines(p_incident_id IN NUMBER,
93 x_return_status OUT NOCOPY VARCHAR2,
94 x_msg_count OUT NOCOPY NUMBER,
95 x_msg_data OUT NOCOPY VARCHAR2);
96
97
98
99
100 -- *******************************************************
101 -- Start of Comments
102 -- *******************************************************
103 -- Procedure Name: Check_Debrief_Status
104 -- Type : Private
105 -- Purpose : This procedure is to validate debreif status before submitting to OM.
106 -- Pre-Req :
107 -- Parameters:
108 -- IN
109 -- p_incident_id IN NUMBER
110 -- p_estimate_detail_id IN NUMBER
111 -- p_currency_code IN VARCHAR2
112 -- p_incident_number IN VARCHAR2
113 -- x_restriction_qualify_flag OUT NOCOPY VARCHAR2
114 -- x_return_status OUT VARCHAR2
115 -- x_msg_data OUT VARCHAR2
116
117
118 PROCEDURE Check_Debrief_Status(p_incident_id NUMBER,
119 p_incident_number VARCHAR2,
120 p_estimate_detail_id NUMBER,
121 p_currency_code VARCHAR2,
122 x_restriction_qualify_flag OUT NOCOPY VARCHAR2,
123 x_return_status OUT NOCOPY VARCHAR2,
124 x_msg_data OUT NOCOPY VARCHAR2);
125
126 End CS_Chg_Auto_Sub_CON_PKG;