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 818: hr_utility.set_location ( 'delete ben_tcs_asg_stmt entry for ASG_STMT_ID :' || asg_rec.asg_stmt_id,74);

814: DELETE FROM ben_tcs_per_item
815: WHERE per_item_id = l_per_item;
816: END LOOP;
817:
818: hr_utility.set_location ( 'delete ben_tcs_asg_stmt entry for ASG_STMT_ID :' || asg_rec.asg_stmt_id,74);
819: DELETE FROM
820: ben_tcs_asg_stmt
821: WHERE ASG_STMT_ID = asg_rec.asg_stmt_id;
822:

Line 820: ben_tcs_asg_stmt

816: END LOOP;
817:
818: hr_utility.set_location ( 'delete ben_tcs_asg_stmt entry for ASG_STMT_ID :' || asg_rec.asg_stmt_id,74);
819: DELETE FROM
820: ben_tcs_asg_stmt
821: WHERE ASG_STMT_ID = asg_rec.asg_stmt_id;
822:
823: IF (p_run_type = 'PURGE') THEN
824:

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

1079: END IF;
1080:
1081: IF gen = 0 THEN
1082:
1083: hr_utility.set_location('Inserting INTO ben_tcs_asg_stmt assignment_id '||l_assign.assignment_id,89);
1084: INSERT INTO ben_tcs_asg_stmt(
1085: asg_stmt_id ,
1086: stmt_id ,
1087: assignment_id,

Line 1084: INSERT INTO ben_tcs_asg_stmt(

1080:
1081: IF gen = 0 THEN
1082:
1083: hr_utility.set_location('Inserting INTO ben_tcs_asg_stmt assignment_id '||l_assign.assignment_id,89);
1084: INSERT INTO ben_tcs_asg_stmt(
1085: asg_stmt_id ,
1086: stmt_id ,
1087: assignment_id,
1088: per_stmt_perd_id,

Line 1091: ( ben_tcs_asg_stmt_s.NEXTVAL ,

1087: assignment_id,
1088: per_stmt_perd_id,
1089: assignment_number )
1090: VALUES
1091: ( ben_tcs_asg_stmt_s.NEXTVAL ,
1092: p_stmt_id,
1093: l_assign.assignment_id,
1094: ben_tcs_per_stmt_perd_s.CURRVAL,
1095: l_assign.assignment_number);

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

1093: l_assign.assignment_id,
1094: ben_tcs_per_stmt_perd_s.CURRVAL,
1095: l_assign.assignment_number);
1096:
1097: hr_utility.set_location('After inserting INTO ben_tcs_asg_stmt ',90);
1098: IF (Record_Created ='N') THEN
1099: get_emp_detail(
1100: l_assign.assignment_id ,
1101: p_person_id ,

Line 1144: ben_tcs_asg_stmt_s.CURRVAL ,

1140: uom ,
1141: nnmntry_uom )
1142: VALUES
1143: ( ben_tcs_per_item_s.NEXTVAL ,
1144: ben_tcs_asg_stmt_s.CURRVAL ,
1145: p_stmt_id,
1146: item_id_process.item_id,
1147: p_person_id,
1148: p_stmt_perd_id,

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

1471: END IF;
1472:
1473: IF gen = 0 THEN
1474:
1475: hr_utility.set_location('inserting INTO ben_tcs_asg_stmt assignment_id '||l_assign.assignment_id||' subcategory',98);
1476: INSERT INTO ben_tcs_asg_stmt(
1477: asg_stmt_id ,
1478: stmt_id ,
1479: assignment_id,

Line 1476: INSERT INTO ben_tcs_asg_stmt(

1472:
1473: IF gen = 0 THEN
1474:
1475: hr_utility.set_location('inserting INTO ben_tcs_asg_stmt assignment_id '||l_assign.assignment_id||' subcategory',98);
1476: INSERT INTO ben_tcs_asg_stmt(
1477: asg_stmt_id ,
1478: stmt_id ,
1479: assignment_id,
1480: per_stmt_perd_id,

Line 1483: ( ben_tcs_asg_stmt_s.NEXTVAL ,

1479: assignment_id,
1480: per_stmt_perd_id,
1481: assignment_number )
1482: VALUES
1483: ( ben_tcs_asg_stmt_s.NEXTVAL ,
1484: p_stmt_id,
1485: l_assign.assignment_id,
1486: ben_tcs_per_stmt_perd_s.CURRVAL,
1487: l_assign.assignment_number);

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

1485: l_assign.assignment_id,
1486: ben_tcs_per_stmt_perd_s.CURRVAL,
1487: l_assign.assignment_number);
1488:
1489: hr_utility.set_location('After inserting INTO ben_tcs_asg_stmt ',99);
1490: IF (Record_Created ='N') THEN
1491: rep_count := l_rep_rec.COUNT +1;
1492: l_rep_rec(rep_count ).p_TYPE := 0;
1493: l_rep_rec(rep_count ).BENEFIT_ACTION_ID :=p_benefit_action_id ;