eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.QA_SPECS_PUB dependencies on QA_SPECS

Line 1: PACKAGE BODY qa_specs_pub AS

1: PACKAGE BODY qa_specs_pub AS
2: /* $Header: qltpspcb.plb 120.1.12010000.2 2008/09/24 11:29:02 pdube ship $ */
3:
4:
5: --

Line 9: TYPE qa_specs_table IS TABLE OF qa_specs%ROWTYPE INDEX BY BINARY_INTEGER;

5: --
6: -- Safe globals.
7: --
8:
9: TYPE qa_specs_table IS TABLE OF qa_specs%ROWTYPE INDEX BY BINARY_INTEGER;
10: g_qa_specs_array qa_specs_table;
11:
12: g_pkg_name CONSTANT VARCHAR2(30):= 'qa_specs_pub';
13: g_user_name_cache fnd_user.user_name%TYPE := NULL;

Line 10: g_qa_specs_array qa_specs_table;

6: -- Safe globals.
7: --
8:
9: TYPE qa_specs_table IS TABLE OF qa_specs%ROWTYPE INDEX BY BINARY_INTEGER;
10: g_qa_specs_array qa_specs_table;
11:
12: g_pkg_name CONSTANT VARCHAR2(30):= 'qa_specs_pub';
13: g_user_name_cache fnd_user.user_name%TYPE := NULL;
14: g_user_id_cache NUMBER;

Line 12: g_pkg_name CONSTANT VARCHAR2(30):= 'qa_specs_pub';

8:
9: TYPE qa_specs_table IS TABLE OF qa_specs%ROWTYPE INDEX BY BINARY_INTEGER;
10: g_qa_specs_array qa_specs_table;
11:
12: g_pkg_name CONSTANT VARCHAR2(30):= 'qa_specs_pub';
13: g_user_name_cache fnd_user.user_name%TYPE := NULL;
14: g_user_id_cache NUMBER;
15:
16: --

Line 65: -- all fetched qa_specs. If the same spec data is required in

61: END get_user_id;
62:
63: --
64: -- Global caching mechanism. A global array is used to kept
65: -- all fetched qa_specs. If the same spec data is required in
66: -- a future call, the cached data will be used.
67: --
68:
69: FUNCTION exists_qa_specs(spec_id IN NUMBER)

Line 69: FUNCTION exists_qa_specs(spec_id IN NUMBER)

65: -- all fetched qa_specs. If the same spec data is required in
66: -- a future call, the cached data will be used.
67: --
68:
69: FUNCTION exists_qa_specs(spec_id IN NUMBER)
70: RETURN BOOLEAN IS
71:
72: BEGIN
73:

Line 74: RETURN g_qa_specs_array.EXISTS(spec_id);

70: RETURN BOOLEAN IS
71:
72: BEGIN
73:
74: RETURN g_qa_specs_array.EXISTS(spec_id);
75:
76: END exists_qa_specs;
77:
78:

Line 76: END exists_qa_specs;

72: BEGIN
73:
74: RETURN g_qa_specs_array.EXISTS(spec_id);
75:
76: END exists_qa_specs;
77:
78:
79: PROCEDURE fetch_qa_specs(spec_id IN NUMBER) IS
80: --

Line 79: PROCEDURE fetch_qa_specs(spec_id IN NUMBER) IS

75:
76: END exists_qa_specs;
77:
78:
79: PROCEDURE fetch_qa_specs(spec_id IN NUMBER) IS
80: --
81: -- Retrieve a specification header and cached.
82: --
83: CURSOR c1 (p_id NUMBER) IS

Line 85: FROM qa_specs

81: -- Retrieve a specification header and cached.
82: --
83: CURSOR c1 (p_id NUMBER) IS
84: SELECT *
85: FROM qa_specs
86: WHERE spec_id = p_id;
87:
88: BEGIN
89: IF NOT exists_qa_specs(spec_id) THEN

Line 89: IF NOT exists_qa_specs(spec_id) THEN

