DBA Data[Home] [Help]

APPS.POS_PROFILE_PKG dependencies on POS_PROFILE_PKG

Line 1: PACKAGE BODY POS_PROFILE_PKG as

1: PACKAGE BODY POS_PROFILE_PKG as
2: /*$Header: POSPRUTB.pls 120.9.12000000.2 2007/09/07 19:52:17 pkapoor ship $ */
3:
4: g_log_module_name VARCHAR2(30) := 'pos.plsql.POSPRUTB';
5:

Line 239: l_party_site_use_rec.created_by_module := 'POS_PROFILE_PKG';

235: BEGIN
236:
237: l_party_site_use_rec.party_site_id := p_party_site_id;
238: l_party_site_use_rec.application_id := 177;
239: l_party_site_use_rec.created_by_module := 'POS_PROFILE_PKG';
240: l_party_site_use_rec.status := 'A';
241: l_party_site_use_rec.site_use_type := p_address_type;
242:
243: hz_party_site_v2pub.create_party_site_use

Line 279: l_party_site_use_rec.created_by_module := 'POS_PROFILE_PKG';

275:
276: --dbms_output.put_line (' In update address type. Start ');
277: l_party_site_use_rec.party_site_use_id := p_party_site_use_id;
278: l_party_site_use_rec.application_id := 177;
279: l_party_site_use_rec.created_by_module := 'POS_PROFILE_PKG';
280: l_party_site_use_rec.status := p_status;
281: l_obj_no := p_object_version_number;
282:
283: if p_status = 'I' then

Line 378: POS_PROFILE_PKG.update_address_type (

374: if l_rfq_use_id is not null and l_status = 'I' then
375:
376: l_step := 4;
377: --dbms_output.put_line (' In update all address types. Step: '||l_step);
378: POS_PROFILE_PKG.update_address_type (
379: p_party_site_use_id => l_rfq_use_id
380: , p_status => l_status
381: , p_object_version_number => l_rfq_obj_no
382: , x_status => x_status

Line 414: POS_PROFILE_PKG.update_address_type (

410: if l_pur_use_id is not null and l_status = 'I' then
411:
412: l_step := 8;
413: --dbms_output.put_line (' In update all address types. Step: '||l_step);
414: POS_PROFILE_PKG.update_address_type (
415: p_party_site_use_id => l_pur_use_id
416: , p_status => l_status
417: , p_object_version_number => l_pur_obj_no
418: , x_status => x_status

Line 452: POS_PROFILE_PKG.update_address_type (

448: if l_pay_use_id is not null and l_status = 'I' then
449:
450: l_step := 13;
451: --dbms_output.put_line (' In update all address types. Step: '||l_step);
452: POS_PROFILE_PKG.update_address_type (
453: p_party_site_use_id => l_pay_use_id
454: , p_status => l_status
455: , p_object_version_number => l_pay_obj_no
456: , x_status => x_status

Line 833: POS_PROFILE_PKG.update_all_address_type(

829:
830: l_step := 1;
831: --dbms_output.put_line (lv_proc_name || ' : '||l_step);
832: -- Assign all address types.
833: POS_PROFILE_PKG.update_all_address_type(
834: p_party_site_id => p_party_site_id
835: , p_rfq => p_rfqFlag
836: , p_pur => p_purFlag
837: , p_pay => p_payFlag

Line 853: POS_PROFILE_PKG.update_address_note(

849:
850: l_step := 2;
851: --dbms_output.put_line (lv_proc_name || ' : '||l_step);
852: -- Add the note
853: POS_PROFILE_PKG.update_address_note(
854: p_party_site_id => p_party_site_id
855: , p_note => p_note
856: , x_status => x_status
857: , x_exception_msg => x_exception_msg

Line 1123: END POS_PROFILE_PKG;

1119: x_exception_msg := 'Failure at step ' || l_step;
1120: raise_application_error(-20015, x_exception_msg || sqlerrm, true);
1121: END remove_address;
1122:
1123: END POS_PROFILE_PKG;