[Home] [Help]
PACKAGE: APPS.CSD_SPLIT_PKG
Source
1 PACKAGE CSD_SPLIT_PKG as
2 /* $Header: csdsplts.pls 120.1 2005/09/19 16:46:57 takwong noship $ */
3 -- Start of Comments
4 -- Package name : CSD_SPLIT_PKG
5 -- Purpose :
6 -- History :
7 -- NOTE :
8 -- End of Comments
9
10
11 PROCEDURE Split_Repair_Order (
12 p_api_version IN NUMBER,
13 p_init_msg_list IN VARCHAR2,
14 p_commit IN VARCHAR2,
15 p_validation_level IN NUMBER,
16 x_return_status OUT NOCOPY VARCHAR2,
17 x_msg_count OUT NOCOPY NUMBER,
18 x_msg_data OUT NOCOPY VARCHAR2,
19 p_original_repair_line_id IN NUMBER,
20 p_split_option IN NUMBER,
21 p_copy_attachment IN VARCHAR2,
22 p_attachment_counts IN NUMBER,
23 p_new_quantity IN NUMBER,
24 p_repair_type_id IN NUMBER
25 );
26
27 PROCEDURE Build_Repln_Record (
28 p_repair_line_id IN NUMBER,
29 x_Repln_Rec OUT NOCOPY CSD_REPAIRS_PUB.Repln_Rec_Type,
30 x_return_status OUT NOCOPY VARCHAR2
31 );
32
33 PROCEDURE Build_Product_TXN_Record (
34 p_product_txn_id IN NUMBER,
35 x_product_txn_Rec OUT NOCOPY CSD_PROCESS_PVT.PRODUCT_TXN_REC,
36 x_return_status OUT NOCOPY VARCHAR2
37 );
38
39 PROCEDURE Is_Split_Repair_Order_Allow (
40 p_repair_line_id IN NUMBER,
41 x_return_status OUT NOCOPY VARCHAR2,
42 x_msg_count OUT NOCOPY NUMBER,
43 x_msg_data OUT NOCOPY VARCHAR2
44 );
45
46 PROCEDURE Set_Error_Message (
47 p_msg_code IN VARCHAR2,
48 x_return_status OUT NOCOPY VARCHAR2,
49 x_msg_count OUT NOCOPY NUMBER,
50 x_msg_data OUT NOCOPY VARCHAR2
51 );
52
53
54 PROCEDURE Create_New_Repair_Order (
55 p_api_version IN NUMBER,
56 p_init_msg_list IN VARCHAR2,
57 p_commit IN VARCHAR2,
58 p_validation_level IN NUMBER,
59 x_return_status OUT NOCOPY VARCHAR2,
60 x_msg_count OUT NOCOPY NUMBER,
61 x_msg_data OUT NOCOPY VARCHAR2,
62 x_repair_line_id OUT NOCOPY NUMBER,
63 p_copy_attachment IN VARCHAR2,
64 p_original_repair_line_id IN NUMBER,
65 p_rep_line_rec IN CSD_REPAIRS_PUB.REPLN_REC_TYPE
66 );
67
68 PROCEDURE Copy_Repair_History (
69 p_api_version IN NUMBER,
70 p_init_msg_list IN VARCHAR2,
71 p_commit IN VARCHAR2,
72 p_validation_level IN NUMBER,
73 x_return_status OUT NOCOPY VARCHAR2,
74 x_msg_count OUT NOCOPY NUMBER,
75 x_msg_data OUT NOCOPY VARCHAR2,
76 p_original_repair_line_id IN NUMBER,
77 p_new_repair_line_id IN NUMBER
78 );
79
80 PROCEDURE Build_Repair_History_Record (
81 p_original_repair_history_id IN NUMBER,
82 x_repair_history_Rec OUT NOCOPY CSD_REPAIR_HISTORY_PVT.REPH_Rec_Type,
83 x_return_status OUT NOCOPY VARCHAR2
84 );
85
86
87 PROCEDURE Copy_JTF_Notes (
88 p_api_version IN NUMBER,
89 p_init_msg_list IN VARCHAR2,
90 p_commit IN VARCHAR2,
91 p_validation_level IN NUMBER,
92 x_return_status OUT NOCOPY VARCHAR2,
93 x_msg_count OUT NOCOPY NUMBER,
94 x_msg_data OUT NOCOPY VARCHAR2,
95 p_original_repair_line_id IN NUMBER,
96 p_new_repair_line_id IN NUMBER
97 );
98
99 PROCEDURE Build_Ship_Prod_Txn_Tbl
100 ( p_repair_line_id IN NUMBER,
101 x_prod_txn_tbl OUT NOCOPY CSD_PROCESS_PVT.PRODUCT_TXN_TBL,
102 x_return_status OUT NOCOPY VARCHAR2
103 );
104
105 End CSD_SPLIT_PKG;