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.PQH_GSP_UTILITY dependencies on BEN_COPY_ENTITY_RESULTS

Line 16: (p_copy_entity_txn_id IN ben_copy_entity_results.copy_entity_result_id%TYPE )

12: ---------------------------CHK_GRADE_EXIST_IN_GL-----------------------------
13: --
14: -- mvankada
15: Function chk_grade_exist_in_gl
16: (p_copy_entity_txn_id IN ben_copy_entity_results.copy_entity_result_id%TYPE )
17: RETURN VARCHAR2;
18:
19: --mvankada
20: Procedure remove_grade_from_grdldr

Line 22: p_Grade_Result_Id IN ben_copy_entity_results.copy_entity_result_id%TYPE,

18:
19: --mvankada
20: Procedure remove_grade_from_grdldr
21: (
22: p_Grade_Result_Id IN ben_copy_entity_results.copy_entity_result_id%TYPE,
23: p_Copy_Entity_Txn_Id IN ben_copy_entity_results.copy_entity_txn_id%TYPE,
24: p_Business_Group_Id IN Number,
25: p_Effective_Date IN Date,
26: p_rec_exists OUT NOCOPY Varchar2

Line 23: p_Copy_Entity_Txn_Id IN ben_copy_entity_results.copy_entity_txn_id%TYPE,

19: --mvankada
20: Procedure remove_grade_from_grdldr
21: (
22: p_Grade_Result_Id IN ben_copy_entity_results.copy_entity_result_id%TYPE,
23: p_Copy_Entity_Txn_Id IN ben_copy_entity_results.copy_entity_txn_id%TYPE,
24: p_Business_Group_Id IN Number,
25: p_Effective_Date IN Date,
26: p_rec_exists OUT NOCOPY Varchar2
27: );

Line 50: p_step_result_id IN ben_copy_entity_results.copy_entity_result_id%TYPE,

46: --
47: --mvankada
48: Procedure remove_step_from_grade
49: (
50: p_step_result_id IN ben_copy_entity_results.copy_entity_result_id%TYPE,
51: p_copy_entity_txn_id IN number,
52: p_effective_date IN Date,
53: p_use_points IN varchar2 ,
54: p_step_id IN ben_copy_entity_results.information1%TYPE default NULL,

Line 54: p_step_id IN ben_copy_entity_results.information1%TYPE default NULL,

50: p_step_result_id IN ben_copy_entity_results.copy_entity_result_id%TYPE,
51: p_copy_entity_txn_id IN number,
52: p_effective_date IN Date,
53: p_use_points IN varchar2 ,
54: p_step_id IN ben_copy_entity_results.information1%TYPE default NULL,
55: p_celing_step_flag IN varchar2 default 'N',
56: p_rec_exists OUT NOCOPY Varchar2
57: );
58: --

Line 61: ( p_copy_entity_result_id IN Ben_Copy_Entity_Results.Copy_Entity_Result_Id%Type,

57: );
58: --
59: --mvankada
60: FUNCTION CHK_PROFILE_EXISTS
61: ( p_copy_entity_result_id IN Ben_Copy_Entity_Results.Copy_Entity_Result_Id%Type,
62: p_copy_entity_txn_id IN Ben_Copy_Entity_Results.Copy_Entity_Txn_Id%Type
63: ) RETURN varchar2;
64:
65:

Line 62: p_copy_entity_txn_id IN Ben_Copy_Entity_Results.Copy_Entity_Txn_Id%Type

58: --
59: --mvankada
60: FUNCTION CHK_PROFILE_EXISTS
61: ( p_copy_entity_result_id IN Ben_Copy_Entity_Results.Copy_Entity_Result_Id%Type,
62: p_copy_entity_txn_id IN Ben_Copy_Entity_Results.Copy_Entity_Txn_Id%Type
63: ) RETURN varchar2;
64:
65:
66: --mvankada

Line 69: p_Table_Alias IN Ben_Copy_Entity_Results.Table_Alias%Type,

65:
66: --mvankada
67: FUNCTION DISPLAY_ICON
68: (p_page IN Varchar2,
69: p_Table_Alias IN Ben_Copy_Entity_Results.Table_Alias%Type,
70: p_action IN Varchar2,
71: p_copy_entity_txn_id IN Ben_Copy_Entity_Results.Copy_Entity_Txn_Id%Type,
72: p_copy_entity_result_id IN Ben_Copy_Entity_Results.Copy_Entity_Result_Id%Type
73: ) RETURN varchar2;

Line 71: p_copy_entity_txn_id IN Ben_Copy_Entity_Results.Copy_Entity_Txn_Id%Type,

67: FUNCTION DISPLAY_ICON
68: (p_page IN Varchar2,
69: p_Table_Alias IN Ben_Copy_Entity_Results.Table_Alias%Type,
70: p_action IN Varchar2,
71: p_copy_entity_txn_id IN Ben_Copy_Entity_Results.Copy_Entity_Txn_Id%Type,
72: p_copy_entity_result_id IN Ben_Copy_Entity_Results.Copy_Entity_Result_Id%Type
73: ) RETURN varchar2;
74:
75:

Line 72: p_copy_entity_result_id IN Ben_Copy_Entity_Results.Copy_Entity_Result_Id%Type

68: (p_page IN Varchar2,
69: p_Table_Alias IN Ben_Copy_Entity_Results.Table_Alias%Type,
70: p_action IN Varchar2,
71: p_copy_entity_txn_id IN Ben_Copy_Entity_Results.Copy_Entity_Txn_Id%Type,
72: p_copy_entity_result_id IN Ben_Copy_Entity_Results.Copy_Entity_Result_Id%Type
73: ) RETURN varchar2;
74:
75:
76: procedure chk_grd_details

Line 82: p_copy_entity_result_id IN ben_copy_entity_results.copy_entity_result_id%TYPE default NULL,

78: p_name IN per_grades.name%TYPE ,
79: p_short_name IN per_grades.short_name%TYPE,
80: p_business_group_id IN per_grades.business_group_id%TYPE,
81: p_grade_id IN per_grades.grade_id%TYPE default NULL,
82: p_copy_entity_result_id IN ben_copy_entity_results.copy_entity_result_id%TYPE default NULL,
83: p_copy_entity_txn_id IN ben_copy_entity_results.copy_entity_txn_id%TYPE,
84: p_status OUT NOCOPY VARCHAR
85: );
86:

Line 83: p_copy_entity_txn_id IN ben_copy_entity_results.copy_entity_txn_id%TYPE,

79: p_short_name IN per_grades.short_name%TYPE,
80: p_business_group_id IN per_grades.business_group_id%TYPE,
81: p_grade_id IN per_grades.grade_id%TYPE default NULL,
82: p_copy_entity_result_id IN ben_copy_entity_results.copy_entity_result_id%TYPE default NULL,
83: p_copy_entity_txn_id IN ben_copy_entity_results.copy_entity_txn_id%TYPE,
84: p_status OUT NOCOPY VARCHAR
85: );
86:
87: --mvankada

Line 90: p_Table_Alias in ben_copy_entity_results.Table_Alias%Type,

86:
87: --mvankada
88: FUNCTION GET_STEP_PRG_RULE_HGRID_NAME( p_copy_entity_result_id in Number,
89: p_copy_entity_txn_id in Number,
90: p_Table_Alias in ben_copy_entity_results.Table_Alias%Type,
91: p_hgrid in Varchar Default NULL)
92: RETURN varchar2;
93: --
94:

Line 368: p_copy_entity_result_id IN ben_copy_entity_results.copy_entity_result_id%TYPE,

364: p_exists_flag Out nocopy varchar2);
365: --
366: procedure update_oipl_records(
367: p_effective_date IN DATE,
368: p_copy_entity_result_id IN ben_copy_entity_results.copy_entity_result_id%TYPE,
369: p_point_name IN ben_copy_entity_results.information99%TYPE,
370: p_sequence IN ben_copy_entity_results.information263%TYPE,
371: p_copy_entity_txn_id IN ben_copy_entity_results.copy_entity_txn_id%TYPE
372: );

Line 369: p_point_name IN ben_copy_entity_results.information99%TYPE,

365: --
366: procedure update_oipl_records(
367: p_effective_date IN DATE,
368: p_copy_entity_result_id IN ben_copy_entity_results.copy_entity_result_id%TYPE,
369: p_point_name IN ben_copy_entity_results.information99%TYPE,
370: p_sequence IN ben_copy_entity_results.information263%TYPE,
371: p_copy_entity_txn_id IN ben_copy_entity_results.copy_entity_txn_id%TYPE
372: );
373: --

Line 370: p_sequence IN ben_copy_entity_results.information263%TYPE,

366: procedure update_oipl_records(
367: p_effective_date IN DATE,
368: p_copy_entity_result_id IN ben_copy_entity_results.copy_entity_result_id%TYPE,
369: p_point_name IN ben_copy_entity_results.information99%TYPE,
370: p_sequence IN ben_copy_entity_results.information263%TYPE,
371: p_copy_entity_txn_id IN ben_copy_entity_results.copy_entity_txn_id%TYPE
372: );
373: --
374: Procedure validate_crset_values(p_copy_entity_txn_id in number,

Line 371: p_copy_entity_txn_id IN ben_copy_entity_results.copy_entity_txn_id%TYPE

367: p_effective_date IN DATE,
368: p_copy_entity_result_id IN ben_copy_entity_results.copy_entity_result_id%TYPE,
369: p_point_name IN ben_copy_entity_results.information99%TYPE,
370: p_sequence IN ben_copy_entity_results.information263%TYPE,
371: p_copy_entity_txn_id IN ben_copy_entity_results.copy_entity_txn_id%TYPE
372: );
373: --
374: Procedure validate_crset_values(p_copy_entity_txn_id in number,
375: p_effective_date in date);

Line 405: (p_in_dml_operation in ben_copy_entity_results.dml_operation%TYPE)

401: p_grade_definition_id IN NUMBER,
402: p_business_group_id IN NUMBER,
403: p_concatenated_segments OUT NOCOPY VARCHAR2);
404: FUNCTION GET_DML_OPERATION
405: (p_in_dml_operation in ben_copy_entity_results.dml_operation%TYPE)
406: RETURN VARCHAR2;
407: --
408: Procedure chk_no_asg_grd_ldr(p_asg_grade_ladder_id in number,
409: p_asg_grade_id in number,

Line 461: FUNCTION get_grd_start_date(p_copy_entity_result_id in ben_copy_entity_results.copy_entity_result_id%TYPE)RETURN DATE;

457: procedure change_scale_name(p_copy_entity_txn_id in number,p_pl_cer_id in number,p_short_name in varchar2);
458: procedure remove_steps(p_copy_entity_txn_id IN NUMBER, p_grade_result_id IN NUMBER);
459: procedure change_rates_date(p_copy_entity_txn_id in number,p_pl_cer_id in number,p_start_date in DATE);
460: FUNCTION GET_CURRENCY_CODE(p_copy_entity_txn_id in number) RETURN varchar2;
461: FUNCTION get_grd_start_date(p_copy_entity_result_id in ben_copy_entity_results.copy_entity_result_id%TYPE)RETURN DATE;
462: procedure change_start_step(p_copy_entity_txn_id in number
463: ,p_init_start_step in number
464: ,p_final_start_step in number
465: ,p_grade_result_id in number