52: ,p_INVESTIGATOR_ORG_NAME in varchar2
53: ,p_INVESTIGATOR_PRIMARY_ORG_ID in number
54: ) as
55: BEGIN
56: PSP_EFF_REPORT_DETAILS_API.g_er_proposed_salary_amt(p_count_eff_detail_id) := hr_api.g_number;
57: PSP_EFF_REPORT_DETAILS_API.g_er_proposed_effort_percent(p_count_eff_detail_id) := hr_api.g_number;
58: PSP_EFF_REPORT_DETAILS_API.g_er_committed_cost_share(p_count_eff_detail_id) := hr_api.g_number;
59: PSP_EFF_REPORT_DETAILS_API.g_er_value1(p_count_eff_detail_id) := hr_api.g_number;
60: PSP_EFF_REPORT_DETAILS_API.g_er_value2(p_count_eff_detail_id) := hr_api.g_number;
53: ,p_INVESTIGATOR_PRIMARY_ORG_ID in number
54: ) as
55: BEGIN
56: PSP_EFF_REPORT_DETAILS_API.g_er_proposed_salary_amt(p_count_eff_detail_id) := hr_api.g_number;
57: PSP_EFF_REPORT_DETAILS_API.g_er_proposed_effort_percent(p_count_eff_detail_id) := hr_api.g_number;
58: PSP_EFF_REPORT_DETAILS_API.g_er_committed_cost_share(p_count_eff_detail_id) := hr_api.g_number;
59: PSP_EFF_REPORT_DETAILS_API.g_er_value1(p_count_eff_detail_id) := hr_api.g_number;
60: PSP_EFF_REPORT_DETAILS_API.g_er_value2(p_count_eff_detail_id) := hr_api.g_number;
61: PSP_EFF_REPORT_DETAILS_API.g_er_value3(p_count_eff_detail_id) := hr_api.g_number;
54: ) as
55: BEGIN
56: PSP_EFF_REPORT_DETAILS_API.g_er_proposed_salary_amt(p_count_eff_detail_id) := hr_api.g_number;
57: PSP_EFF_REPORT_DETAILS_API.g_er_proposed_effort_percent(p_count_eff_detail_id) := hr_api.g_number;
58: PSP_EFF_REPORT_DETAILS_API.g_er_committed_cost_share(p_count_eff_detail_id) := hr_api.g_number;
59: PSP_EFF_REPORT_DETAILS_API.g_er_value1(p_count_eff_detail_id) := hr_api.g_number;
60: PSP_EFF_REPORT_DETAILS_API.g_er_value2(p_count_eff_detail_id) := hr_api.g_number;
61: PSP_EFF_REPORT_DETAILS_API.g_er_value3(p_count_eff_detail_id) := hr_api.g_number;
62: PSP_EFF_REPORT_DETAILS_API.g_er_value4(p_count_eff_detail_id) := hr_api.g_number;
55: BEGIN
56: PSP_EFF_REPORT_DETAILS_API.g_er_proposed_salary_amt(p_count_eff_detail_id) := hr_api.g_number;
57: PSP_EFF_REPORT_DETAILS_API.g_er_proposed_effort_percent(p_count_eff_detail_id) := hr_api.g_number;
58: PSP_EFF_REPORT_DETAILS_API.g_er_committed_cost_share(p_count_eff_detail_id) := hr_api.g_number;
59: PSP_EFF_REPORT_DETAILS_API.g_er_value1(p_count_eff_detail_id) := hr_api.g_number;
60: PSP_EFF_REPORT_DETAILS_API.g_er_value2(p_count_eff_detail_id) := hr_api.g_number;
61: PSP_EFF_REPORT_DETAILS_API.g_er_value3(p_count_eff_detail_id) := hr_api.g_number;
62: PSP_EFF_REPORT_DETAILS_API.g_er_value4(p_count_eff_detail_id) := hr_api.g_number;
63: PSP_EFF_REPORT_DETAILS_API.g_er_value5(p_count_eff_detail_id) := hr_api.g_number;
56: PSP_EFF_REPORT_DETAILS_API.g_er_proposed_salary_amt(p_count_eff_detail_id) := hr_api.g_number;
57: PSP_EFF_REPORT_DETAILS_API.g_er_proposed_effort_percent(p_count_eff_detail_id) := hr_api.g_number;
58: PSP_EFF_REPORT_DETAILS_API.g_er_committed_cost_share(p_count_eff_detail_id) := hr_api.g_number;
59: PSP_EFF_REPORT_DETAILS_API.g_er_value1(p_count_eff_detail_id) := hr_api.g_number;
60: PSP_EFF_REPORT_DETAILS_API.g_er_value2(p_count_eff_detail_id) := hr_api.g_number;
61: PSP_EFF_REPORT_DETAILS_API.g_er_value3(p_count_eff_detail_id) := hr_api.g_number;
62: PSP_EFF_REPORT_DETAILS_API.g_er_value4(p_count_eff_detail_id) := hr_api.g_number;
63: PSP_EFF_REPORT_DETAILS_API.g_er_value5(p_count_eff_detail_id) := hr_api.g_number;
64: PSP_EFF_REPORT_DETAILS_API.g_er_value6(p_count_eff_detail_id) := hr_api.g_number;
57: PSP_EFF_REPORT_DETAILS_API.g_er_proposed_effort_percent(p_count_eff_detail_id) := hr_api.g_number;
58: PSP_EFF_REPORT_DETAILS_API.g_er_committed_cost_share(p_count_eff_detail_id) := hr_api.g_number;
59: PSP_EFF_REPORT_DETAILS_API.g_er_value1(p_count_eff_detail_id) := hr_api.g_number;
60: PSP_EFF_REPORT_DETAILS_API.g_er_value2(p_count_eff_detail_id) := hr_api.g_number;
61: PSP_EFF_REPORT_DETAILS_API.g_er_value3(p_count_eff_detail_id) := hr_api.g_number;
62: PSP_EFF_REPORT_DETAILS_API.g_er_value4(p_count_eff_detail_id) := hr_api.g_number;
63: PSP_EFF_REPORT_DETAILS_API.g_er_value5(p_count_eff_detail_id) := hr_api.g_number;
64: PSP_EFF_REPORT_DETAILS_API.g_er_value6(p_count_eff_detail_id) := hr_api.g_number;
65: PSP_EFF_REPORT_DETAILS_API.g_er_value7(p_count_eff_detail_id) := hr_api.g_number;
58: PSP_EFF_REPORT_DETAILS_API.g_er_committed_cost_share(p_count_eff_detail_id) := hr_api.g_number;
59: PSP_EFF_REPORT_DETAILS_API.g_er_value1(p_count_eff_detail_id) := hr_api.g_number;
60: PSP_EFF_REPORT_DETAILS_API.g_er_value2(p_count_eff_detail_id) := hr_api.g_number;
61: PSP_EFF_REPORT_DETAILS_API.g_er_value3(p_count_eff_detail_id) := hr_api.g_number;
62: PSP_EFF_REPORT_DETAILS_API.g_er_value4(p_count_eff_detail_id) := hr_api.g_number;
63: PSP_EFF_REPORT_DETAILS_API.g_er_value5(p_count_eff_detail_id) := hr_api.g_number;
64: PSP_EFF_REPORT_DETAILS_API.g_er_value6(p_count_eff_detail_id) := hr_api.g_number;
65: PSP_EFF_REPORT_DETAILS_API.g_er_value7(p_count_eff_detail_id) := hr_api.g_number;
66: PSP_EFF_REPORT_DETAILS_API.g_er_value8(p_count_eff_detail_id) := hr_api.g_number;
59: PSP_EFF_REPORT_DETAILS_API.g_er_value1(p_count_eff_detail_id) := hr_api.g_number;
60: PSP_EFF_REPORT_DETAILS_API.g_er_value2(p_count_eff_detail_id) := hr_api.g_number;
61: PSP_EFF_REPORT_DETAILS_API.g_er_value3(p_count_eff_detail_id) := hr_api.g_number;
62: PSP_EFF_REPORT_DETAILS_API.g_er_value4(p_count_eff_detail_id) := hr_api.g_number;
63: PSP_EFF_REPORT_DETAILS_API.g_er_value5(p_count_eff_detail_id) := hr_api.g_number;
64: PSP_EFF_REPORT_DETAILS_API.g_er_value6(p_count_eff_detail_id) := hr_api.g_number;
65: PSP_EFF_REPORT_DETAILS_API.g_er_value7(p_count_eff_detail_id) := hr_api.g_number;
66: PSP_EFF_REPORT_DETAILS_API.g_er_value8(p_count_eff_detail_id) := hr_api.g_number;
67: PSP_EFF_REPORT_DETAILS_API.g_er_value9(p_count_eff_detail_id) := hr_api.g_number;
60: PSP_EFF_REPORT_DETAILS_API.g_er_value2(p_count_eff_detail_id) := hr_api.g_number;
61: PSP_EFF_REPORT_DETAILS_API.g_er_value3(p_count_eff_detail_id) := hr_api.g_number;
62: PSP_EFF_REPORT_DETAILS_API.g_er_value4(p_count_eff_detail_id) := hr_api.g_number;
63: PSP_EFF_REPORT_DETAILS_API.g_er_value5(p_count_eff_detail_id) := hr_api.g_number;
64: PSP_EFF_REPORT_DETAILS_API.g_er_value6(p_count_eff_detail_id) := hr_api.g_number;
65: PSP_EFF_REPORT_DETAILS_API.g_er_value7(p_count_eff_detail_id) := hr_api.g_number;
66: PSP_EFF_REPORT_DETAILS_API.g_er_value8(p_count_eff_detail_id) := hr_api.g_number;
67: PSP_EFF_REPORT_DETAILS_API.g_er_value9(p_count_eff_detail_id) := hr_api.g_number;
68: PSP_EFF_REPORT_DETAILS_API.g_er_value10(p_count_eff_detail_id) := hr_api.g_number;
61: PSP_EFF_REPORT_DETAILS_API.g_er_value3(p_count_eff_detail_id) := hr_api.g_number;
62: PSP_EFF_REPORT_DETAILS_API.g_er_value4(p_count_eff_detail_id) := hr_api.g_number;
63: PSP_EFF_REPORT_DETAILS_API.g_er_value5(p_count_eff_detail_id) := hr_api.g_number;
64: PSP_EFF_REPORT_DETAILS_API.g_er_value6(p_count_eff_detail_id) := hr_api.g_number;
65: PSP_EFF_REPORT_DETAILS_API.g_er_value7(p_count_eff_detail_id) := hr_api.g_number;
66: PSP_EFF_REPORT_DETAILS_API.g_er_value8(p_count_eff_detail_id) := hr_api.g_number;
67: PSP_EFF_REPORT_DETAILS_API.g_er_value9(p_count_eff_detail_id) := hr_api.g_number;
68: PSP_EFF_REPORT_DETAILS_API.g_er_value10(p_count_eff_detail_id) := hr_api.g_number;
69: PSP_EFF_REPORT_DETAILS_API.g_er_attribute1(p_count_eff_detail_id) := hr_api.g_varchar2;
62: PSP_EFF_REPORT_DETAILS_API.g_er_value4(p_count_eff_detail_id) := hr_api.g_number;
63: PSP_EFF_REPORT_DETAILS_API.g_er_value5(p_count_eff_detail_id) := hr_api.g_number;
64: PSP_EFF_REPORT_DETAILS_API.g_er_value6(p_count_eff_detail_id) := hr_api.g_number;
65: PSP_EFF_REPORT_DETAILS_API.g_er_value7(p_count_eff_detail_id) := hr_api.g_number;
66: PSP_EFF_REPORT_DETAILS_API.g_er_value8(p_count_eff_detail_id) := hr_api.g_number;
67: PSP_EFF_REPORT_DETAILS_API.g_er_value9(p_count_eff_detail_id) := hr_api.g_number;
68: PSP_EFF_REPORT_DETAILS_API.g_er_value10(p_count_eff_detail_id) := hr_api.g_number;
69: PSP_EFF_REPORT_DETAILS_API.g_er_attribute1(p_count_eff_detail_id) := hr_api.g_varchar2;
70: PSP_EFF_REPORT_DETAILS_API.g_er_attribute2(p_count_eff_detail_id) := hr_api.g_varchar2;
63: PSP_EFF_REPORT_DETAILS_API.g_er_value5(p_count_eff_detail_id) := hr_api.g_number;
64: PSP_EFF_REPORT_DETAILS_API.g_er_value6(p_count_eff_detail_id) := hr_api.g_number;
65: PSP_EFF_REPORT_DETAILS_API.g_er_value7(p_count_eff_detail_id) := hr_api.g_number;
66: PSP_EFF_REPORT_DETAILS_API.g_er_value8(p_count_eff_detail_id) := hr_api.g_number;
67: PSP_EFF_REPORT_DETAILS_API.g_er_value9(p_count_eff_detail_id) := hr_api.g_number;
68: PSP_EFF_REPORT_DETAILS_API.g_er_value10(p_count_eff_detail_id) := hr_api.g_number;
69: PSP_EFF_REPORT_DETAILS_API.g_er_attribute1(p_count_eff_detail_id) := hr_api.g_varchar2;
70: PSP_EFF_REPORT_DETAILS_API.g_er_attribute2(p_count_eff_detail_id) := hr_api.g_varchar2;
71: PSP_EFF_REPORT_DETAILS_API.g_er_attribute3(p_count_eff_detail_id) := hr_api.g_varchar2;
64: PSP_EFF_REPORT_DETAILS_API.g_er_value6(p_count_eff_detail_id) := hr_api.g_number;
65: PSP_EFF_REPORT_DETAILS_API.g_er_value7(p_count_eff_detail_id) := hr_api.g_number;
66: PSP_EFF_REPORT_DETAILS_API.g_er_value8(p_count_eff_detail_id) := hr_api.g_number;
67: PSP_EFF_REPORT_DETAILS_API.g_er_value9(p_count_eff_detail_id) := hr_api.g_number;
68: PSP_EFF_REPORT_DETAILS_API.g_er_value10(p_count_eff_detail_id) := hr_api.g_number;
69: PSP_EFF_REPORT_DETAILS_API.g_er_attribute1(p_count_eff_detail_id) := hr_api.g_varchar2;
70: PSP_EFF_REPORT_DETAILS_API.g_er_attribute2(p_count_eff_detail_id) := hr_api.g_varchar2;
71: PSP_EFF_REPORT_DETAILS_API.g_er_attribute3(p_count_eff_detail_id) := hr_api.g_varchar2;
72: PSP_EFF_REPORT_DETAILS_API.g_er_attribute4(p_count_eff_detail_id) := hr_api.g_varchar2;
65: PSP_EFF_REPORT_DETAILS_API.g_er_value7(p_count_eff_detail_id) := hr_api.g_number;
66: PSP_EFF_REPORT_DETAILS_API.g_er_value8(p_count_eff_detail_id) := hr_api.g_number;
67: PSP_EFF_REPORT_DETAILS_API.g_er_value9(p_count_eff_detail_id) := hr_api.g_number;
68: PSP_EFF_REPORT_DETAILS_API.g_er_value10(p_count_eff_detail_id) := hr_api.g_number;
69: PSP_EFF_REPORT_DETAILS_API.g_er_attribute1(p_count_eff_detail_id) := hr_api.g_varchar2;
70: PSP_EFF_REPORT_DETAILS_API.g_er_attribute2(p_count_eff_detail_id) := hr_api.g_varchar2;
71: PSP_EFF_REPORT_DETAILS_API.g_er_attribute3(p_count_eff_detail_id) := hr_api.g_varchar2;
72: PSP_EFF_REPORT_DETAILS_API.g_er_attribute4(p_count_eff_detail_id) := hr_api.g_varchar2;
73: PSP_EFF_REPORT_DETAILS_API.g_er_attribute5(p_count_eff_detail_id) := hr_api.g_varchar2;
66: PSP_EFF_REPORT_DETAILS_API.g_er_value8(p_count_eff_detail_id) := hr_api.g_number;
67: PSP_EFF_REPORT_DETAILS_API.g_er_value9(p_count_eff_detail_id) := hr_api.g_number;
68: PSP_EFF_REPORT_DETAILS_API.g_er_value10(p_count_eff_detail_id) := hr_api.g_number;
69: PSP_EFF_REPORT_DETAILS_API.g_er_attribute1(p_count_eff_detail_id) := hr_api.g_varchar2;
70: PSP_EFF_REPORT_DETAILS_API.g_er_attribute2(p_count_eff_detail_id) := hr_api.g_varchar2;
71: PSP_EFF_REPORT_DETAILS_API.g_er_attribute3(p_count_eff_detail_id) := hr_api.g_varchar2;
72: PSP_EFF_REPORT_DETAILS_API.g_er_attribute4(p_count_eff_detail_id) := hr_api.g_varchar2;
73: PSP_EFF_REPORT_DETAILS_API.g_er_attribute5(p_count_eff_detail_id) := hr_api.g_varchar2;
74: PSP_EFF_REPORT_DETAILS_API.g_er_attribute6(p_count_eff_detail_id) := hr_api.g_varchar2;
67: PSP_EFF_REPORT_DETAILS_API.g_er_value9(p_count_eff_detail_id) := hr_api.g_number;
68: PSP_EFF_REPORT_DETAILS_API.g_er_value10(p_count_eff_detail_id) := hr_api.g_number;
69: PSP_EFF_REPORT_DETAILS_API.g_er_attribute1(p_count_eff_detail_id) := hr_api.g_varchar2;
70: PSP_EFF_REPORT_DETAILS_API.g_er_attribute2(p_count_eff_detail_id) := hr_api.g_varchar2;
71: PSP_EFF_REPORT_DETAILS_API.g_er_attribute3(p_count_eff_detail_id) := hr_api.g_varchar2;
72: PSP_EFF_REPORT_DETAILS_API.g_er_attribute4(p_count_eff_detail_id) := hr_api.g_varchar2;
73: PSP_EFF_REPORT_DETAILS_API.g_er_attribute5(p_count_eff_detail_id) := hr_api.g_varchar2;
74: PSP_EFF_REPORT_DETAILS_API.g_er_attribute6(p_count_eff_detail_id) := hr_api.g_varchar2;
75: PSP_EFF_REPORT_DETAILS_API.g_er_attribute7(p_count_eff_detail_id) := hr_api.g_varchar2;
68: PSP_EFF_REPORT_DETAILS_API.g_er_value10(p_count_eff_detail_id) := hr_api.g_number;
69: PSP_EFF_REPORT_DETAILS_API.g_er_attribute1(p_count_eff_detail_id) := hr_api.g_varchar2;
70: PSP_EFF_REPORT_DETAILS_API.g_er_attribute2(p_count_eff_detail_id) := hr_api.g_varchar2;
71: PSP_EFF_REPORT_DETAILS_API.g_er_attribute3(p_count_eff_detail_id) := hr_api.g_varchar2;
72: PSP_EFF_REPORT_DETAILS_API.g_er_attribute4(p_count_eff_detail_id) := hr_api.g_varchar2;
73: PSP_EFF_REPORT_DETAILS_API.g_er_attribute5(p_count_eff_detail_id) := hr_api.g_varchar2;
74: PSP_EFF_REPORT_DETAILS_API.g_er_attribute6(p_count_eff_detail_id) := hr_api.g_varchar2;
75: PSP_EFF_REPORT_DETAILS_API.g_er_attribute7(p_count_eff_detail_id) := hr_api.g_varchar2;
76: PSP_EFF_REPORT_DETAILS_API.g_er_attribute8(p_count_eff_detail_id) := hr_api.g_varchar2;
69: PSP_EFF_REPORT_DETAILS_API.g_er_attribute1(p_count_eff_detail_id) := hr_api.g_varchar2;
70: PSP_EFF_REPORT_DETAILS_API.g_er_attribute2(p_count_eff_detail_id) := hr_api.g_varchar2;
71: PSP_EFF_REPORT_DETAILS_API.g_er_attribute3(p_count_eff_detail_id) := hr_api.g_varchar2;
72: PSP_EFF_REPORT_DETAILS_API.g_er_attribute4(p_count_eff_detail_id) := hr_api.g_varchar2;
73: PSP_EFF_REPORT_DETAILS_API.g_er_attribute5(p_count_eff_detail_id) := hr_api.g_varchar2;
74: PSP_EFF_REPORT_DETAILS_API.g_er_attribute6(p_count_eff_detail_id) := hr_api.g_varchar2;
75: PSP_EFF_REPORT_DETAILS_API.g_er_attribute7(p_count_eff_detail_id) := hr_api.g_varchar2;
76: PSP_EFF_REPORT_DETAILS_API.g_er_attribute8(p_count_eff_detail_id) := hr_api.g_varchar2;
77: PSP_EFF_REPORT_DETAILS_API.g_er_attribute9(p_count_eff_detail_id) := hr_api.g_varchar2;
70: PSP_EFF_REPORT_DETAILS_API.g_er_attribute2(p_count_eff_detail_id) := hr_api.g_varchar2;
71: PSP_EFF_REPORT_DETAILS_API.g_er_attribute3(p_count_eff_detail_id) := hr_api.g_varchar2;
72: PSP_EFF_REPORT_DETAILS_API.g_er_attribute4(p_count_eff_detail_id) := hr_api.g_varchar2;
73: PSP_EFF_REPORT_DETAILS_API.g_er_attribute5(p_count_eff_detail_id) := hr_api.g_varchar2;
74: PSP_EFF_REPORT_DETAILS_API.g_er_attribute6(p_count_eff_detail_id) := hr_api.g_varchar2;
75: PSP_EFF_REPORT_DETAILS_API.g_er_attribute7(p_count_eff_detail_id) := hr_api.g_varchar2;
76: PSP_EFF_REPORT_DETAILS_API.g_er_attribute8(p_count_eff_detail_id) := hr_api.g_varchar2;
77: PSP_EFF_REPORT_DETAILS_API.g_er_attribute9(p_count_eff_detail_id) := hr_api.g_varchar2;
78: PSP_EFF_REPORT_DETAILS_API.g_er_attribute10(p_count_eff_detail_id) := hr_api.g_varchar2;
71: PSP_EFF_REPORT_DETAILS_API.g_er_attribute3(p_count_eff_detail_id) := hr_api.g_varchar2;
72: PSP_EFF_REPORT_DETAILS_API.g_er_attribute4(p_count_eff_detail_id) := hr_api.g_varchar2;
73: PSP_EFF_REPORT_DETAILS_API.g_er_attribute5(p_count_eff_detail_id) := hr_api.g_varchar2;
74: PSP_EFF_REPORT_DETAILS_API.g_er_attribute6(p_count_eff_detail_id) := hr_api.g_varchar2;
75: PSP_EFF_REPORT_DETAILS_API.g_er_attribute7(p_count_eff_detail_id) := hr_api.g_varchar2;
76: PSP_EFF_REPORT_DETAILS_API.g_er_attribute8(p_count_eff_detail_id) := hr_api.g_varchar2;
77: PSP_EFF_REPORT_DETAILS_API.g_er_attribute9(p_count_eff_detail_id) := hr_api.g_varchar2;
78: PSP_EFF_REPORT_DETAILS_API.g_er_attribute10(p_count_eff_detail_id) := hr_api.g_varchar2;
79: PSP_EFF_REPORT_DETAILS_API.g_er_grouping_category(p_count_eff_detail_id) := hr_api.g_varchar2; -- Add for Hospital Effort Report
72: PSP_EFF_REPORT_DETAILS_API.g_er_attribute4(p_count_eff_detail_id) := hr_api.g_varchar2;
73: PSP_EFF_REPORT_DETAILS_API.g_er_attribute5(p_count_eff_detail_id) := hr_api.g_varchar2;
74: PSP_EFF_REPORT_DETAILS_API.g_er_attribute6(p_count_eff_detail_id) := hr_api.g_varchar2;
75: PSP_EFF_REPORT_DETAILS_API.g_er_attribute7(p_count_eff_detail_id) := hr_api.g_varchar2;
76: PSP_EFF_REPORT_DETAILS_API.g_er_attribute8(p_count_eff_detail_id) := hr_api.g_varchar2;
77: PSP_EFF_REPORT_DETAILS_API.g_er_attribute9(p_count_eff_detail_id) := hr_api.g_varchar2;
78: PSP_EFF_REPORT_DETAILS_API.g_er_attribute10(p_count_eff_detail_id) := hr_api.g_varchar2;
79: PSP_EFF_REPORT_DETAILS_API.g_er_grouping_category(p_count_eff_detail_id) := hr_api.g_varchar2; -- Add for Hospital Effort Report
80:
73: PSP_EFF_REPORT_DETAILS_API.g_er_attribute5(p_count_eff_detail_id) := hr_api.g_varchar2;
74: PSP_EFF_REPORT_DETAILS_API.g_er_attribute6(p_count_eff_detail_id) := hr_api.g_varchar2;
75: PSP_EFF_REPORT_DETAILS_API.g_er_attribute7(p_count_eff_detail_id) := hr_api.g_varchar2;
76: PSP_EFF_REPORT_DETAILS_API.g_er_attribute8(p_count_eff_detail_id) := hr_api.g_varchar2;
77: PSP_EFF_REPORT_DETAILS_API.g_er_attribute9(p_count_eff_detail_id) := hr_api.g_varchar2;
78: PSP_EFF_REPORT_DETAILS_API.g_er_attribute10(p_count_eff_detail_id) := hr_api.g_varchar2;
79: PSP_EFF_REPORT_DETAILS_API.g_er_grouping_category(p_count_eff_detail_id) := hr_api.g_varchar2; -- Add for Hospital Effort Report
80:
81: -- EDIT:Add your code here
74: PSP_EFF_REPORT_DETAILS_API.g_er_attribute6(p_count_eff_detail_id) := hr_api.g_varchar2;
75: PSP_EFF_REPORT_DETAILS_API.g_er_attribute7(p_count_eff_detail_id) := hr_api.g_varchar2;
76: PSP_EFF_REPORT_DETAILS_API.g_er_attribute8(p_count_eff_detail_id) := hr_api.g_varchar2;
77: PSP_EFF_REPORT_DETAILS_API.g_er_attribute9(p_count_eff_detail_id) := hr_api.g_varchar2;
78: PSP_EFF_REPORT_DETAILS_API.g_er_attribute10(p_count_eff_detail_id) := hr_api.g_varchar2;
79: PSP_EFF_REPORT_DETAILS_API.g_er_grouping_category(p_count_eff_detail_id) := hr_api.g_varchar2; -- Add for Hospital Effort Report
80:
81: -- EDIT:Add your code here
82: --p_EFFORT_REPORT_DETAIL_ID is the Effort Report Detail id
75: PSP_EFF_REPORT_DETAILS_API.g_er_attribute7(p_count_eff_detail_id) := hr_api.g_varchar2;
76: PSP_EFF_REPORT_DETAILS_API.g_er_attribute8(p_count_eff_detail_id) := hr_api.g_varchar2;
77: PSP_EFF_REPORT_DETAILS_API.g_er_attribute9(p_count_eff_detail_id) := hr_api.g_varchar2;
78: PSP_EFF_REPORT_DETAILS_API.g_er_attribute10(p_count_eff_detail_id) := hr_api.g_varchar2;
79: PSP_EFF_REPORT_DETAILS_API.g_er_grouping_category(p_count_eff_detail_id) := hr_api.g_varchar2; -- Add for Hospital Effort Report
80:
81: -- EDIT:Add your code here
82: --p_EFFORT_REPORT_DETAIL_ID is the Effort Report Detail id
83: