APPS.BIX_DM_AGENT_CALL_SUMMARY_PKG dependencies on BIX_DM_COLLECT_LOG

Line 47: | for writing error details into BIX_DM_COLLECT_LOG table when ever any procedure fails in this Package.|

43: g_ao_dummy_resource NUMBER;
44:
45: /*======================================================================================================+
46: | WRITE_LOG procedure writes error message into FND log file and also calls INSERT_LOG procedure |
47: | for writing error details into BIX_DM_COLLECT_LOG table when ever any procedure fails in this Package.|
48: ======================================================================================================+*/
49:
50: -- GET_CALLS collects calls from OLTP to the temporary
51: -- Deletes in chunks, thus easing the rollback segments problem.

Line 57: | INSERT_LOG procedure inserts collection concurrent program status into BIX_DM_COLLECT_LOG table |

53: -- BIX_DM_DELETE_SIZE profile. If this is not set, then the default
54: -- chunk size is 100 rows.
55:
56: /*===================================================================================================+
57: | INSERT_LOG procedure inserts collection concurrent program status into BIX_DM_COLLECT_LOG table |
58: | It inserts a row with the following details : |
59: | |
60: | COLLECT_STATUS column equals to FAILED if the program failed otherwise SUCCESS |
61: | COLLECT_EXCEP_MESG as error message if the program failed otherwise NULL |

Line 73: SELECT BIX_DM_COLLECT_LOG_S.NEXTVAL INTO l_bix_collect_log_seq FROM DUAL;

69: AS
70: l_bix_collect_log_seq NUMBER;
71: BEGIN
72:
73: SELECT BIX_DM_COLLECT_LOG_S.NEXTVAL INTO l_bix_collect_log_seq FROM DUAL;
74:
75: /* Insert status into log table */
76:
77: INSERT INTO BIX_DM_COLLECT_LOG

Line 77: INSERT INTO BIX_DM_COLLECT_LOG

73: SELECT BIX_DM_COLLECT_LOG_S.NEXTVAL INTO l_bix_collect_log_seq FROM DUAL;
74:
75: /* Insert status into log table */
76:
77: INSERT INTO BIX_DM_COLLECT_LOG
78: (
79: COLLECT_ID,
80: COLLECT_CONCUR_ID,
81: OBJECT_NAME,

Line 4336: | the log table BIX_DM_COLLECT_LOG. |

4332: | 5. CALL_SUM : Summarizes call data and inserts it into the BIX_DM_CALL_SUM table |
4333: | |
4334: | The procedure 1 populates BIX_DM_INTERFACE staging table, the others use the staging table to populate |
4335: | the other tables. After each procedure the insert_log procedure is called to insert the table data into |
4336: | the log table BIX_DM_COLLECT_LOG. |
4337: | There are two versions of this procedure, one called from the concurrent manager and the other callable |
4338: | from sqlplus for debugging purposses. The version below is the one callable from sqlplus. |
4339: ========================================================================================================+*/
4340:

Line 4556: | the log table BIX_DM_COLLECT_LOG. |

4552: | 5. CALL_SUM : Summarizes call data and inserts it into the BIX_DM_CALL_SUM table |
4553: | |
4554: | The procedure 1 populates BIX_DM_INTERFACE staging table, the others use the staging table to populate |
4555: | the other tables. After each procedure the insert_log procedure is called to insert the table data into |
4556: | the log table BIX_DM_COLLECT_LOG. |
4557: | There are two versions of this procedure, one called from the concurrent manager and the other callable |
4558: | from sqlplus for debugging purposses. The version below is the one called from the concurrent manager. |
4559: ========================================================================================================+*/
4560: