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.PSP_PSPENEXR_XMLP_PKG dependencies on PSP_PSPENEXR_XMLP_PKG

Line 1: PACKAGE BODY PSP_PSPENEXR_XMLP_PKG AS

1: PACKAGE BODY PSP_PSPENEXR_XMLP_PKG AS
2: /* $Header: PSPENEXRB.pls 120.6 2007/10/29 07:22:52 amakrish noship $ */
3: --FUNCTION BEFOREREPORT(ORIENTATION IN VARCHAR2) RETURN BOOLEAN IS
4: FUNCTION BEFOREREPORT RETURN BOOLEAN IS
5: CURSOR GL_APPLICATION_ID_CUR IS

Line 39: P_ACTUAL_SELECT := P_ACTUAL_SELECT || 'PSP_PSPENEXR_XMLP_PKG.CF_SORT_DESCRIPTION1FORMULA(paf.organization_id, TO_NUMBER(NULL), TO_NUMBER(NULL), TO_NUMBER(NULL), TO_NUMBER(NULL), TO_NUMBER(NULL), NULL) CF_sort_description1,';

35: MAX(NVL(TO_DATE(DECODE(pesl.gl_project_flag, ''P'', pesl.GMS_POSTING_OVERRIDE_DATE, pesl.gl_posting_override_date), ''DD/MM/RRRR''), pesl.EFFECTIVE_DATE)) max_end_date,
36: 1 row_num,
37: pesl.payroll_id,';
38: IF P_SORT_BY = 'O' THEN
39: P_ACTUAL_SELECT := P_ACTUAL_SELECT || 'PSP_PSPENEXR_XMLP_PKG.CF_SORT_DESCRIPTION1FORMULA(paf.organization_id, TO_NUMBER(NULL), TO_NUMBER(NULL), TO_NUMBER(NULL), TO_NUMBER(NULL), TO_NUMBER(NULL), NULL) CF_sort_description1,';
40: ELSE
41: P_ACTUAL_SELECT := P_ACTUAL_SELECT || 'PSP_PSPENEXR_XMLP_PKG.CF_SORT_DESCRIPTION1FORMULA(TO_NUMBER(NULL), pesl.gl_code_combination_id, pesl.project_id, pesl.task_id, pesl.award_id, pesl.expenditure_organization_id, ';
42: P_ACTUAL_SELECT := P_ACTUAL_SELECT || 'pesl.expenditure_type) CF_sort_description1,';
43: END IF;

Line 41: P_ACTUAL_SELECT := P_ACTUAL_SELECT || 'PSP_PSPENEXR_XMLP_PKG.CF_SORT_DESCRIPTION1FORMULA(TO_NUMBER(NULL), pesl.gl_code_combination_id, pesl.project_id, pesl.task_id, pesl.award_id, pesl.expenditure_organization_id, ';

37: pesl.payroll_id,';
38: IF P_SORT_BY = 'O' THEN
39: P_ACTUAL_SELECT := P_ACTUAL_SELECT || 'PSP_PSPENEXR_XMLP_PKG.CF_SORT_DESCRIPTION1FORMULA(paf.organization_id, TO_NUMBER(NULL), TO_NUMBER(NULL), TO_NUMBER(NULL), TO_NUMBER(NULL), TO_NUMBER(NULL), NULL) CF_sort_description1,';
40: ELSE
41: P_ACTUAL_SELECT := P_ACTUAL_SELECT || 'PSP_PSPENEXR_XMLP_PKG.CF_SORT_DESCRIPTION1FORMULA(TO_NUMBER(NULL), pesl.gl_code_combination_id, pesl.project_id, pesl.task_id, pesl.award_id, pesl.expenditure_organization_id, ';
42: P_ACTUAL_SELECT := P_ACTUAL_SELECT || 'pesl.expenditure_type) CF_sort_description1,';
43: END IF;
44: P_ACTUAL_SELECT := P_ACTUAL_SELECT || 'PSP_PSPENEXR_XMLP_PKG.CF_PERSON_NAMEFORMULA(pesl.person_id,MAX(NVL(TO_DATE(DECODE(pesl.gl_project_flag, ''P'', pesl.GMS_POSTING_OVERRIDE_DATE, pesl.gl_posting_override_date), ''DD/MM/RRRR''), ';
45: P_ACTUAL_SELECT := P_ACTUAL_SELECT || 'pesl.EFFECTIVE_DATE)),MIN(NVL(TO_DATE(DECODE(pesl.gl_project_flag, ''P'', pesl.GMS_POSTING_OVERRIDE_DATE, pesl.gl_posting_override_date), ''DD/MM/RRRR''), pesl.EFFECTIVE_DATE))) CF_person_name,';

