APPS.BEN_TCS_STMT_PROCESS dependencies on BEN_TCS_ASG_STMT

Line 759: FROM ben_tcs_asg_stmt

755:
756: CURSOR c_asg_stmt ( v_per_stmt_perd_id IN NUMBER)
757: IS
758: SELECT ASG_STMT_ID ,assignment_number, assignment_id
759: FROM ben_tcs_asg_stmt
760: WHERE per_stmt_perd_id = v_per_stmt_perd_id;
761:
762: CURSOR c_per_item(v_asg_stmt_id IN NUMBER)
763: IS

Line 825: hr_utility.set_location ( 'delete ben_tcs_asg_stmt entry for ASG_STMT_ID :' || asg_rec.asg_stmt_id,74);

821: DELETE FROM ben_tcs_per_item
822: WHERE per_item_id = l_per_item;
823: END LOOP;
824:
825: hr_utility.set_location ( 'delete ben_tcs_asg_stmt entry for ASG_STMT_ID :' || asg_rec.asg_stmt_id,74);
826: DELETE FROM
827: ben_tcs_asg_stmt
828: WHERE ASG_STMT_ID = asg_rec.asg_stmt_id;
829:

Line 827: ben_tcs_asg_stmt

823: END LOOP;
824:
825: hr_utility.set_location ( 'delete ben_tcs_asg_stmt entry for ASG_STMT_ID :' || asg_rec.asg_stmt_id,74);
826: DELETE FROM
827: ben_tcs_asg_stmt
828: WHERE ASG_STMT_ID = asg_rec.asg_stmt_id;
829:
830: IF (p_run_type = 'PURGE') THEN
831:

Line 1091: hr_utility.set_location('Inserting INTO ben_tcs_asg_stmt assignment_id '||l_assign.assignment_id,89);

1087: END IF;
1088:
1089: IF gen = 0 THEN
1090:
1091: hr_utility.set_location('Inserting INTO ben_tcs_asg_stmt assignment_id '||l_assign.assignment_id,89);
1092: INSERT INTO ben_tcs_asg_stmt(
1093: asg_stmt_id ,
1094: stmt_id ,
1095: assignment_id,

Line 1092: INSERT INTO ben_tcs_asg_stmt(

1088:
1089: IF gen = 0 THEN
1090:
1091: hr_utility.set_location('Inserting INTO ben_tcs_asg_stmt assignment_id '||l_assign.assignment_id,89);
1092: INSERT INTO ben_tcs_asg_stmt(
1093: asg_stmt_id ,
1094: stmt_id ,
1095: assignment_id,
1096: per_stmt_perd_id,

Line 1099: ( ben_tcs_asg_stmt_s.NEXTVAL ,

1095: assignment_id,
1096: per_stmt_perd_id,
1097: assignment_number )
1098: VALUES
1099: ( ben_tcs_asg_stmt_s.NEXTVAL ,
1100: p_stmt_id,
1101: l_assign.assignment_id,
1102: ben_tcs_per_stmt_perd_s.CURRVAL,
1103: l_assign.assignment_number);

Line 1105: hr_utility.set_location('After inserting INTO ben_tcs_asg_stmt ',90);

1101: l_assign.assignment_id,
1102: ben_tcs_per_stmt_perd_s.CURRVAL,
1103: l_assign.assignment_number);
1104:
1105: hr_utility.set_location('After inserting INTO ben_tcs_asg_stmt ',90);
1106: IF (Record_Created ='N') THEN
1107: get_emp_detail(
1108: l_assign.assignment_id ,
1109: p_person_id ,

Line 1152: ben_tcs_asg_stmt_s.CURRVAL ,

1148: uom ,
1149: nnmntry_uom )
1150: VALUES
1151: ( ben_tcs_per_item_s.NEXTVAL ,
1152: ben_tcs_asg_stmt_s.CURRVAL ,
1153: p_stmt_id,
1154: item_id_process.item_id,
1155: p_person_id,
1156: p_stmt_perd_id,

Line 1483: hr_utility.set_location('inserting INTO ben_tcs_asg_stmt assignment_id '||l_assign.assignment_id||' subcategory',98);

1479: END IF;
1480:
1481: IF gen = 0 THEN
1482:
1483: hr_utility.set_location('inserting INTO ben_tcs_asg_stmt assignment_id '||l_assign.assignment_id||' subcategory',98);
1484: INSERT INTO ben_tcs_asg_stmt(
1485: asg_stmt_id ,
1486: stmt_id ,
1487: assignment_id,

Line 1484: INSERT INTO ben_tcs_asg_stmt(

1480:
1481: IF gen = 0 THEN
1482:
1483: hr_utility.set_location('inserting INTO ben_tcs_asg_stmt assignment_id '||l_assign.assignment_id||' subcategory',98);
1484: INSERT INTO ben_tcs_asg_stmt(
1485: asg_stmt_id ,
1486: stmt_id ,
1487: assignment_id,
1488: per_stmt_perd_id,

Line 1491: ( ben_tcs_asg_stmt_s.NEXTVAL ,

1487: assignment_id,
1488: per_stmt_perd_id,
1489: assignment_number )
1490: VALUES
1491: ( ben_tcs_asg_stmt_s.NEXTVAL ,
1492: p_stmt_id,
1493: l_assign.assignment_id,
1494: ben_tcs_per_stmt_perd_s.CURRVAL,
1495: l_assign.assignment_number);

Line 1497: hr_utility.set_location('After inserting INTO ben_tcs_asg_stmt ',99);

1493: l_assign.assignment_id,
1494: ben_tcs_per_stmt_perd_s.CURRVAL,
1495: l_assign.assignment_number);
1496:
1497: hr_utility.set_location('After inserting INTO ben_tcs_asg_stmt ',99);
1498: IF (Record_Created ='N') THEN
1499: rep_count := l_rep_rec.COUNT +1;
1500: l_rep_rec(rep_count ).p_TYPE := 0;
1501: l_rep_rec(rep_count ).BENEFIT_ACTION_ID :=p_benefit_action_id ;