APPS.HZ_MAP_PARTY_PUB dependencies on HZ_DNB_REQUEST_LOG

Line 1065: INSERT INTO hz_dnb_request_log(

1061:
1062: l_party_interface_id NUMBER;
1063:
1064: BEGIN
1065: INSERT INTO hz_dnb_request_log(
1066: REQUEST_ID,
1067: PARTY_ID,
1068: REQUESTED_PRODUCT,
1069: DUNS_NUMBER,

Line 1075: HZ_DNB_REQUEST_LOG_S.nextval,

1071: CREATION_DATE,
1072: LAST_UPDATED_BY,
1073: LAST_UPDATE_DATE )
1074: VALUES(
1075: HZ_DNB_REQUEST_LOG_S.nextval,
1076: p_interface_rec.PARTY_ID,
1077: p_interface_rec.GDP_NAME,
1078: p_interface_rec.DUNS_NUMBER,
1079: hz_utility_v2pub.CREATED_BY,

Line 1127: UPDATE hz_dnb_request_log

1123: l_request_id NUMBER;
1124:
1125: BEGIN
1126:
1127: UPDATE hz_dnb_request_log
1128: SET PARTY_ID = p_party_id,
1129: STATUS = p_status,
1130: LAST_UPDATED_BY = hz_utility_v2pub.LAST_UPDATED_BY,
1131: LAST_UPDATE_DATE = hz_utility_v2pub.LAST_UPDATE_DATE,

Line 1375: --Create a row in hz_dnb_request_log if request_log_id is NULL

1371: ELSIF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
1372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1373: END IF;
1374: --
1375: --Create a row in hz_dnb_request_log if request_log_id is NULL
1376: --
1377:
1378: IF l_interface_rec.request_log_id IS NULL THEN
1379:

Line 1394: --hz_dnb_request_log

1390: x_return_status => x_return_status
1391: );
1392:
1393: --store original party id. The party id will be used to update
1394: --hz_dnb_request_log
1395: --store original and final party id.
1396: l_original_party_id := l_interface_rec.party_id;
1397: l_final_party_id := l_original_party_id;
1398: