DBA Data[Home] [Help]

APPS.HZ_CUST_ACCOUNT_MERGE_V2PVT dependencies on HZ_RELATIONSHIP_V2PUB

Line 253: p_relationship_rec IN OUT NOCOPY HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE,

249:
250: ---------------------------RELATIONSHIP----------------------------------------------------
251:
252: PROCEDURE do_create_rel(
253: p_relationship_rec IN OUT NOCOPY HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE,
254: p_direction_code IN VARCHAR2,
255: x_created_party OUT NOCOPY VARCHAR2,
256: x_relationship_id OUT NOCOPY NUMBER,
257: x_party_id OUT NOCOPY NUMBER,

Line 264: p_relationship_rec IN HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE,

260: );
261:
262: PROCEDURE do_create_party(
263: p_party_type IN VARCHAR2,
264: p_relationship_rec IN HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE,
265: x_party_id OUT NOCOPY NUMBER,
266: x_party_number OUT NOCOPY VARCHAR2,
267: x_profile_id OUT NOCOPY NUMBER,
268: x_return_status IN OUT NOCOPY VARCHAR2

Line 272: p_relationship_rec IN HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE,

268: x_return_status IN OUT NOCOPY VARCHAR2
269: );
270:
271: PROCEDURE do_update_party_flags(
272: p_relationship_rec IN HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE,
273: p_party_id IN NUMBER
274: );
275:
276:

Line 288: p_relationship_rec IN OUT NOCOPY HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE,

284: -- body of private procedures
285: -----------------------------
286:
287: PROCEDURE do_create_rel(
288: p_relationship_rec IN OUT NOCOPY HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE,
289: p_direction_code IN VARCHAR2,
290: x_created_party OUT NOCOPY VARCHAR2,
291: x_relationship_id OUT NOCOPY NUMBER,
292: x_party_id OUT NOCOPY NUMBER,

Line 401: l_party_rel_rec HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE;

397: l_directional_flag VARCHAR2(1);
398: l_msg_count NUMBER;
399: l_msg_data VARCHAR2(2000);
400: l_end_date DATE;
401: l_party_rel_rec HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE;
402: l_dummy VARCHAR2(1) := 'Y';
403: l_debug_prefix VARCHAR2(30) := '';
404: l_back_direction VARCHAR2(30);
405:

Line 866: p_relationship_rec IN HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE,

862:
863:
864: PROCEDURE do_create_party(
865: p_party_type IN VARCHAR2,
866: p_relationship_rec IN HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE,
867: x_party_id OUT NOCOPY NUMBER,
868: x_party_number OUT NOCOPY VARCHAR2,
869: x_profile_id OUT NOCOPY NUMBER,
870: x_return_status IN OUT NOCOPY VARCHAR2

Line 1026: p_relationship_rec IN HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE,

1022:
1023: END do_create_party;
1024:
1025: PROCEDURE do_update_party_flags(
1026: p_relationship_rec IN HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE,
1027: p_party_id IN NUMBER
1028: ) IS
1029:
1030: l_party_id NUMBER;

Line 1108: p_relationship_rec IN HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE,

1104:
1105:
1106: PROCEDURE create_relationship (
1107: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
1108: p_relationship_rec IN HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE,
1109: p_direction_code IN VARCHAR2,
1110: x_relationship_id OUT NOCOPY NUMBER,
1111: x_party_id OUT NOCOPY NUMBER,
1112: x_party_number OUT NOCOPY VARCHAR2,

Line 1118: l_rel_rec HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE := p_relationship_rec;

1114: x_msg_count OUT NOCOPY NUMBER,
1115: x_msg_data OUT NOCOPY VARCHAR2
1116: ) IS
1117:
1118: l_rel_rec HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE := p_relationship_rec;
1119: l_created_party VARCHAR2(1);
1120:
1121: BEGIN
1122:

Line 1216: x_rel_rec OUT NOCOPY HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE,

1212: PROCEDURE get_relationship_rec (
1213: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1214: p_relationship_id IN NUMBER,
1215: p_directional_flag IN VARCHAR2 := 'F',
1216: x_rel_rec OUT NOCOPY HZ_RELATIONSHIP_V2PUB.RELATIONSHIP_REC_TYPE,
1217: x_direction_code OUT NOCOPY VARCHAR2,
1218: x_return_status OUT NOCOPY VARCHAR2,
1219: x_msg_count OUT NOCOPY NUMBER,
1220: x_msg_data OUT NOCOPY VARCHAR2