Line 44: P_ACTUAL_SELECT := P_ACTUAL_SELECT || 'PSP_PSPENEXR_XMLP_PKG.CF_PERSON_NAMEFORMULA(pesl.person_id,MAX(NVL(TO_DATE(DECODE(pesl.gl_project_flag, ''P'', pesl.GMS_POSTING_OVERRIDE_DATE, pesl.gl_posting_override_date), ''DD/MM/RRRR''), ';

40: ELSE
41: P_ACTUAL_SELECT := P_ACTUAL_SELECT || 'PSP_PSPENEXR_XMLP_PKG.CF_SORT_DESCRIPTION1FORMULA(TO_NUMBER(NULL), pesl.gl_code_combination_id, pesl.project_id, pesl.task_id, pesl.award_id, pesl.expenditure_organization_id, ';
42: P_ACTUAL_SELECT := P_ACTUAL_SELECT || 'pesl.expenditure_type) CF_sort_description1,';
43: END IF;
44: P_ACTUAL_SELECT := P_ACTUAL_SELECT || 'PSP_PSPENEXR_XMLP_PKG.CF_PERSON_NAMEFORMULA(pesl.person_id,MAX(NVL(TO_DATE(DECODE(pesl.gl_project_flag, ''P'', pesl.GMS_POSTING_OVERRIDE_DATE, pesl.gl_posting_override_date), ''DD/MM/RRRR''), ';
45: P_ACTUAL_SELECT := P_ACTUAL_SELECT || 'pesl.EFFECTIVE_DATE)),MIN(NVL(TO_DATE(DECODE(pesl.gl_project_flag, ''P'', pesl.GMS_POSTING_OVERRIDE_DATE, pesl.gl_posting_override_date), ''DD/MM/RRRR''), pesl.EFFECTIVE_DATE))) CF_person_name,';
46: P_ACTUAL_SELECT := P_ACTUAL_SELECT || 'PSP_PSPENEXR_XMLP_PKG.CF_ASSIGNMENT_NUMBERFORMULA(pesl.assignment_id,MAX(NVL(TO_DATE(DECODE(pesl.gl_project_flag, ''P'', pesl.GMS_POSTING_OVERRIDE_DATE, pesl.gl_posting_override_date), ''DD/MM/RRRR''), ';
47: P_ACTUAL_SELECT := P_ACTUAL_SELECT || 'pesl.EFFECTIVE_DATE)),MIN(NVL(TO_DATE(DECODE(pesl.gl_project_flag, ''P'', pesl.GMS_POSTING_OVERRIDE_DATE,pesl.gl_posting_override_date),''DD/MM/RRRR''),pesl.EFFECTIVE_DATE))) CF_assignment_number,';
48: IF P_SORT_BY = 'O' THEN

Line 46: P_ACTUAL_SELECT := P_ACTUAL_SELECT || 'PSP_PSPENEXR_XMLP_PKG.CF_ASSIGNMENT_NUMBERFORMULA(pesl.assignment_id,MAX(NVL(TO_DATE(DECODE(pesl.gl_project_flag, ''P'', pesl.GMS_POSTING_OVERRIDE_DATE, pesl.gl_posting_override_date), ''DD/MM/RRRR''), ';

