[Home] [Help]
PACKAGE: APPS.JTF_TERR_TRIGGER_HANDLERS
Source
1 PACKAGE JTF_TERR_TRIGGER_HANDLERS AUTHID CURRENT_USER as
2 /* $Header: jtftrhds.pls 115.12 2002/12/18 01:01:56 jdochert ship $ */
3 -- ---------------------------------------------------
4 -- Start of Comments
5 -- ---------------------------------------------------
6 -- PACKAGE NAME: JTF_TERR_TRIGGER_HANDLERS
7 -- ---------------------------------------------------
8 -- PURPOSE
9 -- Joint task force core territory manager private api's.
10 -- This package is defines Territory Trigger handlers.
11 -- Trigger handler API Spec for JTF_TERR and JTF_TERR_VALUES tables
12 --
13 -- Procedures:
14 -- (see below for specification)
15 --
16 -- NOTES
17 -- This package is available for use
18 -- HISTORY
19 -- 04/23/00 EIHSU Created
20 --
21 -- End of Comments
22
23 PROCEDURE Territory_Trigger_Handler(
24 p_terr_id NUMBER,
25 p_org_id NUMBER,
26 o_parent_territory_id NUMBER,
27 o_last_update_date DATE,
28 o_last_updated_by NUMBER,
29 o_creation_date DATE,
30 o_created_by NUMBER,
31 o_last_update_login VARCHAR2,
32 o_start_date_active DATE,
33 o_end_date_active DATE,
34 o_rank VARCHAR2,
35 o_update_flag VARCHAR2,
36 o_num_winners NUMBER,
37 n_parent_territory_id NUMBER,
38 n_last_update_date DATE,
39 n_last_updated_by NUMBER,
40 n_creation_date DATE,
41 n_created_by NUMBER,
42 n_last_update_login VARCHAR2,
43 n_start_date_active DATE,
44 n_end_date_active DATE,
45 n_rank VARCHAR2,
46 n_update_flag VARCHAR2,
47 n_num_winners NUMBER,
48 Trigger_Mode VARCHAR2
49 );
50
51 PROCEDURE Terr_Values_Trigger_Handler(
52 P_TERR_VALUE_ID NUMBER,
53 P_ORG_ID NUMBER,
54 o_LAST_UPDATED_BY NUMBER,
55 o_LAST_UPDATE_DATE DATE,
56 o_CREATED_BY NUMBER,
57 o_CREATION_DATE DATE,
58 o_LAST_UPDATE_LOGIN NUMBER,
59 o_TERR_QUAL_ID NUMBER,
60 o_INCLUDE_FLAG VARCHAR2,
61 o_COMPARISON_OPERATOR VARCHAR2,
62 o_ID_USED_FLAG VARCHAR2,
63 o_LOW_VALUE_CHAR_ID NUMBER,
64 o_LOW_VALUE_CHAR VARCHAR2,
65 o_HIGH_VALUE_CHAR VARCHAR2,
66 o_LOW_VALUE_NUMBER NUMBER,
67 o_HIGH_VALUE_NUMBER NUMBER,
68 o_VALUE_SET NUMBER,
69 o_INTEREST_TYPE_ID NUMBER,
70 o_PRIMARY_INTEREST_CODE_ID NUMBER,
71 o_SECONDARY_INTEREST_CODE_ID NUMBER,
72 o_CURRENCY_CODE VARCHAR2,
73 n_LAST_UPDATED_BY NUMBER,
74 n_LAST_UPDATE_DATE DATE,
75 n_CREATED_BY NUMBER,
76 n_CREATION_DATE DATE,
77 n_LAST_UPDATE_LOGIN NUMBER,
78 n_TERR_QUAL_ID NUMBER,
79 n_INCLUDE_FLAG VARCHAR2,
80 n_COMPARISON_OPERATOR VARCHAR2,
81 n_ID_USED_FLAG VARCHAR2,
82 n_LOW_VALUE_CHAR_ID NUMBER,
83 n_LOW_VALUE_CHAR VARCHAR2,
84 n_HIGH_VALUE_CHAR VARCHAR2,
85 n_LOW_VALUE_NUMBER NUMBER,
86 n_HIGH_VALUE_NUMBER NUMBER,
87 n_VALUE_SET NUMBER,
88 n_INTEREST_TYPE_ID NUMBER,
89 n_PRIMARY_INTEREST_CODE_ID NUMBER,
90 n_SECONDARY_INTEREST_CODE_ID NUMBER,
91 n_CURRENCY_CODE VARCHAR2,
92 Trigger_Mode VARCHAR2
93 );
94
95 PROCEDURE Terr_Rsc_Trigger_Handler(
96 p_TERR_RSC_ID NUMBER,
97 p_TERR_ID NUMBER,
98 p_ORG_ID NUMBER,
99 o_LAST_UPDATE_DATE DATE,
100 o_LAST_UPDATED_BY NUMBER,
101 o_CREATION_DATE DATE,
102 o_CREATED_BY NUMBER,
103 o_LAST_UPDATE_LOGIN NUMBER,
104 o_RESOURCE_ID NUMBER,
105 o_GROUP_ID NUMBER,
106 o_RESOURCE_TYPE VARCHAR2,
107 o_ROLE VARCHAR2,
108 o_PRIMARY_CONTACT_FLAG VARCHAR2,
109 o_START_DATE_ACTIVE DATE,
110 o_END_DATE_ACTIVE DATE,
111 o_FULL_ACCESS_FLAG VARCHAR2,
112 n_LAST_UPDATE_DATE DATE,
113 n_LAST_UPDATED_BY NUMBER,
114 n_CREATION_DATE DATE,
115 n_CREATED_BY NUMBER,
116 n_LAST_UPDATE_LOGIN NUMBER,
117 n_RESOURCE_ID NUMBER,
118 n_GROUP_ID NUMBER,
119 n_RESOURCE_TYPE VARCHAR2,
120 n_ROLE VARCHAR2,
121 n_PRIMARY_CONTACT_FLAG VARCHAR2,
122 n_START_DATE_ACTIVE DATE,
123 n_END_DATE_ACTIVE DATE,
124 n_FULL_ACCESS_FLAG VARCHAR2,
125 Trigger_Mode VARCHAR2
126 );
127
128 PROCEDURE Terr_QType_Trigger_Handler(
129 p_terr_qtype_usg_id NUMBER,
130 p_terr_id NUMBER,
131 p_org_id NUMBER,
132 o_LAST_UPDATED_BY NUMBER,
133 o_LAST_UPDATE_DATE DATE,
134 o_CREATED_BY NUMBER,
135 o_CREATION_DATE DATE,
136 o_LAST_UPDATE_LOGIN NUMBER,
137 n_LAST_UPDATED_BY NUMBER,
138 n_LAST_UPDATE_DATE DATE,
139 n_CREATED_BY NUMBER,
140 n_CREATION_DATE DATE,
141 n_LAST_UPDATE_LOGIN NUMBER,
142 o_qual_type_usg_id NUMBER,
143 n_qual_type_usg_id NUMBER,
144 Trigger_Mode VARCHAR2
145 );
146
147 PROCEDURE Terr_RscAccess_Trigger_Handler(
148 p_terr_rsc_access_id NUMBER,
149 p_terr_rsc_id NUMBER,
150 p_org_id NUMBER,
151 o_LAST_UPDATED_BY NUMBER,
152 o_LAST_UPDATE_DATE DATE,
153 o_CREATED_BY NUMBER,
154 o_CREATION_DATE DATE,
155 o_LAST_UPDATE_LOGIN NUMBER,
156 n_LAST_UPDATED_BY NUMBER,
157 n_LAST_UPDATE_DATE DATE,
158 n_CREATED_BY NUMBER,
159 n_CREATION_DATE DATE,
160 n_LAST_UPDATE_LOGIN NUMBER,
161 o_access_type VARCHAR2,
162 n_access_type VARCHAR2,
163 Trigger_Mode VARCHAR2
164 );
165
166 End JTF_TERR_TRIGGER_HANDLERS;