APPS.IGS_AD_IMP_002 dependencies on IGS_AD_API_INT_ALL

Line 212: FROM igs_ad_api_int_all api,

208: addr_rec ADDR_cur%ROWTYPE;
209:
210: CURSOR API_cur ( cp_interface_id igs_ad_interface_all.interface_id%TYPE) IS
211: SELECT api.*
212: FROM igs_ad_api_int_all api,
213: igs_ad_interface_all ai
214: WHERE api.interface_id = cp_interface_id
215: AND api.status = '2'
216: AND api.interface_id = ai.interface_id

Line 995: UPDATE igs_ad_api_int_all

991: p_error_code => l_error_code);
992:
993: IF l_status = '3' THEN
994:
995: UPDATE igs_ad_api_int_all
996: SET status = l_status,
997: error_code = l_error_code
998: WHERE interface_api_id = api_rec.interface_api_id;
999: UPDATE igs_ad_interface_all

Line 1009: UPDATE igs_ad_api_int_all

1005: END IF;
1006:
1007: ELSIF l_status = '1' THEN
1008:
1009: UPDATE igs_ad_api_int_all
1010: SET status = '1',
1011: error_code = null
1012: WHERE interface_api_id = api_rec.interface_api_id;
1013:

Line 1067: CURSOR API_cur(cp_interface_id IGS_AD_API_INT_ALL.INTERFACE_ID%TYPE) IS

1063:
1064: addr_rec ADDR_cur%ROWTYPE;
1065:
1066:
1067: CURSOR API_cur(cp_interface_id IGS_AD_API_INT_ALL.INTERFACE_ID%TYPE) IS
1068: SELECT *
1069: FROM IGS_AD_API_INT_ALL
1070: WHERE INTERFACE_ID = cp_interface_id
1071: AND NVL(STATUS, '2') = '2'; -- The mandatory data restriction for other person type is removed

Line 1069: FROM IGS_AD_API_INT_ALL

1065:
1066:
1067: CURSOR API_cur(cp_interface_id IGS_AD_API_INT_ALL.INTERFACE_ID%TYPE) IS
1068: SELECT *
1069: FROM IGS_AD_API_INT_ALL
1070: WHERE INTERFACE_ID = cp_interface_id
1071: AND NVL(STATUS, '2') = '2'; -- The mandatory data restriction for other person type is removed
1072: -- Therefore the person ID type check is removed
1073:

Line 1680: UPDATE igs_ad_api_int_all

1676: p_status =>l_status,
1677: p_error_code => l_error_code);
1678:
1679: IF l_status = '3' THEN
1680: UPDATE igs_ad_api_int_all
1681: SET status = l_status,
1682: ERROR_CODE = l_error_code
1683: WHERE interface_api_id = api_rec.interface_api_id;
1684: UPDATE igs_ad_interface_all

Line 1695: UPDATE igs_ad_api_int_all

1691: END IF;
1692:
1693: ELSIF l_status = '1' THEN
1694:
1695: UPDATE igs_ad_api_int_all
1696: SET status = '1',
1697: ERROR_CODE = NULL
1698: WHERE interface_api_id = api_rec.interface_api_id;
1699:

Line 1707: PROCEDURE CREATE_API(p_api_rec IN IGS_AD_API_INT_ALL%ROWTYPE,

1703: END;
1704: END UPDATE_PERSON;
1705:
1706:
1707: PROCEDURE CREATE_API(p_api_rec IN IGS_AD_API_INT_ALL%ROWTYPE,
1708: p_person_id IN IGS_PE_PERSON.PERSON_ID%TYPE,
1709: p_status OUT NOCOPY VARCHAR2,
1710: p_error_code OUT NOCOPY VARCHAR2) AS
1711:

Line 1746: FUNCTION validate_api(p_api_rec IN IGS_AD_API_INT_ALL%ROWTYPE )

1742: l_call_ucas_user_hook BOOLEAN;
1743: l_source_type_id1 NUMBER;
1744: l_source_type_id2 NUMBER;
1745:
1746: FUNCTION validate_api(p_api_rec IN IGS_AD_API_INT_ALL%ROWTYPE )
1747: RETURN BOOLEAN AS
1748: /*
1749: || Created By : pkpatel
1750: || Created On : 10-JUN-2002

Line 1875: igs_ad_imp_001.logerrormessage(p_api_rec.Interface_api_Id,p_error_code,'IGS_AD_API_INT_ALL');

1871: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
1872: END IF;
1873:
1874: IF l_enable_log = 'Y' THEN
1875: igs_ad_imp_001.logerrormessage(p_api_rec.Interface_api_Id,p_error_code,'IGS_AD_API_INT_ALL');
1876: END IF;
1877:
1878: RETURN FALSE;
1879: END validate_api;

Line 2036: igs_ad_imp_001.logerrormessage(p_api_rec.interface_api_id,p_error_code,'IGS_AD_API_INT_ALL');

2032: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2033: END IF;
2034:
2035: IF l_enable_log = 'Y' THEN
2036: igs_ad_imp_001.logerrormessage(p_api_rec.interface_api_id,p_error_code,'IGS_AD_API_INT_ALL');
2037: END IF;
2038: RETURN;
2039: END;
2040: ELSE

Line 2132: igs_ad_imp_001.logerrormessage(p_api_rec.interface_api_id,p_error_code,'IGS_AD_API_INT_ALL');

2128: l_debug_str, NULL,
2129: NULL,NULL,NULL,NULL,TO_CHAR(l_request_id));
2130: END IF;
2131: IF l_enable_log = 'Y' THEN
2132: igs_ad_imp_001.logerrormessage(p_api_rec.interface_api_id,p_error_code,'IGS_AD_API_INT_ALL');
2133: END IF;
2134: p_status := '3';
2135: RETURN;
2136: END;