APPS.PQH_GSP_PROCESS_LOG dependencies on PQH_PROCESS_LOG

Line 34: L_Ovn Pqh_Process_Log.Object_Version_Number%TYPE;

30: ,P_Information1 IN Varchar2
31: ,P_Information2 IN Varchar2
32: ,P_Information3 IN Varchar2) IS
33:
34: L_Ovn Pqh_Process_Log.Object_Version_Number%TYPE;
35: L_process_log_Id Pqh_Process_log.Process_log_id%TYPE;
36: PRAGMA AUTONOMOUS_TRANSACTION;
37:
38: Begin

Line 35: L_process_log_Id Pqh_Process_log.Process_log_id%TYPE;

31: ,P_Information2 IN Varchar2
32: ,P_Information3 IN Varchar2) IS
33:
34: L_Ovn Pqh_Process_Log.Object_Version_Number%TYPE;
35: L_process_log_Id Pqh_Process_log.Process_log_id%TYPE;
36: PRAGMA AUTONOMOUS_TRANSACTION;
37:
38: Begin
39:

Line 40: pqh_process_log_api.create_process_log

36: PRAGMA AUTONOMOUS_TRANSACTION;
37:
38: Begin
39:
40: pqh_process_log_api.create_process_log
41: (p_process_log_id => L_Process_Log_Id
42: ,p_module_cd => P_Module_Cd
43: ,p_txn_id => P_Txn_id
44: ,p_log_context => P_Log_Context

Line 103: From Pqh_Process_Log

99: and table_alias ='PGM';
100:
101: Cursor Master_Log is
102: Select Process_Log_Id
103: From Pqh_Process_Log
104: Where Txn_id = P_Master_txn_Id
105: and MODULE_CD = P_Module_Cd;
106:
107: L_Grade_Ladder_Name Ben_Pgm_F.Name%TYPE;

Line 111: L_LOG_ID Pqh_Process_Log.Process_Log_Id%TYPE;

107: L_Grade_Ladder_Name Ben_Pgm_F.Name%TYPE;
108: l_Grade_name Per_Grades.Name%TYPE;
109: l_Step_name Per_Spinal_Points.Spinal_POint%TYPE;
110: l_Person_Name Per_All_People_F.Full_name%TYPE;
111: L_LOG_ID Pqh_Process_Log.Process_Log_Id%TYPE;
112: L_MASTER_LOG_ID Pqh_Process_Log.MASTER_PROCESS_LOG_ID%TYPE;
113: l_Message_Type Varchar2(25);
114: L_Log_Context Pqh_Process_log.Log_Context%TYPE;
115:

Line 112: L_MASTER_LOG_ID Pqh_Process_Log.MASTER_PROCESS_LOG_ID%TYPE;

108: l_Grade_name Per_Grades.Name%TYPE;
109: l_Step_name Per_Spinal_Points.Spinal_POint%TYPE;
110: l_Person_Name Per_All_People_F.Full_name%TYPE;
111: L_LOG_ID Pqh_Process_Log.Process_Log_Id%TYPE;
112: L_MASTER_LOG_ID Pqh_Process_Log.MASTER_PROCESS_LOG_ID%TYPE;
113: l_Message_Type Varchar2(25);
114: L_Log_Context Pqh_Process_log.Log_Context%TYPE;
115:
116: Begin

Line 114: L_Log_Context Pqh_Process_log.Log_Context%TYPE;

110: l_Person_Name Per_All_People_F.Full_name%TYPE;
111: L_LOG_ID Pqh_Process_Log.Process_Log_Id%TYPE;
112: L_MASTER_LOG_ID Pqh_Process_Log.MASTER_PROCESS_LOG_ID%TYPE;
113: l_Message_Type Varchar2(25);
114: L_Log_Context Pqh_Process_log.Log_Context%TYPE;
115:
116: Begin
117:
118: If p_module_cd = 'PQH_GSP_APPROVAL_UI' Then