APPS.IBC_AUDIT_LOG_GRP dependencies on IBC_AUDIT_LOGS

Line 10: FROM IBC_AUDIT_LOGS

6:
7: -- Cursor to retrieve all information about a particular audit_log
8: CURSOR c_audit_log(p_audit_log_id NUMBER) IS
9: SELECT *
10: FROM IBC_AUDIT_LOGS
11: WHERE audit_log_id = p_audit_log_id;
12:
13:
14: -- --------------------------------------------------------------------

Line 371: Ibc_Audit_Logs_Pkg.insert_row(

367: END;
368:
369: END IF;
370:
371: Ibc_Audit_Logs_Pkg.insert_row(
372: px_audit_log_id => audit_log_id
373: ,p_activity => p_activity
374: ,p_parent_value => p_parent_value
375: ,p_user_id => Fnd_Global.user_id

Line 513: l_extra_info_type IBC_AUDIT_LOGS.extra_info1_type%TYPE;

509: ,p_info_number IN NUMBER
510: ) RETURN VARCHAR2 IS
511: TYPE cursorType IS REF CURSOR;
512: l_result VARCHAR2(4000);
513: l_extra_info_type IBC_AUDIT_LOGS.extra_info1_type%TYPE;
514: l_extra_info_ref_type IBC_AUDIT_LOGS.extra_info1_ref_type%TYPE;
515: l_extra_info_value IBC_AUDIT_LOGS.extra_info1_value%TYPE;
516: l_colon_pos NUMBER;
517: l_comma_pos NUMBER;

Line 514: l_extra_info_ref_type IBC_AUDIT_LOGS.extra_info1_ref_type%TYPE;

510: ) RETURN VARCHAR2 IS
511: TYPE cursorType IS REF CURSOR;
512: l_result VARCHAR2(4000);
513: l_extra_info_type IBC_AUDIT_LOGS.extra_info1_type%TYPE;
514: l_extra_info_ref_type IBC_AUDIT_LOGS.extra_info1_ref_type%TYPE;
515: l_extra_info_value IBC_AUDIT_LOGS.extra_info1_value%TYPE;
516: l_colon_pos NUMBER;
517: l_comma_pos NUMBER;
518: l_curr_value_list VARCHAR2(4000);

Line 515: l_extra_info_value IBC_AUDIT_LOGS.extra_info1_value%TYPE;

511: TYPE cursorType IS REF CURSOR;
512: l_result VARCHAR2(4000);
513: l_extra_info_type IBC_AUDIT_LOGS.extra_info1_type%TYPE;
514: l_extra_info_ref_type IBC_AUDIT_LOGS.extra_info1_ref_type%TYPE;
515: l_extra_info_value IBC_AUDIT_LOGS.extra_info1_value%TYPE;
516: l_colon_pos NUMBER;
517: l_comma_pos NUMBER;
518: l_curr_value_list VARCHAR2(4000);
519: l_curr_value VARCHAR2(80);

Line 533: FROM IBC_AUDIT_LOGS

529: SELECT EXTRA_INFO1_TYPE,
530: EXTRA_INFO1_REF_TYPE,
531: EXTRA_INFO1_VALUE
532: INTO l_extra_info_type, l_extra_info_ref_type, l_extra_info_value
533: FROM IBC_AUDIT_LOGS
534: WHERE audit_log_id = p_audit_log_id;
535: ELSIF p_info_number = 2 THEN
536: SELECT EXTRA_INFO2_TYPE,
537: EXTRA_INFO2_REF_TYPE,

Line 540: FROM IBC_AUDIT_LOGS

536: SELECT EXTRA_INFO2_TYPE,
537: EXTRA_INFO2_REF_TYPE,
538: EXTRA_INFO2_VALUE
539: INTO l_extra_info_type, l_extra_info_ref_type, l_extra_info_value
540: FROM IBC_AUDIT_LOGS
541: WHERE audit_log_id = p_audit_log_id;
542: ELSIF p_info_number = 3 THEN
543: SELECT EXTRA_INFO3_TYPE,
544: EXTRA_INFO3_REF_TYPE,

Line 547: FROM IBC_AUDIT_LOGS

543: SELECT EXTRA_INFO3_TYPE,
544: EXTRA_INFO3_REF_TYPE,
545: EXTRA_INFO3_VALUE
546: INTO l_extra_info_type, l_extra_info_ref_type, l_extra_info_value
547: FROM IBC_AUDIT_LOGS
548: WHERE audit_log_id = p_audit_log_id;
549: ELSIF p_info_number = 4 THEN
550: SELECT EXTRA_INFO4_TYPE,
551: EXTRA_INFO4_REF_TYPE,

Line 554: FROM IBC_AUDIT_LOGS

550: SELECT EXTRA_INFO4_TYPE,
551: EXTRA_INFO4_REF_TYPE,
552: EXTRA_INFO4_VALUE
553: INTO l_extra_info_type, l_extra_info_ref_type, l_extra_info_value
554: FROM IBC_AUDIT_LOGS
555: WHERE audit_log_id = p_audit_log_id;
556: ELSE
557: SELECT EXTRA_INFO5_TYPE,
558: EXTRA_INFO5_REF_TYPE,

Line 561: FROM IBC_AUDIT_LOGS

557: SELECT EXTRA_INFO5_TYPE,
558: EXTRA_INFO5_REF_TYPE,
559: EXTRA_INFO5_VALUE
560: INTO l_extra_info_type, l_extra_info_ref_type, l_extra_info_value
561: FROM IBC_AUDIT_LOGS
562: WHERE audit_log_id = p_audit_log_id;
563: END IF;
564:
565: IF l_extra_info_type = G_EI_LOOKUP THEN