eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMF_SUBLEDGER_PKG dependencies on GL_SUBR_STA

Line 476: g_log_msg := l_procedure_name || ': inserting the control record into gl_subr_sta';

472: RAISE e_validation_failed;
473: END IF;
474:
475: /* insert the control record */
476: g_log_msg := l_procedure_name || ': inserting the control record into gl_subr_sta';
477: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
478: THEN
479: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);
480: END IF;

Line 554: UPDATE gl_subr_sta

550: THEN
551: l_msg_text := FND_MESSAGE.get;
552: RAISE e_req_submit_error;
553: ELSE
554: UPDATE gl_subr_sta
555: SET request_id = l_conc_id
556: WHERE reference_no = l_subledger_ref_no;
557:
558: COMMIT;

Line 1131: FROM gl_subr_sta

1127: cp_post_om VARCHAR2, cp_post_pm VARCHAR2,
1128: cp_post_pur VARCHAR2 )
1129: IS
1130: SELECT reference_no, request_id, count(*) over()
1131: FROM gl_subr_sta
1132: WHERE legal_entity_id = cp_le_id
1133: AND ledger_id = cp_ledger_id
1134: AND cost_type_id = cp_cost_type_id
1135: AND fiscal_year = cp_gl_fiscal_year

Line 1148: l_reference_no gl_subr_sta.reference_no%TYPE;

1144: (post_pur = cp_post_pur AND post_pur = 1))
1145: ;
1146:
1147:
1148: l_reference_no gl_subr_sta.reference_no%TYPE;
1149: l_request_id gl_subr_sta.request_id%TYPE;
1150: l_sch_count NUMBER(15);
1151: l_subledger_ref_no NUMBER(15) := NULL;
1152:

Line 1149: l_request_id gl_subr_sta.request_id%TYPE;

1145: ;
1146:
1147:
1148: l_reference_no gl_subr_sta.reference_no%TYPE;
1149: l_request_id gl_subr_sta.request_id%TYPE;
1150: l_sch_count NUMBER(15);
1151: l_subledger_ref_no NUMBER(15) := NULL;
1152:
1153: e_insert_error EXCEPTION;

Line 1241: INSERT INTO gl_subr_sta

1237: END;
1238: END IF;
1239:
1240: /* insert the control record */
1241: INSERT INTO gl_subr_sta
1242: (
1243: co_code,
1244: current_state,
1245: start_time,

Line 1401: g_log_msg := l_procedure_name || ': ' || sql%rowcount || ' control record inserted into gl_subr_sta table. ' ||

1397: x_subledger_ref_no := l_subledger_ref_no;
1398:
1399: x_retstatus := 'S';
1400:
1401: g_log_msg := l_procedure_name || ': ' || sql%rowcount || ' control record inserted into gl_subr_sta table. ' ||
1402: ' end of procedure';
1403: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL )
1404: THEN
1405: FND_LOG.STRING(G_LEVEL_PROCEDURE, G_MODULE_NAME || l_procedure_name, g_log_msg);