eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_DISPLAY_PERIOD_MASKS dependencies on PA_PERIOD_MASK_DETAILS

Line 7: g_period_mask_id pa_period_mask_details.period_mask_id%TYPE;

3:
4: -- Package Variables.
5: g_preceeding_end DATE;
6: g_suceeding_start DATE;
7: g_period_mask_id pa_period_mask_details.period_mask_id%TYPE;
8: g_get_mask_start NUMBER := 0;
9: g_get_mask_end NUMBER := 0;
10:
11:

Line 29: /* get_period_mask_start() returns the min from_anchor_start from pa_period_mask_details

25: ,p_accounted_period_type IN gl_sets_of_books.accounted_period_type%TYPE
26: ,p_pa_period_type IN pa_implementations_all.pa_period_type%TYPE)
27: RETURN DATE;
28:
29: /* get_period_mask_start() returns the min from_anchor_start from pa_period_mask_details
30: -- it will not return rows that have an from_anchor_start with -99999 or 99999
31: -- these are flags for preceeding and suceeding buckets
32: -- this function is called from get_periods to populate the pl/sql table with the
33: -- before anchor date records from gl_periods

Line 35: FUNCTION get_period_mask_start( p_period_mask_id IN pa_period_mask_details.period_mask_id%TYPE) RETURN NUMBER;

31: -- these are flags for preceeding and suceeding buckets
32: -- this function is called from get_periods to populate the pl/sql table with the
33: -- before anchor date records from gl_periods
34: */
35: FUNCTION get_period_mask_start( p_period_mask_id IN pa_period_mask_details.period_mask_id%TYPE) RETURN NUMBER;
36:
37:
38: /* get_period_mask_end() returns the max from_anchor_end from pa_period_mask_details
39: -- it will not return rows that have an from_anchor_start with -99999 or 99999

Line 38: /* get_period_mask_end() returns the max from_anchor_end from pa_period_mask_details

34: */
35: FUNCTION get_period_mask_start( p_period_mask_id IN pa_period_mask_details.period_mask_id%TYPE) RETURN NUMBER;
36:
37:
38: /* get_period_mask_end() returns the max from_anchor_end from pa_period_mask_details
39: -- it will not return rows that have an from_anchor_start with -99999 or 99999
40: -- these are flags for preceeding and suceeding buckets
41: -- this function is called from get_periods to populate the pl/sql table with the
42: -- after anchor date records from gl_periods

Line 45: FUNCTION get_period_mask_end ( p_period_mask_id IN pa_period_mask_details.period_mask_id%TYPE) RETURN NUMBER;

41: -- this function is called from get_periods to populate the pl/sql table with the
42: -- after anchor date records from gl_periods
43: */
44:
45: FUNCTION get_period_mask_end ( p_period_mask_id IN pa_period_mask_details.period_mask_id%TYPE) RETURN NUMBER;
46:
47: TYPE period_names_type IS TABLE OF gl_periods%ROWTYPE INDEX BY BINARY_INTEGER;
48:
49: periods_tab period_names_type;

Line 85: FUNCTION start_period ( p_from_anchor_position IN pa_period_mask_details.from_anchor_position%TYPE ) RETURN VARCHAR2;

81: -- pass the parameter from_anchor_postion
82: */
83:
84:
85: FUNCTION start_period ( p_from_anchor_position IN pa_period_mask_details.from_anchor_position%TYPE ) RETURN VARCHAR2;
86:
87: FUNCTION end_period ( p_from_anchor_position IN pa_period_mask_details.from_anchor_position%TYPE ) RETURN VARCHAR2;
88:
89: FUNCTION display_name ( p_from_anchor_position IN pa_period_mask_details.from_anchor_position%TYPE ) RETURN VARCHAR2;

Line 87: FUNCTION end_period ( p_from_anchor_position IN pa_period_mask_details.from_anchor_position%TYPE ) RETURN VARCHAR2;

83:
84:
85: FUNCTION start_period ( p_from_anchor_position IN pa_period_mask_details.from_anchor_position%TYPE ) RETURN VARCHAR2;
86:
87: FUNCTION end_period ( p_from_anchor_position IN pa_period_mask_details.from_anchor_position%TYPE ) RETURN VARCHAR2;
88:
89: FUNCTION display_name ( p_from_anchor_position IN pa_period_mask_details.from_anchor_position%TYPE ) RETURN VARCHAR2;
90:
91: FUNCTION start_date ( p_from_anchor_position IN pa_period_mask_details.from_anchor_position%TYPE ) RETURN DATE;

Line 89: FUNCTION display_name ( p_from_anchor_position IN pa_period_mask_details.from_anchor_position%TYPE ) RETURN VARCHAR2;

85: FUNCTION start_period ( p_from_anchor_position IN pa_period_mask_details.from_anchor_position%TYPE ) RETURN VARCHAR2;
86:
87: FUNCTION end_period ( p_from_anchor_position IN pa_period_mask_details.from_anchor_position%TYPE ) RETURN VARCHAR2;
88:
89: FUNCTION display_name ( p_from_anchor_position IN pa_period_mask_details.from_anchor_position%TYPE ) RETURN VARCHAR2;
90:
91: FUNCTION start_date ( p_from_anchor_position IN pa_period_mask_details.from_anchor_position%TYPE ) RETURN DATE;
92:
93: FUNCTION end_date ( p_from_anchor_position IN pa_period_mask_details.from_anchor_position%TYPE ) RETURN DATE;

Line 91: FUNCTION start_date ( p_from_anchor_position IN pa_period_mask_details.from_anchor_position%TYPE ) RETURN DATE;

87: FUNCTION end_period ( p_from_anchor_position IN pa_period_mask_details.from_anchor_position%TYPE ) RETURN VARCHAR2;
88:
89: FUNCTION display_name ( p_from_anchor_position IN pa_period_mask_details.from_anchor_position%TYPE ) RETURN VARCHAR2;
90:
91: FUNCTION start_date ( p_from_anchor_position IN pa_period_mask_details.from_anchor_position%TYPE ) RETURN DATE;
92:
93: FUNCTION end_date ( p_from_anchor_position IN pa_period_mask_details.from_anchor_position%TYPE ) RETURN DATE;
94:
95: -- This will be called from the EditPlanLines Page to save the current planning period.

Line 93: FUNCTION end_date ( p_from_anchor_position IN pa_period_mask_details.from_anchor_position%TYPE ) RETURN DATE;

89: FUNCTION display_name ( p_from_anchor_position IN pa_period_mask_details.from_anchor_position%TYPE ) RETURN VARCHAR2;
90:
91: FUNCTION start_date ( p_from_anchor_position IN pa_period_mask_details.from_anchor_position%TYPE ) RETURN DATE;
92:
93: FUNCTION end_date ( p_from_anchor_position IN pa_period_mask_details.from_anchor_position%TYPE ) RETURN DATE;
94:
95: -- This will be called from the EditPlanLines Page to save the current planning period.
96: -- Bug Fix 3975683
97: -- Added Record Version Numbers.