1 PACKAGE CSF_DEBRIEF_CHARGES AUTHID CURRENT_USER as
2 /* $Header: csfdbchs.pls 115.20 2003/01/13 23:14:39 ibalint ship $ */
3 -- Start of Comments
4 -- Package name : CSF_DEBRIEF_CHARGES
5 -- Purpose : Wrapper for Charges
6 -- History :
7 -- NOTE :
8 -- End of Comments
9 -- Default number of records fetch per call
10
11 PROCEDURE CREATE_CHARGES (
12 P_ORIGINAL_SOURCE_ID IN NUMBER,
13 P_ORIGINAL_SOURCE_CODE IN VARCHAR2,
14 P_INCIDENT_ID IN NUMBER,
15 P_BUSINESS_PROCESS_ID IN NUMBER,
16 P_LINE_CATEGORY_CODE IN VARCHAR2,
17 P_SOURCE_CODE IN VARCHAR2,
18 P_SOURCE_ID IN NUMBER,
19 P_INVENTORY_ITEM_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
20 P_ITEM_REVISION IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
21 P_UNIT_OF_MEASURE_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
22 P_QUANTITY IN NUMBER DEFAULT FND_API.G_MISS_NUM,
23 P_TXN_BILLING_TYPE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
24 P_TRANSACTION_TYPE_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
25 P_CUSTOMER_PRODUCT_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
26 P_INSTALLED_CP_RETURN_BY_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
27 P_AFTER_WARRANTY_COST IN NUMBER DEFAULT FND_API.G_MISS_NUM,
28 P_CURRENCY_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
29 P_RETURN_REASON_CODE IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
30 P_INVENTORY_ORG_ID IN VARCHAR2 DEFAULT FND_API.G_MISS_NUM,
31 P_SUBINVENTORY IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
32 P_SERIAL_NUMBER IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
33 P_FINAL_CHARGE_FLAG IN VARCHAR2,
34 P_LABOR_START_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
35 P_LABOR_END_DATE IN DATE DEFAULT FND_API.G_MISS_DATE,
36 X_Return_Status OUT NOCOPY VARCHAR2,
37 X_Msg_Count OUT NOCOPY NUMBER,
38 X_Msg_Data OUT NOCOPY VARCHAR2
39 );
40
41 PROCEDURE UPDATE_LAB_RS_LOC(
42 p_debrief_header_id IN NUMBER,
43 p_debrief_line_id IN NUMBER,
44 p_labor_start_date IN DATE,
45 X_RETURN_STATUS OUT NOCOPY varchar2,
46 X_MSG_COUNT OUT NOCOPY number,
47 X_MSG_DATA OUT NOCOPY VARCHAR2);
48
49 PROCEDURE UPDATE_CHARGES (
50 SOURCE_CODE IN VARCHAR2,
51 SOURCE_ID IN NUMBER,
52 INVENTORY_ITEM_ID IN NUMBER ,
53 UNIT_OF_MEASURE_CODE IN VARCHAR2 ,
54 QUANTITY_REQUIRED IN NUMBER ,
55 TXN_BILLING_TYPE IN NUMBER ,
56 OUT_X_Return_Status OUT NOCOPY VARCHAR2,
57 OUT_X_Msg_Count OUT NOCOPY NUMBER,
58 OUT_X_Msg_Data OUT NOCOPY VARCHAR2
59 );
60
61 PROCEDURE DELETE_CHARGES (SOURCE_ID IN NUMBER,
62 SOURCE_CODE IN VARCHAR2,
63 OUT_X_Return_status OUT NOCOPY VARCHAR2,
64 OUT_X_Msg_Count OUT NOCOPY NUMBER ,
65 OUT_X_MSG_DATA OUT NOCOPY VARCHAR2 );
66 END CSF_DEBRIEF_CHARGES;
67
68
69
[Home] [Help]