1 PACKAGE CSM_PO_LOCATIONS_EVENT_PKG
2 /* $Header: csmepols.pls 120.1.12020000.2 2013/04/09 10:57:56 saradhak ship $*/
3 AUTHID CURRENT_USER AS
4 --
5 -- To modify this template, edit file PKGSPEC.TXT in TEMPLATE
6 -- directory of SQL Navigator
7 --
8 -- Purpose: Briefly explain the functionality of the package
9 --
10 -- MODIFICATION HISTORY
11 -- Person Date Comments
12 -- --------- ------ ------------------------------------------
13 -- Enter package declarations as shown below
14
15 PROCEDURE CSP_SHIP_TO_ADDR_MDIRTY_I(p_location_id IN NUMBER,
16 p_org_id IN NUMBER,
17 p_res_type IN VARCHAR2,
18 p_user_id IN NUMBER);
19
20 PROCEDURE CSP_SHIP_TO_ADDR_MDIRTY_U(p_location_id IN NUMBER,
21 p_org_id IN NUMBER,
22 p_res_type IN VARCHAR2,
23 p_user_id IN NUMBER);
24
25 FUNCTION CUST_ACCT_SITE_UPD_WF_EVENT(p_subscription_guid IN RAW, p_event IN OUT NOCOPY WF_EVENT_T)
26 RETURN VARCHAR2;
27
28 PROCEDURE GRP_ADDRESS_I(p_group_id IN jtf_rs_group_members.group_id%TYPE,p_resource_id IN jtf_rs_group_members.resource_id%TYPE);
29 PROCEDURE GRP_ADDRESS_D(p_group_id IN jtf_rs_group_members.group_id%TYPE,p_resource_id IN jtf_rs_group_members.resource_id%TYPE);
30
31 END CSM_PO_LOCATIONS_EVENT_PKG; -- Package spec