eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_AD_IMP_002 dependencies on IGS_AD_ADDR_INT_ALL

Line 199: FROM igs_ad_addr_int_all ai,

195:
196:
197: CURSOR addr_cur(cp_interface_id igs_ad_interface_all.interface_id%TYPE) IS
198: SELECT ai.*
199: FROM igs_ad_addr_int_all ai,
200: igs_ad_interface_all i
201: WHERE ai.interface_id = cp_interface_id
202: AND ai.status = '2'
203: AND i.interface_id = ai.interface_id

Line 1057: CURSOR addr_cur(cp_interface_id IGS_AD_ADDR_INT_ALL.INTERFACE_ID%TYPE) IS

1053: l_request_id NUMBER(10);
1054: l_message_name VARCHAR2(30);
1055: l_app VARCHAR2(50);
1056:
1057: CURSOR addr_cur(cp_interface_id IGS_AD_ADDR_INT_ALL.INTERFACE_ID%TYPE) IS
1058: SELECT AI.*
1059: FROM IGS_AD_ADDR_INT_ALL AI
1060: WHERE (AI.INTERFACE_ID = cp_interface_id)
1061: AND NVL(AI.STATUS, '2') = '2';

Line 1059: FROM IGS_AD_ADDR_INT_ALL AI

1055: l_app VARCHAR2(50);
1056:
1057: CURSOR addr_cur(cp_interface_id IGS_AD_ADDR_INT_ALL.INTERFACE_ID%TYPE) IS
1058: SELECT AI.*
1059: FROM IGS_AD_ADDR_INT_ALL AI
1060: WHERE (AI.INTERFACE_ID = cp_interface_id)
1061: AND NVL(AI.STATUS, '2') = '2';
1062:
1063:

Line 2143: PROCEDURE CREATE_ADDRESS(P_addr_rec IN IGS_ad_Addr_int_all%ROWTYPE,

2139: p_status :='3';
2140: END IF;
2141: END create_api;
2142:
2143: PROCEDURE CREATE_ADDRESS(P_addr_rec IN IGS_ad_Addr_int_all%ROWTYPE,
2144: P_PERSON_ID IN IGS_PE_PERSON.PERSON_ID%TYPE,
2145: P_STATUS OUT NOCOPY VARCHAR2,
2146: p_error_code OUT NOCOPY VARCHAR2) AS
2147: l_rowid VARCHAR2(25);

Line 2315: UPDATE igs_ad_addr_int_all

2311:
2312: -- Update the parent if any of the child fails.
2313: IF l_failure_child = 1 THEN
2314:
2315: UPDATE igs_ad_addr_int_all
2316: SET status = '4',
2317: error_code = 'E244'
2318: WHERE interface_addr_id = l_interface_addr_id;
2319:

Line 2329: UPDATE igs_ad_addr_int_all

2325: SET STATUS = '3',
2326: ERROR_CODE = 'E244'
2327: WHERE interface_addrusage_id = l_interface_addrusage_id;
2328:
2329: UPDATE igs_ad_addr_int_all
2330: SET status = '4',
2331: error_code = 'E244'
2332: WHERE interface_addr_id = l_interface_addr_id;
2333:

Line 2425: UPDATE IGS_AD_ADDR_INT_ALL

2421: );
2422:
2423: IF (l_return_status IN ('E','U') ) THEN
2424:
2425: UPDATE IGS_AD_ADDR_INT_ALL
2426: SET STATUS = '3',
2427: ERROR_CODE = 'E006'
2428: WHERE INTERFACE_ADDR_ID = p_ADDR_REC.INTERFACE_ADDR_ID;
2429:

Line 2455: igs_ad_imp_001.logerrormessage(p_addr_rec.interface_addr_id,'E006','IGS_AD_ADDR_INT_ALL');

2451: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2452: END IF;
2453:
2454: IF l_enable_log = 'Y' THEN
2455: igs_ad_imp_001.logerrormessage(p_addr_rec.interface_addr_id,'E006','IGS_AD_ADDR_INT_ALL');
2456: END IF;
2457: ELSE
2458: IF l_return_status = 'W' THEN
2459: UPDATE IGS_AD_ADDR_INT_ALL

Line 2459: UPDATE IGS_AD_ADDR_INT_ALL

2455: igs_ad_imp_001.logerrormessage(p_addr_rec.interface_addr_id,'E006','IGS_AD_ADDR_INT_ALL');
2456: END IF;
2457: ELSE
2458: IF l_return_status = 'W' THEN
2459: UPDATE IGS_AD_ADDR_INT_ALL
2460: SET STATUS = '4',
2461: ERROR_CODE = 'E073'
2462: WHERE INTERFACE_ADDR_ID = p_ADDR_REC.INTERFACE_ADDR_ID;
2463:

