APPS.IBE_PARTY_V2PVT dependencies on DUAL

Line 15: | Create_Individual_User

11: | Copyright (c) 1999 Oracle Corporation, Redwood Shores, CA, USA
12: | All rights reserved.
13: |=======================================================================
14: | PROCEDURE NAME
15: | Create_Individual_User
16: |
17: | DESCRIPTION
18: | This API is called during Individuale User Registration
19: |

Line 18: | This API is called during Individuale User Registration

14: | PROCEDURE NAME
15: | Create_Individual_User
16: |
17: | DESCRIPTION
18: | This API is called during Individuale User Registration
19: |
20: | USAGE
21: | - Create a party in HzParties table.
22: | - Creates Contact Points

Line 36: Procedure Create_Individual_User(

32: | - Create_User
33: |
34: |=======================================================================*/
35:
36: Procedure Create_Individual_User(
37: p_username IN VARCHAR2,
38: p_password IN VARCHAR2,
39: p_person_rec IN HZ_PARTY_V2PUB.person_rec_type,
40: p_email_rec IN HZ_CONTACT_POINT_V2PUB.email_rec_type,

Line 58: IBE_UTIL.debug('enter ibe_party_v2pvt.create_individual_user');

54:
55: l_account_id NUMBER;
56: BEGIN
57: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
58: IBE_UTIL.debug('enter ibe_party_v2pvt.create_individual_user');
59: END IF;
60:
61:
62:

Line 175: IBE_UTIL.debug('exit ibe_party_v2.create_individual_user');

171: p_data => x_msg_data
172: );
173:
174: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
175: IBE_UTIL.debug('exit ibe_party_v2.create_individual_user');
176: END IF;
177:
178:
179: EXCEPTION

Line 237: END create_individual_user;

233: IBE_UTIL.debug('error code : '|| to_char(SQLCODE));
234: IBE_UTIL.debug('error text : '|| SQLERRM);
235: END IF;
236:
237: END create_individual_user;
238:
239: /*=======================================================================
240: | Copyright (c) 1999 Oracle Corporation, Redwood Shores, CA, USA
241: | All rights reserved.

Line 705: select hz_party_number_s.nextval into l_rel_party_number from dual;

701: IF NVL(fnd_profile.value('HZ_GENERATE_PARTY_NUMBER'), 'Y') = 'N' THEN
702: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
703: IBE_UTIL.debug('Party Number Auto generation is off');
704: END IF;
705: select hz_party_number_s.nextval into l_rel_party_number from dual;
706: l_party_rel_rec.party_rec.party_number := l_rel_party_number;
707: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
708: IBE_UTIL.debug('Relationship Party Number :' || l_rel_party_number);
709: END IF;

Line 786: IBE_UTIL.debug('exit ibe_party_v2.create_individual_user');

782: p_data => x_msg_data
783: );
784:
785: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
786: IBE_UTIL.debug('exit ibe_party_v2.create_individual_user');
787: END IF;
788:
789:
790: EXCEPTION

Line 855: | This API is called by Create_Individual_User,

851: | PROCEDURE NAME
852: | Create_Person
853: |
854: | DESCRIPTION
855: | This API is called by Create_Individual_User,
856: | Create_Customer
857: | Create_Org_Contact
858: |
859: | USAGE

Line 923: select hz_party_number_s.nextval into l_party_number from dual;

919: IF NVL(fnd_profile.value('HZ_GENERATE_PARTY_NUMBER'), 'Y') = 'N' THEN
920: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
921: IBE_UTIL.debug('Party Number Auto generation is off');
922: END IF;
923: select hz_party_number_s.nextval into l_party_number from dual;
924: l_person_rec.party_rec.party_number := l_party_number;
925: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
926: IBE_UTIL.debug('Person Party Number :' || l_party_number);
927: END IF;

Line 1176: select hz_party_number_s.nextval into l_party_number from dual;

1172: IF NVL(fnd_profile.value('HZ_GENERATE_PARTY_NUMBER'), 'Y') = 'N' THEN
1173: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1174: IBE_UTIL.debug('Party Number Auto generation is off');
1175: END IF;
1176: select hz_party_number_s.nextval into l_party_number from dual;
1177: l_organization_rec.party_rec.party_number := l_party_number;
1178: IF (IBE_UTIL.G_DEBUGON = l_true) THEN
1179: IBE_UTIL.debug('Organization Party Number :' || l_party_number);
1180: END IF;

Line 1645: | This API is called By Create_Individual_User,

1641: | PROCEDURE NAME
1642: | Update_Contact_Preference
1643: |
1644: | DESCRIPTION
1645: | This API is called By Create_Individual_User,
1646: | Creat_Business_User
1647: |
1648: |
1649: | USAGE

Line 2079: FROM dual;

2075: l_count := 1;
2076: WHILE l_count > 0 LOOP
2077:
2078: SELECT hz_account_num_s.nextval INTO l_account_number
2079: FROM dual;
2080:
2081:
2082: SELECT COUNT(*) INTO l_count
2083: FROM hz_cust_accounts