[Home] [Help]
79: FUNCTION create_party_gt (x_party IN hz_party_v2pub.party_rec_type)
80: RETURN NUMBER IS
81: CURSOR partyidcur IS
82: SELECT hz_party_val_gt_s.NEXTVAL
83: FROM DUAL;
84:
85: l_party_id NUMBER(15);
86: l_debug_prefix VARCHAR2(30) := '';
87: BEGIN
204: x_temp_id IN NUMBER DEFAULT NULL
205: ) RETURN NUMBER IS
206: CURSOR relidcur IS
207: SELECT hz_relationship_val_gt_s.NEXTVAL
208: FROM DUAL;
209:
210: l_relationship_id NUMBER(15);
211: l_party_id NUMBER(15);
212: l_debug_prefix VARCHAR2(30) := '';
421: x_temp_id IN NUMBER DEFAULT NULL
422: ) IS
423: CURSOR orgidcur IS
424: SELECT hz_org_profile_val_gt_s.NEXTVAL
425: FROM DUAL;
426:
427: l_org_profile_id NUMBER(15);
428: l_party_id NUMBER(15);
429: l_debug_prefix VARCHAR2(30) := '';
773: x_temp_id IN NUMBER DEFAULT NULL
774: ) IS
775: CURSOR grpidcur IS
776: SELECT hz_group_val_gt_s.NEXTVAL
777: FROM DUAL;
778:
779: l_group_id NUMBER(15);
780: l_party_id NUMBER(15);
781: l_debug_prefix VARCHAR2(30) := '';
912: x_temp_id IN NUMBER DEFAULT NULL
913: ) IS
914: CURSOR ocidcur IS
915: SELECT hz_contact_val_gt_s.NEXTVAL
916: FROM DUAL;
917:
918: l_org_contact_id NUMBER(15);
919: l_relationship_id NUMBER(15);
920: l_debug_prefix VARCHAR2(30) := '';
1063: x_temp_id IN NUMBER DEFAULT NULL
1064: ) IS
1065: CURSOR psidcur IS
1066: SELECT hz_party_site_val_gt_s.NEXTVAL
1067: FROM DUAL;
1068:
1069: l_party_site_id NUMBER(15);
1070: l_debug_prefix VARCHAR2(30) := '';
1071: BEGIN
1203: x_temp_id IN NUMBER DEFAULT NULL
1204: ) IS
1205: CURSOR locidcur IS
1206: SELECT hz_location_val_gt_s.NEXTVAL
1207: FROM DUAL;
1208:
1209: l_location_id NUMBER(15);
1210: l_debug_prefix VARCHAR2(30) := '';
1211: BEGIN
1403: x_temp_id IN NUMBER DEFAULT NULL
1404: ) IS
1405: CURSOR psidcur IS
1406: SELECT hz_contact_point_val_gt_s.NEXTVAL
1407: FROM DUAL;
1408:
1409: l_contact_point_id NUMBER(15);
1410: l_debug_prefix VARCHAR2(30) := '';
1411: BEGIN