PACKAGE: APPS.CSM_MULTI_MOBQRY_PKG

Source

1 package CSM_MULTI_MOBQRY_PKG AUTHID CURRENT_USER as
2 /*$Header: csm5fmqs.pls 120.0.12020000.2 2013/04/09 06:22:49 saradhak noship $*/
3 
4 -- DESCRIPTION
5 --   This package is used by CSM HTML5 MFS Application for functional MQs
6 --
7 -- HISTORY
8 --   22-feb-2012 saradhak   Created
9 --
10 procedure q_upd_rqmt_ship_to( p_user_name IN VARCHAR2,p_password    IN VARCHAR2,P_REQ_HDR_ID IN VARCHAR2,P_ADDRESS_TYPE IN VARCHAR2,
11                                P_SHIP_LOC_SRC IN VARCHAR2,P_SHIP_LOC_ID IN VARCHAR2,p_result OUT nocopy CLOB,x_return_status OUT nocopy VARCHAR2,x_error_message OUT nocopy VARCHAR2);
12 
13 procedure q_available_parts( p_user_name IN VARCHAR2,p_password IN VARCHAR2,P_ITEM_NAME IN VARCHAR2,P_QTY IN VARCHAR2,P_WH_TYPE IN VARCHAR2,
14                              P_NEED_BY IN VARCHAR2,P_SUBSTITUTE IN VARCHAR2,P_DIST IN NUMBER,
15 							 P_INV_MINE IN VARCHAR2,P_INV_TECH IN VARCHAR2,P_INC_CLOSED IN VARCHAR2,P_QTY_TYPE IN VARCHAR2, P_LOC_SRC IN VARCHAR2, P_LOC_ID IN NUMBER,
16 							 p_result OUT nocopy CLOB,x_return_status OUT nocopy VARCHAR2,x_error_message OUT nocopy VARCHAR2);
17 
18 procedure q_upd_task_status( p_user_name IN VARCHAR2,p_password IN VARCHAR2,P_TA_ID IN VARCHAR2, P_TA_ST_ID IN VARCHAR2
19                              ,p_result OUT nocopy CLOB,x_return_status OUT nocopy VARCHAR2,x_error_message OUT nocopy VARCHAR2);
20 
21 procedure q_create_shipTo(p_user_name IN VARCHAR2,p_password IN VARCHAR2,p_ta_id IN NUMBER,p_address IN VARCHAR2,
22 						  p_result OUT nocopy CLOB,x_return_status OUT nocopy VARCHAR2,x_error_message OUT nocopy VARCHAR2);
23 
24 procedure q_return_item( p_user_name IN VARCHAR2,p_password IN VARCHAR2,P_ITEM_NAME IN VARCHAR2,P_ORG_ID IN NUMBER,
25 					     p_result OUT nocopy CLOB,x_return_status OUT nocopy VARCHAR2,x_error_message OUT nocopy VARCHAR2);
26 
27 procedure q_upd_oe_shipTo(p_user_name IN VARCHAR2,p_password IN VARCHAR2,P_REQ_HDR_ID IN VARCHAR2,P_ADDRESS_TYPE IN VARCHAR2,
28                                P_SHIP_LOC_SRC IN VARCHAR2,P_SHIP_LOC_ID IN VARCHAR2, p_result OUT nocopy CLOB,x_return_status OUT nocopy VARCHAR2,x_error_message OUT nocopy VARCHAR2);
29 
30 procedure q_upd_oe_line_shipMethod(p_user_name IN VARCHAR2,p_password IN VARCHAR2,p_ord_line_id IN NUMBER,p_ship_mtd IN VARCHAR2,
31 						  p_result OUT nocopy CLOB,x_return_status OUT nocopy VARCHAR2,x_error_message OUT nocopy VARCHAR2);
32 
33 FUNCTION get_hr_location(p_user_name in varchar2,p_task_id IN NUMBER,p_party_site_id NUMBER) RETURN NUMBER;
34 
35 procedure q_receivable_parts(p_user_name IN VARCHAR2,p_password IN VARCHAR2,p_task_id IN NUMBER,
36 						  p_result OUT nocopy CLOB,x_return_status OUT nocopy VARCHAR2,x_error_message OUT nocopy VARCHAR2);
37 
38 procedure q_receive_parts(p_user_name IN VARCHAR2,p_password IN VARCHAR2,p_rql_dtl_id IN VARCHAR2,p_qty IN VARCHAR2,p_serials IN VARCHAR2,p_close_short IN VARCHAR2,
39 						  p_result OUT nocopy CLOB,x_return_status OUT nocopy VARCHAR2,x_error_message OUT nocopy VARCHAR2);
40 
41 procedure q_ship_methods(p_user_name IN VARCHAR2,p_password IN VARCHAR2,p_from_org_id IN NUMBER,p_to_hzloc_id IN NUMBER,
42 						  p_result OUT nocopy CLOB,x_return_status OUT nocopy VARCHAR2,x_error_message OUT nocopy VARCHAR2);
43 
44 procedure q_get_address_DFF(p_user_name IN VARCHAR2,p_password IN VARCHAR2,p_addr_style IN VARCHAR2, p_result OUT nocopy CLOB,
45                               x_return_status OUT nocopy VARCHAR2,x_error_message OUT nocopy VARCHAR2);
46 
47 end CSM_MULTI_MOBQRY_PKG;