DBA Data[Home] [Help]

APPS.CSD_PARTIES_PVT dependencies on HZ_CONTACT_POINT_V2PUB

Line 81: p_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,

77: p_org_rec IN HZ_PARTY_V2PUB.organization_rec_type,
78: p_party_type IN VARCHAR2,
79: p_account_rec IN HZ_CUST_ACCOUNT_V2PUB.cust_account_rec_type,
80: p_cust_profile_rec IN HZ_CUSTOMER_PROFILE_V2PUB.customer_profile_rec_type,
81: p_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
82: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
83: p_web_rec IN HZ_CONTACT_POINT_V2PUB.web_rec_type,
84: p_create_phone_flag IN VARCHAR2,
85: p_create_email_flag IN VARCHAR2,

Line 82: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,

78: p_party_type IN VARCHAR2,
79: p_account_rec IN HZ_CUST_ACCOUNT_V2PUB.cust_account_rec_type,
80: p_cust_profile_rec IN HZ_CUSTOMER_PROFILE_V2PUB.customer_profile_rec_type,
81: p_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
82: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
83: p_web_rec IN HZ_CONTACT_POINT_V2PUB.web_rec_type,
84: p_create_phone_flag IN VARCHAR2,
85: p_create_email_flag IN VARCHAR2,
86: p_create_url_flag IN VARCHAR2,

Line 83: p_web_rec IN HZ_CONTACT_POINT_V2PUB.web_rec_type,

79: p_account_rec IN HZ_CUST_ACCOUNT_V2PUB.cust_account_rec_type,
80: p_cust_profile_rec IN HZ_CUSTOMER_PROFILE_V2PUB.customer_profile_rec_type,
81: p_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
82: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
83: p_web_rec IN HZ_CONTACT_POINT_V2PUB.web_rec_type,
84: p_create_phone_flag IN VARCHAR2,
85: p_create_email_flag IN VARCHAR2,
86: p_create_url_flag IN VARCHAR2,
87: p_bill_loc_rec IN CSD_PROCESS_PVT.address_rec_type,

Line 397: p_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,

393: p_commit IN VARCHAR2 := fnd_api.g_false,
394: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
395: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
396: p_person_rec IN HZ_PARTY_V2PUB.person_rec_type,
397: p_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
398: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
399: p_web_rec IN HZ_CONTACT_POINT_V2PUB.web_rec_type,
400: p_create_phone_flag IN VARCHAR2,
401: p_create_email_flag IN VARCHAR2,

Line 398: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,

394: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
395: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
396: p_person_rec IN HZ_PARTY_V2PUB.person_rec_type,
397: p_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
398: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
399: p_web_rec IN HZ_CONTACT_POINT_V2PUB.web_rec_type,
400: p_create_phone_flag IN VARCHAR2,
401: p_create_email_flag IN VARCHAR2,
402: p_create_url_flag IN VARCHAR2,

Line 399: p_web_rec IN HZ_CONTACT_POINT_V2PUB.web_rec_type,

395: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
396: p_person_rec IN HZ_PARTY_V2PUB.person_rec_type,
397: p_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
398: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
399: p_web_rec IN HZ_CONTACT_POINT_V2PUB.web_rec_type,
400: p_create_phone_flag IN VARCHAR2,
401: p_create_email_flag IN VARCHAR2,
402: p_create_url_flag IN VARCHAR2,
403: x_party_id OUT NOCOPY NUMBER,

Line 1082: p_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,

1078: ( p_api_version IN NUMBER,
1079: p_commit IN VARCHAR2 := fnd_api.g_false,
1080: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1081: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1082: p_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
1083: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
1084: p_web_rec IN HZ_CONTACT_POINT_V2PUB.web_rec_type,
1085: p_create_phone_flag IN VARCHAR2,
1086: p_create_email_flag IN VARCHAR2,

Line 1083: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,

1079: p_commit IN VARCHAR2 := fnd_api.g_false,
1080: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1081: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1082: p_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
1083: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
1084: p_web_rec IN HZ_CONTACT_POINT_V2PUB.web_rec_type,
1085: p_create_phone_flag IN VARCHAR2,
1086: p_create_email_flag IN VARCHAR2,
1087: p_create_url_flag IN VARCHAR2,

Line 1084: p_web_rec IN HZ_CONTACT_POINT_V2PUB.web_rec_type,

1080: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
1081: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
1082: p_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
1083: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
1084: p_web_rec IN HZ_CONTACT_POINT_V2PUB.web_rec_type,
1085: p_create_phone_flag IN VARCHAR2,
1086: p_create_email_flag IN VARCHAR2,
1087: p_create_url_flag IN VARCHAR2,
1088: p_party_id IN NUMBER,

Line 1098: l_phone_create_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type

1094: x_msg_data OUT NOCOPY VARCHAR2 )
1095: IS
1096: l_api_name CONSTANT VARCHAR2(30) := 'Create_ContactPoints';
1097: l_api_version CONSTANT NUMBER := 1.0;
1098: l_phone_create_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type
1099: := CSD_PROCESS_PVT.get_phone_rec_type;
1100: l_email_create_rec HZ_CONTACT_POINT_V2PUB.email_rec_type
1101: := CSD_PROCESS_PVT.get_email_rec_type;
1102: l_web_create_rec HZ_CONTACT_POINT_V2PUB.web_rec_type

