APPS.AP_WEB_EXPENSE_WF dependencies on WF_ITEM_ATTRIBUTE_VALUES

Line 265: l_mess Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

261: iNum NUMBER :=0;
262: iText NUMBER :=0;
263:
264: --ER 1552747 - withdraw expense report
265: l_mess Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
266:
267: -- Policy Violation
268: l_violation_count NUMBER:=0;
269: l_policy_violation_value VARCHAR2(50);

Line 3045: l_mess Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

3041: l_report_header_id AP_WEB_DB_EXPLINE_PKG.expLines_headerID;
3042: l_num_req_receipt NUMBER;
3043: l_violation VARCHAR2(1);
3044: l_debug_info VARCHAR2(200);
3045: l_mess Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
3046: BEGIN
3047:
3048: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start AnyJustificationRequired');
3049:

Line 3437: l_mess Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

3433: /* jrautiai ADJ Fix Start */
3434: AdjustmentsCursor AP_WEB_DB_EXPLINE_PKG.AdjustmentCursorType;
3435: adjustment_rec AP_WEB_DB_EXPLINE_PKG.AdjustmentRecordType;
3436:
3437: l_mess Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
3438: l_crd_card_count NUMBER := 0;
3439:
3440: l_no_receipts_ccard_amt NUMBER := 0;
3441: l_no_receipts_emp_amt NUMBER := 0;

Line 6165: l_mess Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

6161: -- for bug 2069362
6162: l_AMEEnabled VARCHAR2(1);
6163:
6164: -- jrautiai ADJ Fix
6165: l_mess Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
6166: BEGIN
6167:
6168: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start StartPolicyShortPayProcess');
6169:

Line 6739: l_mess Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

6735: -- for bug 2069362
6736: l_AMEEnabled VARCHAR2(1);
6737:
6738: -- jrautiai ADJ Fix
6739: l_mess Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
6740: BEGIN
6741:
6742: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start StartNoReceiptsShortPayProcess');
6743:

Line 8599: l_rejection_reason Wf_Item_Attribute_Values.TEXT_VALUE%TYPE := NULL;

8595: ---------------------------------------------------------
8596: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
8597: l_WorkflowRec AP_WEB_DB_EXPRPT_PKG.ExpWorkflowRec;
8598: l_debug_info VARCHAR2(200);
8599: l_rejection_reason Wf_Item_Attribute_Values.TEXT_VALUE%TYPE := NULL;
8600: BEGIN
8601:
8602: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start PayablesReviewed');
8603:

Line 8999: l_message Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

8995: document_type IN OUT NOCOPY VARCHAR2) IS
8996:
8997: l_document_max NUMBER := 25000; -- 27721 fails
8998: l_debug_info VARCHAR2(1000);
8999: l_message Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
9000: l_temp_clob CLOB;
9001: l_colon NUMBER;
9002: BEGIN
9003:

Line 12214: l_mess Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

12210: l_debug_info VARCHAR2(200);
12211: l_report_header_id AP_WEB_DB_EXPLINE_PKG.expLines_HeaderID;
12212: l_modified_count NUMBER :=0;
12213: l_new_count NUMBER :=0;
12214: l_mess Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
12215:
12216: BEGIN
12217:
12218: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start determineMileageAdjusted');

Line 13957: l_mess Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

13953: p_funmode IN VARCHAR2,
13954: p_result OUT NOCOPY VARCHAR2) IS
13955: ------------------------------------------------------------------------
13956: l_debug_info VARCHAR2(2000);
13957: l_mess Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
13958: l_document_number AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;
13959: l_preparer_name VARCHAR2(2000);
13960: BEGIN
13961:

Line 14055: l_return_instruction Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

14051: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
14052: l_workflow_approved_flag AP_WEB_DB_EXPRPT_PKG.expHdr_wkflApprvdFlag;
14053:
14054: l_return_reason VARCHAR2(80);
14055: l_return_instruction Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
14056:
14057: l_debug_info VARCHAR2(200);
14058: BEGIN
14059: