APPS.PA_CLIENT_EXTEN_CIP_GROUPING dependencies on PA_EXPENDITURE_TYPES

Line 7: p_expnd_type IN PA_EXPENDITURE_TYPES.expenditure_type%TYPE,

3: FUNCTION CLIENT_GROUPING_METHOD( p_proj_id IN PA_PROJECTS_ALL.project_id%TYPE,
4: p_task_id IN PA_TASKS.task_id%TYPE,
5: p_expnd_item_id IN PA_EXPENDITURE_ITEMS_ALL.expenditure_item_id%TYPE,
6: p_expnd_id IN PA_EXPENDITURE_ITEMS_ALL.expenditure_id%TYPE,
7: p_expnd_type IN PA_EXPENDITURE_TYPES.expenditure_type%TYPE,
8: p_expnd_category IN PA_EXPENDITURE_CATEGORIES.expenditure_category%TYPE,
9: p_attribute1 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
10: p_attribute2 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,
11: p_attribute3 IN PA_EXPENDITURE_ITEMS_ALL.attribute1%TYPE,

Line 26: v_material_flag pa_expenditure_types.attribute10%TYPE;

22: p_ref3 IN PA_COST_DISTRIBUTION_LINES_ALL.system_reference3%TYPE,
23: p_ref4 IN PA_COST_DISTRIBUTION_LINES_ALL.system_reference4%TYPE)
24: return VARCHAR2 IS
25: v_grouping_method varchar2(2000) default null;
26: v_material_flag pa_expenditure_types.attribute10%TYPE;
27:
28: /* Adding cursor for IPA for bug 5637615 */
29: CURSOR get_crl_instal_rec is
30: SELECT asset_name_id

Line 77: Note : Make sure the attrubute10 in pa_expenditure_types is populated

73: Portion for grouping by Material and Non material */
74:
75: /* CRL customers using Material flag as one of the grouping critera
76: uncomment the portion below
77: Note : Make sure the attrubute10 in pa_expenditure_types is populated
78: with the material flag indicator */
79: /* Select attribute10 into v_material_flag
80: From PA_EXPENDITURE_TYPES
81: Where expenditure_type = p_expnd_type;

Line 80: From PA_EXPENDITURE_TYPES

76: uncomment the portion below
77: Note : Make sure the attrubute10 in pa_expenditure_types is populated
78: with the material flag indicator */
79: /* Select attribute10 into v_material_flag
80: From PA_EXPENDITURE_TYPES
81: Where expenditure_type = p_expnd_type;
82:
83: if (v_material_flag is not null ) then
84: v_grouping_method := v_grouping_method || v_material_flag;