85: FROM qa_specs
86: WHERE spec_id = p_id;
87:
88: BEGIN
89: IF NOT exists_qa_specs(spec_id) THEN
90: OPEN c1(spec_id);
91: FETCH c1 INTO g_qa_specs_array(spec_id);
92: CLOSE c1;
93: END IF;

Line 91: FETCH c1 INTO g_qa_specs_array(spec_id);

87:
88: BEGIN
89: IF NOT exists_qa_specs(spec_id) THEN
90: OPEN c1(spec_id);
91: FETCH c1 INTO g_qa_specs_array(spec_id);
92: CLOSE c1;
93: END IF;
94: END fetch_qa_specs;
95:

Line 94: END fetch_qa_specs;

90: OPEN c1(spec_id);
91: FETCH c1 INTO g_qa_specs_array(spec_id);
92: CLOSE c1;
93: END IF;
94: END fetch_qa_specs;
95:
96:
97: PROCEDURE fetch_qa_specs(p_spec_name IN VARCHAR2, x_spec_id OUT NOCOPY NUMBER) IS
98: --

Line 97: PROCEDURE fetch_qa_specs(p_spec_name IN VARCHAR2, x_spec_id OUT NOCOPY NUMBER) IS

93: END IF;
94: END fetch_qa_specs;
95:
96:
97: PROCEDURE fetch_qa_specs(p_spec_name IN VARCHAR2, x_spec_id OUT NOCOPY NUMBER) IS
98: --
99: -- Retrieve a specification header and cached. Similar to
100: -- the previous function but query by spec name instead of id.
101: --

Line 104: FROM qa_specs

100: -- the previous function but query by spec name instead of id.
101: --
102: CURSOR c1 IS
103: SELECT *
104: FROM qa_specs
105: WHERE spec_name = p_spec_name;
106:
107: temp qa_specs%ROWTYPE;
108:

Line 107: temp qa_specs%ROWTYPE;

103: SELECT *
104: FROM qa_specs
105: WHERE spec_name = p_spec_name;
106:
107: temp qa_specs%ROWTYPE;
108:
109: BEGIN
110: OPEN c1;
111: FETCH c1 INTO temp;

Line 118: g_qa_specs_array(x_spec_id) := temp;

114: RETURN;
115: END IF;
116:
117: x_spec_id := temp.spec_id;
118: g_qa_specs_array(x_spec_id) := temp;
119: CLOSE c1;
120: END fetch_qa_specs;
121:
122:

Line 120: END fetch_qa_specs;

116:
117: x_spec_id := temp.spec_id;
118: g_qa_specs_array(x_spec_id) := temp;
119: CLOSE c1;
120: END fetch_qa_specs;
121:
122:
123: FUNCTION item_id(spec_id IN NUMBER)
124: RETURN NUMBER IS

Line 128: fetch_qa_specs(spec_id);

124: RETURN NUMBER IS
125:
126: BEGIN
127:
128: fetch_qa_specs(spec_id);
129: IF NOT exists_qa_specs(spec_id) THEN
130: RETURN NULL;
131: END IF;
132: RETURN g_qa_specs_array(spec_id).item_id;

Line 129: IF NOT exists_qa_specs(spec_id) THEN

125:
126: BEGIN
127:
128: fetch_qa_specs(spec_id);
129: IF NOT exists_qa_specs(spec_id) THEN
130: RETURN NULL;
131: END IF;
132: RETURN g_qa_specs_array(spec_id).item_id;
133:

Line 132: RETURN g_qa_specs_array(spec_id).item_id;

128: fetch_qa_specs(spec_id);
129: IF NOT exists_qa_specs(spec_id) THEN
130: RETURN NULL;
131: END IF;
132: RETURN g_qa_specs_array(spec_id).item_id;
133:
134: END item_id;
135:
136:

Line 142: fetch_qa_specs(spec_id);

138: RETURN NUMBER IS
139:
140: BEGIN
141:
142: fetch_qa_specs(spec_id);
143: IF NOT exists_qa_specs(spec_id) THEN
144: RETURN NULL;
145: END IF;
146: RETURN g_qa_specs_array(spec_id).organization_id;

Line 143: IF NOT exists_qa_specs(spec_id) THEN

