PACKAGE: APPS.PSP_PQH_INTEGRATION

Source

1 PACKAGE PSP_PQH_INTEGRATION AUTHID CURRENT_USER as
2 --$Header: PSPENPQHS.pls 115.3 2002/11/19 12:26:16 ddubey ship $
3 
4 TYPE t_num_15_type IS TABLE OF NUMBER(15) INDEX BY BINARY_INTEGER;
5 TYPE t_num_15d2_type IS TABLE OF NUMBER(15,2) INDEX BY BINARY_INTEGER;
6 
7 TYPE encumbrance_table_rec_col IS RECORD
8 (
9 r_element_type_id t_num_15_type,
10 r_gl_enc_amount   t_num_15d2_type,
11 r_gms_enc_amount  t_num_15d2_type);
12 
13 
14 
15 TYPE assignment_enc_ld_col is RECORD
16 (
17 r_assignment_id        t_num_15_type,
18 r_element_type_id      t_num_15_type,
19 r_encumbrance_amount   t_num_15d2_type,
20 r_begin_time_period_id t_num_15_type,
21 r_end_time_period_id   t_num_15_type);
22 
23 
24 
25 PROCEDURE  get_asg_encumbrances(p_assignment_id IN NUMBER,
26                                 p_encumbrance_start_date IN  DATE,
27                                 p_encumbrance_end_date  IN  DATE,
28                                 p_encumbrance_table OUT NOCOPY ENCUMBRANCE_TABLE_REC_COL,
29                                 p_asg_psp_encumbered OUT NOCOPY BOOLEAN,
30                                 p_return_status OUT NOCOPY VARCHAR2);
31 
32 PROCEDURE get_encumbrance_details ( p_calling_process IN VARCHAR2,
33                                     p_assignment_enc_ld_table OUT NOCOPY assignment_enc_ld_col,
34                                     p_psp_encumbered  OUT NOCOPY BOOLEAN,
35                                     p_return_status OUT NOCOPY VARCHAR2);
36 END PSP_PQH_INTEGRATION;