APPS.AP_WEB_AUDIT_UTILS dependencies on AP_WEB_AUDIT_UTILS

Line 1: PACKAGE BODY AP_WEB_AUDIT_UTILS AS

1: PACKAGE BODY AP_WEB_AUDIT_UTILS AS
2: /* $Header: apwaudub.pls 120.51.12020000.2 2013/03/05 10:02:12 preshukl ship $ */
3:
4: pg_personal_parameter_id number := to_number(null);
5: pg_rounding_parameter_id number := to_number(null);

Line 824: v_value := AP_WEB_AUDIT_UTILS.get_attribute_value(p_report_header_id, p_distribution_line_number, segments.application_column_name(i));

820: fnd_dflex.get_segments(fnd_dflex.make_context(flexfield, contexts.context_code(contexts.global_context)),segments,TRUE);
821:
822: FOR i IN 1 .. segments.nsegments LOOP
823:
824: v_value := AP_WEB_AUDIT_UTILS.get_attribute_value(p_report_header_id, p_distribution_line_number, segments.application_column_name(i));
825:
826: IF v_value is not null THEN
827:
828: IF not first_component THEN

Line 857: v_value := AP_WEB_AUDIT_UTILS.get_attribute_value(p_report_header_id, p_distribution_line_number, segments.application_column_name(i));

853:
854:
855: FOR i IN 1 .. segments.nsegments LOOP
856:
857: v_value := AP_WEB_AUDIT_UTILS.get_attribute_value(p_report_header_id, p_distribution_line_number, segments.application_column_name(i));
858:
859: IF v_value is not null THEN
860:
861: IF not first_component THEN

Line 1507: NVL(AP_WEB_AUDIT_UTILS.get_employee_info(usr.employee_id,'full_name','VARCHAR2'),

1503:
1504: CURSOR auditor_cur IS
1505: select DECODE(usr.user_id,
1506: -1, fnd_message.GET_STRING('SQLAP','OIE_AUD_FALLBACK_AUDITOR'),
1507: NVL(AP_WEB_AUDIT_UTILS.get_employee_info(usr.employee_id,'full_name','VARCHAR2'),
1508: usr.user_name)) auditor_name
1509: from fnd_user usr
1510: where usr.user_id = p_auditor_id;
1511:

Line 2131: ln_rounding_expense_id := AP_WEB_AUDIT_UTILS.get_seeded_expense_id('ROUNDING');

2127: ELSE
2128: /**
2129: * Get the expense type parameter id for rounding.
2130: */
2131: ln_rounding_expense_id := AP_WEB_AUDIT_UTILS.get_seeded_expense_id('ROUNDING');
2132:
2133: IF p_parameter_id = ln_rounding_expense_id THEN
2134: return 'Y';
2135: ELSE

Line 2563: AP_WEB_AUDIT_UTILS.get_employee_info(usr.employee_id,'full_name','VARCHAR2')) last_audited_by_name

2559:
2560: CURSOR user_c IS
2561: SELECT DECODE(usr.employee_id,
2562: null, usr.user_name,
2563: AP_WEB_AUDIT_UTILS.get_employee_info(usr.employee_id,'full_name','VARCHAR2')) last_audited_by_name
2564: FROM fnd_user usr
2565: WHERE usr.user_id = p_user_id;
2566:
2567: user_rec user_c%ROWTYPE;

Line 3439: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AUDIT_UTILS', 'Start GetDefaultAcctgSegValues');

3435: l_ccid NUMBER;
3436:
3437: BEGIN
3438:
3439: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AUDIT_UTILS', 'Start GetDefaultAcctgSegValues');
3440:
3441: -- Initialize API return status to success
3442: x_return_status := FND_API.G_RET_STS_SUCCESS;
3443:

Line 3466: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AUDIT_UTILS', 'end GetDefaultAcctgSegValues');

3462: if (l_return_error_message is not null) then
3463: raise G_EXC_ERROR;
3464: end if;
3465:
3466: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AUDIT_UTILS', 'end GetDefaultAcctgSegValues');
3467:
3468: EXCEPTION
3469: WHEN G_EXC_ERROR THEN
3470: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3481: END AP_WEB_AUDIT_UTILS;

3477: p_data => x_msg_data);
3478: END GetDefaultAcctgSegValues;
3479:
3480:
3481: END AP_WEB_AUDIT_UTILS;