Line 1100: l_email_create_rec HZ_CONTACT_POINT_V2PUB.email_rec_type

1096: l_api_name CONSTANT VARCHAR2(30) := 'Create_ContactPoints';
1097: l_api_version CONSTANT NUMBER := 1.0;
1098: l_phone_create_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type
1099: := CSD_PROCESS_PVT.get_phone_rec_type;
1100: l_email_create_rec HZ_CONTACT_POINT_V2PUB.email_rec_type
1101: := CSD_PROCESS_PVT.get_email_rec_type;
1102: l_web_create_rec HZ_CONTACT_POINT_V2PUB.web_rec_type
1103: := CSD_PROCESS_PVT.get_web_rec_type;
1104: l_edi_create_rec HZ_CONTACT_POINT_V2PUB.edi_rec_type

Line 1102: l_web_create_rec HZ_CONTACT_POINT_V2PUB.web_rec_type

1098: l_phone_create_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type
1099: := CSD_PROCESS_PVT.get_phone_rec_type;
1100: l_email_create_rec HZ_CONTACT_POINT_V2PUB.email_rec_type
1101: := CSD_PROCESS_PVT.get_email_rec_type;
1102: l_web_create_rec HZ_CONTACT_POINT_V2PUB.web_rec_type
1103: := CSD_PROCESS_PVT.get_web_rec_type;
1104: l_edi_create_rec HZ_CONTACT_POINT_V2PUB.edi_rec_type
1105: := CSD_PROCESS_PVT.get_edi_rec_type;
1106: l_telex_create_rec HZ_CONTACT_POINT_V2PUB.telex_rec_type

Line 1104: l_edi_create_rec HZ_CONTACT_POINT_V2PUB.edi_rec_type

1100: l_email_create_rec HZ_CONTACT_POINT_V2PUB.email_rec_type
1101: := CSD_PROCESS_PVT.get_email_rec_type;
1102: l_web_create_rec HZ_CONTACT_POINT_V2PUB.web_rec_type
1103: := CSD_PROCESS_PVT.get_web_rec_type;
1104: l_edi_create_rec HZ_CONTACT_POINT_V2PUB.edi_rec_type
1105: := CSD_PROCESS_PVT.get_edi_rec_type;
1106: l_telex_create_rec HZ_CONTACT_POINT_V2PUB.telex_rec_type
1107: := CSD_PROCESS_PVT.get_telex_rec_type;
1108: l_contpt_create_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type

Line 1106: l_telex_create_rec HZ_CONTACT_POINT_V2PUB.telex_rec_type

1102: l_web_create_rec HZ_CONTACT_POINT_V2PUB.web_rec_type
1103: := CSD_PROCESS_PVT.get_web_rec_type;
1104: l_edi_create_rec HZ_CONTACT_POINT_V2PUB.edi_rec_type
1105: := CSD_PROCESS_PVT.get_edi_rec_type;
1106: l_telex_create_rec HZ_CONTACT_POINT_V2PUB.telex_rec_type
1107: := CSD_PROCESS_PVT.get_telex_rec_type;
1108: l_contpt_create_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type
1109: := CSD_PROCESS_PVT.get_contact_points_rec_type;
1110: BEGIN

Line 1108: l_contpt_create_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type

1104: l_edi_create_rec HZ_CONTACT_POINT_V2PUB.edi_rec_type
1105: := CSD_PROCESS_PVT.get_edi_rec_type;
1106: l_telex_create_rec HZ_CONTACT_POINT_V2PUB.telex_rec_type
1107: := CSD_PROCESS_PVT.get_telex_rec_type;
1108: l_contpt_create_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type
1109: := CSD_PROCESS_PVT.get_contact_points_rec_type;
1110: BEGIN
1111:
1112: -- Standard Start of API savepoint

