DBA Data[Home] [Help]

APPS.HZ_MAP_PARTY_PUB dependencies on HZ_UTILITY_V2PUB

Line 222: hz_utility_v2pub.created_by,

218: VALUES (
219: hz_party_interface_errors_s.nextval,
220: G_PARTY_INTERFACE_ID,
221: l_message_text,
222: hz_utility_v2pub.created_by,
223: hz_utility_v2pub.creation_date,
224: hz_utility_v2pub.last_updated_by,
225: hz_utility_v2pub.last_update_date,
226: hz_utility_v2pub.last_update_login);

Line 223: hz_utility_v2pub.creation_date,

219: hz_party_interface_errors_s.nextval,
220: G_PARTY_INTERFACE_ID,
221: l_message_text,
222: hz_utility_v2pub.created_by,
223: hz_utility_v2pub.creation_date,
224: hz_utility_v2pub.last_updated_by,
225: hz_utility_v2pub.last_update_date,
226: hz_utility_v2pub.last_update_login);
227: G_ERROR_FLAG:='Y';

Line 224: hz_utility_v2pub.last_updated_by,

220: G_PARTY_INTERFACE_ID,
221: l_message_text,
222: hz_utility_v2pub.created_by,
223: hz_utility_v2pub.creation_date,
224: hz_utility_v2pub.last_updated_by,
225: hz_utility_v2pub.last_update_date,
226: hz_utility_v2pub.last_update_login);
227: G_ERROR_FLAG:='Y';
228:

Line 225: hz_utility_v2pub.last_update_date,

221: l_message_text,
222: hz_utility_v2pub.created_by,
223: hz_utility_v2pub.creation_date,
224: hz_utility_v2pub.last_updated_by,
225: hz_utility_v2pub.last_update_date,
226: hz_utility_v2pub.last_update_login);
227: G_ERROR_FLAG:='Y';
228:
229: END set_hz_dnb_invalid_data;

Line 226: hz_utility_v2pub.last_update_login);

222: hz_utility_v2pub.created_by,
223: hz_utility_v2pub.creation_date,
224: hz_utility_v2pub.last_updated_by,
225: hz_utility_v2pub.last_update_date,
226: hz_utility_v2pub.last_update_login);
227: G_ERROR_FLAG:='Y';
228:
229: END set_hz_dnb_invalid_data;
230:

Line 1079: hz_utility_v2pub.CREATED_BY,

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,
1080: hz_utility_v2pub.CREATION_DATE,
1081: hz_utility_v2pub.LAST_UPDATED_BY,
1082: hz_utility_v2pub.LAST_UPDATE_DATE )
1083: RETURNING REQUEST_ID INTO l_request_log_id;

Line 1080: hz_utility_v2pub.CREATION_DATE,

1076: p_interface_rec.PARTY_ID,
1077: p_interface_rec.GDP_NAME,
1078: p_interface_rec.DUNS_NUMBER,
1079: hz_utility_v2pub.CREATED_BY,
1080: hz_utility_v2pub.CREATION_DATE,
1081: hz_utility_v2pub.LAST_UPDATED_BY,
1082: hz_utility_v2pub.LAST_UPDATE_DATE )
1083: RETURNING REQUEST_ID INTO l_request_log_id;
1084:

Line 1081: hz_utility_v2pub.LAST_UPDATED_BY,

1077: p_interface_rec.GDP_NAME,
1078: p_interface_rec.DUNS_NUMBER,
1079: hz_utility_v2pub.CREATED_BY,
1080: hz_utility_v2pub.CREATION_DATE,
1081: hz_utility_v2pub.LAST_UPDATED_BY,
1082: hz_utility_v2pub.LAST_UPDATE_DATE )
1083: RETURNING REQUEST_ID INTO l_request_log_id;
1084:
1085: UPDATE hz_party_interface

Line 1082: hz_utility_v2pub.LAST_UPDATE_DATE )

1078: p_interface_rec.DUNS_NUMBER,
1079: hz_utility_v2pub.CREATED_BY,
1080: hz_utility_v2pub.CREATION_DATE,
1081: hz_utility_v2pub.LAST_UPDATED_BY,
1082: hz_utility_v2pub.LAST_UPDATE_DATE )
1083: RETURNING REQUEST_ID INTO l_request_log_id;
1084:
1085: UPDATE hz_party_interface
1086: SET REQUEST_LOG_ID = l_request_log_id

Line 1130: LAST_UPDATED_BY = hz_utility_v2pub.LAST_UPDATED_BY,

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,
1132: LAST_UPDATE_LOGIN = hz_utility_v2pub.LAST_UPDATE_LOGIN
1133: WHERE REQUEST_ID = p_request_log_id;
1134:

Line 1131: LAST_UPDATE_DATE = hz_utility_v2pub.LAST_UPDATE_DATE,

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,
1132: LAST_UPDATE_LOGIN = hz_utility_v2pub.LAST_UPDATE_LOGIN
1133: WHERE REQUEST_ID = p_request_log_id;
1134:
1135: COMMIT;

Line 1132: LAST_UPDATE_LOGIN = hz_utility_v2pub.LAST_UPDATE_LOGIN

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,
1132: LAST_UPDATE_LOGIN = hz_utility_v2pub.LAST_UPDATE_LOGIN
1133: WHERE REQUEST_ID = p_request_log_id;
1134:
1135: COMMIT;
1136:

Line 6679: hz_utility_v2pub.created_by,

