APPS.AP_WEB_CREDIT_CARD_WF dependencies on WF_ITEM_ATTRIBUTE_VALUES

Line 341: l_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

337: l_currency AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;
338: l_debugInfo VARCHAR2(200);
339: l_cardProgramID AP_WEB_DB_CCARD_PKG.cardProgs_cardProgID;
340: l_orgId number;
341: l_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
342: l_mgr_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
343:
344: BEGIN
345: ------------------------------------------------------------

Line 342: l_mgr_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

338: l_debugInfo VARCHAR2(200);
339: l_cardProgramID AP_WEB_DB_CCARD_PKG.cardProgs_cardProgID;
340: l_orgId number;
341: l_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
342: l_mgr_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
343:
344: BEGIN
345: ------------------------------------------------------------
346: l_debugInfo := 'Get Name Info Associated With employee_Id';

Line 594: l_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

590: l_currency AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;
591: l_cardProgramName AP_WEB_DB_CCARD_PKG.cardProgs_cardProgName;
592: l_orgId number;
593: l_debugInfo VARCHAR2(200);
594: l_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
595: l_mgr_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
596: l_plus_sign VARCHAR2(1) := '+';
597:
598: --Amulya Mishra : Notification Esclation Project

Line 595: l_mgr_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

591: l_cardProgramName AP_WEB_DB_CCARD_PKG.cardProgs_cardProgName;
592: l_orgId number;
593: l_debugInfo VARCHAR2(200);
594: l_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
595: l_mgr_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
596: l_plus_sign VARCHAR2(1) := '+';
597:
598: --Amulya Mishra : Notification Esclation Project
599:

Line 600: l_add_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

596: l_plus_sign VARCHAR2(1) := '+';
597:
598: --Amulya Mishra : Notification Esclation Project
599:
600: l_add_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
601: l_mgmt_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
602: l_notes Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
603: l_aging_oustanding NUMBER;
604: l_total_outstanding NUMBER;

Line 601: l_mgmt_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

597:
598: --Amulya Mishra : Notification Esclation Project
599:
600: l_add_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
601: l_mgmt_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
602: l_notes Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
603: l_aging_oustanding NUMBER;
604: l_total_outstanding NUMBER;
605: l_esc_managerName wf_users.name%type;

Line 602: l_notes Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

598: --Amulya Mishra : Notification Esclation Project
599:
600: l_add_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
601: l_mgmt_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
602: l_notes Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
603: l_aging_oustanding NUMBER;
604: l_total_outstanding NUMBER;
605: l_esc_managerName wf_users.name%type;
606: l_esc_managerId NUMBER;

Line 624: l_mgr_esc_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

620: l_prev_manager_name wf_users.name%type;
621: l_prev_manager_display_name wf_users.name%type;
622:
623:
624: l_mgr_esc_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
625: l_mgr_esc_mgmt_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
626: l_mgr_esc_add_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
627:
628: l_next_mgr_esc_instr VARCHAR2(2000);

Line 625: l_mgr_esc_mgmt_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

621: l_prev_manager_display_name wf_users.name%type;
622:
623:
624: l_mgr_esc_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
625: l_mgr_esc_mgmt_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
626: l_mgr_esc_add_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
627:
628: l_next_mgr_esc_instr VARCHAR2(2000);
629: l_next_mgr_esc_mgmt_instr VARCHAR2(2000);

Line 626: l_mgr_esc_add_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

622:
623:
624: l_mgr_esc_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
625: l_mgr_esc_mgmt_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
626: l_mgr_esc_add_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
627:
628: l_next_mgr_esc_instr VARCHAR2(2000);
629: l_next_mgr_esc_mgmt_instr VARCHAR2(2000);
630: l_next_mgr_esc_add_instr VARCHAR2(2000);