DBA Data[Home] [Help]

APPS.HZ_CONTACT_POINT_BO_PUB dependencies on HZ_SMS_CP_BO

Line 258: p_sms_obj IN HZ_SMS_CP_BO,

254: --
255: -- 14-DEC-2004 Arnold Ng Created.
256:
257: PROCEDURE assign_sms_rec(
258: p_sms_obj IN HZ_SMS_CP_BO,
259: p_owner_table_id IN NUMBER,
260: p_owner_table_name IN VARCHAR2,
261: p_cp_id IN NUMBER,
262: p_cp_os IN VARCHAR2,

Line 947: p_sms_obj IN HZ_SMS_CP_BO,

943: -- Create a logical sms contact point.
944: PROCEDURE create_sms_bo(
945: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
946: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
947: p_sms_obj IN HZ_SMS_CP_BO,
948: p_created_by_module IN VARCHAR2,
949: x_return_status OUT NOCOPY VARCHAR2,
950: x_msg_count OUT NOCOPY NUMBER,
951: x_msg_data OUT NOCOPY VARCHAR2,

Line 960: l_sms_obj HZ_SMS_CP_BO;

956: px_parent_os IN OUT NOCOPY VARCHAR2,
957: px_parent_osr IN OUT NOCOPY VARCHAR2,
958: px_parent_obj_type IN OUT NOCOPY VARCHAR2
959: ) IS
960: l_sms_obj HZ_SMS_CP_BO;
961: BEGIN
962: l_sms_obj := p_sms_obj;
963: do_create_contact_point (
964: p_init_msg_list => p_init_msg_list,

Line 994: p_sms_obj IN HZ_SMS_CP_BO,

990: END create_sms_bo;
991:
992: PROCEDURE create_sms_bo(
993: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
994: p_sms_obj IN HZ_SMS_CP_BO,
995: p_created_by_module IN VARCHAR2,
996: p_obj_source IN VARCHAR2 := null,
997: p_return_obj_flag IN VARCHAr2 := fnd_api.g_true,
998: x_return_status OUT NOCOPY VARCHAR2,

Line 1000: x_return_obj OUT NOCOPY HZ_SMS_CP_BO,

996: p_obj_source IN VARCHAR2 := null,
997: p_return_obj_flag IN VARCHAr2 := fnd_api.g_true,
998: x_return_status OUT NOCOPY VARCHAR2,
999: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
1000: x_return_obj OUT NOCOPY HZ_SMS_CP_BO,
1001: x_sms_id OUT NOCOPY NUMBER,
1002: x_sms_os OUT NOCOPY VARCHAR2,
1003: x_sms_osr OUT NOCOPY VARCHAR2,
1004: px_parent_id IN OUT NOCOPY NUMBER,

Line 1011: l_sms_obj HZ_SMS_CP_BO;

1007: px_parent_obj_type IN OUT NOCOPY VARCHAR2
1008: ) IS
1009: l_msg_data VARCHAR2(2000);
1010: l_msg_count NUMBER;
1011: l_sms_obj HZ_SMS_CP_BO;
1012: BEGIN
1013: l_sms_obj := p_sms_obj;
1014: do_create_contact_point (
1015: p_init_msg_list => fnd_api.g_true,

Line 1601: p_sms_obj IN HZ_SMS_CP_BO,

1597: --
1598: -- 14-DEC-2004 Arnold Ng Created.
1599:
1600: PROCEDURE assign_sms_rec(
1601: p_sms_obj IN HZ_SMS_CP_BO,
1602: p_owner_table_id IN NUMBER,
1603: p_owner_table_name IN VARCHAR2,
1604: p_cp_id IN NUMBER,
1605: p_cp_os IN VARCHAR2,

Line 1683: p_sms_obj IN HZ_SMS_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,
1683: p_sms_obj IN HZ_SMS_CP_BO,
1684: p_cp_pref_objs IN OUT NOCOPY HZ_CONTACT_PREF_OBJ_TBL,
1685: p_cp_type IN VARCHAR2,
1686: p_created_by_module IN VARCHAR2,
1687: p_obj_source IN VARCHAR2 := null,

Line 1754: p_sms_objs => HZ_SMS_CP_BO_TBL(p_sms_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),
1754: p_sms_objs => HZ_SMS_CP_BO_TBL(p_sms_obj),
1755: p_bus_object => l_bus_object
1756: );
1757:
1758: IF NOT(l_valid_obj) THEN

Line 2657: p_sms_obj IN HZ_SMS_CP_BO,

2653: -- DESCRIPTION
2654: -- Update a logical sms contact point.
2655: PROCEDURE update_sms_bo(
2656: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2657: p_sms_obj IN HZ_SMS_CP_BO,
2658: p_created_by_module IN VARCHAR2,
2659: x_return_status OUT NOCOPY VARCHAR2,
2660: x_msg_count OUT NOCOPY NUMBER,
2661: x_msg_data OUT NOCOPY VARCHAR2,

Line 2666: l_sms_obj HZ_SMS_CP_BO;

2662: x_sms_id OUT NOCOPY NUMBER,
2663: x_sms_os OUT NOCOPY VARCHAR2,
2664: x_sms_osr OUT NOCOPY VARCHAR2
2665: )IS
2666: l_sms_obj HZ_SMS_CP_BO;
2667: BEGIN
2668: l_sms_obj := p_sms_obj;
2669: do_update_contact_point (
2670: p_init_msg_list => p_init_msg_list,

Line 2695: p_sms_obj IN HZ_SMS_CP_BO,

2691: p_parent_os => NULL );
2692: END update_sms_bo;
2693:
2694: PROCEDURE update_sms_bo(
2695: p_sms_obj IN HZ_SMS_CP_BO,
2696: p_created_by_module IN VARCHAR2,
2697: p_obj_source IN VARCHAR2 := null,
2698: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
2699: x_return_status OUT NOCOPY VARCHAR2,

Line 2701: x_return_obj OUT NOCOPY HZ_SMS_CP_BO,

2697: p_obj_source IN VARCHAR2 := null,
2698: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
2699: x_return_status OUT NOCOPY VARCHAR2,
2700: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
2701: x_return_obj OUT NOCOPY HZ_SMS_CP_BO,
2702: x_sms_id OUT NOCOPY NUMBER,
2703: x_sms_os OUT NOCOPY VARCHAR2,
2704: x_sms_osr OUT NOCOPY VARCHAR2
2705: )IS

Line 2708: l_sms_obj HZ_SMS_CP_BO;

2704: x_sms_osr OUT NOCOPY VARCHAR2
2705: )IS
2706: l_msg_data VARCHAR2(2000);
2707: l_msg_count NUMBER;
2708: l_sms_obj HZ_SMS_CP_BO;
2709: BEGIN
2710: l_sms_obj := p_sms_obj;
2711: do_update_contact_point (
2712: p_init_msg_list => fnd_api.g_true,

Line 2757: p_sms_obj IN HZ_SMS_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,
2757: p_sms_obj IN HZ_SMS_CP_BO,
2758: p_cp_pref_objs IN OUT NOCOPY HZ_CONTACT_PREF_OBJ_TBL,
2759: p_cp_type IN VARCHAR2,
2760: p_created_by_module IN VARCHAR2,
2761: p_obj_source IN VARCHAR2 := null,

Line 3845: p_sms_obj IN HZ_SMS_CP_BO,

3841: -- Create or update a logical sms contact point.
3842: PROCEDURE save_sms_bo(
3843: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
3844: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
3845: p_sms_obj IN HZ_SMS_CP_BO,
3846: p_created_by_module IN VARCHAR2,
3847: x_return_status OUT NOCOPY VARCHAR2,
3848: x_msg_count OUT NOCOPY NUMBER,
3849: x_msg_data OUT NOCOPY VARCHAR2,

Line 3858: l_sms_obj HZ_SMS_CP_BO;

3854: px_parent_os IN OUT NOCOPY VARCHAR2,
3855: px_parent_osr IN OUT NOCOPY VARCHAR2,
3856: px_parent_obj_type IN OUT NOCOPY VARCHAR2
3857: ) IS
3858: l_sms_obj HZ_SMS_CP_BO;
3859: BEGIN
3860: l_sms_obj := p_sms_obj;
3861: do_save_contact_point (
3862: p_init_msg_list => p_init_msg_list,

Line 3893: p_sms_obj IN HZ_SMS_CP_BO,

3889: END save_sms_bo;
3890:
3891: PROCEDURE save_sms_bo(
3892: p_validate_bo_flag IN VARCHAR2 := fnd_api.g_true,
3893: p_sms_obj IN HZ_SMS_CP_BO,
3894: p_created_by_module IN VARCHAR2,
3895: p_obj_source IN VARCHAR2 := null,
3896: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
3897: x_return_status OUT NOCOPY VARCHAR2,

Line 3899: x_return_obj OUT NOCOPY HZ_SMS_CP_BO,

3895: p_obj_source IN VARCHAR2 := null,
3896: p_return_obj_flag IN VARCHAR2 := fnd_api.g_true,
3897: x_return_status OUT NOCOPY VARCHAR2,
3898: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL,
3899: x_return_obj OUT NOCOPY HZ_SMS_CP_BO,
3900: x_sms_id OUT NOCOPY NUMBER,
3901: x_sms_os OUT NOCOPY VARCHAR2,
3902: x_sms_osr OUT NOCOPY VARCHAR2,
3903: px_parent_id IN OUT NOCOPY NUMBER,

Line 3910: l_sms_obj HZ_SMS_CP_BO;

3906: px_parent_obj_type IN OUT NOCOPY VARCHAR2
3907: ) IS
3908: l_msg_data VARCHAR2(2000);
3909: l_msg_count NUMBER;
3910: l_sms_obj HZ_SMS_CP_BO;
3911: BEGIN
3912: l_sms_obj := p_sms_obj;
3913: do_save_contact_point (
3914: p_init_msg_list => fnd_api.g_true,

Line 3967: p_sms_obj IN HZ_SMS_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,
3967: p_sms_obj IN HZ_SMS_CP_BO,
3968: p_cp_pref_objs IN OUT NOCOPY HZ_CONTACT_PREF_OBJ_TBL,
3969: p_cp_type IN VARCHAR2,
3970: p_created_by_module IN VARCHAR2,
3971: p_obj_source IN VARCHAR2 := null,

Line 5824: x_sms_obj OUT NOCOPY HZ_SMS_CP_BO,

5820: PROCEDURE get_sms_bo (
5821: p_sms_id IN NUMBER,
5822: p_sms_os IN VARCHAR2,
5823: p_sms_osr IN VARCHAR2,
5824: x_sms_obj OUT NOCOPY HZ_SMS_CP_BO,
5825: x_return_status OUT NOCOPY VARCHAR2,
5826: x_messages OUT NOCOPY HZ_MESSAGE_OBJ_TBL
5827: ) IS
5828: l_msg_data VARCHAR2(2000);

Line 5885: x_sms_obj OUT NOCOPY HZ_SMS_CP_BO,

5881: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
5882: p_sms_id IN NUMBER,
5883: p_sms_os IN VARCHAR2,
5884: p_sms_osr IN VARCHAR2,
5885: x_sms_obj OUT NOCOPY HZ_SMS_CP_BO,
5886: x_return_status OUT NOCOPY VARCHAR2,
5887: x_msg_count OUT NOCOPY NUMBER,
5888: x_msg_data OUT NOCOPY VARCHAR2
5889: ) is

Line 5895: l_sms_objs HZ_SMS_CP_BO_TBL;

5891:
5892: l_sms_id number;
5893: l_sms_os varchar2(30);
5894: l_sms_osr varchar2(255);
5895: l_sms_objs HZ_SMS_CP_BO_TBL;
5896: BEGIN
5897:
5898: -- initialize API return status to success.
5899: x_return_status := FND_API.G_RET_STS_SUCCESS;