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.PQP_VEH_ALLOC_INFO_TYPES_PKG dependencies on PQP_VEH_ALLOC_INFO_TYPES

Line 1: PACKAGE BODY pqp_veh_alloc_info_types_pkg as

1: PACKAGE BODY pqp_veh_alloc_info_types_pkg as
2: /* $Header: pqpvehalloceit.pkb 120.0 2005/05/29 02:23:27 appldev noship $ */
3: ------------------------------------------------------------------------------
4: /*
5: ==============================================================================

Line 26: from pqp_veh_alloc_info_types t

22: IS
23: L_DUMMY1 number;
24: CURSOR C1 IS
25: select 1
26: from pqp_veh_alloc_info_types t
27: where upper(t.description) = upper(P_DESCRIPTION)
28: and nvl(t.legislation_code, nvl(P_LEGISLATION_CODE, 'XXX') )
29: = nvl(P_LEGISLATION_CODE, 'XXX')
30: and (P_ROWID is null

Line 58: cursor C is select ROWID from pqp_veh_alloc_info_types

54: X_LAST_UPDATE_DATE in DATE,
55: X_LAST_UPDATED_BY in NUMBER,
56: X_LAST_UPDATE_LOGIN in NUMBER
57: ) is
58: cursor C is select ROWID from pqp_veh_alloc_info_types
59: where INFORMATION_TYPE = X_INFORMATION_TYPE
60: ;
61: begin
62: insert into pqp_veh_alloc_info_types (

Line 62: insert into pqp_veh_alloc_info_types (

58: cursor C is select ROWID from pqp_veh_alloc_info_types
59: where INFORMATION_TYPE = X_INFORMATION_TYPE
60: ;
61: begin
62: insert into pqp_veh_alloc_info_types (
63: INFORMATION_TYPE,
64: ACTIVE_INACTIVE_FLAG,
65: MULTIPLE_OCCURENCES_FLAG,
66: LEGISLATION_CODE,

Line 111: from pqp_veh_alloc_info_types

107: ACTIVE_INACTIVE_FLAG,
108: MULTIPLE_OCCURENCES_FLAG,
109: LEGISLATION_CODE,
110: OBJECT_VERSION_NUMBER
111: from pqp_veh_alloc_info_types
112: where INFORMATION_TYPE = X_INFORMATION_TYPE
113: for update of INFORMATION_TYPE nowait;
114: recinfo c%rowtype;
115:

Line 153: update pqp_veh_alloc_info_types set

149: X_LAST_UPDATED_BY in NUMBER,
150: X_LAST_UPDATE_LOGIN in NUMBER
151: ) is
152: begin
153: update pqp_veh_alloc_info_types set
154: ACTIVE_INACTIVE_FLAG = X_ACTIVE_INACTIVE_FLAG,
155: MULTIPLE_OCCURENCES_FLAG = X_MULTIPLE_OCCURENCES_FLAG,
156: LEGISLATION_CODE = X_LEGISLATION_CODE,
157: OBJECT_VERSION_NUMBER = X_OBJECT_VERSION_NUMBER,

Line 175: delete from pqp_veh_alloc_info_types

171: X_INFORMATION_TYPE in VARCHAR2
172: ) is
173: begin
174:
175: delete from pqp_veh_alloc_info_types
176: where INFORMATION_TYPE = X_INFORMATION_TYPE;
177:
178: if (sql%notfound) then
179: raise no_data_found;

Line 194: l_proc VARCHAR2(61) := 'pqp_veh_alloc_info_types_PKG.LOAD_ROW';

190: ,X_OWNER in varchar2
191: ,X_LAST_UPDATE_DATE in date
192: )
193: is
194: l_proc VARCHAR2(61) := 'pqp_veh_alloc_info_types_PKG.LOAD_ROW';
195: l_rowid rowid;
196: l_created_by pqp_veh_alloc_info_types.created_by%TYPE := 0;
197: l_creation_date pqp_veh_alloc_info_types.creation_date%TYPE := SYSDATE;
198: l_last_update_date pqp_veh_alloc_info_types.last_update_date%TYPE := SYSDATE;

Line 196: l_created_by pqp_veh_alloc_info_types.created_by%TYPE := 0;

192: )
193: is
194: l_proc VARCHAR2(61) := 'pqp_veh_alloc_info_types_PKG.LOAD_ROW';
195: l_rowid rowid;
196: l_created_by pqp_veh_alloc_info_types.created_by%TYPE := 0;
197: l_creation_date pqp_veh_alloc_info_types.creation_date%TYPE := SYSDATE;
198: l_last_update_date pqp_veh_alloc_info_types.last_update_date%TYPE := SYSDATE;
199: l_last_updated_by pqp_veh_alloc_info_types.last_updated_by%TYPE := 0;
200: l_last_update_login pqp_veh_alloc_info_types.last_update_login%TYPE := 0;

Line 197: l_creation_date pqp_veh_alloc_info_types.creation_date%TYPE := SYSDATE;

193: is
194: l_proc VARCHAR2(61) := 'pqp_veh_alloc_info_types_PKG.LOAD_ROW';
195: l_rowid rowid;
196: l_created_by pqp_veh_alloc_info_types.created_by%TYPE := 0;
197: l_creation_date pqp_veh_alloc_info_types.creation_date%TYPE := SYSDATE;
198: l_last_update_date pqp_veh_alloc_info_types.last_update_date%TYPE := SYSDATE;
199: l_last_updated_by pqp_veh_alloc_info_types.last_updated_by%TYPE := 0;
200: l_last_update_login pqp_veh_alloc_info_types.last_update_login%TYPE := 0;
201: begin

Line 198: l_last_update_date pqp_veh_alloc_info_types.last_update_date%TYPE := SYSDATE;

194: l_proc VARCHAR2(61) := 'pqp_veh_alloc_info_types_PKG.LOAD_ROW';
195: l_rowid rowid;
196: l_created_by pqp_veh_alloc_info_types.created_by%TYPE := 0;
197: l_creation_date pqp_veh_alloc_info_types.creation_date%TYPE := SYSDATE;
198: l_last_update_date pqp_veh_alloc_info_types.last_update_date%TYPE := SYSDATE;
199: l_last_updated_by pqp_veh_alloc_info_types.last_updated_by%TYPE := 0;
200: l_last_update_login pqp_veh_alloc_info_types.last_update_login%TYPE := 0;
201: begin
202: -- Translate developer keys to internal parameters

Line 199: l_last_updated_by pqp_veh_alloc_info_types.last_updated_by%TYPE := 0;

195: l_rowid rowid;
196: l_created_by pqp_veh_alloc_info_types.created_by%TYPE := 0;
197: l_creation_date pqp_veh_alloc_info_types.creation_date%TYPE := SYSDATE;
198: l_last_update_date pqp_veh_alloc_info_types.last_update_date%TYPE := SYSDATE;
199: l_last_updated_by pqp_veh_alloc_info_types.last_updated_by%TYPE := 0;
200: l_last_update_login pqp_veh_alloc_info_types.last_update_login%TYPE := 0;
201: begin
202: -- Translate developer keys to internal parameters
203: if X_OWNER = 'ORACLE' then

Line 200: l_last_update_login pqp_veh_alloc_info_types.last_update_login%TYPE := 0;

196: l_created_by pqp_veh_alloc_info_types.created_by%TYPE := 0;
197: l_creation_date pqp_veh_alloc_info_types.creation_date%TYPE := SYSDATE;
198: l_last_update_date pqp_veh_alloc_info_types.last_update_date%TYPE := SYSDATE;
199: l_last_updated_by pqp_veh_alloc_info_types.last_updated_by%TYPE := 0;
200: l_last_update_login pqp_veh_alloc_info_types.last_update_login%TYPE := 0;
201: begin
202: -- Translate developer keys to internal parameters
203: if X_OWNER = 'ORACLE' then
204: l_created_by := 2;

Line 247: UPDATE pqp_veh_alloc_info_types

243: ,X_OWNER in varchar2
244: )
245: is
246: begin
247: UPDATE pqp_veh_alloc_info_types
248: SET description = X_DESCRIPTION
249: ,last_update_date = SYSDATE
250: ,last_updated_by = DECODE(X_OWNER,'ORACLE',2,1)
251: ,last_update_login = 0

Line 258: END pqp_veh_alloc_info_types_pkg;

254: AND information_type = X_INFORMATION_TYPE;
255: end TRANSLATE_ROW;
256:
257:
258: END pqp_veh_alloc_info_types_pkg;