APPS.AK_AMPARAM_REGISTRY_PVT dependencies on AK_AM_PARAMETER_REGISTRY

Line 38: from AK_AM_PARAMETER_REGISTRY

34: p_nls_language IN VARCHAR2
35: ) is
36: cursor l_get_ap_registry_csr (param_query_code in varchar2) is
37: select *
38: from AK_AM_PARAMETER_REGISTRY
39: where APPLICATIONMODULE_DEFN_NAME = param_query_code
40: order by APPLICATIONMODULE_DEFN_NAME;
41:
42: l_api_name CONSTANT varchar2(30) := 'Write_to_buffer';

Line 45: l_ap_registry_rec ak_am_parameter_registry%ROWTYPE;

41:
42: l_api_name CONSTANT varchar2(30) := 'Write_to_buffer';
43: l_databuffer_tbl AK_ON_OBJECTS_PUB.Buffer_Tbl_Type;
44: l_index NUMBER;
45: l_ap_registry_rec ak_am_parameter_registry%ROWTYPE;
46: l_return_status varchar2(1);
47:
48: begin
49: -- Retrieve object information from the database

Line 199: from ak_am_parameter_registry

195: p_nls_language IN VARCHAR2
196: ) is
197: cursor l_get_ap_registry_list_csr (appl_id_parm in number) is
198: select APPLICATIONMODULE_DEFN_NAME
199: from ak_am_parameter_registry
200: where APPLICATION_ID = appl_id_parm;
201: l_api_version_number CONSTANT number := 1.0;
202: l_api_name CONSTANT varchar2(30) := 'Download_AP_Registry';
203: l_application_id NUMBER;

Line 375: from ak_am_parameter_registry

371: ) RETURN BOOLEAN IS
372: CURSOR l_chk_amparam_exists_csr (appmodule_defn_name_param in varchar2,
373: param_name_param in varchar2, param_value_param in varchar2) is
374: select 1
375: from ak_am_parameter_registry
376: where APPLICATIONMODULE_DEFN_NAME = appmodule_defn_name_param
377: and PARAM_NAME = param_name_param
378: and param_source = param_value_param;
379: l_dummy number;

Line 505: insert into AK_AM_PARAMETER_REGISTRY (

501: p_last_update_date => l_last_update_date,
502: p_last_update_login => l_last_update_login);
503: */
504:
505: insert into AK_AM_PARAMETER_REGISTRY (
506: APPLICATIONMODULE_DEFN_NAME,
507: PARAM_NAME,
508: PARAM_SOURCE,
509: APPLICATION_ID

Line 602: from AK_AM_PARAMETER_REGISTRY

598: p_pass IN NUMBER := 2
599: ) IS
600: cursor l_get_amparam_registry_csr is
601: select *
602: from AK_AM_PARAMETER_REGISTRY
603: where APPLICATIONMODULE_DEFN_NAME = p_applicationmodule_defn_name
604: for update of APPLICATION_ID;
605:
606: l_api_version_number CONSTANT number := 1.0;

Line 608: l_amparam_reg_rec AK_AM_PARAMETER_REGISTRY%ROWTYPE;

604: for update of APPLICATION_ID;
605:
606: l_api_version_number CONSTANT number := 1.0;
607: l_api_name CONSTANT varchar2(30) := 'Update_AmPara_Registry';
608: l_amparam_reg_rec AK_AM_PARAMETER_REGISTRY%ROWTYPE;
609: l_created_by number;
610: l_creation_date date;
611: l_last_update_date date;
612: l_last_update_login number;

Line 669: update AK_AM_PARAMETER_REGISTRY set

665: p_last_update_date => l_last_update_date,
666: p_last_update_login => l_last_update_login);
667: */
668:
669: update AK_AM_PARAMETER_REGISTRY set
670: application_id = l_amparam_reg_rec.application_id
671: where applicationmodule_defn_name = p_applicationmodule_defn_name
672: and param_name = p_param_name
673: and param_source = p_param_value;

Line 807: l_amparam_rec ak_am_parameter_registry%ROWTYPE;

803: l_more_apregistry BOOLEAN := TRUE;
804: l_msg_count NUMBER;
805: l_msg_data VARCHAR2(2000);
806: l_amparam_index NUMBER := 0;
807: l_amparam_rec ak_am_parameter_registry%ROWTYPE;
808: l_empty_amparam_rec ak_am_parameter_registry%ROWTYPE;
809: l_amparam_tbl AK_AMPARAM_REGISTRY_PUB.amparamreg_Tbl_Type;
810: l_return_status varchar2(1);
811: l_saved_token AK_ON_OBJECTS_PUB.Buffer_Type;

Line 808: l_empty_amparam_rec ak_am_parameter_registry%ROWTYPE;

804: l_msg_count NUMBER;
805: l_msg_data VARCHAR2(2000);
806: l_amparam_index NUMBER := 0;
807: l_amparam_rec ak_am_parameter_registry%ROWTYPE;
808: l_empty_amparam_rec ak_am_parameter_registry%ROWTYPE;
809: l_amparam_tbl AK_AMPARAM_REGISTRY_PUB.amparamreg_Tbl_Type;
810: l_return_status varchar2(1);
811: l_saved_token AK_ON_OBJECTS_PUB.Buffer_Type;
812: l_state NUMBER;