PACKAGE: APPS.JTY_TERR_TRIGGER_HANDLERS

Source

1 PACKAGE JTY_TERR_TRIGGER_HANDLERS 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;