APPS.PAY_PAYRG_PKG dependencies on PAY_US_RPT_TOTALS

Line 777: -- Insert a row in pay_us_rpt_totals which includes

773: exception when others then
774: null;
775: end;
776:
777: -- Insert a row in pay_us_rpt_totals which includes
778: -- payroll_action_id,
779: -- report created assignment_action_id (lockingactid)
780: -- and "payroll run" assignment_action id.
781:

Line 782: insert into pay_us_rpt_totals

778: -- payroll_action_id,
779: -- report created assignment_action_id (lockingactid)
780: -- and "payroll run" assignment_action id.
781:
782: insert into pay_us_rpt_totals
783: (session_id,
784: tax_unit_id,
785: location_id,
786: value1)

Line 843: insert into pay_us_rpt_totals

839: loop
840: fetch c_multi_ba_acts into l_asg_act_id,run_action_type;
841: exit when c_multi_ba_acts%notfound;
842:
843: insert into pay_us_rpt_totals
844: (session_id,
845: tax_unit_id,
846: location_id,
847: value1)

Line 874: -- pay_us_rpt_totals is populated for all Balance Adjustments.

870: end if;
871: end loop;
872: close c_multi_ba_acts;
873: lv_max_run_flag := 'N'; -- This is addded to Fix Bug # 5204333
874: -- pay_us_rpt_totals is populated for all Balance Adjustments.
875:
876: begin
877: if runactid is not NULL then
878: serialno := nvl(lv_run_action_type,'R') ||

Line 903: -- Insert a row in pay_us_rpt_totals which includes

899:
900: fetch c_multi_asg_rpt_acts into l_asg_act_id;
901:
902: exit when c_multi_asg_rpt_acts%NOTFOUND;
903: -- Insert a row in pay_us_rpt_totals which includes
904: -- payroll_action_id,
905: -- report created assignment_action_id (lockingactid)
906: -- and "payroll run" assignment_action id.
907:

Line 908: insert into pay_us_rpt_totals

904: -- payroll_action_id,
905: -- report created assignment_action_id (lockingactid)
906: -- and "payroll run" assignment_action id.
907:
908: insert into pay_us_rpt_totals
909: (session_id,
910: tax_unit_id,
911: location_id,
912: value1)

Line 953: -- Insert a row in pay_us_rpt_totals which includes

949: exception when others then
950: null;
951: end;
952:
953: -- Insert a row in pay_us_rpt_totals which includes
954: -- payroll_action_id,
955: -- report created assignment_action_id (lockingactid)
956: -- and "payroll run" assignment_action id.
957:

Line 958: insert into pay_us_rpt_totals

954: -- payroll_action_id,
955: -- report created assignment_action_id (lockingactid)
956: -- and "payroll run" assignment_action id.
957:
958: insert into pay_us_rpt_totals
959: (session_id,
960: tax_unit_id,
961: location_id,
962: value1)

Line 1023: - insert multiple rows in pay_us_rpt_totals

1019:
1020: open c_payroll_run (lockedactid);
1021: /* Pre-payment can lock more then one run so this should loop
1022: commented out following two lines - bug 3385676
1023: - insert multiple rows in pay_us_rpt_totals
1024:
1025: fetch c_payroll_run into ln_master_action_id,lv_run_action_type;
1026: close c_payroll_run;
1027: */

Line 1054: -- Insert a row in pay_us_rpt_totals which includes

1050: exception when others then
1051: null;
1052: end;
1053:
1054: -- Insert a row in pay_us_rpt_totals which includes
1055: -- payroll_action_id,
1056: -- report created assignment_action_id (lockingactid)
1057: -- and "payroll run" assignment_action id.
1058:

Line 1059: insert into pay_us_rpt_totals

1055: -- payroll_action_id,
1056: -- report created assignment_action_id (lockingactid)
1057: -- and "payroll run" assignment_action id.
1058:
1059: insert into pay_us_rpt_totals
1060: (session_id,
1061: tax_unit_id,
1062: location_id,
1063: value1)

Line 1121: -- Insert a row in pay_us_rpt_totals which includes

1117: exception when others then
1118: null;
1119: end;
1120:
1121: -- Insert a row in pay_us_rpt_totals which includes
1122: -- payroll_action_id,
1123: -- report created assignment_action_id (lockingactid)
1124: -- and "payroll run" assignment_action id.
1125:

Line 1126: insert into pay_us_rpt_totals

1122: -- payroll_action_id,
1123: -- report created assignment_action_id (lockingactid)
1124: -- and "payroll run" assignment_action id.
1125:
1126: insert into pay_us_rpt_totals
1127: (session_id,
1128: tax_unit_id,
1129: location_id,
1130: value1)

Line 1139: -- Bug 4074976 Begin-- We will loop the cursor c_payroll_run and insert rows in pay_us_rpt_totals for max(run) action

1135:
1136: -- skip till next source action id
1137:
1138: ln_prev_source_action_id := ln_source_action_id;
1139: -- Bug 4074976 Begin-- We will loop the cursor c_payroll_run and insert rows in pay_us_rpt_totals for max(run) action
1140: -- id and all the balance id's which the prepayment locks.
1141: else
1142: lv_max_run_flag := 'N' ; -- Initialise the variables.
1143:

Line 1175: -- Insert a row in pay_us_rpt_totals which includes

1171: exception when others then
1172: null;
1173: end;
1174:
1175: -- Insert a row in pay_us_rpt_totals which includes
1176: -- payroll_action_id,
1177: -- report created assignment_action_id (lockingactid)
1178: -- and "payroll run" assignment_action id.
1179:

Line 1180: insert into pay_us_rpt_totals

1176: -- payroll_action_id,
1177: -- report created assignment_action_id (lockingactid)
1178: -- and "payroll run" assignment_action id.
1179:
1180: insert into pay_us_rpt_totals
1181: (session_id,
1182: tax_unit_id,
1183: location_id,
1184: value1)

Line 1232: -- Insert a row in pay_us_rpt_totals which includes

1228: exception when others then
1229: null;
1230: end;
1231:
1232: -- Insert a row in pay_us_rpt_totals which includes
1233: -- payroll_action_id,
1234: -- report created assignment_action_id (lockingactid)
1235: -- and "payroll run" assignment_action id.
1236:

Line 1237: insert into pay_us_rpt_totals

1233: -- payroll_action_id,
1234: -- report created assignment_action_id (lockingactid)
1235: -- and "payroll run" assignment_action id.
1236:
1237: insert into pay_us_rpt_totals
1238: (session_id,
1239: tax_unit_id,
1240: location_id,
1241: value1)