139:
140: BEGIN
141:
142: fetch_qa_specs(spec_id);
143: IF NOT exists_qa_specs(spec_id) THEN
144: RETURN NULL;
145: END IF;
146: RETURN g_qa_specs_array(spec_id).organization_id;
147:

Line 146: RETURN g_qa_specs_array(spec_id).organization_id;

142: fetch_qa_specs(spec_id);
143: IF NOT exists_qa_specs(spec_id) THEN
144: RETURN NULL;
145: END IF;
146: RETURN g_qa_specs_array(spec_id).organization_id;
147:
148: END organization_id;
149:
150:

Line 156: fetch_qa_specs(spec_id);

152: RETURN VARCHAR2 IS
153:
154: BEGIN
155:
156: fetch_qa_specs(spec_id);
157: IF NOT exists_qa_specs(spec_id) THEN
158: RETURN NULL;
159: END IF;
160: RETURN g_qa_specs_array(spec_id).spec_name;

Line 157: IF NOT exists_qa_specs(spec_id) THEN

153:
154: BEGIN
155:
156: fetch_qa_specs(spec_id);
157: IF NOT exists_qa_specs(spec_id) THEN
158: RETURN NULL;
159: END IF;
160: RETURN g_qa_specs_array(spec_id).spec_name;
161:

Line 160: RETURN g_qa_specs_array(spec_id).spec_name;

156: fetch_qa_specs(spec_id);
157: IF NOT exists_qa_specs(spec_id) THEN
158: RETURN NULL;
159: END IF;
160: RETURN g_qa_specs_array(spec_id).spec_name;
161:
162: END spec_name;
163:
164:

Line 170: fetch_qa_specs(spec_id);

166: RETURN NUMBER IS
167:
168: BEGIN
169:
170: fetch_qa_specs(spec_id);
171: IF NOT exists_qa_specs(spec_id) THEN
172: RETURN NULL;
173: END IF;
174: RETURN g_qa_specs_array(spec_id).category_set_id;

Line 171: IF NOT exists_qa_specs(spec_id) THEN

167:
168: BEGIN
169:
170: fetch_qa_specs(spec_id);
171: IF NOT exists_qa_specs(spec_id) THEN
172: RETURN NULL;
173: END IF;
174: RETURN g_qa_specs_array(spec_id).category_set_id;
175:

Line 174: RETURN g_qa_specs_array(spec_id).category_set_id;

170: fetch_qa_specs(spec_id);
171: IF NOT exists_qa_specs(spec_id) THEN
172: RETURN NULL;
173: END IF;
174: RETURN g_qa_specs_array(spec_id).category_set_id;
175:
176: END category_set_id;
177:
178:

Line 184: fetch_qa_specs(spec_id);

180: RETURN NUMBER IS
181:
182: BEGIN
183:
184: fetch_qa_specs(spec_id);
185: IF NOT exists_qa_specs(spec_id) THEN
186: RETURN NULL;
187: END IF;
188: RETURN g_qa_specs_array(spec_id).category_id;

Line 185: IF NOT exists_qa_specs(spec_id) THEN

181:
182: BEGIN
183:
184: fetch_qa_specs(spec_id);
185: IF NOT exists_qa_specs(spec_id) THEN
186: RETURN NULL;
187: END IF;
188: RETURN g_qa_specs_array(spec_id).category_id;
189:

Line 188: RETURN g_qa_specs_array(spec_id).category_id;

184: fetch_qa_specs(spec_id);
185: IF NOT exists_qa_specs(spec_id) THEN
186: RETURN NULL;
187: END IF;
188: RETURN g_qa_specs_array(spec_id).category_id;
189:
190: END category_id;
191:
192:

Line 198: fetch_qa_specs(spec_id);

194: RETURN VARCHAR2 IS
195:
196: BEGIN
197:
198: fetch_qa_specs(spec_id);
199: IF NOT exists_qa_specs(spec_id) THEN
200: RETURN NULL;
201: END IF;
202: RETURN g_qa_specs_array(spec_id).item_revision;

