1 PACKAGE CSD_REPAIR_ACTUAL_PROCESS_PVT AUTHID CURRENT_USER as
2 /* $Header: csdactps.pls 120.1 2008/05/23 23:12:34 swai ship $ csdactps.pls */
3 -- ---------------------------------------------------------
4 -- Define global variables
5 -- ---------------------------------------------------------
6 G_PKG_NAME CONSTANT VARCHAR2(30) := 'CSD_REPAIR_ACTUAL_PROCESS_PVT';
7 G_FILE_NAME CONSTANT VARCHAR2(12) := 'csdactps.pls';
8 G_MSG_MODULE_CODE_ACT CONSTANT VARCHAR2(5) := 'ACT';
9
10 /*--------------------------------------------------------------------*/
11 /* procedure name: Import_Actuals_From_Task */
12 /* description : Procedure is used to import Task debrief lines into */
13 /* repair actual lines. We only create links to */
14 /* existing charge lines for the debrief lines. The */
15 /* links are represented in repair actual lines table. */
16 /* No new charge lines are created. */
17 /* */
18 /* Called from : Depot Repair Actuals UI */
19 /* */
20 /* x_warning_flag - This flag communicates to the calling procedure */
21 /* whether there are any messages logged that can be */
22 /* displayed to the user. If the value is G_TRUE */
23 /* then it indicates that one or more message have */
24 /* been logged. */
25 /*--------------------------------------------------------------------*/
26
27 PROCEDURE Import_Actuals_From_Task
28 (
29 p_api_version IN NUMBER,
30 p_commit IN VARCHAR2,
31 p_init_msg_list IN VARCHAR2,
32 p_validation_level IN NUMBER,
33 x_return_status OUT NOCOPY VARCHAR2,
34 x_msg_count OUT NOCOPY NUMBER,
35 x_msg_data OUT NOCOPY VARCHAR2,
36 p_repair_line_id IN NUMBER,
37 p_repair_actual_id IN NUMBER,
38 x_warning_flag OUT NOCOPY VARCHAR2
39 );
40
41 /*--------------------------------------------------------------------*/
42 /* procedure name: Import_Actuals_From_Wip */
43 /* description : Procedure is used to import WIP debrief lines into */
44 /* repair actual lines. We consider material and */
45 /* resource transactions to create charge/repair actual */
46 /* lines. */
47 /* */
48 /* Called from : Depot Repair Actuals UI */
49 /* */
50 /* x_warning_flag - This flag communicates to the calling procedure */
51 /* whether there are any messages logged that can be */
52 /* displayed to the user. If the value is G_TRUE */
53 /* then it indicates that one or more message have */
54 /* been logged. */
55 /*--------------------------------------------------------------------*/
56
57 PROCEDURE Import_Actuals_From_Wip (
58 p_api_version IN NUMBER,
59 p_commit IN VARCHAR2,
60 p_init_msg_list IN VARCHAR2,
61 p_validation_level IN NUMBER,
62 x_return_status OUT NOCOPY VARCHAR2,
63 x_msg_count OUT NOCOPY NUMBER,
64 x_msg_data OUT NOCOPY VARCHAR2,
65 p_repair_line_id IN NUMBER,
66 p_repair_actual_id IN NUMBER,
67 p_repair_type_id IN NUMBER,
68 p_business_process_id IN NUMBER,
69 p_currency_code IN VARCHAR2,
70 p_incident_id IN NUMBER,
71 p_organization_id IN NUMBER,
72 x_warning_flag OUT NOCOPY VARCHAR2
73 );
74
75 /*--------------------------------------------------------------------*/
76 /* procedure name: Import_Actuals_From_Estimate */
77 /* description : Procedure is used to import Estimates lines into */
81 /* Called from : Depot Repair Actuals UI */
78 /* repair actual lines. Creates new charge lines and */
79 /* corresponding repair actual lines. */
80 /* */
82 /* */
83 /* x_warning_flag - This flag communicates to the calling procedure */
84 /* whether there are any messages logged that can be */
85 /* displayed to the user. If the value is G_TRUE */
86 /* then it indicates that one or more message have */
87 /* been logged. */
88 /*--------------------------------------------------------------------*/
89
90 PROCEDURE Import_Actuals_From_Estimate
91 (
92 p_api_version IN NUMBER,
93 p_commit IN VARCHAR2,
94 p_init_msg_list IN VARCHAR2,
95 p_validation_level IN NUMBER,
96 x_return_status OUT NOCOPY VARCHAR2,
97 x_msg_count OUT NOCOPY NUMBER,
98 x_msg_data OUT NOCOPY VARCHAR2,
99 p_repair_line_id IN NUMBER,
100 p_repair_actual_id IN NUMBER,
101 x_warning_flag OUT NOCOPY VARCHAR2
102 );
103
104 /*--------------------------------------------------------------------*/
105 /* procedure name: Convert_MLE_To_Actuals */
106 /* description : Procedure is used to convert table of records from */
107 /* MLE table format to repair actual lines format. */
108 /* */
109 /* Called from : Import_Actuals_From_Wip */
110 /* */
111 /*--------------------------------------------------------------------*/
112
113 PROCEDURE Convert_MLE_To_Actuals ( p_MLE_lines_tbl IN CSD_CHARGE_LINE_UTIL. MLE_LINES_TBL_TYPE,
114 p_repair_line_id IN NUMBER,
115 p_repair_actual_id IN NUMBER,
116 x_actual_lines_tbl IN OUT NOCOPY CSD_REPAIR_ACTUAL_LINES_PVT.CSD_ACTUAL_LINES_TBL_TYPE
117 );
118
119
120 /*--------------------------------------------------------------------*/
121 /* procedure name: Get_Default_Third_Party_Info */
122 /* description : Procedure is used to get the default bill and ship */
123 /* information from the repair actual header. If no */
124 /* header is found, defaults are gotten from the SR */
125 /* */
126 /* Called from : Get_Default_Third_Party_Info */
127 /* */
128 /*--------------------------------------------------------------------*/
129 PROCEDURE Get_Default_Third_Party_Info (p_repair_line_id IN NUMBER,
130 x_bill_to_account_id OUT NOCOPY NUMBER,
131 x_bill_to_party_id OUT NOCOPY NUMBER,
132 x_bill_to_party_site_id OUT NOCOPY NUMBER,
133 x_ship_to_account_id OUT NOCOPY NUMBER,
134 x_ship_to_party_id OUT NOCOPY NUMBER,
135 x_ship_to_party_site_id OUT NOCOPY NUMBER
136 );
137
138
139 End CSD_REPAIR_ACTUAL_PROCESS_PVT;