DBA Data[Home] [Help]

APPS.PA_FUNDS_CONTROL_UTILS dependencies on GL_PERIOD_STATUSES

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

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

Line 80: ,p_set_of_books_id IN gl_period_statuses.set_of_books_id%type

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