Line 199: IF NOT exists_qa_specs(spec_id) THEN

195:
196: BEGIN
197:
198: fetch_qa_specs(spec_id);
199: IF NOT exists_qa_specs(spec_id) THEN
200: RETURN NULL;
201: END IF;
202: RETURN g_qa_specs_array(spec_id).item_revision;
203:

Line 202: RETURN g_qa_specs_array(spec_id).item_revision;

198: fetch_qa_specs(spec_id);
199: IF NOT exists_qa_specs(spec_id) THEN
200: RETURN NULL;
201: END IF;
202: RETURN g_qa_specs_array(spec_id).item_revision;
203:
204: END item_revision;
205:
206:

Line 212: fetch_qa_specs(spec_id);

208: RETURN NUMBER IS
209:
210: BEGIN
211:
212: fetch_qa_specs(spec_id);
213: IF NOT exists_qa_specs(spec_id) THEN
214: RETURN NULL;
215: END IF;
216: RETURN g_qa_specs_array(spec_id).vendor_id;

Line 213: IF NOT exists_qa_specs(spec_id) THEN

209:
210: BEGIN
211:
212: fetch_qa_specs(spec_id);
213: IF NOT exists_qa_specs(spec_id) THEN
214: RETURN NULL;
215: END IF;
216: RETURN g_qa_specs_array(spec_id).vendor_id;
217:

Line 216: RETURN g_qa_specs_array(spec_id).vendor_id;

212: fetch_qa_specs(spec_id);
213: IF NOT exists_qa_specs(spec_id) THEN
214: RETURN NULL;
215: END IF;
216: RETURN g_qa_specs_array(spec_id).vendor_id;
217:
218: END vendor_id;
219:
220:

Line 226: fetch_qa_specs(spec_id);

222: RETURN NUMBER IS
223:
224: BEGIN
225:
226: fetch_qa_specs(spec_id);
227: IF NOT exists_qa_specs(spec_id) THEN
228: RETURN NULL;
229: END IF;
230: RETURN g_qa_specs_array(spec_id).customer_id;

Line 227: IF NOT exists_qa_specs(spec_id) THEN

223:
224: BEGIN
225:
226: fetch_qa_specs(spec_id);
227: IF NOT exists_qa_specs(spec_id) THEN
228: RETURN NULL;
229: END IF;
230: RETURN g_qa_specs_array(spec_id).customer_id;
231:

Line 230: RETURN g_qa_specs_array(spec_id).customer_id;

226: fetch_qa_specs(spec_id);
227: IF NOT exists_qa_specs(spec_id) THEN
228: RETURN NULL;
229: END IF;
230: RETURN g_qa_specs_array(spec_id).customer_id;
231:
232: END customer_id;
233:
234:

Line 240: fetch_qa_specs(spec_id);

236: RETURN NUMBER IS
237:
238: BEGIN
239:
240: fetch_qa_specs(spec_id);
241: IF NOT exists_qa_specs(spec_id) THEN
242: RETURN NULL;
243: END IF;
244: RETURN g_qa_specs_array(spec_id).char_id;

Line 241: IF NOT exists_qa_specs(spec_id) THEN

237:
238: BEGIN
239:
240: fetch_qa_specs(spec_id);
241: IF NOT exists_qa_specs(spec_id) THEN
242: RETURN NULL;
243: END IF;
244: RETURN g_qa_specs_array(spec_id).char_id;
245:

Line 244: RETURN g_qa_specs_array(spec_id).char_id;

240: fetch_qa_specs(spec_id);
241: IF NOT exists_qa_specs(spec_id) THEN
242: RETURN NULL;
243: END IF;
244: RETURN g_qa_specs_array(spec_id).char_id;
245:
246: END char_id;
247:
248:

Line 254: fetch_qa_specs(spec_id);

250: RETURN VARCHAR2 IS
251:
252: BEGIN
253:
254: fetch_qa_specs(spec_id);
255: IF NOT exists_qa_specs(spec_id) THEN
256: RETURN NULL;
257: END IF;
258: RETURN g_qa_specs_array(spec_id).spec_element_value;

