APPS.HRDPP_UPLOAD_SALARY_PROPOSAL SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 66

insert into hr_pump_batch_line_user_keys
(user_key_id, batch_line_id,user_key_value,unique_key_id)
values
(hr_pump_batch_line_user_keys_s.nextval,
p_batch_line_id,
p_user_key_value,
p_unique_key_id);

Line: 76

procedure insert_batch_lines
(p_batch_id      in number
,p_data_pump_batch_line_id in number default null
,p_data_pump_business_grp_name in varchar2 default null
,p_user_sequence in number default null
,p_link_value    in number default null
,P_CHANGE_DATE in date
,P_PROPOSED_SALARY in number default null
,P_PROPOSAL_REASON in varchar2 default null
,P_NEXT_SAL_REVIEW_DATE in date default null
,P_FORCED_RANKING in number default null
,P_DATE_TO in date default null
,P_PAY_PROPOSAL_ID in number
,P_OBJECT_VERSION_NUMBER in number
,P_COMPONENT_REASON_1 in varchar2
,P_CHANGE_AMOUNT_1 in number default null
,P_CHANGE_PERCENTAGE_1 in number default null
,P_APPROVED_1 in varchar2
,P_COMPONENT_ID_1 in number
,P_PPC_OBJECT_VERSION_NUMBER_1 in number
,P_COMPONENT_REASON_2 in varchar2
,P_CHANGE_AMOUNT_2 in number default null
,P_CHANGE_PERCENTAGE_2 in number default null
,P_APPROVED_2 in varchar2
,P_COMPONENT_ID_2 in number
,P_PPC_OBJECT_VERSION_NUMBER_2 in number
,P_COMPONENT_REASON_3 in varchar2
,P_CHANGE_AMOUNT_3 in number default null
,P_CHANGE_PERCENTAGE_3 in number default null
,P_APPROVED_3 in varchar2
,P_COMPONENT_ID_3 in number
,P_PPC_OBJECT_VERSION_NUMBER_3 in number
,P_COMPONENT_REASON_4 in varchar2
,P_CHANGE_AMOUNT_4 in number default null
,P_CHANGE_PERCENTAGE_4 in number default null
,P_APPROVED_4 in varchar2
,P_COMPONENT_ID_4 in number
,P_PPC_OBJECT_VERSION_NUMBER_4 in number
,P_COMPONENT_REASON_5 in varchar2
,P_CHANGE_AMOUNT_5 in number default null
,P_CHANGE_PERCENTAGE_5 in number default null
,P_APPROVED_5 in varchar2
,P_COMPONENT_ID_5 in number
,P_PPC_OBJECT_VERSION_NUMBER_5 in number
,P_COMPONENT_REASON_6 in varchar2
,P_CHANGE_AMOUNT_6 in number default null
,P_CHANGE_PERCENTAGE_6 in number default null
,P_APPROVED_6 in varchar2
,P_COMPONENT_ID_6 in number
,P_PPC_OBJECT_VERSION_NUMBER_6 in number
,P_COMPONENT_REASON_7 in varchar2
,P_CHANGE_AMOUNT_7 in number default null
,P_CHANGE_PERCENTAGE_7 in number default null
,P_APPROVED_7 in varchar2
,P_COMPONENT_ID_7 in number
,P_PPC_OBJECT_VERSION_NUMBER_7 in number
,P_COMPONENT_REASON_8 in varchar2
,P_CHANGE_AMOUNT_8 in number default null
,P_CHANGE_PERCENTAGE_8 in number default null
,P_APPROVED_8 in varchar2
,P_COMPONENT_ID_8 in number
,P_PPC_OBJECT_VERSION_NUMBER_8 in number
,P_COMPONENT_REASON_9 in varchar2
,P_CHANGE_AMOUNT_9 in number default null
,P_CHANGE_PERCENTAGE_9 in number default null
,P_APPROVED_9 in varchar2
,P_COMPONENT_ID_9 in number
,P_PPC_OBJECT_VERSION_NUMBER_9 in number
,P_COMPONENT_REASON_10 in varchar2
,P_CHANGE_AMOUNT_10 in number default null
,P_CHANGE_PERCENTAGE_10 in number default null
,P_APPROVED_10 in varchar2
,P_COMPONENT_ID_10 in number
,P_PPC_OBJECT_VERSION_NUMBER_10 in number
,P_ATTRIBUTE_CATEGORY in varchar2 default null
,P_ATTRIBUTE1 in varchar2 default null
,P_ATTRIBUTE2 in varchar2 default null
,P_ATTRIBUTE3 in varchar2 default null
,P_ATTRIBUTE4 in varchar2 default null
,P_ATTRIBUTE5 in varchar2 default null
,P_ATTRIBUTE6 in varchar2 default null
,P_ATTRIBUTE7 in varchar2 default null
,P_ATTRIBUTE8 in varchar2 default null
,P_ATTRIBUTE9 in varchar2 default null
,P_ATTRIBUTE10 in varchar2 default null
,P_ATTRIBUTE11 in varchar2 default null
,P_ATTRIBUTE12 in varchar2 default null
,P_ATTRIBUTE13 in varchar2 default null
,P_ATTRIBUTE14 in varchar2 default null
,P_ATTRIBUTE15 in varchar2 default null
,P_ATTRIBUTE16 in varchar2 default null
,P_ATTRIBUTE17 in varchar2 default null
,P_ATTRIBUTE18 in varchar2 default null
,P_ATTRIBUTE19 in varchar2 default null
,P_ATTRIBUTE20 in varchar2 default null
,P_ASSIGNMENT_USER_KEY in varchar2) is
blid number := p_data_pump_batch_line_id;

