DBA Data[Home] [Help]

APPS.JTM_CHECK_ACC_PKG dependencies on JTM_MESSAGE_LOG_PKG

Line 30: JTM_MESSAGE_LOG_PKG.INSERT_CONC_STATUS_LOG

26: for i IN 1 .. acctable_list.count loop
27:
28: l_query_string := 'SELECT COUNT(*) FROM ' || acctable_list(i) ;
29:
30: JTM_MESSAGE_LOG_PKG.INSERT_CONC_STATUS_LOG
31: (v_package_name => NULL
32: ,v_procedure_name => NULL
33: ,v_con_query_id => NULL
34: ,v_query_stmt => l_query_string

Line 45: JTM_MESSAGE_LOG_PKG.INSERT_CONC_STATUS_LOG

41: ,x_msg_data => ll_message);
42:
43: EXECUTE IMMEDIATE l_query_string into l_counter;
44:
45: JTM_MESSAGE_LOG_PKG.INSERT_CONC_STATUS_LOG
46: (v_package_name => NULL
47: ,v_procedure_name => NULL
48: ,v_con_query_id => NULL
49: ,v_query_stmt => l_query_string

Line 73: JTM_MESSAGE_LOG_PKG.INSERT_CONC_STATUS_LOG

69: return l_status;
70:
71: EXCEPTION WHEN OTHERS THEN
72: ROLLBACK;
73: JTM_MESSAGE_LOG_PKG.INSERT_CONC_STATUS_LOG
74: (v_package_name => NULL
75: ,v_procedure_name => NULL
76: ,v_con_query_id => NULL
77: ,v_query_stmt => l_query_string

Line 115: JTM_MESSAGE_LOG_PKG.INSERT_CONC_STATUS_LOG

111: for i IN 1 .. acctable_list.count loop
112:
113: l_query_string := 'SELECT COUNT(*) FROM ' || acctable_list(i) ;
114:
115: JTM_MESSAGE_LOG_PKG.INSERT_CONC_STATUS_LOG
116: (v_package_name => NULL
117: ,v_procedure_name => NULL
118: ,v_con_query_id => NULL
119: ,v_query_stmt => l_query_string

Line 130: JTM_MESSAGE_LOG_PKG.INSERT_CONC_STATUS_LOG

126: ,x_msg_data => ll_message);
127:
128: EXECUTE IMMEDIATE l_query_string into l_counter;
129:
130: JTM_MESSAGE_LOG_PKG.INSERT_CONC_STATUS_LOG
131: (v_package_name => NULL
132: ,v_procedure_name => NULL
133: ,v_con_query_id => NULL
134: ,v_query_stmt => l_query_string

Line 157: JTM_MESSAGE_LOG_PKG.INSERT_CONC_STATUS_LOG

153: return l_status;
154:
155: EXCEPTION WHEN OTHERS THEN
156: ROLLBACK;
157: JTM_MESSAGE_LOG_PKG.INSERT_CONC_STATUS_LOG
158: (v_package_name => NULL
159: ,v_procedure_name => NULL
160: ,v_con_query_id => NULL
161: ,v_query_stmt => l_query_string