APPS.JTF_TERR_NA_MERGE_PUB dependencies on JTF_TTY_ACCT_QUAL_MAPS

Line 87: INSERT INTO jtf_tty_acct_qual_maps

83: END;
84:
85: IF (p_business_name IS NOT NULL) THEN
86: /* key name for business name */
87: INSERT INTO jtf_tty_acct_qual_maps
88: (ACCOUNT_QUAL_MAP_ID,
89: OBJECT_VERSION_NUMBER,
90: NAMED_ACCOUNT_ID,
91: QUAL_USG_ID,

Line 100: SELECT jtf_tty_acct_qual_maps_s.NEXTVAL,

96: CREATION_DATE,
97: LAST_UPDATED_BY,
98: LAST_UPDATE_DATE)
99: (
100: SELECT jtf_tty_acct_qual_maps_s.NEXTVAL,
101: 1,
102: p_acct_id,
103: -1012,
104: '=',

Line 115: INSERT INTO jtf_tty_acct_qual_maps

111: END IF;
112:
113: /* key name for trade name */
114: IF (p_trade_name IS NOT NULL) THEN
115: INSERT INTO jtf_tty_acct_qual_maps
116: (ACCOUNT_QUAL_MAP_ID,
117: OBJECT_VERSION_NUMBER,
118: NAMED_ACCOUNT_ID,
119: QUAL_USG_ID,

Line 127: (SELECT jtf_tty_acct_qual_maps_s.NEXTVAL,

123: CREATED_BY,
124: CREATION_DATE,
125: LAST_UPDATED_BY,
126: LAST_UPDATE_DATE)
127: (SELECT jtf_tty_acct_qual_maps_s.NEXTVAL,
128: 1,
129: p_acct_id,
130: -1012,
131: '=',

Line 142: INSERT INTO jtf_tty_acct_qual_maps

138: END IF;
139:
140: /* key name for postal code */
141: IF (p_postal_code IS NOT NULL) THEN
142: INSERT INTO jtf_tty_acct_qual_maps
143: (ACCOUNT_QUAL_MAP_ID,
144: OBJECT_VERSION_NUMBER,
145: NAMED_ACCOUNT_ID,
146: QUAL_USG_ID,

Line 154: (SELECT jtf_tty_acct_qual_maps_s.NEXTVAL,

150: CREATED_BY,
151: CREATION_DATE,
152: LAST_UPDATED_BY,
153: LAST_UPDATE_DATE)
154: (SELECT jtf_tty_acct_qual_maps_s.NEXTVAL,
155: 1,
156: p_acct_id,
157: -1007,
158: '=',

Line 376: UPDATE jtf_tty_acct_qual_maps

372: DELETE FROM jtf_tty_terr_grp_accts
373: WHERE terr_group_account_id = tga_rec.terr_group_account_id;
374:
375: if ( tga_rec.matching_rule_code = '1' ) then
376: UPDATE jtf_tty_acct_qual_maps
377: SET named_account_id = p_to_na_id
378: WHERE named_account_id = p_from_na_id;
379: end if;
380:

Line 398: FROM jtf_tty_acct_qual_maps

394:
395: BEGIN
396: SELECT 'Y'
397: INTO l_acct_qual_maps_exist
398: FROM jtf_tty_acct_qual_maps
399: WHERE named_account_id = p_to_na_id
400: AND rownum < 2;
401: EXCEPTION
402: WHEN NO_DATA_FOUND THEN

Line 413: UPDATE jtf_tty_acct_qual_maps

409: create_acct_mappings(p_to_na_id, l_to_party_id, p_to_fk_id, p_user_id );
410: end if;
411:
412: if ( tga_rec.matching_rule_code = '1' ) then
413: UPDATE jtf_tty_acct_qual_maps
414: SET named_account_id = p_to_na_id
415: WHERE named_account_id = p_from_na_id;
416: end if;
417:

Line 427: DELETE FROM jtf_tty_acct_qual_maps

423: END LOOP; /* Processed all TGs */
424:
425: /* Do delete from jtf_tty_named_accts and acct_qual_maps after all processing is done */
426:
427: DELETE FROM jtf_tty_acct_qual_maps
428: WHERE named_account_id = p_from_na_id;
429:
430: DELETE FROM jtf_tty_named_accts
431: WHERE party_id = l_from_party_id

Line 507: DELETE FROM jtf_tty_acct_qual_maps

503: DELETE FROM jtf_tty_terr_grp_accts
504: WHERE terr_group_account_id = tga_rec.terr_group_account_id;
505:
506: /*
507: DELETE FROM jtf_tty_acct_qual_maps
508: WHERE named_account_id = p_from_na_id;
509: */
510:
511: END IF; /* l_to_party_na_exists = 'N' */

Line 525: DELETE FROM jtf_tty_acct_qual_maps

521:
522: l_to_na_exists := 'N';
523:
524: /*
525: DELETE FROM jtf_tty_acct_qual_maps
526: WHERE named_account_id = p_from_na_id;
527: */
528:
529: BEGIN