APPS.IGS_AD_PS_APLINSTUNT_PKG dependencies on IGS_AD_PS_APLINSTUNT_ALL

Line 4: old_references IGS_AD_PS_APLINSTUNT_ALL%RowType;

1: package body IGS_AD_PS_APLINSTUNT_PKG as
2: /* $Header: IGSAI20B.pls 120.3 2005/10/03 08:19:56 appldev ship $*/
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_PS_APLINSTUNT_ALL%RowType;
5: new_references IGS_AD_PS_APLINSTUNT_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,

Line 5: new_references IGS_AD_PS_APLINSTUNT_ALL%RowType;

1: package body IGS_AD_PS_APLINSTUNT_PKG as
2: /* $Header: IGSAI20B.pls 120.3 2005/10/03 08:19:56 appldev ship $*/
3: l_rowid VARCHAR2(25);
4: old_references IGS_AD_PS_APLINSTUNT_ALL%RowType;
5: new_references IGS_AD_PS_APLINSTUNT_ALL%RowType;
6:
7: PROCEDURE Set_Column_Values (
8: p_action IN VARCHAR2,
9: x_rowid IN VARCHAR2 DEFAULT NULL,

Line 38: FROM IGS_AD_PS_APLINSTUNT_ALL

34: ) AS
35:
36: CURSOR cur_old_ref_values IS
37: SELECT *
38: FROM IGS_AD_PS_APLINSTUNT_ALL
39: WHERE rowid = x_rowid;
40:
41: BEGIN
42:

Line 835: FROM IGS_AD_PS_APLINSTUNT_ALL

831: AS
832:
833: CURSOR cur_rowid IS
834: SELECT rowid
835: FROM IGS_AD_PS_APLINSTUNT_ALL
836: WHERE adm_ps_appl_inst_unit_id = x_adm_ps_appl_inst_unit_id
837: FOR UPDATE NOWAIT;
838:
839: lv_rowid cur_rowid%RowType;

Line 870: FROM IGS_AD_PS_APLINSTUNT_ALL

866: AS
867:
868: CURSOR cur_rowid IS
869: SELECT rowid
870: FROM IGS_AD_PS_APLINSTUNT_ALL
871: WHERE person_id = x_person_id
872: AND admission_appl_number = x_admission_appl_number
873: AND nominated_course_cd = x_nominated_course_cd
874: AND acai_sequence_number = x_acai_sequence_number

Line 908: FROM IGS_AD_PS_APLINSTUNT_ALL

904: ) AS
905:
906: CURSOR cur_rowid IS
907: SELECT rowid
908: FROM IGS_AD_PS_APLINSTUNT_ALL
909: WHERE person_id = x_person_id
910: AND admission_appl_number = x_admission_appl_number
911: AND nominated_course_cd = x_nominated_course_cd
912: AND acai_sequence_number = x_sequence_number ;

Line 937: FROM IGS_AD_PS_APLINSTUNT_ALL

933: ) AS
934:
935: CURSOR cur_rowid IS
936: SELECT rowid
937: FROM IGS_AD_PS_APLINSTUNT_ALL
938: WHERE adm_unit_outcome_status = x_adm_unit_outcome_status ;
939:
940: lv_rowid cur_rowid%RowType;
941:

Line 963: FROM IGS_AD_PS_APLINSTUNT_ALL

959: ) AS
960:
961: CURSOR cur_rowid IS
962: SELECT rowid
963: FROM IGS_AD_PS_APLINSTUNT_ALL
964: WHERE location_cd = x_location_cd ;
965:
966: lv_rowid cur_rowid%RowType;
967:

Line 989: FROM IGS_AD_PS_APLINSTUNT_ALL

985: ) AS
986:
987: CURSOR cur_rowid IS
988: SELECT rowid
989: FROM IGS_AD_PS_APLINSTUNT_ALL
990: WHERE rule_waived_person_id = x_person_id ;
991:
992: lv_rowid cur_rowid%RowType;
993:

Line 1016: FROM IGS_AD_PS_APLINSTUNT_ALL

1012: ) AS
1013:
1014: CURSOR cur_rowid IS
1015: SELECT rowid
1016: FROM IGS_AD_PS_APLINSTUNT_ALL
1017: WHERE sup_unit_cd = x_unit_cd
1018: AND sup_uv_version_number = x_version_number ;
1019:
1020: lv_rowid cur_rowid%RowType;

Line 1043: FROM IGS_AD_PS_APLINSTUNT_ALL

1039: ) AS
1040:
1041: CURSOR cur_rowid IS
1042: SELECT rowid
1043: FROM IGS_AD_PS_APLINSTUNT_ALL
1044: WHERE ass_tracking_id = x_tracking_id ;
1045:
1046: lv_rowid cur_rowid%RowType;
1047:

