APPS.GL_DAILY_CONV_TYPES_PKG dependencies on GL_DAILY_CONVERSION_TYPES

Line 21: PROCEDURE select_row( recinfo IN OUT NOCOPY gl_daily_conversion_types%ROWTYPE) IS

17: -- Example
18: -- gl_daily_conv_types_pkg.select_row(recinfo)
19: -- Notes
20: --
21: PROCEDURE select_row( recinfo IN OUT NOCOPY gl_daily_conversion_types%ROWTYPE) IS
22: BEGIN
23: SELECT *
24: INTO recinfo
25: FROM gl_daily_conversion_types

Line 25: FROM gl_daily_conversion_types

21: PROCEDURE select_row( recinfo IN OUT NOCOPY gl_daily_conversion_types%ROWTYPE) IS
22: BEGIN
23: SELECT *
24: INTO recinfo
25: FROM gl_daily_conversion_types
26: WHERE conversion_type = recinfo.conversion_type;
27: END SELECT_ROW;
28:
29: --

Line 37: recinfo gl_daily_conversion_types%ROWTYPE;

33: PROCEDURE select_columns(
34: x_conversion_type VARCHAR2,
35: x_user_conversion_type IN OUT NOCOPY VARCHAR2) IS
36:
37: recinfo gl_daily_conversion_types%ROWTYPE;
38:
39: BEGIN
40: recinfo.conversion_type := x_conversion_type;
41:

Line 52: FROM GL_DAILY_CONVERSION_TYPES dct

48: x_rowid VARCHAR2) IS
49:
50: CURSOR check_dups is
51: SELECT 1
52: FROM GL_DAILY_CONVERSION_TYPES dct
53: WHERE dct.user_conversion_type =
54: check_unique_user_type.user_conversion_type
55: AND ( x_rowid is NULL
56: OR dct.rowid <> x_rowid );

Line 84: FROM GL_DAILY_CONVERSION_TYPES dct

80: x_rowid VARCHAR2) IS
81:
82: CURSOR chk_dups is
83: SELECT 1
84: FROM GL_DAILY_CONVERSION_TYPES dct
85: WHERE dct.conversion_type =
86: check_unique_type.conversion_type
87: AND ( x_rowid is NULL
88: OR dct.rowid <> x_rowid );

Line 99: fnd_message.set_token('TAB_S', 'GL_DAILY_CONVERSION_TYPES_S');

95:
96: IF chk_dups%FOUND THEN
97: CLOSE chk_dups;
98: fnd_message.set_name('SQLGL', 'GL_DUP_UNIQUE_ID');
99: fnd_message.set_token('TAB_S', 'GL_DAILY_CONVERSION_TYPES_S');
100: app_exception.raise_exception;
101: END IF;
102:
103: CLOSE chk_dups;

Line 115: select GL_DAILY_CONVERSION_TYPES_S.NEXTVAL

111:
112: PROCEDURE Get_New_Id(next_val IN OUT NOCOPY VARCHAR2) IS
113:
114: BEGIN
115: select GL_DAILY_CONVERSION_TYPES_S.NEXTVAL
116: into next_val
117: from dual;
118:
119: IF (next_val is NULL) THEN

Line 121: fnd_message.set_token('TAB_S', 'GL_DAILY_CONVERSION_TYPES_S');

117: from dual;
118:
119: IF (next_val is NULL) THEN
120: fnd_message.set_name('SQLGL', 'GL_SEQUENCE_NOT_FOUND');
121: fnd_message.set_token('TAB_S', 'GL_DAILY_CONVERSION_TYPES_S');
122: app_exception.raise_exception;
123: END IF;
124: EXCEPTION
125: WHEN app_exception.application_exception THEN RAISE;

Line 160: FROM GL_DAILY_CONVERSION_TYPES

156: X_Attribute15 VARCHAR2,
157: X_Context VARCHAR2,
158: X_Security_Flag VARCHAR2) IS
159: CURSOR C IS SELECT rowid
160: FROM GL_DAILY_CONVERSION_TYPES
161: WHERE conversion_type = X_Conversion_Type
162: AND user_conversion_type = X_User_Conversion_Type;
163:
164: BEGIN

Line 166: INSERT INTO GL_DAILY_CONVERSION_TYPES(

162: AND user_conversion_type = X_User_Conversion_Type;
163:
164: BEGIN
165:
166: INSERT INTO GL_DAILY_CONVERSION_TYPES(
167: conversion_type,
168: user_conversion_type,
169: last_update_date,
170: last_updated_by,

Line 282: FROM GL_DAILY_CONVERSION_TYPES

278: attribute14,
279: attribute15,
280: context,
281: security_flag
282: FROM GL_DAILY_CONVERSION_TYPES
283: WHERE ROWID = X_Rowid
284: FOR UPDATE OF conversion_type NOWAIT;
285: recinfo C%ROWTYPE;
286:

Line 403: UPDATE gl_daily_conversion_types

399: X_Attribute15 VARCHAR2,
400: X_Context VARCHAR2,
401: X_Security_Flag VARCHAR2) IS
402: BEGIN
403: UPDATE gl_daily_conversion_types
404: SET
405: user_conversion_type = X_User_Conversion_Type,
406: last_update_date = X_Last_Update_Date,
407: last_updated_by = X_Last_Updated_By,

Line 498: from gl_daily_conversion_types

494: the creation date for update_row. */
495: -- Added security_flag for DAS project
496: select creation_date, security_flag
497: into x_creation_date, x_security_flag
498: from gl_daily_conversion_types
499: where conversion_type = V_Conversion_Type;
500:
501: /* Update only if Force_Edits is 'Y' or user_id = 1 */
502: IF ( Force_Edits = 'Y' OR user_id = 1 ) THEN

Line 585: UPDATE GL_DAILY_CONVERSION_TYPES

581: END IF;
582:
583: /* Update only if Force_Edits is 'Y' or user_id = 1 */
584: IF ( Force_Edits = 'Y' OR user_id = 1 ) THEN
585: UPDATE GL_DAILY_CONVERSION_TYPES
586: SET
587: user_conversion_type = V_User_Conversion_Type,
588: description = V_Description,
589: last_update_date = sysdate,