APPS.JTF_TERR_NA_MERGE_PUB dependencies on JTF_TTY_NAMED_ACCTS

Line 221: FROM jtf_tty_named_accts

217: l_terr_group_id NUMBER;
218:
219: CURSOR c_from_na_id(p_party_id NUMBER) IS
220: SELECT named_account_id na_id
221: FROM jtf_tty_named_accts
222: WHERE party_id = p_party_id;
223:
224: CURSOR c_to_na_id(p_party_id NUMBER) IS
225: SELECT named_account_id na_id

Line 226: FROM jtf_tty_named_accts

222: WHERE party_id = p_party_id;
223:
224: CURSOR c_to_na_id(p_party_id NUMBER) IS
225: SELECT named_account_id na_id
226: FROM jtf_tty_named_accts
227: WHERE party_id = p_party_id;
228:
229: CURSOR c_get_tga_details (p_na_id NUMBER) IS
230: SELECT tga.terr_group_account_id, tga.terr_group_id, tg.matching_rule_code

Line 260: IF ( p_entity_name <> 'JTF_TTY_NAMED_ACCTS' OR p_parent_entity_name <> 'HZ_PARTY_SITES' ) THEN

256: END IF;
257:
258: x_return_status := fnd_api.g_ret_sts_success;
259:
260: IF ( p_entity_name <> 'JTF_TTY_NAMED_ACCTS' OR p_parent_entity_name <> 'HZ_PARTY_SITES' ) THEN
261: FND_FILE.PUT_LINE(FND_FILE.LOG,' Entity error');
262: fnd_message.set_name ('JTF', 'JTF_TERR_ENTITY_NAME_ERR');
263: fnd_message.set_token('P_ENTITY',p_entity_name);
264: fnd_message.set_token('P_PARENT_ENTITY',p_parent_entity_name);

Line 279: from jtf_tty_named_accts

275: FND_FILE.PUT_LINE(FND_FILE.LOG,' Check if merged FROM party site is a named account');
276:
277: select 'Y', named_account_id
278: into p_from_na_flag, p_from_na_id
279: from jtf_tty_named_accts
280: where party_site_id = p_from_fk_id
281: and rownum < 2;
282: EXCEPTION
283: WHEN NO_DATA_FOUND THEN

Line 296: from jtf_tty_named_accts

292: BEGIN
293: FND_FILE.PUT_LINE(FND_FILE.LOG,' Check if merged to party is a named account');
294: select 'Y', named_account_id
295: into p_to_na_flag, p_to_na_id
296: from jtf_tty_named_accts
297: where party_site_id = p_to_fk_id
298: and rownum < 2;
299: EXCEPTION
300: WHEN NO_DATA_FOUND THEN

Line 425: /* Do delete from jtf_tty_named_accts and acct_qual_maps after all processing is done */

421: END IF; /* Same or different TG */
422:
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:

Line 430: DELETE FROM jtf_tty_named_accts

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
432: AND party_site_id = p_from_fk_id;
433:
434: END IF; /* both Named accounts */

Line 472: jtf_tty_named_accts jna

468: BEGIN
469: SELECT 'Y'
470: INTO l_to_party_na_exists
471: FROM jtf_tty_terr_grp_accts tga,
472: jtf_tty_named_accts jna
473: WHERE jna.named_account_id = tga.named_account_id
474: AND jna.party_id = l_to_party_id
475: AND tga.terr_group_id = tga_rec.terr_group_id
476: AND rownum < 2;

Line 532: FROM jtf_tty_named_accts

528:
529: BEGIN
530: SELECT 'Y'
531: INTO l_to_na_exists
532: FROM jtf_tty_named_accts
533: WHERE party_id = l_to_party_id
534: AND party_site_id = p_to_fk_id;
535: EXCEPTION
536: WHEN NO_DATA_FOUND THEN

Line 542: UPDATE jtf_tty_named_accts

538: END;
539:
540: IF ( l_to_na_exists = 'N' ) then
541:
542: UPDATE jtf_tty_named_accts
543: SET party_id = l_to_party_id,
544: party_site_id = p_to_fk_id
545: WHERE party_id = l_from_party_id
546: AND party_site_id = p_from_fk_id;

Line 562: /* Do delete from jtf_tty_named_accts and acct_qual_maps after all processing is done */

558:
559: END IF;
560: END LOOP;
561:
562: /* Do delete from jtf_tty_named_accts and acct_qual_maps after all processing is done */
563:
564: DELETE FROM jtf_tty_named_accts
565: WHERE party_id = l_from_party_id
566: AND party_site_id = p_from_fk_id;

Line 564: DELETE FROM jtf_tty_named_accts

560: END LOOP;
561:
562: /* Do delete from jtf_tty_named_accts and acct_qual_maps after all processing is done */
563:
564: DELETE FROM jtf_tty_named_accts
565: WHERE party_id = l_from_party_id
566: AND party_site_id = p_from_fk_id;
567:
568: END IF; -- end from_na_flag = 'Y'