APPS.AP_WEB_EXPENSE_WF dependencies on WF_ITEM_ATTRIBUTE_VALUES

Line 268: l_mess Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

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

Line 3092: l_mess Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

3088: l_report_header_id AP_WEB_DB_EXPLINE_PKG.expLines_headerID;
3089: l_num_req_receipt NUMBER;
3090: l_violation VARCHAR2(1);
3091: l_debug_info VARCHAR2(200);
3092: l_mess Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
3093: BEGIN
3094:
3095: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start AnyJustificationRequired');
3096:

Line 3486: l_mess Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

3482: /* jrautiai ADJ Fix Start */
3483: AdjustmentsCursor AP_WEB_DB_EXPLINE_PKG.AdjustmentCursorType;
3484: adjustment_rec AP_WEB_DB_EXPLINE_PKG.AdjustmentRecordType;
3485:
3486: l_mess Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
3487: l_crd_card_count NUMBER := 0;
3488:
3489: l_no_receipts_ccard_amt NUMBER := 0;
3490: l_no_receipts_emp_amt NUMBER := 0;

Line 6546: l_mess Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

6542: -- for bug 2069362
6543: l_AMEEnabled VARCHAR2(1);
6544:
6545: -- jrautiai ADJ Fix
6546: l_mess Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
6547: BEGIN
6548:
6549: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start StartPolicyShortPayProcess');
6550:

Line 7120: l_mess Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

7116: -- for bug 2069362
7117: l_AMEEnabled VARCHAR2(1);
7118:
7119: -- jrautiai ADJ Fix
7120: l_mess Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
7121: l_missing_receipt_type VARCHAR2(50);
7122: BEGIN
7123:
7124: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start StartNoReceiptsShortPayProcess');

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

9041: ---------------------------------------------------------
9042: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
9043: l_WorkflowRec AP_WEB_DB_EXPRPT_PKG.ExpWorkflowRec;
9044: l_debug_info VARCHAR2(200);
9045: l_rejection_reason Wf_Item_Attribute_Values.TEXT_VALUE%TYPE := NULL;
9046: BEGIN
9047:
9048: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start PayablesReviewed');
9049:

Line 9445: l_message Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

9441: document_type IN OUT NOCOPY VARCHAR2) IS
9442:
9443: l_document_max NUMBER := 25000; -- 27721 fails
9444: l_debug_info VARCHAR2(1000);
9445: l_message Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
9446: l_temp_clob CLOB;
9447: l_colon NUMBER;
9448: BEGIN
9449:

Line 12977: l_mess Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

12973: l_debug_info VARCHAR2(200);
12974: l_report_header_id AP_WEB_DB_EXPLINE_PKG.expLines_HeaderID;
12975: l_modified_count NUMBER :=0;
12976: l_new_count NUMBER :=0;
12977: l_mess Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
12978:
12979: BEGIN
12980:
12981: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_EXPENSE_WF', 'start determineMileageAdjusted');

Line 14845: l_mess Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

14841: p_funmode IN VARCHAR2,
14842: p_result OUT NOCOPY VARCHAR2) IS
14843: ------------------------------------------------------------------------
14844: l_debug_info VARCHAR2(2000);
14845: l_mess Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
14846: l_document_number AP_WEB_DB_EXPRPT_PKG.expHdr_invNum;
14847: l_preparer_name VARCHAR2(2000);
14848: BEGIN
14849:

Line 14943: l_return_instruction Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

14939: l_report_header_id AP_WEB_DB_EXPRPT_PKG.expHdr_headerID;
14940: l_workflow_approved_flag AP_WEB_DB_EXPRPT_PKG.expHdr_wkflApprvdFlag;
14941:
14942: l_return_reason VARCHAR2(80);
14943: l_return_instruction Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
14944:
14945: l_debug_info VARCHAR2(200);
14946: BEGIN
14947: