DBA Data[Home] [Help]

APPS.HZ_CONTACT_POINT_BO_PUB dependencies on HZ_EMAIL_CP_BO

Line 106: p_email_obj IN HZ_EMAIL_CP_BO,

102: --
103: -- 14-DEC-2004 Arnold Ng Created.
104:
105: PROCEDURE assign_email_rec(
106: p_email_obj IN HZ_EMAIL_CP_BO,
107: p_owner_table_id IN NUMBER,
108: p_owner_table_name IN VARCHAR2,
109: p_cp_id IN NUMBER,
110: p_cp_os IN VARCHAR2,

Line 503: p_email_obj IN HZ_EMAIL_CP_BO,

499: -- Create a logical email contact point.
500: PROCEDURE create_email_bo(
501: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
502: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
503: p_email_obj IN HZ_EMAIL_CP_BO,
504: p_created_by_module IN VARCHAR2,
505: x_return_status OUT NOCOPY VARCHAR2,
506: x_msg_count OUT NOCOPY NUMBER,
507: x_msg_data OUT NOCOPY VARCHAR2,

Line 516: l_email_obj HZ_EMAIL_CP_BO;

512: px_parent_os IN OUT NOCOPY VARCHAR2,
513: px_parent_osr IN OUT NOCOPY VARCHAR2,
514: px_parent_obj_type IN OUT NOCOPY VARCHAR2
515: ) IS
516: l_email_obj HZ_EMAIL_CP_BO;
517: BEGIN
518: l_email_obj := p_email_obj;
519: do_create_contact_point (
520: p_init_msg_list => p_init_msg_list,

Line 550: p_email_obj IN HZ_EMAIL_CP_BO,

546: END create_email_bo;
547:
548: PROCEDURE create_email_bo(
549: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
550: p_email_obj IN HZ_EMAIL_CP_BO,
551: p_created_by_module IN VARCHAR2,
552: p_obj_source IN VARCHAR2 := null,
553: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
554: x_return_status OUT NOCOPY VARCHAR2,

Line 556: x_return_obj OUT NOCOPY HZ_EMAIL_CP_BO,

552: p_obj_source IN VARCHAR2 := null,
553: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
554: x_return_status OUT NOCOPY VARCHAR2,
555: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
556: x_return_obj OUT NOCOPY HZ_EMAIL_CP_BO,
557: x_email_id OUT NOCOPY NUMBER,
558: x_email_os OUT NOCOPY VARCHAR2,
559: x_email_osr OUT NOCOPY VARCHAR2,
560: px_parent_id IN OUT NOCOPY NUMBER,

Line 567: l_email_obj HZ_EMAIL_CP_BO;

563: px_parent_obj_type IN OUT NOCOPY VARCHAR2
564: ) IS
565: l_msg_data VARCHAR2(2000);
566: l_msg_count NUMBER;
567: l_email_obj HZ_EMAIL_CP_BO;
568: BEGIN
569: l_email_obj := p_email_obj;
570: do_create_contact_point (
571: p_init_msg_list => fnd_api.g_true,

Line 1253: p_email_obj IN HZ_EMAIL_CP_BO,

1249: --
1250: -- 14-DEC-2004 Arnold Ng Created.
1251:
1252: PROCEDURE assign_email_rec(
1253: p_email_obj IN HZ_EMAIL_CP_BO,
1254: p_owner_table_id IN NUMBER,
1255: p_owner_table_name IN VARCHAR2,
1256: p_cp_id IN NUMBER,
1257: p_cp_os IN VARCHAR2,

Line 1678: p_email_obj IN HZ_EMAIL_CP_BO,

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,
1682: p_eft_obj IN HZ_EFT_CP_BO,

Line 1749: p_email_objs => HZ_EMAIL_CP_BO_TBL(p_email_obj),

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),
1753: p_eft_objs => HZ_EFT_CP_BO_TBL(p_eft_obj),

Line 2293: p_email_obj IN HZ_EMAIL_CP_BO,

2289: -- DESCRIPTION
2290: -- Update a logical email contact point.
2291: PROCEDURE update_email_bo(
2292: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2293: p_email_obj IN HZ_EMAIL_CP_BO,
2294: p_created_by_module IN VARCHAR2,
2295: x_return_status OUT NOCOPY VARCHAR2,
2296: x_msg_count OUT NOCOPY NUMBER,
2297: x_msg_data OUT NOCOPY VARCHAR2,

Line 2302: l_email_obj HZ_EMAIL_CP_BO;

2298: x_email_id OUT NOCOPY NUMBER,
2299: x_email_os OUT NOCOPY VARCHAR2,
2300: x_email_osr OUT NOCOPY VARCHAR2
2301: )IS
2302: l_email_obj HZ_EMAIL_CP_BO;
2303: BEGIN
2304: l_email_obj := p_email_obj;
2305: do_update_contact_point (
2306: p_init_msg_list => p_init_msg_list,

Line 2331: p_email_obj IN HZ_EMAIL_CP_BO,

2327: p_parent_os => NULL );
2328: END update_email_bo;
2329:
2330: PROCEDURE update_email_bo(
2331: p_email_obj IN HZ_EMAIL_CP_BO,
2332: p_created_by_module IN VARCHAR2,
2333: p_obj_source IN VARCHAR2 := null,
2334: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
2335: x_return_status OUT NOCOPY VARCHAR2,

Line 2337: x_return_obj OUT NOCOPY HZ_EMAIL_CP_BO,

2333: p_obj_source IN VARCHAR2 := null,
2334: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
2335: x_return_status OUT NOCOPY VARCHAR2,
2336: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
2337: x_return_obj OUT NOCOPY HZ_EMAIL_CP_BO,
2338: x_email_id OUT NOCOPY NUMBER,
2339: x_email_os OUT NOCOPY VARCHAR2,
2340: x_email_osr OUT NOCOPY VARCHAR2
2341: )IS

Line 2344: l_email_obj HZ_EMAIL_CP_BO;

2340: x_email_osr OUT NOCOPY VARCHAR2
2341: )IS
2342: l_msg_data VARCHAR2(2000);
2343: l_msg_count NUMBER;
2344: l_email_obj HZ_EMAIL_CP_BO;
2345: BEGIN
2346: l_email_obj := p_email_obj;
2347: do_update_contact_point (
2348: p_init_msg_list => fnd_api.g_true,

Line 2752: p_email_obj IN HZ_EMAIL_CP_BO,

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,
2756: p_eft_obj IN HZ_EFT_CP_BO,

Line 3280: p_email_obj IN HZ_EMAIL_CP_BO,

3276: -- Create or update a logical email contact point.
3277: PROCEDURE save_email_bo(
3278: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3279: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
3280: p_email_obj IN HZ_EMAIL_CP_BO,
3281: p_created_by_module IN VARCHAR2,
3282: x_return_status OUT NOCOPY VARCHAR2,
3283: x_msg_count OUT NOCOPY NUMBER,
3284: x_msg_data OUT NOCOPY VARCHAR2,

Line 3293: l_email_obj HZ_EMAIL_CP_BO;

3289: px_parent_os IN OUT NOCOPY VARCHAR2,
3290: px_parent_osr IN OUT NOCOPY VARCHAR2,
3291: px_parent_obj_type IN OUT NOCOPY VARCHAR2
3292: ) IS
3293: l_email_obj HZ_EMAIL_CP_BO;
3294: BEGIN
3295: l_email_obj := p_email_obj;
3296: do_save_contact_point (
3297: p_init_msg_list => p_init_msg_list,

Line 3328: p_email_obj IN HZ_EMAIL_CP_BO,

3324: END save_email_bo;
3325:
3326: PROCEDURE save_email_bo(
3327: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
3328: p_email_obj IN HZ_EMAIL_CP_BO,
3329: p_created_by_module IN VARCHAR2,
3330: p_obj_source IN VARCHAR2 := null,
3331: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
3332: x_return_status OUT NOCOPY VARCHAR2,

Line 3334: x_return_obj OUT NOCOPY HZ_EMAIL_CP_BO,

3330: p_obj_source IN VARCHAR2 := null,
3331: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
3332: x_return_status OUT NOCOPY VARCHAR2,
3333: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
3334: x_return_obj OUT NOCOPY HZ_EMAIL_CP_BO,
3335: x_email_id OUT NOCOPY NUMBER,
3336: x_email_os OUT NOCOPY VARCHAR2,
3337: x_email_osr OUT NOCOPY VARCHAR2,
3338: px_parent_id IN OUT NOCOPY NUMBER,

Line 3345: l_email_obj HZ_EMAIL_CP_BO;

3341: px_parent_obj_type IN OUT NOCOPY VARCHAR2
3342: ) IS
3343: l_msg_data VARCHAR2(2000);
3344: l_msg_count NUMBER;
3345: l_email_obj HZ_EMAIL_CP_BO;
3346: BEGIN
3347: l_email_obj := p_email_obj;
3348: do_save_contact_point (
3349: p_init_msg_list => fnd_api.g_true,

Line 3962: p_email_obj IN HZ_EMAIL_CP_BO,

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,
3966: p_eft_obj IN HZ_EFT_CP_BO,

Line 4973: x_email_obj OUT NOCOPY HZ_EMAIL_CP_BO,

4969: PROCEDURE get_email_bo (
4970: p_email_id IN NUMBER,
4971: p_email_os IN VARCHAR2,
4972: p_email_osr IN VARCHAR2,
4973: x_email_obj OUT NOCOPY HZ_EMAIL_CP_BO,
4974: x_return_status OUT NOCOPY VARCHAR2,
4975: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL
4976: ) IS
4977: l_msg_data VARCHAR2(2000);

Line 5034: x_email_obj OUT NOCOPY HZ_EMAIL_CP_BO,

5030: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
5031: p_email_id IN NUMBER,
5032: p_email_os IN VARCHAR2,
5033: p_email_osr IN VARCHAR2,
5034: x_email_obj OUT NOCOPY HZ_EMAIL_CP_BO,
5035: x_return_status OUT NOCOPY VARCHAR2,
5036: x_msg_count OUT NOCOPY NUMBER,
5037: x_msg_data OUT NOCOPY VARCHAR2
5038: ) is

Line 5044: l_email_objs HZ_EMAIL_CP_BO_TBL;

5040:
5041: l_email_id number;
5042: l_email_os varchar2(30);
5043: l_email_osr varchar2(255);
5044: l_email_objs HZ_EMAIL_CP_BO_TBL;
5045: BEGIN
5046:
5047: -- initialize API return status to success.
5048: x_return_status := FND_API.G_RET_STS_SUCCESS;