DBA Data[Home] [Help]

PACKAGE: APPS.JAI_CMN_RGM_TERMS_PKG

Source


1 PACKAGE jai_cmn_rgm_terms_pkg AS
2 /* $Header: jai_cmn_rgm_term.pls 120.1 2005/07/20 12:57:36 avallabh ship $ */
3 
4 /***************************************************************************************************
5 CREATED BY       : rallamse
6 CREATED DATE     : 25-FEB-2005
7 ENHANCEMENT BUG  :
8 PURPOSE          : To provide claim term information
9 CALLED FROM      :
10 
11 ***************************************************************************************************/
12 
13 PROCEDURE generate_term_schedules
14                                (
15                                 p_term_id       IN          JAI_RGM_TERMS.TERM_ID%TYPE                ,
16                                 p_amount        IN          NUMBER                                    ,
17                                 p_register_date IN          DATE                                      ,
18                                 p_schedule_id   OUT NOCOPY  JAI_RGM_TRM_SCHEDULES_T.SCHEDULE_ID%TYPE  ,
19                                 p_process_flag  OUT NOCOPY  VARCHAR2                                  ,
20                                 p_process_msg   OUT NOCOPY  VARCHAR2
21                                );
22 
23 PROCEDURE get_term_id
24                     (
25                      p_regime_id         IN           JAI_RGM_TERM_ASSIGNS.REGIME_ID         %TYPE  ,
26                      p_item_id           IN           NUMBER                                        ,
27                      p_organization_id   IN           JAI_RGM_TERM_ASSIGNS.ORGANIZATION_ID   %TYPE  ,
28                      p_party_type        IN           JAI_RGM_TERM_ASSIGNS.ORGANIZATION_TYPE %TYPE  ,
29                      p_location_id       IN           JAI_RGM_TERM_ASSIGNS.LOCATION_ID       %TYPE  ,
30                      p_term_id           OUT  NOCOPY  JAI_RGM_TERM_ASSIGNS.TERM_ID           %TYPE  ,
31                      p_process_flag      OUT  NOCOPY  VARCHAR2                                      ,
32                      p_process_msg       OUT  NOCOPY  VARCHAR2
33                     );
34 
35 PROCEDURE set_term_in_use
36                        (
37                         p_term_id       IN          JAI_RGM_TERMS.TERM_ID%TYPE ,
38                         p_process_flag  OUT NOCOPY  VARCHAR2                   ,
39                         p_process_msg   OUT NOCOPY  VARCHAR2
40                        );
41 
42 END jai_cmn_rgm_terms_pkg;