Line 255: IF NOT exists_qa_specs(spec_id) THEN

251:
252: BEGIN
253:
254: fetch_qa_specs(spec_id);
255: IF NOT exists_qa_specs(spec_id) THEN
256: RETURN NULL;
257: END IF;
258: RETURN g_qa_specs_array(spec_id).spec_element_value;
259:

Line 258: RETURN g_qa_specs_array(spec_id).spec_element_value;

254: fetch_qa_specs(spec_id);
255: IF NOT exists_qa_specs(spec_id) THEN
256: RETURN NULL;
257: END IF;
258: RETURN g_qa_specs_array(spec_id).spec_element_value;
259:
260: END spec_element_value;
261:
262:

Line 301: FROM qa_spec_chars qsc, qa_specs qs

297: PROCEDURE check_for_spec_element(p_spec_id IN NUMBER) IS
298:
299: CURSOR c IS
300: SELECT 1
301: FROM qa_spec_chars qsc, qa_specs qs
302: WHERE qs.spec_id = p_spec_id
303: AND qs.common_spec_id = qsc.spec_id;
304:
305: l_dummy NUMBER;

Line 440: FROM qa_specs

436: l_spec_name varchar2(30);
437:
438: CURSOR c IS
439: SELECT spec_name
440: FROM qa_specs
441: WHERE category_set_id = p_category_set_id
442: AND category_id = p_category_id
443: AND item_id = p_item_id
444: AND item_revision = nvl(p_item_revision, 'NONE')

Line 551: FROM qa_specs

547: l_org_id NUMBER;
548:
549: CURSOR c IS
550: SELECT spec_id
551: FROM qa_specs
552: WHERE spec_name = p_spec_name AND organization_id = l_org_id;
553:
554: BEGIN
555:

Line 580: FROM qa_specs

576: RETURN BOOLEAN IS
577:
578: CURSOR c IS
579: SELECT 1
580: FROM qa_specs
581: WHERE spec_name = p_name;
582:
583: result BOOLEAN;
584: dummy NUMBER;

Line 654: FROM qa_specs

650: FUNCTION is_child_spec(p_spec_id IN NUMBER) RETURN BOOLEAN IS
651:
652: CURSOR c IS
653: SELECT 1
654: FROM qa_specs
655: WHERE spec_id = p_spec_id
656: AND spec_id <> common_spec_id;
657:
658: result BOOLEAN;

Line 676: FROM qa_specs

672: FUNCTION is_child_spec(p_spec_name IN VARCHAR2) RETURN BOOLEAN IS
673:
674: CURSOR c IS
675: SELECT 1
676: FROM qa_specs
677: WHERE spec_name = p_spec_name
678: AND spec_id <> common_spec_id;
679:
680: result BOOLEAN;

Line 698: FROM qa_specs

694: FUNCTION child_spec_exists(p_spec_id IN NUMBER) RETURN BOOLEAN IS
695:
696: CURSOR c IS
697: SELECT 1
698: FROM qa_specs
699: WHERE common_spec_id = p_spec_id
700: AND spec_id <> common_spec_id;
701:
702: result BOOLEAN;

Line 720: FROM qa_specs qs1, qa_specs qs2

716: FUNCTION child_spec_exists(p_spec_name IN VARCHAR2) RETURN BOOLEAN IS
717:
718: CURSOR c IS
719: SELECT 1
720: FROM qa_specs qs1, qa_specs qs2
721: WHERE qs1.spec_name = p_spec_name
722: AND qs1.spec_id = qs2.common_spec_id
723: AND qs2.spec_id <> qs2.common_spec_id;
724:

Line 761: p_assignment_type IN NUMBER := qa_specs_pub.g_spec_type_item,

757: p_organization_code IN VARCHAR2,
758: p_reference_spec IN VARCHAR2 := NULL,
759: p_effective_from IN DATE := SYSDATE,
760: p_effective_to IN DATE := NULL,
761: p_assignment_type IN NUMBER := qa_specs_pub.g_spec_type_item,
762: p_category_set_name IN VARCHAR2 := NULL,
763: p_category_name IN VARCHAR2 := NULL,
764: p_item_name IN VARCHAR2 := NULL,
765: p_item_revision IN VARCHAR2 := NULL,

