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.PQP_EXPREPLOD_PKG dependencies on PQP_EXCEPTION_REPORTS

Line 52: l_varvalue pqp_exception_reports.variance_value%TYPE ;

48: l_date VARCHAR2(15) ;
49: l_report_id NUMBER ;
50: l_group_id VARCHAR2(60) ;
51: l_vartype VARCHAR2(1) ;
52: l_varvalue pqp_exception_reports.variance_value%TYPE ;
53: g_proc_name Varchar2(200) :='PQP_EXPREPLOD_PKG.';
54:
55: TYPE r_date_detail IS RECORD (
56: exception_report_id pqp_exception_reports.exception_report_id%TYPE,

Line 56: exception_report_id pqp_exception_reports.exception_report_id%TYPE,

52: l_varvalue pqp_exception_reports.variance_value%TYPE ;
53: g_proc_name Varchar2(200) :='PQP_EXPREPLOD_PKG.';
54:
55: TYPE r_date_detail IS RECORD (
56: exception_report_id pqp_exception_reports.exception_report_id%TYPE,
57: defined_balance_id pay_defined_balances.defined_balance_id%TYPE,
58: payroll_id per_assignments_f.payroll_id%TYPE,
59: pay_date DATE
60: );

Line 66: exception_report_id pqp_exception_reports.exception_report_id%TYPE,

62: INDEX BY binary_integer ;
63: l_date_detail t_date_detail ;
64:
65: TYPE r_rep_detail IS RECORD (
66: exception_report_id pqp_exception_reports.exception_report_id%TYPE,
67: balance_type_id pqp_exception_reports.balance_type_id%TYPE,
68: dimension_type_id pqp_exception_reports.balance_dimension_id%TYPE,
69: variance_type pqp_exception_reports.variance_type%TYPE,
70: variance_value pqp_exception_reports.variance_value%TYPE,

Line 67: balance_type_id pqp_exception_reports.balance_type_id%TYPE,

63: l_date_detail t_date_detail ;
64:
65: TYPE r_rep_detail IS RECORD (
66: exception_report_id pqp_exception_reports.exception_report_id%TYPE,
67: balance_type_id pqp_exception_reports.balance_type_id%TYPE,
68: dimension_type_id pqp_exception_reports.balance_dimension_id%TYPE,
69: variance_type pqp_exception_reports.variance_type%TYPE,
70: variance_value pqp_exception_reports.variance_value%TYPE,
71: variance_operator pqp_exception_reports.variance_operator%TYPE,

Line 68: dimension_type_id pqp_exception_reports.balance_dimension_id%TYPE,

64:
65: TYPE r_rep_detail IS RECORD (
66: exception_report_id pqp_exception_reports.exception_report_id%TYPE,
67: balance_type_id pqp_exception_reports.balance_type_id%TYPE,
68: dimension_type_id pqp_exception_reports.balance_dimension_id%TYPE,
69: variance_type pqp_exception_reports.variance_type%TYPE,
70: variance_value pqp_exception_reports.variance_value%TYPE,
71: variance_operator pqp_exception_reports.variance_operator%TYPE,
72: comparison_type pqp_exception_reports.comparison_type%TYPE,

Line 69: variance_type pqp_exception_reports.variance_type%TYPE,

65: TYPE r_rep_detail IS RECORD (
66: exception_report_id pqp_exception_reports.exception_report_id%TYPE,
67: balance_type_id pqp_exception_reports.balance_type_id%TYPE,
68: dimension_type_id pqp_exception_reports.balance_dimension_id%TYPE,
69: variance_type pqp_exception_reports.variance_type%TYPE,
70: variance_value pqp_exception_reports.variance_value%TYPE,
71: variance_operator pqp_exception_reports.variance_operator%TYPE,
72: comparison_type pqp_exception_reports.comparison_type%TYPE,
73: comparison_value pqp_exception_reports.comparison_value%TYPE,

Line 70: variance_value pqp_exception_reports.variance_value%TYPE,

66: exception_report_id pqp_exception_reports.exception_report_id%TYPE,
67: balance_type_id pqp_exception_reports.balance_type_id%TYPE,
68: dimension_type_id pqp_exception_reports.balance_dimension_id%TYPE,
69: variance_type pqp_exception_reports.variance_type%TYPE,
70: variance_value pqp_exception_reports.variance_value%TYPE,
71: variance_operator pqp_exception_reports.variance_operator%TYPE,
72: comparison_type pqp_exception_reports.comparison_type%TYPE,
73: comparison_value pqp_exception_reports.comparison_value%TYPE,
74: defined_balance_id pay_defined_balances.defined_balance_id%TYPE

Line 71: variance_operator pqp_exception_reports.variance_operator%TYPE,

67: balance_type_id pqp_exception_reports.balance_type_id%TYPE,
68: dimension_type_id pqp_exception_reports.balance_dimension_id%TYPE,
69: variance_type pqp_exception_reports.variance_type%TYPE,
70: variance_value pqp_exception_reports.variance_value%TYPE,
71: variance_operator pqp_exception_reports.variance_operator%TYPE,
72: comparison_type pqp_exception_reports.comparison_type%TYPE,
73: comparison_value pqp_exception_reports.comparison_value%TYPE,
74: defined_balance_id pay_defined_balances.defined_balance_id%TYPE
75: );

Line 72: comparison_type pqp_exception_reports.comparison_type%TYPE,

68: dimension_type_id pqp_exception_reports.balance_dimension_id%TYPE,
69: variance_type pqp_exception_reports.variance_type%TYPE,
70: variance_value pqp_exception_reports.variance_value%TYPE,
71: variance_operator pqp_exception_reports.variance_operator%TYPE,
72: comparison_type pqp_exception_reports.comparison_type%TYPE,
73: comparison_value pqp_exception_reports.comparison_value%TYPE,
74: defined_balance_id pay_defined_balances.defined_balance_id%TYPE
75: );
76:

Line 73: comparison_value pqp_exception_reports.comparison_value%TYPE,

69: variance_type pqp_exception_reports.variance_type%TYPE,
70: variance_value pqp_exception_reports.variance_value%TYPE,
71: variance_operator pqp_exception_reports.variance_operator%TYPE,
72: comparison_type pqp_exception_reports.comparison_type%TYPE,
73: comparison_value pqp_exception_reports.comparison_value%TYPE,
74: defined_balance_id pay_defined_balances.defined_balance_id%TYPE
75: );
76:
77: TYPE t_rep_detail IS TABLE OF r_rep_detail

Line 83: exception_report_id pqp_exception_reports.exception_report_id%TYPE,

79: l_rep_detail t_rep_detail;
80:
81:
82: TYPE r_ret_value IS RECORD (
83: exception_report_id pqp_exception_reports.exception_report_id%TYPE,
84: balance_type_id pqp_exception_reports.balance_type_id%TYPE,
85: curent_balance NUMBER,
86: previous_balance NUMBER,
87: ret_val VARCHAR2(1)

Line 84: balance_type_id pqp_exception_reports.balance_type_id%TYPE,

80:
81:
82: TYPE r_ret_value IS RECORD (
83: exception_report_id pqp_exception_reports.exception_report_id%TYPE,
84: balance_type_id pqp_exception_reports.balance_type_id%TYPE,
85: curent_balance NUMBER,
86: previous_balance NUMBER,
87: ret_val VARCHAR2(1)
88: );

Line 507: FROM pqp_exception_reports

503: NVL(p_varvalue,variance_value),
504: variance_operator,
505: comparison_type,
506: comparison_value
507: FROM pqp_exception_reports
508: WHERE exception_report_id=p_report_id
509: AND (business_group_id =p_business_group_id
510: OR business_group_id IS NULL)
511: AND (legislation_code=p_legislation_code

Line 525: pqp_exception_reports per

521: per.variance_operator,
522: per.comparison_type,
523: per.comparison_value
524: FROM pqp_exception_report_groups perg,
525: pqp_exception_reports per
526: WHERE exception_group_name=(SELECT exception_group_name from
527: pqp_exception_report_groups
528: where exception_group_id=to_number(p_group_id))
529: AND ( perg.business_group_id =p_business_group_id

Line 552: l_exp_rep_id pqp_exception_reports.exception_report_id%TYPE ;

548: l_maxdate DATE ;
549: l_maxdate1 DATE ;
550: l_prev_pay_period DATE ;
551: l_def_bal_id NUMBER ;
552: l_exp_rep_id pqp_exception_reports.exception_report_id%TYPE ;
553: l_comp_type pqp_exception_reports.comparison_type%TYPE ;
554: l_comp_value pqp_exception_reports.comparison_value%TYPE ;
555: l_balance_type NUMBER ;
556: l_variance_type pqp_exception_reports.variance_type%TYPE ;

Line 553: l_comp_type pqp_exception_reports.comparison_type%TYPE ;

549: l_maxdate1 DATE ;
550: l_prev_pay_period DATE ;
551: l_def_bal_id NUMBER ;
552: l_exp_rep_id pqp_exception_reports.exception_report_id%TYPE ;
553: l_comp_type pqp_exception_reports.comparison_type%TYPE ;
554: l_comp_value pqp_exception_reports.comparison_value%TYPE ;
555: l_balance_type NUMBER ;
556: l_variance_type pqp_exception_reports.variance_type%TYPE ;
557: l_variance_value pqp_exception_reports.variance_value%TYPE ;

Line 554: l_comp_value pqp_exception_reports.comparison_value%TYPE ;

550: l_prev_pay_period DATE ;
551: l_def_bal_id NUMBER ;
552: l_exp_rep_id pqp_exception_reports.exception_report_id%TYPE ;
553: l_comp_type pqp_exception_reports.comparison_type%TYPE ;
554: l_comp_value pqp_exception_reports.comparison_value%TYPE ;
555: l_balance_type NUMBER ;
556: l_variance_type pqp_exception_reports.variance_type%TYPE ;
557: l_variance_value pqp_exception_reports.variance_value%TYPE ;
558: l_variance_operator pqp_exception_reports.variance_operator%TYPE;

Line 556: l_variance_type pqp_exception_reports.variance_type%TYPE ;

552: l_exp_rep_id pqp_exception_reports.exception_report_id%TYPE ;
553: l_comp_type pqp_exception_reports.comparison_type%TYPE ;
554: l_comp_value pqp_exception_reports.comparison_value%TYPE ;
555: l_balance_type NUMBER ;
556: l_variance_type pqp_exception_reports.variance_type%TYPE ;
557: l_variance_value pqp_exception_reports.variance_value%TYPE ;
558: l_variance_operator pqp_exception_reports.variance_operator%TYPE;
559: l_rowcount NUMBER ;
560: l_prev_balance NUMBER:=0 ;

Line 557: l_variance_value pqp_exception_reports.variance_value%TYPE ;

553: l_comp_type pqp_exception_reports.comparison_type%TYPE ;
554: l_comp_value pqp_exception_reports.comparison_value%TYPE ;
555: l_balance_type NUMBER ;
556: l_variance_type pqp_exception_reports.variance_type%TYPE ;
557: l_variance_value pqp_exception_reports.variance_value%TYPE ;
558: l_variance_operator pqp_exception_reports.variance_operator%TYPE;
559: l_rowcount NUMBER ;
560: l_prev_balance NUMBER:=0 ;
561: l_prev_balance1 NUMBER:=0 ;

Line 558: l_variance_operator pqp_exception_reports.variance_operator%TYPE;

554: l_comp_value pqp_exception_reports.comparison_value%TYPE ;
555: l_balance_type NUMBER ;
556: l_variance_type pqp_exception_reports.variance_type%TYPE ;
557: l_variance_value pqp_exception_reports.variance_value%TYPE ;
558: l_variance_operator pqp_exception_reports.variance_operator%TYPE;
559: l_rowcount NUMBER ;
560: l_prev_balance NUMBER:=0 ;
561: l_prev_balance1 NUMBER:=0 ;
562: l_pay_count NUMBER:=0 ;