[Home] [Help]
55: BEGIN
56:
57: SELECT 'Y'
58: INTO l_chk_done
59: FROM DUAL
60: WHERE EXISTS ( SELECT 'Y'
61: FROM hz_relationships hzr
62: WHERE hzr.subject_table_name = 'HZ_PARTIES'
63: AND hzr.object_table_name = 'HZ_PARTIES'
80:
81: BEGIN
82: SELECT 'Y'
83: INTO l_chk_done
84: FROM DUAL
85: WHERE EXISTS ( SELECT 'Y'
86: FROM hz_relationships hzr
87: WHERE hzr.subject_table_name = 'HZ_PARTIES'
88: AND hzr.object_table_name = 'HZ_PARTIES'
449: hierarchy_flag VARCHAR2(25);
450: BEGIN
451: SELECT 'SAME'
452: INTO x_hierarchy_status
453: FROM dual
454: WHERE (p_group_id1 IN
455: (SELECT parent_group_id FROM jtf_rs_groups_denorm
456: WHERE group_id = p_group_id2)
457: OR p_group_id1 IN
937: p_user_id,
938: SYSDATE,
939: p_user_id,
940: SYSDATE
941: FROM dual
942: );
943: END IF;
944:
945:
990: p_user_id,
991: sysdate,
992: p_user_id,
993: sysdate
994: FROM dual
995: WHERE NOT EXISTS
996: ( SELECT NULL
997: FROM jtf_tty_named_acct_rsc r
998: WHERE r.TERR_GROUP_ACCOUNT_ID = tgaHasParent.tga_id
1047: p_user_id,
1048: sysdate,
1049: p_user_id,
1050: sysdate
1051: FROM dual
1052: WHERE NOT EXISTS
1053: ( SELECT NULL
1054: FROM jtf_tty_named_acct_rsc r
1055: WHERE r.TERR_GROUP_ACCOUNT_ID = tgaNoParent.tga_id
1369: p_user_id,
1370: SYSDATE,
1371: p_user_id,
1372: SYSDATE
1373: FROM dual
1374: WHERE NOT EXISTS
1375: ( SELECT NULL FROM jtf_tty_named_acct_rsc r
1376: WHERE r.TERR_GROUP_ACCOUNT_ID = p_terr_gp_acct_id
1377: AND r.RESOURCE_ID = p_resource_id
1410: p_user_id,
1411: sysdate,
1412: p_user_id,
1413: sysdate
1414: from dual
1415: WHERE NOT EXISTS
1416: ( SELECT NULL FROM jtf_tty_acct_rsc_dn r
1417: WHERE r.TERR_GROUP_ACCOUNT_ID = p_terr_gp_acct_id
1418: AND r.RESOURCE_ID = p_resource_id
1469: p_user_id,
1470: SYSDATE,
1471: p_user_id,
1472: SYSDATE
1473: FROM jtf_tty_terr_grp_accts a, dual
1474: WHERE terr_group_id = p_terr_gp_id
1475: AND NOT EXISTS
1476: ( SELECT NULL FROM jtf_tty_named_acct_rsc r
1477: WHERE r.TERR_GROUP_ACCOUNT_ID = a.TERR_GROUP_ACCOUNT_ID
1518: p_user_id,
1519: sysdate,
1520: p_user_id,
1521: sysdate
1522: from jtf_tty_terr_grp_accts a, dual
1523: where terr_group_id = p_terr_gp_id
1524: AND NOT EXISTS
1525: ( SELECT NULL FROM jtf_tty_acct_rsc_dn r
1526: WHERE r.TERR_GROUP_ACCOUNT_ID = a.TERR_GROUP_ACCOUNT_ID
2867: NULL,
2868: p_user_id,
2869: SYSDATE,
2870: p_user_id,
2871: SYSDATE FROM dual);
2872: END IF;
2873: /* key name for trade name */
2874: IF (p_trade_name IS NOT NULL) THEN
2875: INSERT INTO jtf_tty_acct_qual_maps
2893: NULL,
2894: p_user_id,
2895: SYSDATE,
2896: p_user_id,
2897: SYSDATE FROM dual);
2898: END IF;
2899:
2900: /* key name for postal code */
2901: IF (p_postal_code IS NOT NULL) THEN
2920: NULL,
2921: p_user_id,
2922: SYSDATE,
2923: p_user_id,
2924: SYSDATE FROM dual);
2925: END IF;
2926: END create_acct_mappings;
2927:
2928: PROCEDURE create_tgp_named_account(p_terr_gp_id IN NUMBER,
2957: IF (p_account_count < 1) THEN
2958:
2959: SELECT JTF_TTY_NAMED_ACCTS_S.NEXTVAL
2960: INTO p_account_id
2961: FROM dual;
2962: INSERT INTO jtf_tty_named_accts
2963: (NAMED_ACCOUNT_ID,
2964: OBJECT_VERSION_NUMBER ,
2965: PARTY_ID ,
3019: END IF;
3020:
3021: SELECT JTF_TTY_TERR_GRP_ACCTS_S.NEXTVAL
3022: INTO p_terr_gp_acct_id
3023: FROM dual;
3024:
3025: -- assign a named account for the party to terr gp, if one does not exist
3026: IF (p_grp_acct_count < 1) THEN
3027: x_gp_acct_id := p_terr_gp_acct_id;
3083: WHERE party_id = p_party_id;
3084: -- create a new named account for the party, if one does not exist
3085: SELECT JTF_TTY_NAMED_ACCTS_S.NEXTVAL
3086: INTO p_account_id
3087: FROM dual;
3088:
3089: p_site_type_code := get_site_type_code(p_party_id);
3090:
3091: IF (p_account_count < 1) THEN
3124: AND tna.party_id = p_party_id;
3125:
3126: SELECT JTF_TTY_TERR_GRP_ACCTS_S.NEXTVAL
3127: INTO p_terr_gp_acct_id
3128: FROM dual;
3129: -- assign a named account for the party to terr gp, if one does not exist
3130:
3131: p_site_type_code := get_site_type_code(p_party_id);
3132:
3161: -- assign resource to the named account
3162:
3163: SELECT jtf_tty_named_acct_rsc_s.NEXTVAL
3164: INTO p_terr_gp_acct_rsc_id
3165: FROM dual;
3166:
3167: INSERT INTO jtf_tty_named_acct_rsc
3168: (ACCOUNT_RESOURCE_ID,
3169: OBJECT_VERSION_NUMBER ,
3196: /* commenting for now */
3197: /*
3198: select jtf_tty_acct_rsc_dn_s.nextval
3199: into p_terr_gp_acct_rsc_dn_id
3200: from dual;
3201: insert into jtf_tty_acct_rsc_dn
3202: (ACCOUNT_RESOURCE_DN_ID,
3203: OBJECT_VERSION_NUMBER ,
3204: TERR_GROUP_ACCOUNT_ID,