APPS.IGS_AD_TST_RSLT_DTLS_PKG dependencies on IGS_SC_GEN_001

Line 1203: igs_sc_gen_001.set_ctx('R');

1199: x_last_update_date=>X_LAST_UPDATE_DATE,
1200: x_last_updated_by=>X_LAST_UPDATED_BY,
1201: x_last_update_login=>X_LAST_UPDATE_LOGIN);
1202: IF (x_mode = 'S') THEN
1203: igs_sc_gen_001.set_ctx('R');
1204: END IF;
1205: insert into IGS_AD_TST_RSLT_DTLS (
1206: TST_RSLT_DTLS_ID
1207: ,TEST_RESULTS_ID

Line 1291: igs_sc_gen_001.unset_ctx('R');

1287: ,X_PROGRAM_APPLICATION_ID
1288: ,X_PROGRAM_UPDATE_DATE
1289: )RETURNING TST_RSLT_DTLS_ID INTO X_TST_RSLT_DTLS_ID ;
1290: IF (x_mode = 'S') THEN
1291: igs_sc_gen_001.unset_ctx('R');
1292: END IF;
1293:
1294:
1295: NEW_REFERENCES.TST_RSLT_DTLS_ID := X_TST_RSLT_DTLS_ID;

Line 1314: igs_sc_gen_001.unset_ctx('R');

1310: IF (SQLCODE IN (-28115, -28113, -28111)) THEN
1311: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_EXCEPTION');
1312: fnd_message.set_token ('ERR_CD', SQLCODE);
1313: igs_ge_msg_stack.add;
1314: igs_sc_gen_001.unset_ctx('R');
1315: app_exception.raise_exception;
1316: ELSE
1317: igs_sc_gen_001.unset_ctx('R');
1318: RAISE;

Line 1317: igs_sc_gen_001.unset_ctx('R');

1313: igs_ge_msg_stack.add;
1314: igs_sc_gen_001.unset_ctx('R');
1315: app_exception.raise_exception;
1316: ELSE
1317: igs_sc_gen_001.unset_ctx('R');
1318: RAISE;
1319: END IF;
1320:
1321: end INSERT_ROW;

Line 1647: igs_sc_gen_001.set_ctx('R');

1643: end if;
1644: end if;
1645:
1646: IF (x_mode = 'S') THEN
1647: igs_sc_gen_001.set_ctx('R');
1648: END IF;
1649: update IGS_AD_TST_RSLT_DTLS set
1650: TEST_RESULTS_ID = NEW_REFERENCES.TEST_RESULTS_ID,
1651: TEST_SEGMENT_ID = NEW_REFERENCES.TEST_SEGMENT_ID,

Line 1692: igs_sc_gen_001.unset_ctx('R');

1688: where ROWID = X_ROWID;
1689: if (sql%notfound) then
1690: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1691: igs_ge_msg_stack.add;
1692: igs_sc_gen_001.unset_ctx('R');
1693: app_exception.raise_exception;
1694: end if;
1695: IF (x_mode = 'S') THEN
1696: igs_sc_gen_001.unset_ctx('R');

Line 1696: igs_sc_gen_001.unset_ctx('R');

1692: igs_sc_gen_001.unset_ctx('R');
1693: app_exception.raise_exception;
1694: end if;
1695: IF (x_mode = 'S') THEN
1696: igs_sc_gen_001.unset_ctx('R');
1697: END IF;
1698:
1699:
1700: After_DML (

Line 1711: igs_sc_gen_001.unset_ctx('R');

1707: IF (SQLCODE = (-28115)) THEN
1708: fnd_message.set_name ('IGS', 'IGS_SC_UPD_POLICY_EXCP');
1709: fnd_message.set_token ('ERR_CD', SQLCODE);
1710: igs_ge_msg_stack.add;
1711: igs_sc_gen_001.unset_ctx('R');
1712: app_exception.raise_exception;
1713: ELSE
1714: igs_sc_gen_001.unset_ctx('R');
1715: RAISE;

Line 1714: igs_sc_gen_001.unset_ctx('R');

1710: igs_ge_msg_stack.add;
1711: igs_sc_gen_001.unset_ctx('R');
1712: app_exception.raise_exception;
1713: ELSE
1714: igs_sc_gen_001.unset_ctx('R');
1715: RAISE;
1716: END IF;
1717:
1718: end UPDATE_ROW;

Line 1875: igs_sc_gen_001.set_ctx('R');

1871: p_action => 'DELETE',
1872: x_rowid => X_ROWID
1873: );
1874: IF (x_mode = 'S') THEN
1875: igs_sc_gen_001.set_ctx('R');
1876: END IF;
1877: delete from IGS_AD_TST_RSLT_DTLS
1878: where ROWID = X_ROWID;
1879: if (sql%notfound) then

Line 1882: igs_sc_gen_001.unset_ctx('R');

1878: where ROWID = X_ROWID;
1879: if (sql%notfound) then
1880: fnd_message.set_name ('IGS', 'IGS_SC_POLICY_UPD_DEL_EXCEP');
1881: igs_ge_msg_stack.add;
1882: igs_sc_gen_001.unset_ctx('R');
1883: app_exception.raise_exception;
1884: end if;
1885: IF (x_mode = 'S') THEN
1886: igs_sc_gen_001.unset_ctx('R');

Line 1886: igs_sc_gen_001.unset_ctx('R');

1882: igs_sc_gen_001.unset_ctx('R');
1883: app_exception.raise_exception;
1884: end if;
1885: IF (x_mode = 'S') THEN
1886: igs_sc_gen_001.unset_ctx('R');
1887: END IF;
1888:
1889: After_DML (
1890: p_action => 'DELETE',