42: P_ACTUAL_SELECT := P_ACTUAL_SELECT || 'pesl.expenditure_type) CF_sort_description1,';
43: END IF;
44: P_ACTUAL_SELECT := P_ACTUAL_SELECT || 'PSP_PSPENEXR_XMLP_PKG.CF_PERSON_NAMEFORMULA(pesl.person_id,MAX(NVL(TO_DATE(DECODE(pesl.gl_project_flag, ''P'', pesl.GMS_POSTING_OVERRIDE_DATE, pesl.gl_posting_override_date), ''DD/MM/RRRR''), ';
45: P_ACTUAL_SELECT := P_ACTUAL_SELECT || 'pesl.EFFECTIVE_DATE)),MIN(NVL(TO_DATE(DECODE(pesl.gl_project_flag, ''P'', pesl.GMS_POSTING_OVERRIDE_DATE, pesl.gl_posting_override_date), ''DD/MM/RRRR''), pesl.EFFECTIVE_DATE))) CF_person_name,';
46: P_ACTUAL_SELECT := P_ACTUAL_SELECT || 'PSP_PSPENEXR_XMLP_PKG.CF_ASSIGNMENT_NUMBERFORMULA(pesl.assignment_id,MAX(NVL(TO_DATE(DECODE(pesl.gl_project_flag, ''P'', pesl.GMS_POSTING_OVERRIDE_DATE, pesl.gl_posting_override_date), ''DD/MM/RRRR''), ';
47: P_ACTUAL_SELECT := P_ACTUAL_SELECT || 'pesl.EFFECTIVE_DATE)),MIN(NVL(TO_DATE(DECODE(pesl.gl_project_flag, ''P'', pesl.GMS_POSTING_OVERRIDE_DATE,pesl.gl_posting_override_date),''DD/MM/RRRR''),pesl.EFFECTIVE_DATE))) CF_assignment_number,';
48: IF P_SORT_BY = 'O' THEN
49: P_ACTUAL_SELECT := P_ACTUAL_SELECT || 'PSP_PSPENEXR_XMLP_PKG.CF_ELEMENT_NAMEFORMULA(pelh.enc_element_type_id,MAX(NVL(TO_DATE(DECODE(pesl.gl_project_flag, ''P'', pesl.GMS_POSTING_OVERRIDE_DATE, pesl.gl_posting_override_date), ''DD/MM/RRRR''), ';
50: P_ACTUAL_SELECT := P_ACTUAL_SELECT || 'pesl.EFFECTIVE_DATE)),MIN(NVL(TO_DATE(DECODE(pesl.gl_project_flag, ''P'', pesl.GMS_POSTING_OVERRIDE_DATE, pesl.gl_posting_override_date), ''DD/MM/RRRR''), pesl.EFFECTIVE_DATE)),';

Line 49: P_ACTUAL_SELECT := P_ACTUAL_SELECT || 'PSP_PSPENEXR_XMLP_PKG.CF_ELEMENT_NAMEFORMULA(pelh.enc_element_type_id,MAX(NVL(TO_DATE(DECODE(pesl.gl_project_flag, ''P'', pesl.GMS_POSTING_OVERRIDE_DATE, pesl.gl_posting_override_date), ''DD/MM/RRRR''), ';