Line: 175

delete from hr_pump_batch_lines where batch_line_id = blid;

Line: 176

delete from hr_pump_batch_exceptions
where source_type = 'BATCH_LINE' and source_id = blid;

Line: 179

insert into hr_pump_batch_lines
(batch_id
,batch_line_id
,business_group_name
,api_module_id
,line_status
,user_sequence
,link_value
,pval001
,pval002
,pval003
,pval004
,pval005
,pval006
,pval007
,pval008
,pval009
,pval010
,pval011
,pval012
,pval013
,pval014
,pval015
,pval016
,pval017
,pval018
,pval019
,pval020
,pval021
,pval022
,pval023
,pval024
,pval025
,pval026
,pval027
,pval028
,pval029
,pval030
,pval031
,pval032
,pval033
,pval034
,pval035
,pval036
,pval037
,pval038
,pval039
,pval040
,pval041
,pval042
,pval043
,pval044
,pval045
,pval046
,pval047
,pval048
,pval049
,pval050
,pval051
,pval052
,pval053
,pval054
,pval055
,pval056
,pval057
,pval058
,pval059
,pval060
,pval061
,pval062
,pval063
,pval064
,pval065
,pval066
,pval067
,pval068
,pval071
,pval072
,pval073
,pval074
,pval075
,pval076
,pval077
,pval078
,pval079
,pval080
,pval081
,pval082
,pval083
,pval084
,pval085
,pval086
,pval087
,pval088
,pval089
,pval090
,pval091
,pval092)
values
(p_batch_id
,nvl(blid,hr_pump_batch_lines_s.nextval)
,p_data_pump_business_grp_name
,1324
,'U'
,p_user_sequence
,p_link_value
,dc(P_CHANGE_DATE)
,P_PROPOSED_SALARY
,P_PROPOSAL_REASON
,dc(P_NEXT_SAL_REVIEW_DATE)
,P_FORCED_RANKING
,dc(P_DATE_TO)
,P_PAY_PROPOSAL_ID
,P_OBJECT_VERSION_NUMBER
,P_COMPONENT_REASON_1
,P_CHANGE_AMOUNT_1
,P_CHANGE_PERCENTAGE_1
,P_APPROVED_1
,P_COMPONENT_ID_1
,P_PPC_OBJECT_VERSION_NUMBER_1
,P_COMPONENT_REASON_2
,P_CHANGE_AMOUNT_2
,P_CHANGE_PERCENTAGE_2
,P_APPROVED_2
,P_COMPONENT_ID_2
,P_PPC_OBJECT_VERSION_NUMBER_2
,P_COMPONENT_REASON_3
,P_CHANGE_AMOUNT_3
,P_CHANGE_PERCENTAGE_3
,P_APPROVED_3
,P_COMPONENT_ID_3
,P_PPC_OBJECT_VERSION_NUMBER_3
,P_COMPONENT_REASON_4
,P_CHANGE_AMOUNT_4
,P_CHANGE_PERCENTAGE_4
,P_APPROVED_4
,P_COMPONENT_ID_4
,P_PPC_OBJECT_VERSION_NUMBER_4
,P_COMPONENT_REASON_5
,P_CHANGE_AMOUNT_5
,P_CHANGE_PERCENTAGE_5
,P_APPROVED_5
,P_COMPONENT_ID_5
,P_PPC_OBJECT_VERSION_NUMBER_5
,P_COMPONENT_REASON_6
,P_CHANGE_AMOUNT_6
,P_CHANGE_PERCENTAGE_6
,P_APPROVED_6
,P_COMPONENT_ID_6
,P_PPC_OBJECT_VERSION_NUMBER_6
,P_COMPONENT_REASON_7
,P_CHANGE_AMOUNT_7
,P_CHANGE_PERCENTAGE_7
,P_APPROVED_7
,P_COMPONENT_ID_7
,P_PPC_OBJECT_VERSION_NUMBER_7
,P_COMPONENT_REASON_8
,P_CHANGE_AMOUNT_8
,P_CHANGE_PERCENTAGE_8
,P_APPROVED_8
,P_COMPONENT_ID_8
,P_PPC_OBJECT_VERSION_NUMBER_8
,P_COMPONENT_REASON_9
,P_CHANGE_AMOUNT_9
,P_CHANGE_PERCENTAGE_9
,P_APPROVED_9
,P_COMPONENT_ID_9
,P_PPC_OBJECT_VERSION_NUMBER_9
,P_COMPONENT_REASON_10
,P_CHANGE_AMOUNT_10
,P_CHANGE_PERCENTAGE_10
,P_APPROVED_10
,P_COMPONENT_ID_10
,P_PPC_OBJECT_VERSION_NUMBER_10
,P_ATTRIBUTE_CATEGORY
,P_ATTRIBUTE1
,P_ATTRIBUTE2
,P_ATTRIBUTE3
,P_ATTRIBUTE4
,P_ATTRIBUTE5
,P_ATTRIBUTE6
,P_ATTRIBUTE7
,P_ATTRIBUTE8
,P_ATTRIBUTE9
,P_ATTRIBUTE10
,P_ATTRIBUTE11
,P_ATTRIBUTE12
,P_ATTRIBUTE13
,P_ATTRIBUTE14
,P_ATTRIBUTE15
,P_ATTRIBUTE16
,P_ATTRIBUTE17
,P_ATTRIBUTE18
,P_ATTRIBUTE19
,P_ATTRIBUTE20
,P_ASSIGNMENT_USER_KEY);

Line: 375

end insert_batch_lines;

Line: 381

select l.rowid myrowid,
decode(l.pval001,cn,dn,d(l.pval001)) p1,
decode(l.pval002,cn,nn,vn,nn,n(l.pval002)) p2,
l.pval002 d2,
decode(l.pval003,cn,vn,vn,vn,
 hr_pump_get.gl(l.pval003,'PROPOSAL_REASON',dn,vn)) p3,
l.pval003 d3,
decode(l.pval004,cn,dn,vn,dn,d(l.pval004)) p4,
l.pval004 d4,
decode(l.pval005,cn,nn,vn,nn,n(l.pval005)) p5,
l.pval005 d5,
decode(l.pval006,cn,dn,vn,dn,d(l.pval006)) p6,
l.pval006 d6,
decode(l.pval007,cn,nn,n(l.pval007)) p7,
decode(l.pval008,cn,nn,n(l.pval008)) p8,
decode(l.pval009,cn,vn,
 hr_pump_get.gl(l.pval009,'PROPOSAL_REASON',dn,vn)) p9,
decode(l.pval010,cn,nn,vn,nn,n(l.pval010)) p10,
l.pval010 d10,
decode(l.pval011,cn,nn,vn,nn,n(l.pval011)) p11,
l.pval011 d11,
decode(l.pval012,cn,vn,
 hr_pump_get.gl(l.pval012,'YES_NO',dn,vn)) p12,
decode(l.pval013,cn,nn,n(l.pval013)) p13,
decode(l.pval014,cn,nn,n(l.pval014)) p14,
decode(l.pval015,cn,vn,
 hr_pump_get.gl(l.pval015,'PROPOSAL_REASON',dn,vn)) p15,
decode(l.pval016,cn,nn,vn,nn,n(l.pval016)) p16,
l.pval016 d16,
decode(l.pval017,cn,nn,vn,nn,n(l.pval017)) p17,
l.pval017 d17,
decode(l.pval018,cn,vn,
 hr_pump_get.gl(l.pval018,'YES_NO',dn,vn)) p18,
decode(l.pval019,cn,nn,n(l.pval019)) p19,
decode(l.pval020,cn,nn,n(l.pval020)) p20,
decode(l.pval021,cn,vn,
 hr_pump_get.gl(l.pval021,'PROPOSAL_REASON',dn,vn)) p21,
decode(l.pval022,cn,nn,vn,nn,n(l.pval022)) p22,
l.pval022 d22,
decode(l.pval023,cn,nn,vn,nn,n(l.pval023)) p23,
l.pval023 d23,
decode(l.pval024,cn,vn,
 hr_pump_get.gl(l.pval024,'YES_NO',dn,vn)) p24,
decode(l.pval025,cn,nn,n(l.pval025)) p25,
decode(l.pval026,cn,nn,n(l.pval026)) p26,
decode(l.pval027,cn,vn,
 hr_pump_get.gl(l.pval027,'PROPOSAL_REASON',dn,vn)) p27,
decode(l.pval028,cn,nn,vn,nn,n(l.pval028)) p28,
l.pval028 d28,
decode(l.pval029,cn,nn,vn,nn,n(l.pval029)) p29,
l.pval029 d29,
decode(l.pval030,cn,vn,
 hr_pump_get.gl(l.pval030,'YES_NO',dn,vn)) p30,
decode(l.pval031,cn,nn,n(l.pval031)) p31,
decode(l.pval032,cn,nn,n(l.pval032)) p32,
decode(l.pval033,cn,vn,
 hr_pump_get.gl(l.pval033,'PROPOSAL_REASON',dn,vn)) p33,
decode(l.pval034,cn,nn,vn,nn,n(l.pval034)) p34,
l.pval034 d34,
decode(l.pval035,cn,nn,vn,nn,n(l.pval035)) p35,
l.pval035 d35,
decode(l.pval036,cn,vn,
 hr_pump_get.gl(l.pval036,'YES_NO',dn,vn)) p36,
decode(l.pval037,cn,nn,n(l.pval037)) p37,
decode(l.pval038,cn,nn,n(l.pval038)) p38,
decode(l.pval039,cn,vn,
 hr_pump_get.gl(l.pval039,'PROPOSAL_REASON',dn,vn)) p39,
decode(l.pval040,cn,nn,vn,nn,n(l.pval040)) p40,
l.pval040 d40,
decode(l.pval041,cn,nn,vn,nn,n(l.pval041)) p41,
l.pval041 d41,
decode(l.pval042,cn,vn,
 hr_pump_get.gl(l.pval042,'YES_NO',dn,vn)) p42,
decode(l.pval043,cn,nn,n(l.pval043)) p43,
decode(l.pval044,cn,nn,n(l.pval044)) p44,
decode(l.pval045,cn,vn,
 hr_pump_get.gl(l.pval045,'PROPOSAL_REASON',dn,vn)) p45,
decode(l.pval046,cn,nn,vn,nn,n(l.pval046)) p46,
l.pval046 d46,
decode(l.pval047,cn,nn,vn,nn,n(l.pval047)) p47,
l.pval047 d47,
decode(l.pval048,cn,vn,
 hr_pump_get.gl(l.pval048,'YES_NO',dn,vn)) p48,
decode(l.pval049,cn,nn,n(l.pval049)) p49,
decode(l.pval050,cn,nn,n(l.pval050)) p50,
decode(l.pval051,cn,vn,
 hr_pump_get.gl(l.pval051,'PROPOSAL_REASON',dn,vn)) p51,
decode(l.pval052,cn,nn,vn,nn,n(l.pval052)) p52,
l.pval052 d52,
decode(l.pval053,cn,nn,vn,nn,n(l.pval053)) p53,
l.pval053 d53,
decode(l.pval054,cn,vn,
 hr_pump_get.gl(l.pval054,'YES_NO',dn,vn)) p54,
decode(l.pval055,cn,nn,n(l.pval055)) p55,
decode(l.pval056,cn,nn,n(l.pval056)) p56,
decode(l.pval057,cn,vn,
 hr_pump_get.gl(l.pval057,'PROPOSAL_REASON',dn,vn)) p57,
decode(l.pval058,cn,nn,vn,nn,n(l.pval058)) p58,
l.pval058 d58,
decode(l.pval059,cn,nn,vn,nn,n(l.pval059)) p59,
l.pval059 d59,
decode(l.pval060,cn,vn,
 hr_pump_get.gl(l.pval060,'YES_NO',dn,vn)) p60,
decode(l.pval061,cn,nn,n(l.pval061)) p61,
decode(l.pval062,cn,nn,n(l.pval062)) p62,
decode(l.pval063,cn,vn,
 hr_pump_get.gl(l.pval063,'PROPOSAL_REASON',dn,vn)) p63,
decode(l.pval064,cn,nn,vn,nn,n(l.pval064)) p64,
l.pval064 d64,
decode(l.pval065,cn,nn,vn,nn,n(l.pval065)) p65,
l.pval065 d65,
decode(l.pval066,cn,vn,
 hr_pump_get.gl(l.pval066,'YES_NO',dn,vn)) p66,
decode(l.pval067,cn,nn,n(l.pval067)) p67,
decode(l.pval068,cn,nn,n(l.pval068)) p68,
l.pval069 p69,
l.pval070 p70,
decode(l.pval071,cn,vn,vn,vn,l.pval071) p71,
l.pval071 d71,
decode(l.pval072,cn,vn,vn,vn,l.pval072) p72,
l.pval072 d72,
decode(l.pval073,cn,vn,vn,vn,l.pval073) p73,
l.pval073 d73,
decode(l.pval074,cn,vn,vn,vn,l.pval074) p74,
l.pval074 d74,
decode(l.pval075,cn,vn,vn,vn,l.pval075) p75,
l.pval075 d75,
decode(l.pval076,cn,vn,vn,vn,l.pval076) p76,
l.pval076 d76,
decode(l.pval077,cn,vn,vn,vn,l.pval077) p77,
l.pval077 d77,
decode(l.pval078,cn,vn,vn,vn,l.pval078) p78,
l.pval078 d78,
decode(l.pval079,cn,vn,vn,vn,l.pval079) p79,
l.pval079 d79,
decode(l.pval080,cn,vn,vn,vn,l.pval080) p80,
l.pval080 d80,
decode(l.pval081,cn,vn,vn,vn,l.pval081) p81,
l.pval081 d81,
decode(l.pval082,cn,vn,vn,vn,l.pval082) p82,
l.pval082 d82,
decode(l.pval083,cn,vn,vn,vn,l.pval083) p83,
l.pval083 d83,
decode(l.pval084,cn,vn,vn,vn,l.pval084) p84,
l.pval084 d84,
decode(l.pval085,cn,vn,vn,vn,l.pval085) p85,
l.pval085 d85,
decode(l.pval086,cn,vn,vn,vn,l.pval086) p86,
l.pval086 d86,
decode(l.pval087,cn,vn,vn,vn,l.pval087) p87,
l.pval087 d87,
decode(l.pval088,cn,vn,vn,vn,l.pval088) p88,
l.pval088 d88,
decode(l.pval089,cn,vn,vn,vn,l.pval089) p89,
l.pval089 d89,
decode(l.pval090,cn,vn,vn,vn,l.pval090) p90,
l.pval090 d90,
decode(l.pval091,cn,vn,vn,vn,l.pval091) p91,
l.pval091 d91,
decode(l.pval092,cn,vn,l.pval092) p92
from hr_pump_batch_lines l
where l.batch_line_id = p_batch_line_id;

Line: 680

update hr_pump_batch_lines l set
l.pval007 = decode(c.p7,null,cn,c.p7),
l.pval008 = decode(c.p8,null,cn,c.p8),
l.pval013 = decode(c.p13,null,cn,c.p13),
l.pval014 = decode(c.p14,null,cn,c.p14),
l.pval019 = decode(c.p19,null,cn,c.p19),
l.pval020 = decode(c.p20,null,cn,c.p20),
l.pval025 = decode(c.p25,null,cn,c.p25),
l.pval026 = decode(c.p26,null,cn,c.p26),
l.pval031 = decode(c.p31,null,cn,c.p31),
l.pval032 = decode(c.p32,null,cn,c.p32),
l.pval037 = decode(c.p37,null,cn,c.p37),
l.pval038 = decode(c.p38,null,cn,c.p38),
l.pval043 = decode(c.p43,null,cn,c.p43),
l.pval044 = decode(c.p44,null,cn,c.p44),
l.pval049 = decode(c.p49,null,cn,c.p49),
l.pval050 = decode(c.p50,null,cn,c.p50),
l.pval055 = decode(c.p55,null,cn,c.p55),
l.pval056 = decode(c.p56,null,cn,c.p56),
l.pval061 = decode(c.p61,null,cn,c.p61),
l.pval062 = decode(c.p62,null,cn,c.p62),
l.pval067 = decode(c.p67,null,cn,c.p67),
l.pval068 = decode(c.p68,null,cn,c.p68),
l.pval069 = decode(c.p69,null,cn,c.p69),
l.pval070 = decode(c.p70,null,cn,c.p70)
where l.rowid = c.myrowid;