1 PACKAGE OE_CANSRV AUTHID CURRENT_USER AS
2 /* $Header: OECANSVS.pls 115.2 99/07/16 08:10:40 porting shi $ */
3
4 procedure CHECK_LINE_INTERFACED(
5 V_LINE_ID IN NUMBER
6 , V_RESULT OUT NUMBER
7 );
8
9
10 procedure CHECK_ORDER_INT_RECS_EXIST(
11 V_LINE_ID IN NUMBER
12 , V_CONCURRENT_PROCESS_ID IN OUT NUMBER
13 , V_RESULT OUT NUMBER
14 );
15
16
17 procedure CHECK_ORDER_INT_NOT_IN_PROG(
18 V_LINE_ID IN NUMBER
19 , V_PRINT_ERR_MSG IN NUMBER
20 , V_CONCURRENT_PROCESS_ID IN OUT NUMBER
21 , V_RESULT OUT NUMBER
22 );
23
24
25 procedure MAKE_DELETE_INT_RECS(
26 V_LINE_ID IN NUMBER
27 , V_CUSTOMER_PRODUCT_ID IN NUMBER
28 , V_CP_SERVICE_ID IN NUMBER
29 , V_LAST_UPDATED_BY IN NUMBER
30 , V_SERVICE_MASS_TXN_TEMP_ID IN NUMBER
31 , V_RESULT OUT NUMBER
32 );
33
34
35 procedure CANCEL_SERVICE_CHILDREN(
36 V_LINE_ID IN NUMBER
37 , V_HEADER_ID IN NUMBER
38 , V_CANCEL_CODE IN VARCHAR2
39 , V_CANCEL_COMMENT IN LONG
40 , V_FULL IN NUMBER
41 , V_STATUS IN VARCHAR2
42 , V_REQUESTED_CANCEL_QTY IN NUMBER
43 , V_CUSTOMER_PRODUCT_ID IN NUMBER
44 , V_CP_SERVICE_ID IN NUMBER
45 , V_LAST_UPDATED_BY IN NUMBER
46 , V_LAST_UPDATE_LOGIN IN NUMBER
47 , V_SERVICE_MASS_TXN_TEMP_ID IN NUMBER
48 , V_PRINT_ERR_MSG IN NUMBER
49 , V_CONCURRENT_PROCESS_ID IN OUT NUMBER
50 , V_RESULT OUT NUMBER
51 );
52
53
54 procedure CANCEL_LINE(
55 V_LINE_ID IN NUMBER
56 , V_REQUESTED_CANCEL_QTY IN NUMBER
57 , V_ORDERED_QUANTITY IN NUMBER
58 , V_RECEIVED_QUANTITY IN NUMBER
59 , V_S29 IN NUMBER
60 , V_SOURCE_CODE IN VARCHAR2
61 , V_LINE_TYPE_CODE IN VARCHAR2
62 , V_HEADER_ID IN NUMBER
63 , V_CANCEL_CODE IN VARCHAR2
64 , V_CANCEL_COMMENT IN LONG
65 , V_LAST_UPDATED_BY IN NUMBER
66 , V_LAST_UPDATE_LOGIN IN NUMBER
67 , V_FULL IN NUMBER
68 , V_STATUS IN VARCHAR2
69 , V_RESULT OUT NUMBER
70 );
71
72
73 procedure CANCEL_SERVICE(
74 V_LINE_ID IN NUMBER
75 , V_REQUESTED_CANCEL_QTY IN NUMBER
76 , V_ORDERED_QUANTITY IN NUMBER
77 , V_RECEIVED_QUANTITY IN NUMBER
78 , V_S29 IN NUMBER
79 , V_HEADER_ID IN NUMBER
80 , V_CANCEL_CODE IN VARCHAR2
81 , V_CANCEL_COMMENT IN LONG
82 , V_LAST_UPDATE_LOGIN IN NUMBER
83 , V_FULL IN NUMBER
84 , V_STATUS IN VARCHAR2
85 , V_CUSTOMER_PRODUCT_ID IN NUMBER
86 , V_CP_SERVICE_ID IN NUMBER
87 , V_LAST_UPDATED_BY IN NUMBER
88 , V_SERVICE_MASS_TXN_TEMP_ID IN NUMBER
89 , V_SOURCE_CODE IN VARCHAR2
90 , V_LINE_TYPE_CODE IN VARCHAR2
91 , V_PRINT_ERR_MSG IN NUMBER
92 , V_CONCURRENT_PROCESS_ID IN OUT NUMBER
93 , V_RESULT OUT NUMBER
94 );
95
96
97 procedure HISTORY(
98 V_LINE_ID IN NUMBER
99 , V_ITEM OUT VARCHAR2
100 , V_BASE_LINE_NUMBER OUT NUMBER
101 , V_SHIPMENT_SCHEDULE_NUMBER OUT NUMBER
102 , V_OPTION_LINE_NUMBER OUT NUMBER
103 );
104
105
106 procedure HOLDS(
107 V_HEADER_ID IN NUMBER
108 , V_LOGIN_ID IN NUMBER
109 , V_USER_ID IN NUMBER
110 );
111
112
113 procedure ALL_HOLDS(
114 V_HEADER_ID IN NUMBER
115 , V_LOGIN_ID IN NUMBER
116 , V_USER_ID IN NUMBER
117 );
118
119
120 END OE_CANSRV;