APPS.PAY_TIME_DEFINITION_API dependencies on PER_TIME_PERIODS

Line 42: l_period_name per_time_periods.period_name%type ;

38:
39: l_multiple number;
40: l_base_period_type varchar2(1);
41: l_period_number number;
42: l_period_name per_time_periods.period_name%type ;
43: l_end_years_marker date;
44: l_display_period_type per_time_period_types.display_period_type%type ;
45: l_date date;
46:

Line 79: from per_time_periods ptp

75: cursor csr_existing_period_details is
76: select min(start_date),
77: max(end_date),
78: count(time_period_id)
79: from per_time_periods ptp
80: where ptp.time_definition_id = p_time_definition_id;
81:
82: cursor csr_first_period_end_date is
83: select end_date

Line 84: from per_time_periods ptp

80: where ptp.time_definition_id = p_time_definition_id;
81:
82: cursor csr_first_period_end_date is
83: select end_date
84: from per_time_periods ptp
85: where ptp.time_definition_id = p_time_definition_id
86: and start_date = l_first_period_start_date;
87:
88: --

Line 387: insert into per_time_periods

383: fnd_message.set_name('PAY','PAY_33414_FLSA_CROSS_VAL3');
384: fnd_message.raise_error;
385: End if;
386:
387: insert into per_time_periods
388: (time_period_id,
389: start_date,
390: end_date,
391: period_type,

Line 397: per_time_periods_s.nextval,

393: period_name,
394: time_definition_id
395: )
396: select
397: per_time_periods_s.nextval,
398: l_period_start_date,
399: l_period_end_date,
400: l_period_type,
401: l_period_number,

Line 713: delete from per_time_periods

709: close csr_definition_type;
710:
711: if l_definition_type not in ('P', 'E', 'C') then
712:
713: delete from per_time_periods
714: where time_definition_id = p_time_definition_id;
715:
716: generate_time_periods
717: (p_time_definition_id => p_time_definition_id);

Line 845: delete from per_time_periods

841: --
842: -- Process Logic
843: --
844:
845: delete from per_time_periods
846: where time_definition_id = p_time_definition_id;
847:
848: delete from pay_time_def_usages
849: where time_definition_id = p_time_definition_id;