Line 2483: igs_ad_imp_001.logerrormessage(p_addr_rec.interface_addr_id,'E073','IGS_AD_ADDR_INT_ALL');

2479: l_debug_str, NULL,
2480: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2481: END IF;
2482: IF l_enable_log = 'Y' THEN
2483: igs_ad_imp_001.logerrormessage(p_addr_rec.interface_addr_id,'E073','IGS_AD_ADDR_INT_ALL');
2484: END IF;
2485: ELSE
2486: UPDATE IGS_AD_ADDR_INT_ALL
2487: SET STATUS = '1',

Line 2486: UPDATE IGS_AD_ADDR_INT_ALL

2482: IF l_enable_log = 'Y' THEN
2483: igs_ad_imp_001.logerrormessage(p_addr_rec.interface_addr_id,'E073','IGS_AD_ADDR_INT_ALL');
2484: END IF;
2485: ELSE
2486: UPDATE IGS_AD_ADDR_INT_ALL
2487: SET STATUS = '1',
2488: ERROR_CODE = NULL --ssomani, added this 3/15/01
2489: WHERE INTERFACE_ADDR_ID = P_ADDR_REC.INTERFACE_ADDR_ID;
2490:

Line 2499: UPDATE IGS_AD_ADDR_INT_ALL

2495: process_addrusage(p_addr_rec.interface_addr_id);
2496:
2497: END IF;
2498: ELSE
2499: UPDATE IGS_AD_ADDR_INT_ALL
2500: SET STATUS = '3',
2501: ERROR_CODE = p_error_code
2502: WHERE INTERFACE_ADDR_ID = p_ADDR_REC.INTERFACE_ADDR_ID;
2503:

Line 2510: igs_ad_imp_001.logerrormessage(P_addr_REC.INTERFACE_addr_ID,'E006','IGS_AD_ADDR_INT_ALL');

2506: error_code = 'E006'
2507: WHERE interface_id = p_addr_rec.interface_id;
2508:
2509: IF l_enable_log = 'Y' THEN
2510: igs_ad_imp_001.logerrormessage(P_addr_REC.INTERFACE_addr_ID,'E006','IGS_AD_ADDR_INT_ALL');
2511: END IF;
2512: p_status := '3';
2513: END IF;
2514: EXCEPTION

Line 2520: UPDATE IGS_AD_ADDR_INT_ALL

2516: l_msg_data := SQLERRM;
2517: p_status := '3';
2518: p_error_code := 'E006';
2519:
2520: UPDATE IGS_AD_ADDR_INT_ALL
2521: SET STATUS = '3',
2522: ERROR_CODE = 'E006'
2523: WHERE INTERFACE_ADDR_ID = p_ADDR_REC.INTERFACE_ADDR_ID;
2524:

Line 2550: igs_ad_imp_001.logerrormessage(P_addr_REC.INTERFACE_addr_ID,'E006','IGS_AD_ADDR_INT_ALL');

2546: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2547: END IF;
2548:
2549: IF l_enable_log = 'Y' THEN
2550: igs_ad_imp_001.logerrormessage(P_addr_REC.INTERFACE_addr_ID,'E006','IGS_AD_ADDR_INT_ALL');
2551: END IF;
2552:
2553: END CREATE_ADDRESS;
2554:

Line 2557: p_addr_rec IN IGS_AD_ADDR_INT_ALL%ROWTYPE,

2553: END CREATE_ADDRESS;
2554:
2555:
2556: PROCEDURE UPDATE_ADDRESS(
2557: p_addr_rec IN IGS_AD_ADDR_INT_ALL%ROWTYPE,
2558: p_person_id IN IGS_PE_PERSON.PERSON_ID%TYPE,
2559: p_location_id IN hz_party_sites.location_id%TYPE,
2560: p_party_site_id IN hz_party_sites.party_site_id%TYPE) AS
2561:

Line 2743: UPDATE igs_ad_addr_int_all

2739:
2740: -- Update the parent if any of the child fails.
2741: IF l_failure_child = 1 THEN
2742:
2743: UPDATE igs_ad_addr_int_all
2744: SET status = '4',
2745: error_code = 'E244'
2746: WHERE interface_addr_id = l_interface_addr_id;
2747:

Line 2757: UPDATE igs_ad_addr_int_all

