1 PACKAGE CSF_DEBRIEF_CHARGES AUTHID CURRENT_USER as
2 /* $Header: csfdbchs.pls 120.0.12020000.2 2013/04/09 10:35:56 shadas 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 P_EXPENDITURE_ORG_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
37 P_PROJECT_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
38 P_PROJECT_TASK_ID IN NUMBER DEFAULT FND_API.G_MISS_NUM,
39 X_Return_Status OUT NOCOPY VARCHAR2,
40 X_Msg_Count OUT NOCOPY NUMBER,
41 X_Msg_Data OUT NOCOPY VARCHAR2
42 );
43
44 PROCEDURE UPDATE_LAB_RS_LOC(
45 p_debrief_header_id IN NUMBER,
46 p_debrief_line_id IN NUMBER,
47 p_labor_start_date IN DATE,
48 X_RETURN_STATUS OUT NOCOPY varchar2,
49 X_MSG_COUNT OUT NOCOPY number,
50 X_MSG_DATA OUT NOCOPY VARCHAR2);
51
52 PROCEDURE UPDATE_CHARGES (
53 SOURCE_CODE IN VARCHAR2,
54 SOURCE_ID IN NUMBER,
55 INVENTORY_ITEM_ID IN NUMBER ,
56 UNIT_OF_MEASURE_CODE IN VARCHAR2 ,
57 QUANTITY_REQUIRED IN NUMBER ,
58 TXN_BILLING_TYPE IN NUMBER ,
59 OUT_X_Return_Status OUT NOCOPY VARCHAR2,
60 OUT_X_Msg_Count OUT NOCOPY NUMBER,
61 OUT_X_Msg_Data OUT NOCOPY VARCHAR2
62 );
63
64 PROCEDURE DELETE_CHARGES (SOURCE_ID IN NUMBER,
65 SOURCE_CODE IN VARCHAR2,
66 OUT_X_Return_status OUT NOCOPY VARCHAR2,
67 OUT_X_Msg_Count OUT NOCOPY NUMBER ,
68 OUT_X_MSG_DATA OUT NOCOPY VARCHAR2 );
69 END CSF_DEBRIEF_CHARGES;
70