APPS.GMP_PROCESS_PARAMETERS_PKG dependencies on GMP_PROCESS_PARAMETERS_B

Line 51: cursor C is select ROWID from GMP_PROCESS_PARAMETERS_B

47: X_LAST_UPDATE_DATE in DATE,
48: X_LAST_UPDATED_BY in NUMBER,
49: X_LAST_UPDATE_LOGIN in NUMBER
50: ) is
51: cursor C is select ROWID from GMP_PROCESS_PARAMETERS_B
52: where PARAMETER_ID = X_PARAMETER_ID
53: ;
54: begin
55: insert into GMP_PROCESS_PARAMETERS_B (

Line 55: insert into GMP_PROCESS_PARAMETERS_B (

51: cursor C is select ROWID from GMP_PROCESS_PARAMETERS_B
52: where PARAMETER_ID = X_PARAMETER_ID
53: ;
54: begin
55: insert into GMP_PROCESS_PARAMETERS_B (
56: ATTRIBUTE21,
57: ATTRIBUTE22,
58: ATTRIBUTE23,
59: ATTRIBUTE24,

Line 266: from GMP_PROCESS_PARAMETERS_B

262: PARAMETER_TYPE,
263: MINIMUM_VALUE,
264: PARAMETER_NAME,
265: UNITS
266: from GMP_PROCESS_PARAMETERS_B
267: where PARAMETER_ID = X_PARAMETER_ID
268: for update of PARAMETER_ID nowait;
269: recinfo c%rowtype;
270:

Line 428: update GMP_PROCESS_PARAMETERS_B set

424: X_LAST_UPDATED_BY in NUMBER,
425: X_LAST_UPDATE_LOGIN in NUMBER
426: ) is
427: begin
428: update GMP_PROCESS_PARAMETERS_B set
429: ATTRIBUTE21 = X_ATTRIBUTE21,
430: ATTRIBUTE22 = X_ATTRIBUTE22,
431: ATTRIBUTE23 = X_ATTRIBUTE23,
432: ATTRIBUTE24 = X_ATTRIBUTE24,

Line 501: delete from GMP_PROCESS_PARAMETERS_B

497: if (sql%notfound) then
498: raise no_data_found;
499: end if;
500:
501: delete from GMP_PROCESS_PARAMETERS_B
502: where PARAMETER_ID = X_PARAMETER_ID;
503:
504: if (sql%notfound) then
505: raise no_data_found;

Line 515: from GMP_PROCESS_PARAMETERS_B B

511: begin
512: delete from GMP_PROCESS_PARAMETERS_TL T
513: where not exists
514: (select NULL
515: from GMP_PROCESS_PARAMETERS_B B
516: where B.PARAMETER_ID = T.PARAMETER_ID
517: );
518:
519: update GMP_PROCESS_PARAMETERS_TL T set (