DBA Data[Home] [Help]

APPS.AMW_PARAMETERS_PVT_PKG dependencies on AMW_PARAMETERS

Line 1: PACKAGE BODY AMW_PARAMETERS_PVT_PKG AS

1: PACKAGE BODY AMW_PARAMETERS_PVT_PKG AS
2: /* $Header: amwparpb.pls 120.1 2005/10/25 23:25:14 appldev noship $ */
3: -- HISTORY
4: -- 11/19/2004 kosriniv Creates
5: ---------------------------------------------------------------------

Line 7: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMW_PARAMETERS_PVT_PKG';

3: -- HISTORY
4: -- 11/19/2004 kosriniv Creates
5: ---------------------------------------------------------------------
6:
7: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMW_PARAMETERS_PVT_PKG';
8: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amwparpb.pls';
9: G_USER_ID NUMBER := FND_GLOBAL.USER_ID;
10: G_LOGIN_ID NUMBER := FND_GLOBAL.CONC_LOGIN_ID;
11:

Line 25: from amw_parameters

21: l_dummy number;
22: begin
23:
24: select 1 into l_dummy
25: from amw_parameters
26: where parameter_name = p_parameter_name
27: and pk1 = p_pk1
28: and NVL(pk2,-99) = NVL(p_pk2,-99)
29: and NVL(pk3,-99) = NVL(p_pk3,-99)

Line 36: AMW_PARAMETERS(

32:
33: EXCEPTION
34: when no_data_found then
35: INSERT INTO
36: AMW_PARAMETERS(
37: OBJECT_VERSION_NUMBER,
38: PARAMETER_NAME,
39: PARAMETER_VALUE,
40: PK1,PK2,PK3,PK4,PK5,CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,

Line 65: from amw_parameters

61: -- Retrieve the parameter..row...
62:
63: select parameter_value
64: into l_param_value
65: from amw_parameters
66: where parameter_name = p_parameter_name
67: and pk1 = p_pk1
68: and NVL(pk2,-99) = NVL(p_pk2,-99)
69: and NVL(pk3,-99) = NVL(p_pk3,-99)

Line 74: update amw_parameters

70: and NVL(pk4,-99) = NVL(p_pk4,-99)
71: and NVL(pk5,-99) = NVL(p_pk5,-99) ;
72: -- Make sure that the parameter value changed..
73: IF l_param_value <> p_parameter_value THEN
74: update amw_parameters
75: set parameter_value = p_parameter_value,
76: last_updated_by = g_user_id,
77: last_update_date = sysdate,
78: last_update_login = G_LOGIN_ID,

Line 295: select 1 into l_dummy from amw_parameters where PARAMETER_NAME = p_PARAMETER_NAME and PK1 = p_PK1;

291: l_OWNER number;
292: l_last_update_date date;
293: l_dummy number;
294: begin
295: select 1 into l_dummy from amw_parameters where PARAMETER_NAME = p_PARAMETER_NAME and PK1 = p_PK1;
296: exception
297: when no_data_found then
298: l_OWNER := fnd_load_util.owner_id(X_OWNER);
299: l_last_update_date := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);

Line 300: insert into amw_parameters(OBJECT_VERSION_NUMBER,

296: exception
297: when no_data_found then
298: l_OWNER := fnd_load_util.owner_id(X_OWNER);
299: l_last_update_date := nvl(to_date(X_LAST_UPDATE_DATE, 'YYYY/MM/DD'), sysdate);
300: insert into amw_parameters(OBJECT_VERSION_NUMBER,
301: PARAMETER_NAME,
302: PARAMETER_VALUE,
303: PK1,
304: pk2,

Line 342: l_proc_approval_option AMW_PARAMETERS.PARAMETER_VALUE%TYPE;

338: x_msg_count OUT NOCOPY VARCHAR2,
339: x_msg_data OUT NOCOPY VARCHAR2
340: ) IS
341: L_API_NAME CONSTANT VARCHAR2(30) := 'default_org_parameters';
342: l_proc_approval_option AMW_PARAMETERS.PARAMETER_VALUE%TYPE;
343: l_proc_auto_approve AMW_PARAMETERS.PARAMETER_VALUE%TYPE;
344: BEGIN
345:
346:

Line 343: l_proc_auto_approve AMW_PARAMETERS.PARAMETER_VALUE%TYPE;

339: x_msg_data OUT NOCOPY VARCHAR2
340: ) IS
341: L_API_NAME CONSTANT VARCHAR2(30) := 'default_org_parameters';
342: l_proc_approval_option AMW_PARAMETERS.PARAMETER_VALUE%TYPE;
343: l_proc_auto_approve AMW_PARAMETERS.PARAMETER_VALUE%TYPE;
344: BEGIN
345:
346:
347: -- Standard Initialization..

Line 365: from amw_parameters

361: -- Select the Values from Risk Library...
362:
363: select parameter_value
364: into l_proc_approval_option
365: from amw_parameters
366: where parameter_name = 'PROCESS_APPROVAL_OPTION'
367: and pk1 = -1;
368:
369: select parameter_value

Line 371: from amw_parameters

367: and pk1 = -1;
368:
369: select parameter_value
370: into l_proc_auto_approve
371: from amw_parameters
372: where parameter_name = 'PROCESS_AUTO_APPROVE'
373: and pk1 = -1;
374:
375: -- Initialize the Parameters...

Line 416: l_proc_approval_option AMW_PARAMETERS.PARAMETER_VALUE%TYPE;

412: p_all_orgs in varchar2 -- NOCONF means only orgs that have not been configured..ALL means set/update all the orgs..
413: ) is
414:
415: L_API_NAME CONSTANT VARCHAR2(30) := 'update_all_org_params_cp';
416: l_proc_approval_option AMW_PARAMETERS.PARAMETER_VALUE%TYPE;
417: l_proc_auto_approve AMW_PARAMETERS.PARAMETER_VALUE%TYPE;
418: conc_status boolean;
419:
420: cursor orgs_to_configure is

