[Home] [Help]
PACKAGE: APPS.JTY_TERR_TRIGGER_HANDLERS
Source
1 PACKAGE JTY_TERR_TRIGGER_HANDLERS AUTHID CURRENT_USER as
2 /* $Header: jtfyrhds.pls 120.1 2006/03/30 17:26:10 achanda noship $ */
3 -- ---------------------------------------------------
4 -- Start of Comments
5 -- ---------------------------------------------------
6 -- PACKAGE NAME: JTY_TERR_TRIGGER_HANDLERS
7 -- ---------------------------------------------------
8 -- PURPOSE
9 -- This package defines Territory Trigger handlers.
10 -- Trigger handler API Spec for TABLES:
11 -- JTF_TERR, JTF_TERR_VALUES, JTF_TERR_RSC, JTF_TERR_RSC_ACCESS, JTF_TERR_QTYPE_USGS, JTF_TERR_QUAL
12 --
13 -- Procedures:
14 -- (see below for specification)
15 --
16 -- HISTORY
17 -- 08/25/05 achanda Created
18 -- End of Comments
19
20 PROCEDURE Territory_Trigger_Handler (
21 p_terr_id IN NUMBER,
22 o_parent_territory_id IN NUMBER,
23 o_start_date_active IN DATE,
24 o_end_date_active IN DATE,
25 o_rank IN NUMBER,
26 o_num_winners IN NUMBER,
27 o_named_acct_flag IN VARCHAR2,
28 n_parent_territory_id IN NUMBER,
29 n_start_date_active IN DATE,
30 n_end_date_active IN DATE,
31 n_rank IN NUMBER,
32 n_num_winners IN NUMBER,
33 n_named_acct_flag IN VARCHAR2,
34 Trigger_Mode IN VARCHAR2);
35
36 PROCEDURE Terr_Values_Trigger_Handler(
37 p_terr_qual_id IN NUMBER);
38
39 PROCEDURE Terr_Rsc_Trigger_Handler(
40 p_TERR_ID IN NUMBER);
41
42 PROCEDURE Terr_QType_Trigger_Handler(
43 p_terr_id IN NUMBER);
44
45 PROCEDURE Terr_RscAccess_Trigger_Handler(
46 p_terr_rsc_id IN NUMBER);
47
48 PROCEDURE Terr_Qual_Trigger_Handler(
49 p_terr_id IN NUMBER);
50
51 PROCEDURE Terr_Usgs_Trigger_Handler(
52 p_terr_id IN NUMBER,
53 p_source_id IN NUMBER,
54 triggering_mode IN VARCHAR2);
55
56 End JTY_TERR_TRIGGER_HANDLERS;