45: P_ACTUAL_SELECT := P_ACTUAL_SELECT || 'pesl.EFFECTIVE_DATE)),MIN(NVL(TO_DATE(DECODE(pesl.gl_project_flag, ''P'', pesl.GMS_POSTING_OVERRIDE_DATE, pesl.gl_posting_override_date), ''DD/MM/RRRR''), pesl.EFFECTIVE_DATE))) CF_person_name,';
46: P_ACTUAL_SELECT := P_ACTUAL_SELECT || 'PSP_PSPENEXR_XMLP_PKG.CF_ASSIGNMENT_NUMBERFORMULA(pesl.assignment_id,MAX(NVL(TO_DATE(DECODE(pesl.gl_project_flag, ''P'', pesl.GMS_POSTING_OVERRIDE_DATE, pesl.gl_posting_override_date), ''DD/MM/RRRR''), ';
47: P_ACTUAL_SELECT := P_ACTUAL_SELECT || 'pesl.EFFECTIVE_DATE)),MIN(NVL(TO_DATE(DECODE(pesl.gl_project_flag, ''P'', pesl.GMS_POSTING_OVERRIDE_DATE,pesl.gl_posting_override_date),''DD/MM/RRRR''),pesl.EFFECTIVE_DATE))) CF_assignment_number,';
48: IF P_SORT_BY = 'O' THEN
49: P_ACTUAL_SELECT := P_ACTUAL_SELECT || 'PSP_PSPENEXR_XMLP_PKG.CF_ELEMENT_NAMEFORMULA(pelh.enc_element_type_id,MAX(NVL(TO_DATE(DECODE(pesl.gl_project_flag, ''P'', pesl.GMS_POSTING_OVERRIDE_DATE, pesl.gl_posting_override_date), ''DD/MM/RRRR''), ';
50: P_ACTUAL_SELECT := P_ACTUAL_SELECT || 'pesl.EFFECTIVE_DATE)),MIN(NVL(TO_DATE(DECODE(pesl.gl_project_flag, ''P'', pesl.GMS_POSTING_OVERRIDE_DATE, pesl.gl_posting_override_date), ''DD/MM/RRRR''), pesl.EFFECTIVE_DATE)),';
51: P_ACTUAL_SELECT := P_ACTUAL_SELECT || 'pesl.gl_code_combination_id, pesl.project_id, pesl.task_id, pesl.award_id, pesl.expenditure_organization_id,pesl.expenditure_type,TO_NUMBER(NULL)) CF_element_name,';
52: ELSE
53: P_ACTUAL_SELECT := P_ACTUAL_SELECT || 'PSP_PSPENEXR_XMLP_PKG.CF_ELEMENT_NAMEFORMULA(pelh.enc_element_type_id,MAX(NVL(TO_DATE(DECODE(pesl.gl_project_flag, ''P'', pesl.GMS_POSTING_OVERRIDE_DATE, pesl.gl_posting_override_date), ';

Line 53: P_ACTUAL_SELECT := P_ACTUAL_SELECT || 'PSP_PSPENEXR_XMLP_PKG.CF_ELEMENT_NAMEFORMULA(pelh.enc_element_type_id,MAX(NVL(TO_DATE(DECODE(pesl.gl_project_flag, ''P'', pesl.GMS_POSTING_OVERRIDE_DATE, pesl.gl_posting_override_date), ';

