[Home] [Help]
PACKAGE: APPS.CSP_PROD_TASK_PARTS_HISTORY
Source
1 PACKAGE CSP_PROD_TASK_PARTS_HISTORY AUTHID CURRENT_USER as
2 /* $Header: cspgpths.pls 115.9 2002/11/26 07:06:49 hhaugeru noship $ */
3 -- Start of Comments
4 -- Package name : CSP_PROD_TASK_PARTS_HISTORY
5 -- Purpose : This package includes the procedures that handle the history of Product-Task-Parts details.
6 -- History : 04-May-2001, Arul Joseph.
7 -- NOTE :
8 -- End of Comments
9 -- Default number of records fetch per call
10 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
11 TYPE PROD_TASK_Rec_Type IS RECORD
12 (
13 PRODUCT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
14 PRODUCT_ID NUMBER := FND_API.G_MISS_NUM,
15 TASK_TEMPLATE_ID NUMBER := FND_API.G_MISS_NUM,
16 AUTO_MANUAL VARCHAR2(6) := FND_API.G_MISS_CHAR,
17 ACTUAL_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
18 TASK_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
19 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
20 ATTRUBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
21 ATTRUBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
22 ATTRUBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
23 ATTRUBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
24 ATTRUBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
25 ATTRUBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
26 ATTRUBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
27 ATTRUBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
28 ATTRUBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
29 ATTRUBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
30 ATTRUBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
31 ATTRUBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
32 ATTRUBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
33 ATTRUBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
34 ATTRUBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
35 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
36 CREATION_DATE DATE := FND_API.G_MISS_DATE,
37 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
38 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
39 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
40 );
41 G_MISS_PROD_TASK_REC PROD_TASK_Rec_Type;
42 TYPE PROD_TASK_Tbl_Type IS TABLE OF PROD_TASK_Rec_Type
43 INDEX BY BINARY_INTEGER;
44 G_MISS_PROD_TASK_TBL PROD_TASK_Tbl_Type;
45 TYPE PROD_TASK_sort_rec_type IS RECORD ( -- Please define your own sort by record here.
46 PRODUCT_ID NUMBER := NULL
47 );
48 TYPE TASK_PART_Rec_Type IS RECORD
49 (
50 TASK_PART_ID NUMBER := FND_API.G_MISS_NUM,
51 PRODUCT_TASK_ID NUMBER := FND_API.G_MISS_NUM,
52 INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
53 MANUAL_QUANTITY NUMBER := FND_API.G_MISS_NUM,
54 MANUAL_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
55 QUANTITY_USED NUMBER := FND_API.G_MISS_NUM,
56 ACTUAL_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
57 CALCULATED_QUANTITY NUMBER := FND_API.G_MISS_NUM,
58 PART_PERCENTAGE NUMBER := FND_API.G_MISS_NUM,
59 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
60 CREATION_DATE DATE := FND_API.G_MISS_DATE,
61 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
62 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
63 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
64 ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
65 ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
66 ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
67 ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
68 ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
69 ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
70 ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
71 ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
72 ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
73 ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
74 ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
75 ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
76 ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
77 ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
78 ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
79 ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
80 PRIMARY_UOM_CODE VARCHAR2(3) := FND_API.G_MISS_CHAR,
81 REVISION VARCHAR2(30) := FND_API.G_MISS_CHAR,
82 START_DATE DATE := FND_API.G_MISS_DATE,
83 END_DATE DATE := FND_API.G_MISS_DATE,
84 ROLLUP_QUANTITY_USED NUMBER := FND_API.G_MISS_NUM,
85 ROLLUP_TIMES_USED NUMBER := FND_API.G_MISS_NUM,
86 SUBSTITUTE_ITEM NUMBER := FND_API.G_MISS_NUM
87 );
88
89 G_MISS_TASK_PART_REC TASK_PART_Rec_Type;
90 TYPE TASK_PART_Tbl_Type IS TABLE OF TASK_PART_Rec_Type
91 INDEX BY BINARY_INTEGER;
92 G_MISS_TASK_PART_TBL TASK_PART_Tbl_Type;
93 TYPE TASK_PART_sort_rec_type IS RECORD ( -- Please define your own sort by record here.
94 PRODUCT_TASK_ID NUMBER := NULL
95 );
96 PROCEDURE Create_parts_history(
97 errbuf OUT NOCOPY varchar2,
98 retcode OUT NOCOPY number);
99
100 PROCEDURE Create_product_task(
101 p_product_id in number,
102 p_template_id in number,
103 x_product_task_id OUT NOCOPY number);
104 PROCEDURE Update_product_task(
105 p_product_task_id in number,
106 p_actual_times_used in number);
107
108 PROCEDURE Create_task_part(
109 p_product_task_id in number,
110 p_inventory_item_id in number,
111 p_quantity in number,
112 p_uom_code in varchar2,
113 p_revision in varchar2,
114 p_actual_times_used in number,
115 x_task_part_id OUT NOCOPY number);
116
117 PROCEDURE update_task_part(
118 p_task_part_id number,
119 p_quantity_used number,
120 p_actual_times_used number,
121 p_rollup_quantity_used number,
122 p_rollup_times_used number,
123 p_substitute_item number);
124
125 procedure update_task_percentage;
126
127 procedure handle_substitutes(
128 p_product_task_id in number,
129 p_task_part_id in number,
130 p_inventory_item_id in number,
131 p_quantity_used in number,
132 p_actual_times_used in number,
133 p_rollup_quantity_used in number,
134 p_rollup_times_used in number,
135 p_increment in number,
136 p_debrief_header_id in number); -- added to handel duplicate count for rolled up times used);
137
138 procedure handle_supersede_items(p_product_task_id in number,
139 p_task_part_id in number,
140 p_inventory_item_id in number,
141 p_rollup_quantity_used in number,
142 p_rollup_times_used in number,
143 p_debrief_header_id in number);
144
145 END CSP_PROD_TASK_PARTS_HISTORY;