Line 417: l_proc_auto_approve AMW_PARAMETERS.PARAMETER_VALUE%TYPE;

413: ) is
414:
415: L_API_NAME CONSTANT VARCHAR2(30) := 'update_all_org_params_cp';
416: l_proc_approval_option AMW_PARAMETERS.PARAMETER_VALUE%TYPE;
417: l_proc_auto_approve AMW_PARAMETERS.PARAMETER_VALUE%TYPE;
418: conc_status boolean;
419:
420: cursor orgs_to_configure is
421: select organization_id

Line 447: from amw_parameters

443: fnd_file.put_line (fnd_file.LOG, 'No Process Approval Option provided. Defaulting from Risk Library');
444: -- Select the Values from Risk Library...
445: select parameter_value
446: into l_proc_approval_option
447: from amw_parameters
448: where parameter_name = 'PROCESS_APPROVAL_OPTION'
449: and pk1 = -1;
450: else
451: l_proc_approval_option := p_proc_approval_option;

Line 458: from amw_parameters

454: if p_approval_required is null then
455: fnd_file.put_line (fnd_file.LOG, 'No Process Approval Required Parameter provided. Defaulting from Risk Library');
456: select parameter_value
457: into l_proc_auto_approve
458: from amw_parameters
459: where parameter_name = 'PROCESS_AUTO_APPROVE'
460: and pk1 = -1;
461: else
462: if p_approval_required = 'N' then

Line 567: END AMW_PARAMETERS_PVT_PKG;

563: errbuf :=SUBSTR(SQLERRM,1,1000);
564: conc_status := FND_CONCURRENT.SET_COMPLETION_STATUS('ERROR','Error: '|| SQLERRM);
565: end update_all_org_params_cp;
566:
567: END AMW_PARAMETERS_PVT_PKG;