2753: SET STATUS = '3',
2754: ERROR_CODE = 'E244'
2755: WHERE interface_addrusage_id = l_interface_addrusage_id;
2756:
2757: UPDATE igs_ad_addr_int_all
2758: SET status = '4',
2759: error_code = 'E244'
2760: WHERE interface_addr_id = l_interface_addr_id;
2761:

Line 2889: UPDATE igs_ad_addr_int_all

2885: p_status => null_hand_addr_rec.status
2886: );
2887: IF (l_return_status IN ('E','U') ) THEN
2888:
2889: UPDATE igs_ad_addr_int_all
2890: SET status = '3', error_code = 'E014'
2891: WHERE interface_addr_id = p_addr_rec.interface_addr_id;
2892:
2893: UPDATE igs_ad_interface_all

Line 2917: igs_ad_imp_001.logerrormessage(P_addr_REC.INTERFACE_ADDR_ID,p_error_code,'IGS_AD_ADDR_INT_ALL');

2913: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2914: END IF;
2915:
2916: IF l_enable_log = 'Y' THEN
2917: igs_ad_imp_001.logerrormessage(P_addr_REC.INTERFACE_ADDR_ID,p_error_code,'IGS_AD_ADDR_INT_ALL');
2918: END IF;
2919: ELSE
2920: IF l_return_status = 'W' THEN
2921: UPDATE igs_ad_addr_int_all

Line 2921: UPDATE igs_ad_addr_int_all

2917: igs_ad_imp_001.logerrormessage(P_addr_REC.INTERFACE_ADDR_ID,p_error_code,'IGS_AD_ADDR_INT_ALL');
2918: END IF;
2919: ELSE
2920: IF l_return_status = 'W' THEN
2921: UPDATE igs_ad_addr_int_all
2922: SET status = '4', error_code = 'E073'
2923: WHERE interface_addr_id = p_addr_rec.interface_addr_id;
2924:
2925: p_error_code := 'E073';

Line 2944: igs_ad_imp_001.logerrormessage(P_addr_REC.INTERFACE_ADDR_ID,p_error_code,'IGS_AD_ADDR_INT_ALL');

2940: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2941: END IF;
2942:
2943: IF l_enable_log = 'Y' THEN
2944: igs_ad_imp_001.logerrormessage(P_addr_REC.INTERFACE_ADDR_ID,p_error_code,'IGS_AD_ADDR_INT_ALL');
2945: END IF;
2946: ELSE
2947: UPDATE igs_ad_addr_int_all
2948: SET status = '1',

Line 2947: UPDATE igs_ad_addr_int_all

2943: IF l_enable_log = 'Y' THEN
2944: igs_ad_imp_001.logerrormessage(P_addr_REC.INTERFACE_ADDR_ID,p_error_code,'IGS_AD_ADDR_INT_ALL');
2945: END IF;
2946: ELSE
2947: UPDATE igs_ad_addr_int_all
2948: SET status = '1',
2949: ERROR_CODE = NULL
2950: WHERE interface_addr_id = p_addr_rec.interface_addr_id;
2951: END IF;

Line 2962: UPDATE igs_ad_addr_int_all

2958: EXCEPTION
2959: WHEN OTHERS THEN
2960:
2961: l_msg_data := SQLERRM;
2962: UPDATE igs_ad_addr_int_all
2963: SET status = '3', error_code = p_error_code
2964: WHERE interface_addr_id = p_addr_rec.interface_addr_id;
2965:
2966: UPDATE igs_ad_interface_all

Line 2990: igs_ad_imp_001.logerrormessage(P_addr_REC.INTERFACE_ADDR_ID,'E014','IGS_AD_ADDR_INT_ALL');

2986: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2987: END IF;
2988:
2989: IF l_enable_log = 'Y' THEN
2990: igs_ad_imp_001.logerrormessage(P_addr_REC.INTERFACE_ADDR_ID,'E014','IGS_AD_ADDR_INT_ALL');
2991: END IF;
2992:
2993: END UPDATE_ADDRESS;
2994:

Line 3572: PROCEDURE validate_address (p_addr_rec IN IGS_AD_ADDR_INT_ALL%ROWTYPE,

3568: CLOSE person_cur;
3569: END prc_pe_dtls;
3570:
3571:
3572: PROCEDURE validate_address (p_addr_rec IN IGS_AD_ADDR_INT_ALL%ROWTYPE,
3573: p_person_id IN igs_pe_person_base_v.PERSON_ID%TYPE,
3574: p_status OUT NOCOPY VARCHAR2,
3575: p_error_code OUT NOCOPY VARCHAR2) AS
3576: