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 170: /* get_period_mask_start() returns the min from_anchor_start from pa_period_mask_details

166:
167: END get_plan_period_start;
168:
169:
170: /* get_period_mask_start() returns the min from_anchor_start from pa_period_mask_details
171: -- it will not return rows that have an from_anchor_start with -99999 or 99999
172: -- these are flags for preceeding and suceeding buckets
173: -- this function is called from get_periods to populate the pl/sql table with the
174: -- before anchor date records from gl_periods

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

172: -- these are flags for preceeding and suceeding buckets
173: -- this function is called from get_periods to populate the pl/sql table with the
174: -- before anchor date records from gl_periods
175: */
176: FUNCTION get_period_mask_start( p_period_mask_id IN pa_period_mask_details.period_mask_id%TYPE) RETURN NUMBER
177: IS
178:
179: l_period_mask_start pa_period_mask_details.from_anchor_start%type; --RETURN value
180:

Line 179: l_period_mask_start pa_period_mask_details.from_anchor_start%type; --RETURN value

175: */
176: FUNCTION get_period_mask_start( p_period_mask_id IN pa_period_mask_details.period_mask_id%TYPE) RETURN NUMBER
177: IS
178:
179: l_period_mask_start pa_period_mask_details.from_anchor_start%type; --RETURN value
180:
181: CURSOR get_min_csr IS
182: SELECT min(from_anchor_start) from_anchor_start_min
183: FROM pa_period_mask_details

Line 183: FROM pa_period_mask_details

179: l_period_mask_start pa_period_mask_details.from_anchor_start%type; --RETURN value
180:
181: CURSOR get_min_csr IS
182: SELECT min(from_anchor_start) from_anchor_start_min
183: FROM pa_period_mask_details
184: WHERE from_anchor_start NOT IN (-99999,99999)
185: AND period_mask_id = p_period_mask_id;
186:
187: get_min_rec get_min_csr%ROWTYPE;

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

205: END get_period_mask_start;
206:
207:
208:
209: /* get_period_mask_end() returns the max from_anchor_end from pa_period_mask_details
210: -- it will not return rows that have an from_anchor_start with -99999 or 99999
211: -- these are flags for preceeding and suceeding buckets
212: -- this function is called from get_periods to populate the pl/sql table with the
213: -- after anchor date records from gl_periods

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

211: -- these are flags for preceeding and suceeding buckets
212: -- this function is called from get_periods to populate the pl/sql table with the
213: -- after anchor date records from gl_periods
214: */
215: FUNCTION get_period_mask_end ( p_period_mask_id IN pa_period_mask_details.period_mask_id%TYPE) RETURN NUMBER
216: IS
217:
218: l_period_mask_end pa_period_mask_details.from_anchor_end%TYPE;
219:

Line 218: l_period_mask_end pa_period_mask_details.from_anchor_end%TYPE;

214: */
215: FUNCTION get_period_mask_end ( p_period_mask_id IN pa_period_mask_details.period_mask_id%TYPE) RETURN NUMBER
216: IS
217:
218: l_period_mask_end pa_period_mask_details.from_anchor_end%TYPE;
219:
220: CURSOR get_max_csr IS
221: SELECT max(from_anchor_end) from_anchor_end_max
222: FROM pa_period_mask_details

Line 222: FROM pa_period_mask_details

218: l_period_mask_end pa_period_mask_details.from_anchor_end%TYPE;
219:
220: CURSOR get_max_csr IS
221: SELECT max(from_anchor_end) from_anchor_end_max
222: FROM pa_period_mask_details
223: WHERE from_anchor_end NOT IN (-99999,99999)
224: AND period_mask_id = p_period_mask_id;
225:
226: get_max_rec get_max_csr%ROWTYPE;

Line 268: l_period_mask_id pa_period_mask_details.period_mask_id%TYPE;

264: l_period_set_name gl_sets_of_books.period_set_name%TYPE;
265: l_accounted_period_type gl_sets_of_books.accounted_period_type%TYPE;
266: l_pa_period_type pa_implementations_all.pa_period_type%TYPE;
267: l_time_phase_code pa_proj_fp_options.cost_time_phased_code%TYPE;
268: l_period_mask_id pa_period_mask_details.period_mask_id%TYPE;
269: l_cpp_start_date DATE;
270: l_count NUMBER := 0 ; --counter variable
271: l_plan_start_date pa_resource_assignments.planning_start_date%TYPE;
272: l_plan_end_date pa_resource_assignments.planning_end_date%TYPE;

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

740: -- return the start period that corresponds to the masks from_anchor_position
741: -- if the from_anchor_position = -99999 or 99999 then set these to Preceeding and Suceeding periods
742: */
743:
744: FUNCTION start_period ( p_from_anchor_position IN pa_period_mask_details.from_anchor_position%TYPE ) RETURN VARCHAR2
745: IS
746:
747: -- Bug 3671424.
748: -- THe gl periods period name is only 15 chars long where

Line 759: FROM pa_period_mask_details

755:
756: CURSOR get_period_mask_details_csr IS
757: SELECT from_anchor_start
758: ,from_anchor_end
759: FROM pa_period_mask_details
760: WHERE from_anchor_position = p_from_anchor_position
761: AND period_mask_id = g_period_mask_id;
762:
763: get_period_mask_details_rec get_period_mask_details_csr%ROWTYPE;

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

815: -- return the end period that corresponds to the masks from_anchor_position
816: -- if the from_anchor_position = -99999 or 99999 then set these to Preceeding and Suceeding periods
817: */
818:
819: FUNCTION end_period ( p_from_anchor_position IN pa_period_mask_details.from_anchor_position%TYPE ) RETURN VARCHAR2
820: IS
821:
822: -- Bug 3671424.
823: -- THe gl periods period name is only 15 chars long where

Line 835: FROM pa_period_mask_details

831:
832: CURSOR get_period_mask_details_csr IS
833: SELECT from_anchor_start
834: ,from_anchor_end
835: FROM pa_period_mask_details
836: WHERE from_anchor_position = p_from_anchor_position
837: AND period_mask_id = g_period_mask_id;
838:
839: get_period_mask_details_rec get_period_mask_details_csr%ROWTYPE;

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

896: -- if start period = end period then display only start period
897: -- if start period or end period is null then display null
898: -- else display start period - end period
899: */
900: FUNCTION display_name ( p_from_anchor_position IN pa_period_mask_details.from_anchor_position%TYPE ) RETURN VARCHAR2
901: IS
902: l_display_name varchar2(2000);
903: BEGIN
904: IF p_from_anchor_position = -99999 THEN

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

943: -- if the from_anchor_position = -99999 set start date = 01-JAN-0001
944: -- if the from_anchor_position = 99999 set start date = g_suceeding start
945: */
946:
947: FUNCTION start_date ( p_from_anchor_position IN pa_period_mask_details.from_anchor_position%TYPE ) RETURN DATE
948: IS
949: l_start_date date;
950:
951: CURSOR get_period_mask_details_csr IS

Line 954: FROM pa_period_mask_details

950:
951: CURSOR get_period_mask_details_csr IS
952: SELECT from_anchor_start
953: ,from_anchor_end
954: FROM pa_period_mask_details
955: WHERE from_anchor_position = p_from_anchor_position
956: AND period_mask_id = g_period_mask_id;
957:
958: get_period_mask_details_rec get_period_mask_details_csr%ROWTYPE;

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

1003: -- return the start date that corresponds to the masks from_anchor_position
1004: -- if the from_anchor_position = -99999 set start date = g_preceeding_end
1005: -- if the from_anchor_position = 99999 set start date = '31-DEC-4712'
1006: */
1007: FUNCTION end_date ( p_from_anchor_position IN pa_period_mask_details.from_anchor_position%TYPE ) RETURN DATE
1008: IS
1009: l_end_date DATE;
1010:
1011: CURSOR get_period_mask_details_csr IS

Line 1014: FROM pa_period_mask_details

1010:
1011: CURSOR get_period_mask_details_csr IS
1012: SELECT from_anchor_start
1013: ,from_anchor_end
1014: FROM pa_period_mask_details
1015: WHERE from_anchor_position = p_from_anchor_position
1016: AND period_mask_id = g_period_mask_id;
1017:
1018: get_period_mask_details_rec get_period_mask_details_csr%ROWTYPE;