DBA Data[Home] [Help]

APPS.PJI_SETUP_PKG dependencies on PJI_SYSTEM_SETTINGS

Line 6: -- Description : This procedure validates and updates PJI_SYSTEM_SETTINGS Table.

2: /* $Header: PJIUT04B.pls 120.2 2005/12/06 18:04:23 appldev noship $ */
3:
4: ----------------------------------------------------------------------------------------------------------------
5: -- API : pji_sys_settings_update_row
6: -- Description : This procedure validates and updates PJI_SYSTEM_SETTINGS Table.
7: ----------------------------------------------------------------------------------------------------------------
8: PROCEDURE pji_sys_settings_update_row (p_organization_structure IN VARCHAR2,
9: p_org_structure_version IN VARCHAR2,
10: p_dflt_prjpip_period_type IN VARCHAR2,

Line 389: UPDATE pji_system_settings

385: --
386: -- Apply the changes.
387: --
388:
389: UPDATE pji_system_settings
390: SET last_update_date = l_last_update_date,
391: last_updated_by = l_last_updated_by,
392: last_update_login = l_last_update_login,
393: organization_structure_id = l_organization_structure_id,

Line 1017: FROM pji_system_settings ;

1013: x_error_message_code OUT NOCOPY VARCHAR2) IS
1014:
1015: CURSOR Cur_PjiSysSettings IS
1016: SELECT *
1017: FROM pji_system_settings ;
1018:
1019: Cur_PjiRowtype Cur_PjiSysSettings%ROWTYPE ;
1020:
1021: TYPE EventAttribute IS RECORD (