APPS.GMD_CUSTOMER_TESTS_PVT dependencies on GMD_CUSTOMER_TESTS_B

Line 17: cursor C is select ROWID from GMD_CUSTOMER_TESTS_B

13: X_LAST_UPDATE_DATE in DATE,
14: X_LAST_UPDATED_BY in NUMBER,
15: X_LAST_UPDATE_LOGIN in NUMBER
16: ) is
17: cursor C is select ROWID from GMD_CUSTOMER_TESTS_B
18: where TEST_ID = X_TEST_ID
19: and CUST_ID = X_CUST_ID
20: ;
21: begin

Line 23: insert into GMD_CUSTOMER_TESTS_B (

19: and CUST_ID = X_CUST_ID
20: ;
21: begin
22:
23: insert into GMD_CUSTOMER_TESTS_B (
24: TEST_ID,
25: CUST_ID,
26: REPORT_PRECISION,
27: TEXT_CODE,

Line 124: from GMD_CUSTOMER_TESTS_B

120: ) is
121: cursor c is select
122: REPORT_PRECISION,
123: TEXT_CODE
124: from GMD_CUSTOMER_TESTS_B
125: where TEST_ID = X_TEST_ID
126: and CUST_ID = X_CUST_ID
127: for update of TEST_ID nowait;
128: recinfo c%rowtype;

Line 183: update GMD_CUSTOMER_TESTS_B set

179: X_LAST_UPDATED_BY in NUMBER,
180: X_LAST_UPDATE_LOGIN in NUMBER
181: ) is
182: begin
183: update GMD_CUSTOMER_TESTS_B set
184: REPORT_PRECISION = X_REPORT_PRECISION,
185: TEXT_CODE = X_TEXT_CODE,
186: LAST_UPDATE_DATE = NVL(X_LAST_UPDATE_DATE,SYSDATE),
187: LAST_UPDATED_BY = NVL(X_LAST_UPDATED_BY,FND_GLOBAL.USER_ID),

Line 224: delete from GMD_CUSTOMER_TESTS_B

220: if (sql%notfound) then
221: raise no_data_found;
222: end if;
223:
224: delete from GMD_CUSTOMER_TESTS_B
225: where TEST_ID = P_TEST_ID
226: and CUST_ID = P_CUST_ID;
227:
228: if (sql%notfound) then

Line 254: from GMD_CUSTOMER_TESTS_B B

250: begin
251: delete from GMD_CUSTOMER_TESTS_TL T
252: where not exists
253: (select NULL
254: from GMD_CUSTOMER_TESTS_B B
255: where B.TEST_ID = T.TEST_ID
256: and B.CUST_ID = T.CUST_ID
257: );
258:

Line 326: FROM gmd_customer_tests_b

322:
323: IF P_TEST_ID IS NOT NULL AND P_CUST_ID IS NOT NULL THEN
324: SELECT test_id
325: INTO dummy
326: FROM gmd_customer_tests_b
327: WHERE test_id = p_test_id
328: AND cust_id = p_cust_id
329: FOR UPDATE OF test_id NOWAIT ;
330: ELSE