DBA Data[Home] [Help]

APPS.PY_ZA_TAX_REG dependencies on PER_TIME_PERIODS

Line 43: , p_period_end_date IN per_time_periods.end_date%TYPE

39: -- It is called from the value set PY_SRS_ZA_TX_RGSTR_ASG
40: -------------------------------------------------------------------------------
41: FUNCTION include_assignment (
42: p_asg_id IN per_all_assignments_f.assignment_id%TYPE
43: , p_period_end_date IN per_time_periods.end_date%TYPE
44: , p_include_flag IN VARCHAR2
45: ) RETURN VARCHAR2;
46:
47: -------------------------------------------------------------------------------

Line 52: , p_start_period_id IN per_time_periods.time_period_id%TYPE DEFAULT NULL

48: -- pre_process
49: -------------------------------------------------------------------------------
50: PROCEDURE pre_process (
51: p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE
52: , p_start_period_id IN per_time_periods.time_period_id%TYPE DEFAULT NULL
53: , p_end_period_id IN per_time_periods.time_period_id%TYPE
54: , p_include IN VARCHAR2
55: , p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
56: , p_retrieve_ptd IN VARCHAR2

Line 53: , p_end_period_id IN per_time_periods.time_period_id%TYPE

49: -------------------------------------------------------------------------------
50: PROCEDURE pre_process (
51: p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE
52: , p_start_period_id IN per_time_periods.time_period_id%TYPE DEFAULT NULL
53: , p_end_period_id IN per_time_periods.time_period_id%TYPE
54: , p_include IN VARCHAR2
55: , p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
56: , p_retrieve_ptd IN VARCHAR2
57: , p_retrieve_mtd IN VARCHAR2

Line 61: , p_period_num OUT NOCOPY per_time_periods.period_num%TYPE

57: , p_retrieve_mtd IN VARCHAR2
58: , p_retrieve_ytd IN VARCHAR2
59: , p_tax_register_id OUT NOCOPY pay_za_tax_registers.tax_register_id%TYPE
60: , p_payroll_name OUT NOCOPY pay_all_payrolls_f.payroll_name%TYPE
61: , p_period_num OUT NOCOPY per_time_periods.period_num%TYPE
62: , p_period_start_date OUT NOCOPY per_time_periods.start_date%TYPE
63: , p_period_end_date OUT NOCOPY per_time_periods.end_date%TYPE
64: , p_tot_employees OUT NOCOPY NUMBER
65: , p_tot_assignments OUT NOCOPY NUMBER

Line 62: , p_period_start_date OUT NOCOPY per_time_periods.start_date%TYPE

58: , p_retrieve_ytd IN VARCHAR2
59: , p_tax_register_id OUT NOCOPY pay_za_tax_registers.tax_register_id%TYPE
60: , p_payroll_name OUT NOCOPY pay_all_payrolls_f.payroll_name%TYPE
61: , p_period_num OUT NOCOPY per_time_periods.period_num%TYPE
62: , p_period_start_date OUT NOCOPY per_time_periods.start_date%TYPE
63: , p_period_end_date OUT NOCOPY per_time_periods.end_date%TYPE
64: , p_tot_employees OUT NOCOPY NUMBER
65: , p_tot_assignments OUT NOCOPY NUMBER
66: , p_assactid IN pay_assignment_actions.assignment_action_id%TYPE DEFAULT NULL -- bug 13444804

Line 63: , p_period_end_date OUT NOCOPY per_time_periods.end_date%TYPE

59: , p_tax_register_id OUT NOCOPY pay_za_tax_registers.tax_register_id%TYPE
60: , p_payroll_name OUT NOCOPY pay_all_payrolls_f.payroll_name%TYPE
61: , p_period_num OUT NOCOPY per_time_periods.period_num%TYPE
62: , p_period_start_date OUT NOCOPY per_time_periods.start_date%TYPE
63: , p_period_end_date OUT NOCOPY per_time_periods.end_date%TYPE
64: , p_tot_employees OUT NOCOPY NUMBER
65: , p_tot_assignments OUT NOCOPY NUMBER
66: , p_assactid IN pay_assignment_actions.assignment_action_id%TYPE DEFAULT NULL -- bug 13444804
67: );

Line 74: , p_start_period_id IN per_time_periods.time_period_id%TYPE DEFAULT NULL

70: -- pre_process_01032009
71: -------------------------------------------------------------------------------
72: PROCEDURE pre_process_01032009 (
73: p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE
74: , p_start_period_id IN per_time_periods.time_period_id%TYPE DEFAULT NULL
75: , p_end_period_id IN per_time_periods.time_period_id%TYPE
76: , p_include IN VARCHAR2
77: , p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
78: , p_retrieve_ptd IN VARCHAR2

Line 75: , p_end_period_id IN per_time_periods.time_period_id%TYPE

71: -------------------------------------------------------------------------------
72: PROCEDURE pre_process_01032009 (
73: p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE
74: , p_start_period_id IN per_time_periods.time_period_id%TYPE DEFAULT NULL
75: , p_end_period_id IN per_time_periods.time_period_id%TYPE
76: , p_include IN VARCHAR2
77: , p_assignment_id IN per_all_assignments_f.assignment_id%TYPE DEFAULT NULL
78: , p_retrieve_ptd IN VARCHAR2
79: , p_retrieve_mtd IN VARCHAR2

Line 83: , p_period_num OUT NOCOPY per_time_periods.period_num%TYPE

79: , p_retrieve_mtd IN VARCHAR2
80: , p_retrieve_ytd IN VARCHAR2
81: , p_tax_register_id OUT NOCOPY pay_za_tax_registers.tax_register_id%TYPE
82: , p_payroll_name OUT NOCOPY pay_all_payrolls_f.payroll_name%TYPE
83: , p_period_num OUT NOCOPY per_time_periods.period_num%TYPE
84: , p_period_start_date OUT NOCOPY per_time_periods.start_date%TYPE
85: , p_period_end_date OUT NOCOPY per_time_periods.end_date%TYPE
86: , p_tot_employees OUT NOCOPY NUMBER
87: , p_tot_assignments OUT NOCOPY NUMBER

Line 84: , p_period_start_date OUT NOCOPY per_time_periods.start_date%TYPE

80: , p_retrieve_ytd IN VARCHAR2
81: , p_tax_register_id OUT NOCOPY pay_za_tax_registers.tax_register_id%TYPE
82: , p_payroll_name OUT NOCOPY pay_all_payrolls_f.payroll_name%TYPE
83: , p_period_num OUT NOCOPY per_time_periods.period_num%TYPE
84: , p_period_start_date OUT NOCOPY per_time_periods.start_date%TYPE
85: , p_period_end_date OUT NOCOPY per_time_periods.end_date%TYPE
86: , p_tot_employees OUT NOCOPY NUMBER
87: , p_tot_assignments OUT NOCOPY NUMBER
88: , p_assactid IN pay_assignment_actions.assignment_action_id%TYPE DEFAULT NULL -- bug 13444804

Line 85: , p_period_end_date OUT NOCOPY per_time_periods.end_date%TYPE

81: , p_tax_register_id OUT NOCOPY pay_za_tax_registers.tax_register_id%TYPE
82: , p_payroll_name OUT NOCOPY pay_all_payrolls_f.payroll_name%TYPE
83: , p_period_num OUT NOCOPY per_time_periods.period_num%TYPE
84: , p_period_start_date OUT NOCOPY per_time_periods.start_date%TYPE
85: , p_period_end_date OUT NOCOPY per_time_periods.end_date%TYPE
86: , p_tot_employees OUT NOCOPY NUMBER
87: , p_tot_assignments OUT NOCOPY NUMBER
88: , p_assactid IN pay_assignment_actions.assignment_action_id%TYPE DEFAULT NULL -- bug 13444804
89: );

Line 99: , p_start_period_id IN per_time_periods.time_period_id%TYPE

95: );
96:
97: PROCEDURE archive_set_globals (
98: p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE
99: , p_start_period_id IN per_time_periods.time_period_id%TYPE
100: , p_end_period_id IN per_time_periods.time_period_id%TYPE
101: , p_include IN VARCHAR2
102: , p_retrieve_ptd IN VARCHAR2
103: , p_retrieve_mtd IN VARCHAR2

Line 100: , p_end_period_id IN per_time_periods.time_period_id%TYPE

96:
97: PROCEDURE archive_set_globals (
98: p_payroll_id IN pay_all_payrolls_f.payroll_id%TYPE
99: , p_start_period_id IN per_time_periods.time_period_id%TYPE
100: , p_end_period_id IN per_time_periods.time_period_id%TYPE
101: , p_include IN VARCHAR2
102: , p_retrieve_ptd IN VARCHAR2
103: , p_retrieve_mtd IN VARCHAR2
104: , p_retrieve_ytd IN VARCHAR2