PACKAGE: APPS.BIS_TERRITORY_HIERARCHIES_PKG

Source

1 package BIS_TERRITORY_HIERARCHIES_PKG AUTHID CURRENT_USER AS
2 /* $Header: BISTERHS.pls 115.1 99/07/17 16:10:59 porting shi $ */
3 /*=======================================================================+
4  |  Copyright (c) 1997 Oracle Corporation Redwood Shores, California, USA|
5  |                            All rights reserved.                       |
6  +=======================================================================+
7  | FILENAME
8  | DESCRIPTION
9  |   PL/SQL spec for package:  BIS_TERRITORY_HIERARCHIES_PKG
10  *=======================================================================*/
11 
12 procedure INSERT_ROW (
13   X_ROWID in out VARCHAR2,
14   X_PARENT_TERRITORY_CODE in VARCHAR2,
15   X_PARENT_TERRITORY_TYPE in VARCHAR2,
16   X_CHILD_TERRITORY_CODE in VARCHAR2,
17   X_CHILD_TERRITORY_TYPE in VARCHAR2,
18   X_START_DATE_ACTIVE in DATE,
19   X_END_DATE_ACTIVE in DATE,
20   X_CREATION_DATE in DATE,
21   X_CREATED_BY in NUMBER,
22   X_LAST_UPDATE_DATE in DATE,
23   X_LAST_UPDATED_BY in NUMBER,
24   X_LAST_UPDATE_LOGIN in NUMBER);
25 procedure LOCK_ROW (
26   X_PARENT_TERRITORY_CODE in VARCHAR2,
27   X_PARENT_TERRITORY_TYPE in VARCHAR2,
28   X_CHILD_TERRITORY_CODE in VARCHAR2,
29   X_CHILD_TERRITORY_TYPE in VARCHAR2,
30   X_START_DATE_ACTIVE in DATE,
31   X_END_DATE_ACTIVE in DATE
32 );
33 procedure UPDATE_ROW (
34   X_PARENT_TERRITORY_CODE in VARCHAR2,
35   X_PARENT_TERRITORY_TYPE in VARCHAR2,
36   X_CHILD_TERRITORY_CODE in VARCHAR2,
37   X_CHILD_TERRITORY_TYPE in VARCHAR2,
38   X_START_DATE_ACTIVE in DATE,
39   X_END_DATE_ACTIVE in DATE,
40   X_LAST_UPDATE_DATE in DATE,
41   X_LAST_UPDATED_BY in NUMBER,
42   X_LAST_UPDATE_LOGIN in NUMBER
43 );
44 procedure DELETE_ROW (
45   X_PARENT_TERRITORY_CODE in VARCHAR2,
46   X_PARENT_TERRITORY_TYPE in VARCHAR2,
47   X_CHILD_TERRITORY_CODE in VARCHAR2,
48   X_CHILD_TERRITORY_TYPE in VARCHAR2
49 );
50 end BIS_TERRITORY_HIERARCHIES_PKG;