Line 1151: HZ_CONTACT_POINT_V2PUB.Create_contact_point(

1147: l_contpt_create_rec.contact_point_type := 'PHONE';
1148: l_contpt_create_rec.owner_table_name := 'HZ_PARTIES';
1149: l_contpt_create_rec.owner_table_id := p_party_id;
1150:
1151: HZ_CONTACT_POINT_V2PUB.Create_contact_point(
1152: p_init_msg_list => FND_API.G_FALSE,
1153: p_contact_point_rec => l_contpt_create_rec,
1154: p_edi_rec => l_edi_create_rec,
1155: p_email_rec => l_email_create_rec,

Line 1177: HZ_CONTACT_POINT_V2PUB.Create_contact_point(

1173: l_contpt_create_rec.contact_point_type := 'EMAIL';
1174: l_contpt_create_rec.owner_table_name := 'HZ_PARTIES';
1175: l_contpt_create_rec.owner_table_id := p_party_id;
1176:
1177: HZ_CONTACT_POINT_V2PUB.Create_contact_point(
1178: p_init_msg_list => FND_API.G_FALSE,
1179: p_contact_point_rec => l_contpt_create_rec,
1180: p_edi_rec => l_edi_create_rec,
1181: p_email_rec => p_email_rec,

Line 1202: HZ_CONTACT_POINT_V2PUB.Create_contact_point(

1198: l_contpt_create_rec.contact_point_type := 'WEB';
1199: l_contpt_create_rec.owner_table_name := 'HZ_PARTIES';
1200: l_contpt_create_rec.owner_table_id := p_party_id;
1201:
1202: HZ_CONTACT_POINT_V2PUB.Create_contact_point(
1203: p_init_msg_list => FND_API.G_FALSE,
1204: p_contact_point_rec => l_contpt_create_rec,
1205: p_edi_rec => l_edi_create_rec,
1206: p_email_rec => l_email_create_rec,

Line 2267: p_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,

2263: p_api_version IN NUMBER,
2264: p_commit IN VARCHAR2 := fnd_api.g_false,
2265: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2266: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
2267: p_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
2268: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
2269: p_web_rec IN HZ_CONTACT_POINT_V2PUB.web_rec_type,
2270: p_phone_cnt_point_id IN NUMBER,
2271: p_email_cnt_point_id IN NUMBER,

Line 2268: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,

2264: p_commit IN VARCHAR2 := fnd_api.g_false,
2265: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2266: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
2267: p_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
2268: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
2269: p_web_rec IN HZ_CONTACT_POINT_V2PUB.web_rec_type,
2270: p_phone_cnt_point_id IN NUMBER,
2271: p_email_cnt_point_id IN NUMBER,
2272: p_url_cnt_point_id IN NUMBER,

Line 2269: p_web_rec IN HZ_CONTACT_POINT_V2PUB.web_rec_type,

2265: p_init_msg_list IN VARCHAR2 := fnd_api.g_false,
2266: p_validation_level IN NUMBER := fnd_api.g_valid_level_full,
2267: p_phone_rec IN HZ_CONTACT_POINT_V2PUB.phone_rec_type,
2268: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,
2269: p_web_rec IN HZ_CONTACT_POINT_V2PUB.web_rec_type,
2270: p_phone_cnt_point_id IN NUMBER,
2271: p_email_cnt_point_id IN NUMBER,
2272: p_url_cnt_point_id IN NUMBER,
2273: p_phone_obj_ver_num IN NUMBER,

Line 2290: l_phone_update_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type

2286: l_api_name CONSTANT VARCHAR2(30) := 'Update_ContactPoints';
2287: l_api_version CONSTANT NUMBER := 1.0;
2288:
2289: -- the following are default records: --
2290: l_phone_update_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type
2291: := CSD_PROCESS_PVT.get_phone_rec_type;
2292: l_email_update_rec HZ_CONTACT_POINT_V2PUB.email_rec_type
2293: := CSD_PROCESS_PVT.get_email_rec_type;
2294: l_web_update_rec HZ_CONTACT_POINT_V2PUB.web_rec_type

Line 2292: l_email_update_rec HZ_CONTACT_POINT_V2PUB.email_rec_type

2288:
2289: -- the following are default records: --
2290: l_phone_update_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type
2291: := CSD_PROCESS_PVT.get_phone_rec_type;
2292: l_email_update_rec HZ_CONTACT_POINT_V2PUB.email_rec_type
2293: := CSD_PROCESS_PVT.get_email_rec_type;
2294: l_web_update_rec HZ_CONTACT_POINT_V2PUB.web_rec_type
2295: := CSD_PROCESS_PVT.get_web_rec_type;
2296: l_edi_update_rec HZ_CONTACT_POINT_V2PUB.edi_rec_type

Line 2294: l_web_update_rec HZ_CONTACT_POINT_V2PUB.web_rec_type

2290: l_phone_update_rec HZ_CONTACT_POINT_V2PUB.phone_rec_type
2291: := CSD_PROCESS_PVT.get_phone_rec_type;
2292: l_email_update_rec HZ_CONTACT_POINT_V2PUB.email_rec_type
2293: := CSD_PROCESS_PVT.get_email_rec_type;
2294: l_web_update_rec HZ_CONTACT_POINT_V2PUB.web_rec_type
2295: := CSD_PROCESS_PVT.get_web_rec_type;
2296: l_edi_update_rec HZ_CONTACT_POINT_V2PUB.edi_rec_type
2297: := CSD_PROCESS_PVT.get_edi_rec_type;
2298: l_telex_update_rec HZ_CONTACT_POINT_V2PUB.telex_rec_type

Line 2296: l_edi_update_rec HZ_CONTACT_POINT_V2PUB.edi_rec_type

2292: l_email_update_rec HZ_CONTACT_POINT_V2PUB.email_rec_type
2293: := CSD_PROCESS_PVT.get_email_rec_type;
2294: l_web_update_rec HZ_CONTACT_POINT_V2PUB.web_rec_type
2295: := CSD_PROCESS_PVT.get_web_rec_type;
2296: l_edi_update_rec HZ_CONTACT_POINT_V2PUB.edi_rec_type
2297: := CSD_PROCESS_PVT.get_edi_rec_type;
2298: l_telex_update_rec HZ_CONTACT_POINT_V2PUB.telex_rec_type
2299: := CSD_PROCESS_PVT.get_telex_rec_type;
2300: l_contpt_update_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type

Line 2298: l_telex_update_rec HZ_CONTACT_POINT_V2PUB.telex_rec_type

2294: l_web_update_rec HZ_CONTACT_POINT_V2PUB.web_rec_type
2295: := CSD_PROCESS_PVT.get_web_rec_type;
2296: l_edi_update_rec HZ_CONTACT_POINT_V2PUB.edi_rec_type
2297: := CSD_PROCESS_PVT.get_edi_rec_type;
2298: l_telex_update_rec HZ_CONTACT_POINT_V2PUB.telex_rec_type
2299: := CSD_PROCESS_PVT.get_telex_rec_type;
2300: l_contpt_update_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type
2301: := CSD_PROCESS_PVT.get_contact_points_rec_type;
2302: BEGIN

Line 2300: l_contpt_update_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type

2296: l_edi_update_rec HZ_CONTACT_POINT_V2PUB.edi_rec_type
2297: := CSD_PROCESS_PVT.get_edi_rec_type;
2298: l_telex_update_rec HZ_CONTACT_POINT_V2PUB.telex_rec_type
2299: := CSD_PROCESS_PVT.get_telex_rec_type;
2300: l_contpt_update_rec HZ_CONTACT_POINT_V2PUB.contact_point_rec_type
2301: := CSD_PROCESS_PVT.get_contact_points_rec_type;
2302: BEGIN
2303:
2304: -- Standard Start of API savepoint

Line 2344: HZ_CONTACT_POINT_V2PUB.Update_contact_point(

2340: l_contpt_update_rec.contact_point_type := 'PHONE';
2341: l_contpt_update_rec.owner_table_name := 'HZ_PARTIES';
2342: l_contpt_update_rec.contact_point_id := p_phone_cnt_point_id;
2343:
2344: HZ_CONTACT_POINT_V2PUB.Update_contact_point(
2345: p_init_msg_list => FND_API.G_FALSE,
2346: p_contact_point_rec => l_contpt_update_rec,
2347: p_edi_rec => l_edi_update_rec,
2348: p_email_rec => l_email_update_rec,

Line 2370: HZ_CONTACT_POINT_V2PUB.Update_contact_point(

2366: l_contpt_update_rec.contact_point_type := 'EMAIL';
2367: l_contpt_update_rec.owner_table_name := 'HZ_PARTIES';
2368: l_contpt_update_rec.contact_point_id := p_email_cnt_point_id;
2369:
2370: HZ_CONTACT_POINT_V2PUB.Update_contact_point(
2371: p_init_msg_list => FND_API.G_FALSE,
2372: x_return_status => x_return_status,
2373: x_msg_count => x_msg_count,
2374: x_msg_data => x_msg_data,

Line 2397: HZ_CONTACT_POINT_V2PUB.Update_contact_point(

2393: l_contpt_update_rec.owner_table_name := 'HZ_PARTIES';
2394: l_contpt_update_rec.contact_point_id := p_url_cnt_point_id;
2395:
2396:
2397: HZ_CONTACT_POINT_V2PUB.Update_contact_point(
2398: p_init_msg_list => FND_API.G_FALSE,
2399: x_return_status => x_return_status,
2400: x_msg_count => x_msg_count,
2401: x_msg_data => x_msg_data,