6675: VALUES (
6676: hz_party_interface_errors_s.nextval ,
6677: p_party_interface_id,
6678: l_message_text,
6679: hz_utility_v2pub.created_by,
6680: hz_utility_v2pub.creation_date,
6681: hz_utility_v2pub.last_updated_by,
6682: hz_utility_v2pub.last_update_date,
6683: hz_utility_v2pub.last_update_login);

Line 6680: hz_utility_v2pub.creation_date,

6676: hz_party_interface_errors_s.nextval ,
6677: p_party_interface_id,
6678: l_message_text,
6679: hz_utility_v2pub.created_by,
6680: hz_utility_v2pub.creation_date,
6681: hz_utility_v2pub.last_updated_by,
6682: hz_utility_v2pub.last_update_date,
6683: hz_utility_v2pub.last_update_login);
6684:

Line 6681: hz_utility_v2pub.last_updated_by,

6677: p_party_interface_id,
6678: l_message_text,
6679: hz_utility_v2pub.created_by,
6680: hz_utility_v2pub.creation_date,
6681: hz_utility_v2pub.last_updated_by,
6682: hz_utility_v2pub.last_update_date,
6683: hz_utility_v2pub.last_update_login);
6684:
6685: END LOOP;

Line 6682: hz_utility_v2pub.last_update_date,

6678: l_message_text,
6679: hz_utility_v2pub.created_by,
6680: hz_utility_v2pub.creation_date,
6681: hz_utility_v2pub.last_updated_by,
6682: hz_utility_v2pub.last_update_date,
6683: hz_utility_v2pub.last_update_login);
6684:
6685: END LOOP;
6686:

Line 6683: hz_utility_v2pub.last_update_login);

6679: hz_utility_v2pub.created_by,
6680: hz_utility_v2pub.creation_date,
6681: hz_utility_v2pub.last_updated_by,
6682: hz_utility_v2pub.last_update_date,
6683: hz_utility_v2pub.last_update_login);
6684:
6685: END LOOP;
6686:
6687: COMMIT; /* commit update to hz_party_interface and inserts into hz_party_interface_errors */

Line 6838: X_VIEW_APPLICATION_ID => /*HZ_UTILITY_V2PUB.application_id*/222,-- Bug 3107162

6834: Fnd_Lookup_Values_Pkg.Insert_Row(
6835: X_ROWID => row_id,
6836: X_LOOKUP_TYPE => p_lookup_type,
6837: X_SECURITY_GROUP_ID => 0,
6838: X_VIEW_APPLICATION_ID => /*HZ_UTILITY_V2PUB.application_id*/222,-- Bug 3107162
6839: X_LOOKUP_CODE => p_lookup_code,
6840: X_TAG => null,
6841: X_ATTRIBUTE_CATEGORY => null,
6842: X_ATTRIBUTE1 => null,

Line 6863: X_CREATION_DATE => HZ_UTILITY_V2PUB.CREATION_DATE,

6859: X_ATTRIBUTE14 => null,
6860: X_ATTRIBUTE15 => null,
6861: X_MEANING => p_lookup_code,
6862: X_DESCRIPTION => p_lookup_code,
6863: X_CREATION_DATE => HZ_UTILITY_V2PUB.CREATION_DATE,
6864: X_CREATED_BY => HZ_UTILITY_V2PUB.CREATED_BY,
6865: X_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
6866: X_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
6867: X_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN);

Line 6864: X_CREATED_BY => HZ_UTILITY_V2PUB.CREATED_BY,

6860: X_ATTRIBUTE15 => null,
6861: X_MEANING => p_lookup_code,
6862: X_DESCRIPTION => p_lookup_code,
6863: X_CREATION_DATE => HZ_UTILITY_V2PUB.CREATION_DATE,
6864: X_CREATED_BY => HZ_UTILITY_V2PUB.CREATED_BY,
6865: X_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
6866: X_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
6867: X_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN);
6868:

Line 6865: X_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,

6861: X_MEANING => p_lookup_code,
6862: X_DESCRIPTION => p_lookup_code,
6863: X_CREATION_DATE => HZ_UTILITY_V2PUB.CREATION_DATE,
6864: X_CREATED_BY => HZ_UTILITY_V2PUB.CREATED_BY,
6865: X_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
6866: X_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
6867: X_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN);
6868:
6869: END IF;

Line 6866: X_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY,

6862: X_DESCRIPTION => p_lookup_code,
6863: X_CREATION_DATE => HZ_UTILITY_V2PUB.CREATION_DATE,
6864: X_CREATED_BY => HZ_UTILITY_V2PUB.CREATED_BY,
6865: X_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
6866: X_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
6867: X_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN);
6868:
6869: END IF;
6870: CLOSE c_check_lookups;

Line 6867: X_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN);

6863: X_CREATION_DATE => HZ_UTILITY_V2PUB.CREATION_DATE,
6864: X_CREATED_BY => HZ_UTILITY_V2PUB.CREATED_BY,
6865: X_LAST_UPDATE_DATE => HZ_UTILITY_V2PUB.LAST_UPDATE_DATE,
6866: X_LAST_UPDATED_BY => HZ_UTILITY_V2PUB.LAST_UPDATED_BY,
6867: X_LAST_UPDATE_LOGIN => HZ_UTILITY_V2PUB.LAST_UPDATE_LOGIN);
6868:
6869: END IF;
6870: CLOSE c_check_lookups;
6871: EXCEPTION