APPS.IGS_AD_SOURCE_CAT_PKG dependencies on IGS_AD_DSCP_ATTR

Line 878: Added logic to populate IGS_AD_DSCP_ATTR table

874: Know limitations, enhancements or remarks
875: Change History
876: Who When What
877: pkpatel 18-JUN-2001 DLD: Modelling and Forecasting-SDQ
878: Added logic to populate IGS_AD_DSCP_ATTR table
879: (reverse chronological order - newest change first)
880: ***************************************************************/
881: l_rowid_ins VARCHAR2(25);
882:

Line 884: l_discrepancy_attr_id igs_ad_dscp_attr.discrepancy_attr_id%TYPE;

880: ***************************************************************/
881: l_rowid_ins VARCHAR2(25);
882:
883: l_rowid_sysdiscrepancy_ins VARCHAR2(25);
884: l_discrepancy_attr_id igs_ad_dscp_attr.discrepancy_attr_id%TYPE;
885:
886: --Inserting records corresponding to CATEGORY_NAME into IGS_AD_DSCP_ATTR reading from IGS_AD_SYSDSCP_ATTR
887: --cursor c_attr is select category_name,attribute_name from IGS_AD_SYSDSCP_ATTR
888: --where category_name=x_CATEGORY_NAME;

Line 886: --Inserting records corresponding to CATEGORY_NAME into IGS_AD_DSCP_ATTR reading from IGS_AD_SYSDSCP_ATTR

882:
883: l_rowid_sysdiscrepancy_ins VARCHAR2(25);
884: l_discrepancy_attr_id igs_ad_dscp_attr.discrepancy_attr_id%TYPE;
885:
886: --Inserting records corresponding to CATEGORY_NAME into IGS_AD_DSCP_ATTR reading from IGS_AD_SYSDSCP_ATTR
887: --cursor c_attr is select category_name,attribute_name from IGS_AD_SYSDSCP_ATTR
888: --where category_name=x_CATEGORY_NAME;
889:
890: CURSOR c_sysdiscrepancy_attr_cur IS

Line 904: igs_ad_dscp_attr_pkg.insert_row(

900:
901: BEGIN
902:
903: FOR c_sysdiscrepancy_attr_rec IN c_sysdiscrepancy_attr_cur LOOP
904: igs_ad_dscp_attr_pkg.insert_row(
905: X_ROWID =>l_rowid_sysdiscrepancy_ins,
906: X_DISCREPANCY_ATTR_ID =>l_discrepancy_attr_id,
907: X_SRC_CAT_ID =>x_src_cat_id,
908: X_ATTRIBUTE_NAME =>c_sysdiscrepancy_attr_rec.lookup_code,

Line 925: Added logic to delete records from IGS_AD_DSCP_ATTR table

921: Know limitations, enhancements or remarks
922: Change History
923: Who When What
924: pkpatel 18-JUN-2001 DLD: Modelling and Forecasting
925: Added logic to delete records from IGS_AD_DSCP_ATTR table
926: (reverse chronological order - newest change first)
927: ***************************************************************/
928: --Deleting records from child table IGS_AD_DSCP_ATTR using foriegn key SRC_CAT_ID
929: CURSOR c_sysdiscrepancy_attr_del_cur IS

Line 928: --Deleting records from child table IGS_AD_DSCP_ATTR using foriegn key SRC_CAT_ID

924: pkpatel 18-JUN-2001 DLD: Modelling and Forecasting
925: Added logic to delete records from IGS_AD_DSCP_ATTR table
926: (reverse chronological order - newest change first)
927: ***************************************************************/
928: --Deleting records from child table IGS_AD_DSCP_ATTR using foriegn key SRC_CAT_ID
929: CURSOR c_sysdiscrepancy_attr_del_cur IS
930: SELECT ROWID
931: FROM igs_ad_dscp_attr
932: WHERE src_cat_id = (SELECT src_cat_id

Line 931: FROM igs_ad_dscp_attr

927: ***************************************************************/
928: --Deleting records from child table IGS_AD_DSCP_ATTR using foriegn key SRC_CAT_ID
929: CURSOR c_sysdiscrepancy_attr_del_cur IS
930: SELECT ROWID
931: FROM igs_ad_dscp_attr
932: WHERE src_cat_id = (SELECT src_cat_id
933: FROM igs_ad_source_cat_all
934: WHERE ROWID = X_ROWID);
935:

Line 942: igs_ad_dscp_attr_pkg.delete_row(l_rowid);

938: OPEN c_sysdiscrepancy_attr_del_cur;
939: LOOP
940: FETCH c_sysdiscrepancy_attr_del_cur into l_rowid;
941: EXIT WHEN c_sysdiscrepancy_attr_del_cur%NOTFOUND;
942: igs_ad_dscp_attr_pkg.delete_row(l_rowid);
943: END LOOP;
944:
945: IF c_sysdiscrepancy_attr_del_cur%ISOPEN THEN
946: CLOSE c_sysdiscrepancy_attr_del_cur;