Line 776: -- fields too into the qa_specs table

772: x_msg_data OUT NOCOPY VARCHAR2,
773: x_return_status OUT NOCOPY VARCHAR2,
774: -- Bug 7430441.FP for Bug 6877858.
775: -- Added the attribute parameters in order to populate the DFF
776: -- fields too into the qa_specs table
777: -- pdube Wed Sep 24 03:17:03 PDT 2008
778: p_attribute_category IN VARCHAR2 := NULL,
779: p_attribute1 IN VARCHAR2 := NULL,
780: p_attribute2 IN VARCHAR2 := NULL,

Line 808: l_sub_type_value qa_specs.spec_element_value%TYPE;

804: l_item_id NUMBER := -1;
805: l_vendor_id NUMBER := -1;
806: l_customer_id NUMBER := -1;
807: l_char_id NUMBER := -1;
808: l_sub_type_value qa_specs.spec_element_value%TYPE;
809: l_existing_spec_name VARCHAR2(30);
810: l_datatype NUMBER;
811:
812: l_reference_spec_id NUMBER;

Line 824: FROM qa_specs

820:
821:
822: CURSOR c IS
823: SELECT spec_id
824: FROM qa_specs
825: WHERE spec_name = p_reference_spec;
826:
827: BEGIN
828:

Line 996: SELECT qa_specs_s.nextval INTO x_spec_id FROM DUAL;

992: fnd_msg_pub.add();
993: RAISE fnd_api.g_exc_error;
994: END IF;
995:
996: SELECT qa_specs_s.nextval INTO x_spec_id FROM DUAL;
997:
998: IF p_reference_spec IS NOT NULL THEN
999: OPEN c;
1000: FETCH c INTO l_reference_spec_id;

Line 1006: INSERT INTO qa_specs(

1002: ELSE
1003: l_reference_spec_id := x_spec_id;
1004: END IF;
1005:
1006: INSERT INTO qa_specs(
1007: spec_id,
1008: last_update_date,
1009: last_updated_by,
1010: creation_date,

Line 1451: FROM qa_specs

1447: FROM qa_spec_chars
1448: WHERE spec_id = p_spec_id;
1449:
1450: DELETE
1451: FROM qa_specs
1452: WHERE spec_id = p_spec_id;
1453:
1454: END delete_spec_private;
1455:

Line 1783: SELECT qa_specs_s.nextval INTO x_spec_id FROM DUAL;

1779: fnd_msg_pub.add();
1780: RAISE fnd_api.g_exc_error;
1781: END IF;
1782:
1783: SELECT qa_specs_s.nextval INTO x_spec_id FROM DUAL;
1784:
1785: INSERT INTO qa_specs(
1786: spec_id,
1787: last_update_date,

Line 1785: INSERT INTO qa_specs(

1781: END IF;
1782:
1783: SELECT qa_specs_s.nextval INTO x_spec_id FROM DUAL;
1784:
1785: INSERT INTO qa_specs(
1786: spec_id,
1787: last_update_date,
1788: last_updated_by,
1789: creation_date,

Line 1831: FROM qa_specs

1827: hide_plan_chars_flag,
1828: char_id,
1829: spec_element_value,
1830: 40 --Bug 3500244 see note below
1831: FROM qa_specs
1832: WHERE spec_id = l_spec_id;
1833:
1834: --Bug 3500244
1835: --In above Select we have not used the variable l_spec_status

Line 1881: qa_specs_pkg.copy_attachment(

1877:
1878: --
1879: -- Bug 5231952. After copying, we should copy attachments.
1880: --
1881: qa_specs_pkg.copy_attachment(
1882: p_from_spec_id => l_spec_id,
1883: p_to_spec_id => x_spec_id);
1884:
1885: IF fnd_api.to_boolean(p_commit) THEN

Line 1921: END qa_specs_pub;

1917:
1918: END copy_specification;
1919:
1920:
1921: END qa_specs_pub;
1922: