APPS.IGS_AD_IMP_002 dependencies on IGS_AD_INTERFACE_DTL_DSCP_V

Line 12: PROCEDURE validate_oss_ext_attr(p_person_rec IN igs_ad_interface_dtl_dscp_v%ROWTYPE,

8:
9: cst_stat_val_1 CONSTANT VARCHAR2(2) := '1';
10: cst_stat_val_3 CONSTANT VARCHAR2(2) := '3';
11:
12: PROCEDURE validate_oss_ext_attr(p_person_rec IN igs_ad_interface_dtl_dscp_v%ROWTYPE,
13: p_person_id IN NUMBER,
14: p_validation_success OUT NOCOPY VARCHAR2)
15: IS
16: /*

Line 152: PROCEDURE CREATE_PERSON(P_person_rec IN IGS_AD_INTERFACE_DTL_DSCP_V%ROWTYPE,

148:
149: END validate_oss_ext_attr;
150:
151:
152: PROCEDURE CREATE_PERSON(P_person_rec IN IGS_AD_INTERFACE_DTL_DSCP_V%ROWTYPE,
153: P_ADDR_TYPE IN VARCHAR2,
154: P_PERSON_ID_TYPE IN VARCHAR2,
155: P_PERSON_ID OUT NOCOPY IGS_PE_PERSON.PERSON_ID%TYPE) AS
156: /*

Line 1022: PROCEDURE UPDATE_PERSON( p_person_rec IN IGS_AD_INTERFACE_DTL_DSCP_V%ROWTYPE,

1018:
1019: END;
1020: END CREATE_PERSON;
1021:
1022: PROCEDURE UPDATE_PERSON( p_person_rec IN IGS_AD_INTERFACE_DTL_DSCP_V%ROWTYPE,
1023: P_ADDR_TYPE IN VARCHAR2,
1024: P_PERSON_ID_TYPE IN VARCHAR2,
1025: P_PERSON_ID IN IGS_PE_PERSON.PERSON_ID%TYPE) AS
1026: /*

Line 1037: || igs_ad_interface_all%ROWTYPE to igs_ad_interface_dtl_dscp_v%ROWTYPE

1033: || skpandey 21-SEP-2005 Bug: 3663505
1034: || Description: Added ATTRIBUTES 21 TO 24 to store additional information
1035: || pkpatel 22-JUN-2001 Bug no.1834307 :For Modeling and Forecasting DLD
1036: || Modified the signature by changing the datatype of parameter from
1037: || igs_ad_interface_all%ROWTYPE to igs_ad_interface_dtl_dscp_v%ROWTYPE
1038: || nsinha 08-Apr-2002 Bug no.2028066: Added Cursor for Null handling Rule.
1039: || pkpatel 25-DEC-2002 Bug No: 2702536
1040: || Added commit after the processing each person record.
1041: || vrathi 25-jun-2003 Bug No:3019813

Line 3041: --Bug no.1834307 MOdified the source table from igs_ad_interface to igs_ad_interface_dtl_dscp_v

3037: SELECT data_element, drop_if_null, partial_include, exact_include
3038: FROM igs_pe_mtch_set_data_all
3039: WHERE match_set_id = cp_match_set_id;
3040:
3041: --Bug no.1834307 MOdified the source table from igs_ad_interface to igs_ad_interface_dtl_dscp_v
3042: CURSOR person_cur(cp_d_batch_id igs_ad_interface_dtl_dscp_v.batch_id%TYPE,
3043: cp_d_source_type_id igs_ad_interface_dtl_dscp_v.source_type_id%TYPE) IS
3044: SELECT ai.*
3045: FROM igs_ad_interface_dtl_dscp_v ai

Line 3042: CURSOR person_cur(cp_d_batch_id igs_ad_interface_dtl_dscp_v.batch_id%TYPE,

3038: FROM igs_pe_mtch_set_data_all
3039: WHERE match_set_id = cp_match_set_id;
3040:
3041: --Bug no.1834307 MOdified the source table from igs_ad_interface to igs_ad_interface_dtl_dscp_v
3042: CURSOR person_cur(cp_d_batch_id igs_ad_interface_dtl_dscp_v.batch_id%TYPE,
3043: cp_d_source_type_id igs_ad_interface_dtl_dscp_v.source_type_id%TYPE) IS
3044: SELECT ai.*
3045: FROM igs_ad_interface_dtl_dscp_v ai
3046: WHERE status = '2'

Line 3043: cp_d_source_type_id igs_ad_interface_dtl_dscp_v.source_type_id%TYPE) IS

3039: WHERE match_set_id = cp_match_set_id;
3040:
3041: --Bug no.1834307 MOdified the source table from igs_ad_interface to igs_ad_interface_dtl_dscp_v
3042: CURSOR person_cur(cp_d_batch_id igs_ad_interface_dtl_dscp_v.batch_id%TYPE,
3043: cp_d_source_type_id igs_ad_interface_dtl_dscp_v.source_type_id%TYPE) IS
3044: SELECT ai.*
3045: FROM igs_ad_interface_dtl_dscp_v ai
3046: WHERE status = '2'
3047: AND batch_id = cp_d_batch_id

Line 3045: FROM igs_ad_interface_dtl_dscp_v ai

3041: --Bug no.1834307 MOdified the source table from igs_ad_interface to igs_ad_interface_dtl_dscp_v
3042: CURSOR person_cur(cp_d_batch_id igs_ad_interface_dtl_dscp_v.batch_id%TYPE,
3043: cp_d_source_type_id igs_ad_interface_dtl_dscp_v.source_type_id%TYPE) IS
3044: SELECT ai.*
3045: FROM igs_ad_interface_dtl_dscp_v ai
3046: WHERE status = '2'
3047: AND batch_id = cp_d_batch_id
3048: AND source_type_id = cp_d_source_type_id;
3049: