DBA Data[Home] [Help]

APPS.HZ_CONTACT_POINT_BO_PUB dependencies on HZ_PHONE_CP_BO

Line 30: p_phone_obj IN HZ_PHONE_CP_BO,

26: --
27: -- 14-DEC-2004 Arnold Ng Created.
28:
29: PROCEDURE assign_phone_rec(
30: p_phone_obj IN HZ_PHONE_CP_BO,
31: p_owner_table_id IN NUMBER,
32: p_owner_table_name IN VARCHAR2,
33: p_cp_id IN NUMBER,
34: p_cp_os IN VARCHAR2,

Line 277: p_phone_obj IN HZ_PHONE_CP_BO,

273: -- Create a logical phone contact point.
274: PROCEDURE create_phone_bo(
275: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
276: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
277: p_phone_obj IN HZ_PHONE_CP_BO,
278: p_created_by_module IN VARCHAR2,
279: x_return_status OUT NOCOPY VARCHAR2,
280: x_msg_count OUT NOCOPY NUMBER,
281: x_msg_data OUT NOCOPY VARCHAR2,

Line 290: l_phone_obj HZ_PHONE_CP_BO;

286: px_parent_os IN OUT NOCOPY VARCHAR2,
287: px_parent_osr IN OUT NOCOPY VARCHAR2,
288: px_parent_obj_type IN OUT NOCOPY VARCHAR2
289: ) IS
290: l_phone_obj HZ_PHONE_CP_BO;
291: BEGIN
292: l_phone_obj := p_phone_obj;
293: do_create_contact_point (
294: p_init_msg_list => p_init_msg_list,

Line 325: p_phone_obj IN HZ_PHONE_CP_BO,

321: END create_phone_bo;
322:
323: PROCEDURE create_phone_bo(
324: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
325: p_phone_obj IN HZ_PHONE_CP_BO,
326: p_created_by_module IN VARCHAR2,
327: p_obj_source IN VARCHAR2 := null,
328: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
329: x_return_status OUT NOCOPY VARCHAR2,

Line 331: x_return_obj OUT NOCOPY HZ_PHONE_CP_BO,

327: p_obj_source IN VARCHAR2 := null,
328: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
329: x_return_status OUT NOCOPY VARCHAR2,
330: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
331: x_return_obj OUT NOCOPY HZ_PHONE_CP_BO,
332: x_phone_id OUT NOCOPY NUMBER,
333: x_phone_os OUT NOCOPY VARCHAR2,
334: x_phone_osr OUT NOCOPY VARCHAR2,
335: px_parent_id IN OUT NOCOPY NUMBER,

Line 342: l_phone_obj HZ_PHONE_CP_BO;

338: px_parent_obj_type IN OUT NOCOPY VARCHAR2
339: ) IS
340: l_msg_count NUMBER;
341: l_msg_data VARCHAR2(2000);
342: l_phone_obj HZ_PHONE_CP_BO;
343: BEGIN
344: l_phone_obj := p_phone_obj;
345: do_create_contact_point (
346: p_init_msg_list => fnd_api.g_true,

Line 1077: p_phone_obj IN HZ_PHONE_CP_BO,

1073: --
1074: -- 14-DEC-2004 Arnold Ng Created.
1075:
1076: PROCEDURE assign_phone_rec(
1077: p_phone_obj IN HZ_PHONE_CP_BO,
1078: p_owner_table_id IN NUMBER,
1079: p_owner_table_name IN VARCHAR2,
1080: p_cp_id IN NUMBER,
1081: p_cp_os IN VARCHAR2,

Line 1677: p_phone_obj IN HZ_PHONE_CP_BO,

1673: p_validate_bo_flag IN VARCHAR2 := FND_API.G_TRUE,
1674: p_cp_id IN NUMBER,
1675: p_cp_os IN VARCHAR2,
1676: p_cp_osr IN VARCHAR2,
1677: p_phone_obj IN HZ_PHONE_CP_BO,
1678: p_email_obj IN HZ_EMAIL_CP_BO,
1679: p_telex_obj IN HZ_TELEX_CP_BO,
1680: p_web_obj IN HZ_WEB_CP_BO,
1681: p_edi_obj IN HZ_EDI_CP_BO,

Line 1748: p_phone_objs => HZ_PHONE_CP_BO_TBL(p_phone_obj),

1744: x_bus_object => l_bus_object
1745: );
1746:
1747: l_valid_obj := HZ_REGISTRY_VALIDATE_BO_PVT.is_cp_bo_comp(
1748: p_phone_objs => HZ_PHONE_CP_BO_TBL(p_phone_obj),
1749: p_email_objs => HZ_EMAIL_CP_BO_TBL(p_email_obj),
1750: p_telex_objs => HZ_TELEX_CP_BO_TBL(p_telex_obj),
1751: p_web_objs => HZ_WEB_CP_BO_TBL(p_web_obj),
1752: p_edi_objs => HZ_EDI_CP_BO_TBL(p_edi_obj),

Line 2111: p_phone_obj IN HZ_PHONE_CP_BO,

2107: -- DESCRIPTION
2108: -- Update a logical phone contact point.
2109: PROCEDURE update_phone_bo(
2110: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2111: p_phone_obj IN HZ_PHONE_CP_BO,
2112: p_created_by_module IN VARCHAR2,
2113: x_return_status OUT NOCOPY VARCHAR2,
2114: x_msg_count OUT NOCOPY NUMBER,
2115: x_msg_data OUT NOCOPY VARCHAR2,

Line 2120: l_phone_obj HZ_PHONE_CP_BO;

2116: x_phone_id OUT NOCOPY NUMBER,
2117: x_phone_os OUT NOCOPY VARCHAR2,
2118: x_phone_osr OUT NOCOPY VARCHAR2
2119: )IS
2120: l_phone_obj HZ_PHONE_CP_BO;
2121: BEGIN
2122: l_phone_obj := p_phone_obj;
2123: do_update_contact_point (
2124: p_init_msg_list => p_init_msg_list,

Line 2149: p_phone_obj IN HZ_PHONE_CP_BO,

2145: p_parent_os => NULL );
2146: END update_phone_bo;
2147:
2148: PROCEDURE update_phone_bo(
2149: p_phone_obj IN HZ_PHONE_CP_BO,
2150: p_created_by_module IN VARCHAR2,
2151: p_obj_source IN VARCHAR2 := null,
2152: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
2153: x_return_status OUT NOCOPY VARCHAR2,

Line 2155: x_return_obj OUT NOCOPY HZ_PHONE_CP_BO,

2151: p_obj_source IN VARCHAR2 := null,
2152: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
2153: x_return_status OUT NOCOPY VARCHAR2,
2154: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
2155: x_return_obj OUT NOCOPY HZ_PHONE_CP_BO,
2156: x_phone_id OUT NOCOPY NUMBER,
2157: x_phone_os OUT NOCOPY VARCHAR2,
2158: x_phone_osr OUT NOCOPY VARCHAR2
2159: )IS

Line 2162: l_phone_obj HZ_PHONE_CP_BO;

2158: x_phone_osr OUT NOCOPY VARCHAR2
2159: )IS
2160: l_msg_data VARCHAR2(2000);
2161: l_msg_count NUMBER;
2162: l_phone_obj HZ_PHONE_CP_BO;
2163: BEGIN
2164: l_phone_obj := p_phone_obj;
2165: do_update_contact_point (
2166: p_init_msg_list => fnd_api.g_true,

Line 2751: p_phone_obj IN HZ_PHONE_CP_BO,

2747: p_init_msg_list IN VARCHAR2:= FND_API.G_FALSE,
2748: p_cp_id IN NUMBER,
2749: p_cp_os IN VARCHAR2,
2750: p_cp_osr IN VARCHAR2,
2751: p_phone_obj IN HZ_PHONE_CP_BO,
2752: p_email_obj IN HZ_EMAIL_CP_BO,
2753: p_telex_obj IN HZ_TELEX_CP_BO,
2754: p_web_obj IN HZ_WEB_CP_BO,
2755: p_edi_obj IN HZ_EDI_CP_BO,

Line 3167: p_phone_obj IN HZ_PHONE_CP_BO,

3163: -- Create or update a logical phone contact point.
3164: PROCEDURE save_phone_bo(
3165: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3166: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
3167: p_phone_obj IN HZ_PHONE_CP_BO,
3168: p_created_by_module IN VARCHAR2,
3169: x_return_status OUT NOCOPY VARCHAR2,
3170: x_msg_count OUT NOCOPY NUMBER,
3171: x_msg_data OUT NOCOPY VARCHAR2,

Line 3180: l_phone_obj HZ_PHONE_CP_BO;

3176: px_parent_os IN OUT NOCOPY VARCHAR2,
3177: px_parent_osr IN OUT NOCOPY VARCHAR2,
3178: px_parent_obj_type IN OUT NOCOPY VARCHAR2
3179: ) IS
3180: l_phone_obj HZ_PHONE_CP_BO;
3181: BEGIN
3182: l_phone_obj := p_phone_obj;
3183: do_save_contact_point (
3184: p_init_msg_list => p_init_msg_list,

Line 3215: p_phone_obj IN HZ_PHONE_CP_BO,

3211: END save_phone_bo;
3212:
3213: PROCEDURE save_phone_bo(
3214: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
3215: p_phone_obj IN HZ_PHONE_CP_BO,
3216: p_created_by_module IN VARCHAR2,
3217: p_obj_source IN VARCHAR2 := null,
3218: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
3219: x_return_status OUT NOCOPY VARCHAR2,

Line 3221: x_return_obj OUT NOCOPY HZ_PHONE_CP_BO,

3217: p_obj_source IN VARCHAR2 := null,
3218: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
3219: x_return_status OUT NOCOPY VARCHAR2,
3220: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
3221: x_return_obj OUT NOCOPY HZ_PHONE_CP_BO,
3222: x_phone_id OUT NOCOPY NUMBER,
3223: x_phone_os OUT NOCOPY VARCHAR2,
3224: x_phone_osr OUT NOCOPY VARCHAR2,
3225: px_parent_id IN OUT NOCOPY NUMBER,

Line 3232: l_phone_obj HZ_PHONE_CP_BO;

3228: px_parent_obj_type IN OUT NOCOPY VARCHAR2
3229: ) IS
3230: l_msg_data VARCHAR2(2000);
3231: l_msg_count NUMBER;
3232: l_phone_obj HZ_PHONE_CP_BO;
3233: BEGIN
3234: l_phone_obj := p_phone_obj;
3235: do_save_contact_point (
3236: p_init_msg_list => fnd_api.g_true,

Line 3961: p_phone_obj IN HZ_PHONE_CP_BO,

3957: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
3958: p_cp_id IN NUMBER,
3959: p_cp_os IN VARCHAR2,
3960: p_cp_osr IN VARCHAR2,
3961: p_phone_obj IN HZ_PHONE_CP_BO,
3962: p_email_obj IN HZ_EMAIL_CP_BO,
3963: p_telex_obj IN HZ_TELEX_CP_BO,
3964: p_web_obj IN HZ_WEB_CP_BO,
3965: p_edi_obj IN HZ_EDI_CP_BO,

Line 4546: x_phone_obj OUT NOCOPY HZ_PHONE_CP_BO,

4542: PROCEDURE get_phone_bo (
4543: p_phone_id IN NUMBER,
4544: p_phone_os IN VARCHAR2,
4545: p_phone_osr IN VARCHAR2,
4546: x_phone_obj OUT NOCOPY HZ_PHONE_CP_BO,
4547: x_return_status OUT NOCOPY VARCHAR2,
4548: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL
4549: ) IS
4550: l_msg_data VARCHAR2(2000);

Line 4608: x_phone_obj OUT NOCOPY HZ_PHONE_CP_BO,

4604: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4605: p_phone_id IN NUMBER,
4606: p_phone_os IN VARCHAR2,
4607: p_phone_osr IN VARCHAR2,
4608: x_phone_obj OUT NOCOPY HZ_PHONE_CP_BO,
4609: x_return_status OUT NOCOPY VARCHAR2,
4610: x_msg_count OUT NOCOPY NUMBER,
4611: x_msg_data OUT NOCOPY VARCHAR2
4612: ) is

Line 4618: l_phone_objs HZ_PHONE_CP_BO_TBL;

4614:
4615: l_phone_id number;
4616: l_phone_os varchar2(30);
4617: l_phone_osr varchar2(255);
4618: l_phone_objs HZ_PHONE_CP_BO_TBL;
4619: BEGIN
4620:
4621: -- initialize API return status to success.
4622: x_return_status := FND_API.G_RET_STS_SUCCESS;