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 51: l_varvalue pqp_exception_reports.variance_value%TYPE ;

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

Line 55: exception_report_id pqp_exception_reports.exception_report_id%TYPE,

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

Line 65: exception_report_id pqp_exception_reports.exception_report_id%TYPE,

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

Line 66: balance_type_id pqp_exception_reports.balance_type_id%TYPE,

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

Line 67: dimension_type_id pqp_exception_reports.balance_dimension_id%TYPE,

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

Line 68: variance_type pqp_exception_reports.variance_type%TYPE,

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

Line 69: variance_value pqp_exception_reports.variance_value%TYPE,

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

Line 70: variance_operator pqp_exception_reports.variance_operator%TYPE,

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

Line 71: comparison_type pqp_exception_reports.comparison_type%TYPE,

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

Line 72: comparison_value pqp_exception_reports.comparison_value%TYPE,

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

Line 82: exception_report_id pqp_exception_reports.exception_report_id%TYPE,

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

Line 83: balance_type_id pqp_exception_reports.balance_type_id%TYPE,

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

Line 350: FROM pqp_exception_reports

346: NVL(p_varvalue,variance_value),
347: variance_operator,
348: comparison_type,
349: comparison_value
350: FROM pqp_exception_reports
351: WHERE exception_report_id=p_report_id
352: AND (business_group_id =p_business_group_id
353: OR business_group_id IS NULL)
354: AND (legislation_code=p_legislation_code

Line 368: pqp_exception_reports per

364: per.variance_operator,
365: per.comparison_type,
366: per.comparison_value
367: FROM pqp_exception_report_groups perg,
368: pqp_exception_reports per
369: WHERE exception_group_name=(SELECT exception_group_name from
370: pqp_exception_report_groups
371: where exception_group_id=to_number(p_group_id))
372: AND ( perg.business_group_id =p_business_group_id

Line 395: l_exp_rep_id pqp_exception_reports.exception_report_id%TYPE ;

391: l_maxdate DATE ;
392: l_maxdate1 DATE ;
393: l_prev_pay_period DATE ;
394: l_def_bal_id NUMBER ;
395: l_exp_rep_id pqp_exception_reports.exception_report_id%TYPE ;
396: l_comp_type pqp_exception_reports.comparison_type%TYPE ;
397: l_comp_value pqp_exception_reports.comparison_value%TYPE ;
398: l_balance_type NUMBER ;
399: l_variance_type pqp_exception_reports.variance_type%TYPE ;

Line 396: l_comp_type pqp_exception_reports.comparison_type%TYPE ;

392: l_maxdate1 DATE ;
393: l_prev_pay_period DATE ;
394: l_def_bal_id NUMBER ;
395: l_exp_rep_id pqp_exception_reports.exception_report_id%TYPE ;
396: l_comp_type pqp_exception_reports.comparison_type%TYPE ;
397: l_comp_value pqp_exception_reports.comparison_value%TYPE ;
398: l_balance_type NUMBER ;
399: l_variance_type pqp_exception_reports.variance_type%TYPE ;
400: l_variance_value pqp_exception_reports.variance_value%TYPE ;

Line 397: l_comp_value pqp_exception_reports.comparison_value%TYPE ;

393: l_prev_pay_period DATE ;
394: l_def_bal_id NUMBER ;
395: l_exp_rep_id pqp_exception_reports.exception_report_id%TYPE ;
396: l_comp_type pqp_exception_reports.comparison_type%TYPE ;
397: l_comp_value pqp_exception_reports.comparison_value%TYPE ;
398: l_balance_type NUMBER ;
399: l_variance_type pqp_exception_reports.variance_type%TYPE ;
400: l_variance_value pqp_exception_reports.variance_value%TYPE ;
401: l_variance_operator pqp_exception_reports.variance_operator%TYPE;

Line 399: l_variance_type pqp_exception_reports.variance_type%TYPE ;

395: l_exp_rep_id pqp_exception_reports.exception_report_id%TYPE ;
396: l_comp_type pqp_exception_reports.comparison_type%TYPE ;
397: l_comp_value pqp_exception_reports.comparison_value%TYPE ;
398: l_balance_type NUMBER ;
399: l_variance_type pqp_exception_reports.variance_type%TYPE ;
400: l_variance_value pqp_exception_reports.variance_value%TYPE ;
401: l_variance_operator pqp_exception_reports.variance_operator%TYPE;
402: l_rowcount NUMBER ;
403: l_prev_balance NUMBER:=0 ;

Line 400: l_variance_value pqp_exception_reports.variance_value%TYPE ;

396: l_comp_type pqp_exception_reports.comparison_type%TYPE ;
397: l_comp_value pqp_exception_reports.comparison_value%TYPE ;
398: l_balance_type NUMBER ;
399: l_variance_type pqp_exception_reports.variance_type%TYPE ;
400: l_variance_value pqp_exception_reports.variance_value%TYPE ;
401: l_variance_operator pqp_exception_reports.variance_operator%TYPE;
402: l_rowcount NUMBER ;
403: l_prev_balance NUMBER:=0 ;
404: l_prev_balance1 NUMBER:=0 ;

Line 401: l_variance_operator pqp_exception_reports.variance_operator%TYPE;

397: l_comp_value pqp_exception_reports.comparison_value%TYPE ;
398: l_balance_type NUMBER ;
399: l_variance_type pqp_exception_reports.variance_type%TYPE ;
400: l_variance_value pqp_exception_reports.variance_value%TYPE ;
401: l_variance_operator pqp_exception_reports.variance_operator%TYPE;
402: l_rowcount NUMBER ;
403: l_prev_balance NUMBER:=0 ;
404: l_prev_balance1 NUMBER:=0 ;
405: l_pay_count NUMBER:=0 ;