APPS.JTF_TERR_NAMED_ACCOUNT dependencies on JTF_TTY_ACCT_QUAL_MAPS

Line 20: delete from jtf_tty_acct_qual_maps

16: -- End of Comments
17: ----
18: PROCEDURE delete_qual(p_acct_qual_map_id IN NUMBER) AS
19: BEGIN
20: delete from jtf_tty_acct_qual_maps
21: where ACCOUNT_QUAL_MAP_ID = p_acct_qual_map_id;
22: commit;
23: END delete_qual;
24:

Line 28: insert into jtf_tty_acct_qual_maps

24:
25: PROCEDURE insert_customer_qual(p_account_id IN NUMBER)
26: AS
27: BEGIN
28: insert into jtf_tty_acct_qual_maps
29: (ACCOUNT_QUAL_MAP_ID,
30: OBJECT_VERSION_NUMBER ,
31: NAMED_ACCOUNT_ID ,
32: QUAL_USG_ID ,

Line 66: from JTF_TTY_ACCT_QUAL_MAPS

62: p_qual_count OUT NOCOPY NUMBER) AS
63: qual_count NUMBER;
64: BEGIN
65: select count(*) into qual_count
66: from JTF_TTY_ACCT_QUAL_MAPS
67: where NAMED_ACCOUNT_ID = p_account_id
68: and QUAL_USG_ID = -1007;
69:
70: p_qual_count := qual_count;

Line 78: from JTF_TTY_ACCT_QUAL_MAPS

74: p_qual_count OUT NOCOPY NUMBER) AS
75: qual_count NUMBER;
76: BEGIN
77: select count(*) into qual_count
78: from JTF_TTY_ACCT_QUAL_MAPS
79: where NAMED_ACCOUNT_ID = p_account_id
80: and QUAL_USG_ID = -1012;
81:
82: p_qual_count := qual_count;

Line 100: from jtf_tty_acct_qual_maps

96: BEGIN
97: BEGIN
98: select 1
99: into qual_count
100: from jtf_tty_acct_qual_maps
101: where ACCOUNT_QUAL_MAP_ID = p_acct_qual_map_id
102: and rownum < 2;
103: EXCEPTION
104: WHEN NO_DATA_FOUND THEN

Line 109: insert into jtf_tty_acct_qual_maps

105: qual_count := 0;
106: END;
107: -- if a new entry, insert
108: if (qual_count = 0) then
109: insert into jtf_tty_acct_qual_maps
110: (ACCOUNT_QUAL_MAP_ID,
111: OBJECT_VERSION_NUMBER ,
112: NAMED_ACCOUNT_ID ,
113: QUAL_USG_ID ,

Line 139: update jtf_tty_acct_qual_maps

135: p_user_id,
136: sysdate
137: );
138: else
139: update jtf_tty_acct_qual_maps
140: set OBJECT_VERSION_NUMBER = 999,
141: COMPARISON_OPERATOR = p_operator,
142: VALUE1_CHAR = upper(p_value1_char),
143: VALUE2_CHAR = upper(p_value2_char),