DBA Data[Home] [Help]

APPS.PA_FUNDS_CONTROL_UTILS dependencies on GL_PERIOD_STATUSES

Line 67: TYPE rec_closed_period IS RECORD(period_name gl_period_statuses.period_name%type,

63: ,p_line_num IN NUMBER
64: )return NUMBER ;
65:
66: -- This is a PLSQL Record for holding the information of the open and closed periods
67: TYPE rec_closed_period IS RECORD(period_name gl_period_statuses.period_name%type,
68: start_date date,
69: end_date date,
70: closing_status VARCHAR2(1)
71: );

Line 83: ,p_set_of_books_id IN gl_period_statuses.set_of_books_id%type

79: -- plsql table
80: PROCEDURE get_gl_periods
81: (p_start_date IN date
82: ,p_end_date IN date
83: ,p_set_of_books_id IN gl_period_statuses.set_of_books_id%type
84: ,x_tab_count IN OUT NOCOPY Number
85: ,x_tab_pds IN OUT NOCOPY pa_funds_control_utils.tab_closed_period
86: ,x_return_status IN OUT NOCOPY varchar2
87: );