DBA Data[Home] [Help]

APPS.IGS_AD_ACT_ASSESSMENTS_PKG dependencies on IGS_AD_ACT_ASSESSMENTS_S

Line 35: IGS_AD_ACT_ASSESSMENTS_S.nextval

31: FUNCTION get_batch_id RETURN NUMBER AS
32: BEGIN
33: IF batch_id IS NULL THEN
34: SELECT
35: IGS_AD_ACT_ASSESSMENTS_S.nextval
36: INTO batch_id
37: FROM dual;
38: END IF;
39: return batch_id;

Line 1298: Update IGS_AD_ACT_ASSESSMENTS set Interface_Transfer_Date = SYSDATE where rowid = Act_Assessment_Rec.rowid;

1294: END IF;
1295: END LOOP;
1296: END IF; -- Academic History Details
1297: -- Update the IGS_AD_ACT_ASSSESSMENT table Interface_Transfer_Date with Sysdate
1298: Update IGS_AD_ACT_ASSESSMENTS set Interface_Transfer_Date = SYSDATE where rowid = Act_Assessment_Rec.rowid;
1299:
1300: EXCEPTION
1301: WHEN OTHERS THEN
1302: -- Insert a log message that Person Record failed to populate into Interface Tables.