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.42.12010000.2 2008/08/06 10:07:20 rveliche ship $ */
3:
4: pg_personal_parameter_id number := to_number(null);
5: pg_rounding_parameter_id number := to_number(null);

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

781: fnd_dflex.get_segments(fnd_dflex.make_context(flexfield, contexts.context_code(contexts.global_context)),segments,TRUE);
782:
783: FOR i IN 1 .. segments.nsegments LOOP
784:
785: v_value := AP_WEB_AUDIT_UTILS.get_attribute_value(p_report_header_id, p_distribution_line_number, segments.application_column_name(i));
786:
787: IF v_value is not null THEN
788:
789: IF not first_component THEN

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

814:
815:
816: FOR i IN 1 .. segments.nsegments LOOP
817:
818: v_value := AP_WEB_AUDIT_UTILS.get_attribute_value(p_report_header_id, p_distribution_line_number, segments.application_column_name(i));
819:
820: IF v_value is not null THEN
821:
822: IF not first_component THEN

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

1464:
1465: CURSOR auditor_cur IS
1466: select DECODE(usr.user_id,
1467: -1, fnd_message.GET_STRING('SQLAP','OIE_AUD_FALLBACK_AUDITOR'),
1468: NVL(AP_WEB_AUDIT_UTILS.get_employee_info(usr.employee_id,'full_name','VARCHAR2'),
1469: usr.user_name)) auditor_name
1470: from fnd_user usr
1471: where usr.user_id = p_auditor_id;
1472:

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

2085: ELSE
2086: /**
2087: * Get the expense type parameter id for rounding.
2088: */
2089: ln_rounding_expense_id := AP_WEB_AUDIT_UTILS.get_seeded_expense_id('ROUNDING');
2090:
2091: IF p_parameter_id = ln_rounding_expense_id THEN
2092: return 'Y';
2093: ELSE

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

2517:
2518: CURSOR user_c IS
2519: SELECT DECODE(usr.employee_id,
2520: null, usr.user_name,
2521: AP_WEB_AUDIT_UTILS.get_employee_info(usr.employee_id,'full_name','VARCHAR2')) last_audited_by_name
2522: FROM fnd_user usr
2523: WHERE usr.user_id = p_user_id;
2524:
2525: user_rec user_c%ROWTYPE;

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

3386: l_ccid NUMBER;
3387:
3388: BEGIN
3389:
3390: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AUDIT_UTILS', 'Start GetDefaultAcctgSegValues');
3391:
3392: -- Initialize API return status to success
3393: x_return_status := FND_API.G_RET_STS_SUCCESS;
3394:

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

3413: if (l_return_error_message is not null) then
3414: raise G_EXC_ERROR;
3415: end if;
3416:
3417: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_AUDIT_UTILS', 'end GetDefaultAcctgSegValues');
3418:
3419: EXCEPTION
3420: WHEN G_EXC_ERROR THEN
3421: x_return_status := FND_API.G_RET_STS_ERROR;

Line 3432: END AP_WEB_AUDIT_UTILS;

3428: p_data => x_msg_data);
3429: END GetDefaultAcctgSegValues;
3430:
3431:
3432: END AP_WEB_AUDIT_UTILS;