Line 1069: FROM IGS_AD_PS_APLINSTUNT_ALL

1065: ) AS
1066:
1067: CURSOR cur_rowid IS
1068: SELECT rowid
1069: FROM IGS_AD_PS_APLINSTUNT_ALL
1070: WHERE unit_mode = x_unit_mode ;
1071:
1072: lv_rowid cur_rowid%RowType;
1073:

Line 1100: FROM IGS_AD_PS_APLINSTUNT_ALL

1096: ) AS
1097:
1098: CURSOR cur_rowid IS
1099: SELECT rowid
1100: FROM IGS_AD_PS_APLINSTUNT_ALL
1101: WHERE unit_cd = x_unit_cd
1102: AND uv_version_number = x_version_number
1103: AND cal_type = x_cal_type
1104: AND ci_sequence_number = x_ci_sequence_number

Line 1134: FROM IGS_AD_PS_APLINSTUNT_ALL

1130: ) AS
1131:
1132: CURSOR cur_rowid IS
1133: SELECT rowid
1134: FROM IGS_AD_PS_APLINSTUNT_ALL
1135: WHERE unit_cd = x_unit_cd
1136: AND uv_version_number = x_version_number
1137: AND cal_type = x_cal_type
1138: AND ci_sequence_number = x_ci_sequence_number ;

Line 1351: cursor C is select ROWID, ADM_PS_APPL_INST_UNIT_ID from IGS_AD_PS_APLINSTUNT_ALL

1347: X_SUP_UV_VERSION_NUMBER in NUMBER,
1348: X_MODE in VARCHAR2,
1349: X_ADM_PS_APPL_INST_UNIT_ID in out NOCOPY NUMBER
1350: ) as
1351: cursor C is select ROWID, ADM_PS_APPL_INST_UNIT_ID from IGS_AD_PS_APLINSTUNT_ALL
1352: where PERSON_ID = X_PERSON_ID
1353: and ADMISSION_APPL_NUMBER = X_ADMISSION_APPL_NUMBER
1354: and NOMINATED_COURSE_CD = X_NOMINATED_COURSE_CD
1355: and ACAI_SEQUENCE_NUMBER = X_ACAI_SEQUENCE_NUMBER

Line 1431: insert into IGS_AD_PS_APLINSTUNT_ALL (

1427: );
1428: IF (x_mode = 'S') THEN
1429: igs_sc_gen_001.set_ctx('R');
1430: END IF;
1431: insert into IGS_AD_PS_APLINSTUNT_ALL (
1432: ORG_ID,
1433: PERSON_ID,
1434: ADMISSION_APPL_NUMBER,
1435: NOMINATED_COURSE_CD,

Line 1560: from IGS_AD_PS_APLINSTUNT_ALL

1556: RULE_WAIVED_DT,
1557: RULE_WAIVED_PERSON_ID,
1558: SUP_UNIT_CD,
1559: SUP_UV_VERSION_NUMBER
1560: from IGS_AD_PS_APLINSTUNT_ALL
1561: where ROWID = X_ROWID for update nowait;
1562: tlinfo c1%rowtype;
1563:
1564: begin

Line 1711: update IGS_AD_PS_APLINSTUNT_ALL set

1707: end if;
1708: IF (x_mode = 'S') THEN
1709: igs_sc_gen_001.set_ctx('R');
1710: END IF;
1711: update IGS_AD_PS_APLINSTUNT_ALL set
1712: UV_VERSION_NUMBER = NEW_REFERENCES.UV_VERSION_NUMBER,
1713: CAL_TYPE = NEW_REFERENCES.CAL_TYPE,
1714: CI_SEQUENCE_NUMBER = NEW_REFERENCES.CI_SEQUENCE_NUMBER,
1715: LOCATION_CD = NEW_REFERENCES.LOCATION_CD,

Line 1787: cursor c1 is select rowid from IGS_AD_PS_APLINSTUNT_ALL

1783: X_SUP_UV_VERSION_NUMBER in NUMBER,
1784: X_MODE in VARCHAR2,
1785: X_ADM_PS_APPL_INST_UNIT_ID in out NOCOPY NUMBER
1786: ) AS
1787: cursor c1 is select rowid from IGS_AD_PS_APLINSTUNT_ALL
1788: where ADM_PS_APPL_INST_UNIT_ID = X_ADM_PS_APPL_INST_UNIT_ID
1789: ;
1790: begin
1791: open c1;

Line 1855: delete from IGS_AD_PS_APLINSTUNT_ALL

1851: );
1852: IF (x_mode = 'S') THEN
1853: igs_sc_gen_001.set_ctx('R');
1854: END IF;
1855: delete from IGS_AD_PS_APLINSTUNT_ALL
1856: where ROWID = X_ROWID;
1857: if (sql%notfound) then
1858: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1859: igs_ge_msg_stack.add;