APPS.AP_WEB_CREDIT_CARD_WF dependencies on WF_ITEM_ATTRIBUTE_VALUES

Line 331: l_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

327: l_currency AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;
328: l_debugInfo VARCHAR2(200);
329: l_cardProgramID AP_WEB_DB_CCARD_PKG.cardProgs_cardProgID;
330: l_orgId number;
331: l_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
332: l_mgr_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
333:
334: BEGIN
335: ------------------------------------------------------------

Line 332: l_mgr_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

328: l_debugInfo VARCHAR2(200);
329: l_cardProgramID AP_WEB_DB_CCARD_PKG.cardProgs_cardProgID;
330: l_orgId number;
331: l_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
332: l_mgr_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
333:
334: BEGIN
335: ------------------------------------------------------------
336: l_debugInfo := 'Get Name Info Associated With employee_Id';

Line 550: l_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

546: l_currency AP_WEB_DB_EXPRPT_PKG.expHdr_defaultCurrCode;
547: l_cardProgramName AP_WEB_DB_CCARD_PKG.cardProgs_cardProgName;
548: l_orgId number;
549: l_debugInfo VARCHAR2(200);
550: l_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
551: l_mgr_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
552: l_plus_sign VARCHAR2(1) := '+';
553:
554: --Amulya Mishra : Notification Esclation Project

Line 551: l_mgr_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

547: l_cardProgramName AP_WEB_DB_CCARD_PKG.cardProgs_cardProgName;
548: l_orgId number;
549: l_debugInfo VARCHAR2(200);
550: l_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
551: l_mgr_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
552: l_plus_sign VARCHAR2(1) := '+';
553:
554: --Amulya Mishra : Notification Esclation Project
555:

Line 556: l_add_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

552: l_plus_sign VARCHAR2(1) := '+';
553:
554: --Amulya Mishra : Notification Esclation Project
555:
556: l_add_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
557: l_mgmt_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
558: l_notes Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
559: l_aging_oustanding NUMBER;
560: l_total_outstanding NUMBER;

Line 557: l_mgmt_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

553:
554: --Amulya Mishra : Notification Esclation Project
555:
556: l_add_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
557: l_mgmt_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
558: l_notes Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
559: l_aging_oustanding NUMBER;
560: l_total_outstanding NUMBER;
561: l_esc_managerName wf_users.name%type;

Line 558: l_notes Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

554: --Amulya Mishra : Notification Esclation Project
555:
556: l_add_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
557: l_mgmt_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
558: l_notes Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
559: l_aging_oustanding NUMBER;
560: l_total_outstanding NUMBER;
561: l_esc_managerName wf_users.name%type;
562: l_esc_managerId NUMBER;

Line 580: l_mgr_esc_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

576: l_prev_manager_name wf_users.name%type;
577: l_prev_manager_display_name wf_users.name%type;
578:
579:
580: l_mgr_esc_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
581: l_mgr_esc_mgmt_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
582: l_mgr_esc_add_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
583:
584: l_next_mgr_esc_instr VARCHAR2(2000);

Line 581: l_mgr_esc_mgmt_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

577: l_prev_manager_display_name wf_users.name%type;
578:
579:
580: l_mgr_esc_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
581: l_mgr_esc_mgmt_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
582: l_mgr_esc_add_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
583:
584: l_next_mgr_esc_instr VARCHAR2(2000);
585: l_next_mgr_esc_mgmt_instr VARCHAR2(2000);

Line 582: l_mgr_esc_add_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

578:
579:
580: l_mgr_esc_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
581: l_mgr_esc_mgmt_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
582: l_mgr_esc_add_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
583:
584: l_next_mgr_esc_instr VARCHAR2(2000);
585: l_next_mgr_esc_mgmt_instr VARCHAR2(2000);
586: l_next_mgr_esc_add_instr VARCHAR2(2000);