DBA Data[Home] [Help]

APPS.AP_WEB_INACTIVE_EMP_WF_PKG dependencies on WF_ITEM_ATTRIBUTE_VALUES

Line 56: l_inact_emp_display_name Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

52: l_process VARCHAR2(50) := 'INFORM_INACT_EMP_MANAGER';
53: l_item_type VARCHAR2(100) := p_wf_item_type;
54: l_Item_Key VARCHAR2(50) := p_wf_item_key;
55: l_inact_employee_name VARCHAR2(30);
56: l_inact_emp_display_name Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
57: l_temp_inact_emp_disp_name Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
58: l_inact_emp_org_id NUMBER;
59: l_inact_emp_org_name VARCHAR2(200);
60: l_total_dsp VARCHAR2(50);

Line 57: l_temp_inact_emp_disp_name Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

53: l_item_type VARCHAR2(100) := p_wf_item_type;
54: l_Item_Key VARCHAR2(50) := p_wf_item_key;
55: l_inact_employee_name VARCHAR2(30);
56: l_inact_emp_display_name Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
57: l_temp_inact_emp_disp_name Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
58: l_inact_emp_org_id NUMBER;
59: l_inact_emp_org_name VARCHAR2(200);
60: l_total_dsp VARCHAR2(50);
61: l_special_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

Line 61: l_special_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

57: l_temp_inact_emp_disp_name Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
58: l_inact_emp_org_id NUMBER;
59: l_inact_emp_org_name VARCHAR2(200);
60: l_total_dsp VARCHAR2(50);
61: l_special_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
62: l_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
63: l_note Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
64: l_resp_notes Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
65: l_resp_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

Line 62: l_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

58: l_inact_emp_org_id NUMBER;
59: l_inact_emp_org_name VARCHAR2(200);
60: l_total_dsp VARCHAR2(50);
61: l_special_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
62: l_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
63: l_note Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
64: l_resp_notes Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
65: l_resp_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
66: l_orgId NUMBER;

Line 63: l_note Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

59: l_inact_emp_org_name VARCHAR2(200);
60: l_total_dsp VARCHAR2(50);
61: l_special_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
62: l_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
63: l_note Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
64: l_resp_notes Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
65: l_resp_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
66: l_orgId NUMBER;
67: l_n_org_id NUMBER;

Line 64: l_resp_notes Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

60: l_total_dsp VARCHAR2(50);
61: l_special_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
62: l_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
63: l_note Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
64: l_resp_notes Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
65: l_resp_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
66: l_orgId NUMBER;
67: l_n_org_id NUMBER;
68: l_debug_info VARCHAR2(200);

Line 65: l_resp_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

61: l_special_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
62: l_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
63: l_note Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
64: l_resp_notes Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
65: l_resp_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
66: l_orgId NUMBER;
67: l_n_org_id NUMBER;
68: l_debug_info VARCHAR2(200);
69: l_err_name VARCHAR2(200);

Line 1369: l_error_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

1365: l_preparer_display_name VARCHAR2(100);
1366: l_preparer_name VARCHAR2(100);
1367: l_error_preparer_name VARCHAR2(150);
1368: l_error_inact_empl_name VARCHAR2(150);
1369: l_error_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
1370: l_error_note Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
1371:
1372:
1373: BEGIN

Line 1370: l_error_note Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;

1366: l_preparer_name VARCHAR2(100);
1367: l_error_preparer_name VARCHAR2(150);
1368: l_error_inact_empl_name VARCHAR2(150);
1369: l_error_instructions Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
1370: l_error_note Wf_Item_Attribute_Values.TEXT_VALUE%TYPE;
1371:
1372:
1373: BEGIN
1374: AP_WEB_UTILITIES_PKG.logProcedure('AP_WEB_INACTIVE_EMP_WF_PKG', 'start AddSecuringAttributePreparer');