49: P_ACTUAL_SELECT := P_ACTUAL_SELECT || 'PSP_PSPENEXR_XMLP_PKG.CF_ELEMENT_NAMEFORMULA(pelh.enc_element_type_id,MAX(NVL(TO_DATE(DECODE(pesl.gl_project_flag, ''P'', pesl.GMS_POSTING_OVERRIDE_DATE, pesl.gl_posting_override_date), ''DD/MM/RRRR''), ';
50: P_ACTUAL_SELECT := P_ACTUAL_SELECT || 'pesl.EFFECTIVE_DATE)),MIN(NVL(TO_DATE(DECODE(pesl.gl_project_flag, ''P'', pesl.GMS_POSTING_OVERRIDE_DATE, pesl.gl_posting_override_date), ''DD/MM/RRRR''), pesl.EFFECTIVE_DATE)),';
51: P_ACTUAL_SELECT := P_ACTUAL_SELECT || 'pesl.gl_code_combination_id, pesl.project_id, pesl.task_id, pesl.award_id, pesl.expenditure_organization_id,pesl.expenditure_type,TO_NUMBER(NULL)) CF_element_name,';
52: ELSE
53: P_ACTUAL_SELECT := P_ACTUAL_SELECT || 'PSP_PSPENEXR_XMLP_PKG.CF_ELEMENT_NAMEFORMULA(pelh.enc_element_type_id,MAX(NVL(TO_DATE(DECODE(pesl.gl_project_flag, ''P'', pesl.GMS_POSTING_OVERRIDE_DATE, pesl.gl_posting_override_date), ';
54: P_ACTUAL_SELECT := P_ACTUAL_SELECT || '''DD/MM/RRRR''), pesl.EFFECTIVE_DATE)),MIN(NVL(TO_DATE(DECODE(pesl.gl_project_flag, ''P'', pesl.GMS_POSTING_OVERRIDE_DATE, pesl.gl_posting_override_date), ''DD/MM/RRRR''), ';
55: P_ACTUAL_SELECT := P_ACTUAL_SELECT || 'pesl.EFFECTIVE_DATE)),TO_NUMBER(NULL), TO_NUMBER(NULL), TO_NUMBER(NULL), TO_NUMBER(NULL), TO_NUMBER(NULL),NULL,paf.organization_id) CF_element_name,';
56: END IF;
57: P_ACTUAL_SELECT := P_ACTUAL_SELECT || 'PSP_PSPENEXR_XMLP_PKG.CF_PAYROLL_NAMEFORMULA(pesl.payroll_id) CF_payroll_name,';

Line 57: P_ACTUAL_SELECT := P_ACTUAL_SELECT || 'PSP_PSPENEXR_XMLP_PKG.CF_PAYROLL_NAMEFORMULA(pesl.payroll_id) CF_payroll_name,';

53: P_ACTUAL_SELECT := P_ACTUAL_SELECT || 'PSP_PSPENEXR_XMLP_PKG.CF_ELEMENT_NAMEFORMULA(pelh.enc_element_type_id,MAX(NVL(TO_DATE(DECODE(pesl.gl_project_flag, ''P'', pesl.GMS_POSTING_OVERRIDE_DATE, pesl.gl_posting_override_date), ';
54: P_ACTUAL_SELECT := P_ACTUAL_SELECT || '''DD/MM/RRRR''), pesl.EFFECTIVE_DATE)),MIN(NVL(TO_DATE(DECODE(pesl.gl_project_flag, ''P'', pesl.GMS_POSTING_OVERRIDE_DATE, pesl.gl_posting_override_date), ''DD/MM/RRRR''), ';
55: P_ACTUAL_SELECT := P_ACTUAL_SELECT || 'pesl.EFFECTIVE_DATE)),TO_NUMBER(NULL), TO_NUMBER(NULL), TO_NUMBER(NULL), TO_NUMBER(NULL), TO_NUMBER(NULL),NULL,paf.organization_id) CF_element_name,';
56: END IF;
57: P_ACTUAL_SELECT := P_ACTUAL_SELECT || 'PSP_PSPENEXR_XMLP_PKG.CF_PAYROLL_NAMEFORMULA(pesl.payroll_id) CF_payroll_name,';
58: P_ACTUAL_SELECT := P_ACTUAL_SELECT ||'
59:
60: PSP_PSPENEXR_XMLP_PKG.CP_SORT_DESCRIPTION2_P CP_sort_description2
61: FROM psp_enc_summary_lines pesl,

Line 60: PSP_PSPENEXR_XMLP_PKG.CP_SORT_DESCRIPTION2_P CP_sort_description2

56: END IF;
57: P_ACTUAL_SELECT := P_ACTUAL_SELECT || 'PSP_PSPENEXR_XMLP_PKG.CF_PAYROLL_NAMEFORMULA(pesl.payroll_id) CF_payroll_name,';
58: P_ACTUAL_SELECT := P_ACTUAL_SELECT ||'
59:
60: PSP_PSPENEXR_XMLP_PKG.CP_SORT_DESCRIPTION2_P CP_sort_description2
61: FROM psp_enc_summary_lines pesl,
62: psp_enc_lines_history pelh,
63: per_assignments_f paf
64: WHERE pesl.payroll_action_id = ' || P_PAYROLL_ACTION_ID || '

Line 331: END PSP_PSPENEXR_XMLP_PKG;

327: BEGIN
328: RETURN CP_SORT_BY_DETAIL;
329: END CP_SORT_BY_DETAIL_P;
330:
331: END PSP_PSPENEXR_XMLP_PKG;