DBA Data[Home] [Help]

APPS.HZ_PARTY_BO_PVT dependencies on HZ_RELATIONSHIP_OBJ

Line 148: p_relationship_obj IN HZ_RELATIONSHIP_OBJ,

144: -- 14-DEC-2004 Arnold Ng Created.
145: --
146:
147: PROCEDURE assign_relationship_rec(
148: p_relationship_obj IN HZ_RELATIONSHIP_OBJ,
149: p_subject_id IN NUMBER,
150: p_subject_type IN VARCHAR2,
151: p_object_id IN NUMBER,
152: p_object_type IN VARCHAR2,

Line 302: p_relationship_obj IN HZ_RELATIONSHIP_OBJ,

298: -- 14-DEC-2004 Arnold Ng Created.
299: --
300:
301: PROCEDURE assign_relationship_rec(
302: p_relationship_obj IN HZ_RELATIONSHIP_OBJ,
303: p_subject_id IN NUMBER,
304: p_subject_type IN VARCHAR2,
305: p_object_id IN NUMBER,
306: p_object_type IN VARCHAR2,

Line 444: p_rel_objs IN OUT NOCOPY HZ_RELATIONSHIP_OBJ_TBL,

440: -- 14-DEC-2004 Arnold Ng Created.
441: --
442:
443: PROCEDURE create_relationships(
444: p_rel_objs IN OUT NOCOPY HZ_RELATIONSHIP_OBJ_TBL,
445: p_subject_id IN NUMBER,
446: p_subject_type IN VARCHAR2,
447: x_return_status OUT NOCOPY VARCHAR2,
448: x_msg_count OUT NOCOPY NUMBER,

Line 653: p_rel_objs IN OUT NOCOPY HZ_RELATIONSHIP_OBJ_TBL,

649: -- 14-DEC-2004 Arnold Ng Created.
650: --
651:
652: PROCEDURE save_relationships(
653: p_rel_objs IN OUT NOCOPY HZ_RELATIONSHIP_OBJ_TBL,
654: p_subject_id IN NUMBER,
655: p_subject_type IN VARCHAR2,
656: x_return_status OUT NOCOPY VARCHAR2,
657: x_msg_count OUT NOCOPY NUMBER,

Line 878: p_rel_obj IN OUT NOCOPY HZ_RELATIONSHIP_OBJ,

874: END save_relationships;
875:
876: PROCEDURE create_relationship_obj(
877: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
878: p_rel_obj IN OUT NOCOPY HZ_RELATIONSHIP_OBJ,
879: p_created_by_module IN VARCHAR2,
880: x_relationship_id OUT NOCOPY NUMBER,
881: x_return_status OUT NOCOPY VARCHAR2,
882: x_msg_count OUT NOCOPY NUMBER,

Line 1056: p_rel_obj IN OUT NOCOPY HZ_RELATIONSHIP_OBJ,

1052: END create_relationship_obj;
1053:
1054: PROCEDURE update_relationship_obj(
1055: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1056: p_rel_obj IN OUT NOCOPY HZ_RELATIONSHIP_OBJ,
1057: x_relationship_id OUT NOCOPY NUMBER,
1058: x_return_status OUT NOCOPY VARCHAR2,
1059: x_msg_count OUT NOCOPY NUMBER,
1060: x_msg_data OUT NOCOPY VARCHAR2

Line 1240: p_rel_obj IN OUT NOCOPY HZ_RELATIONSHIP_OBJ,

1236: END update_relationship_obj;
1237:
1238: PROCEDURE save_relationship_obj(
1239: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1240: p_rel_obj IN OUT NOCOPY HZ_RELATIONSHIP_OBJ,
1241: p_created_by_module IN VARCHAR2,
1242: x_relationship_id OUT NOCOPY NUMBER,
1243: x_return_status OUT NOCOPY VARCHAR2,
1244: x_msg_count OUT NOCOPY NUMBER,

Line 1478: x_relationship_obj OUT NOCOPY HZ_RELATIONSHIP_OBJ,

1474:
1475: PROCEDURE get_relationship_obj(
1476: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1477: p_relationship_id IN NUMBER,
1478: x_relationship_obj OUT NOCOPY HZ_RELATIONSHIP_OBJ,
1479: x_return_status OUT NOCOPY VARCHAR2,
1480: x_msg_count OUT NOCOPY NUMBER,
1481: x_msg_data OUT NOCOPY VARCHAR2
1482: ) IS

Line 1486: SELECT HZ_RELATIONSHIP_OBJ(

1482: ) IS
1483: l_debug_prefix VARCHAR2(30) := '';
1484:
1485: CURSOR c1(l_relationship_id NUMBER) IS
1486: SELECT HZ_RELATIONSHIP_OBJ(
1487: NULL, -- ACTION_TYPE
1488: NULL, --COMMON_OBJ_ID
1489: RELATIONSHIP_ID,
1490: DECODE(SUBJECT_TYPE, 'ORGANIZATION', 'ORG', SUBJECT_TYPE),