APPS.PO_UDA_DEFAULTING_PKG dependencies on PO_UDA_AG_TEMPLATE_USAGES

Line 136: l_attr_category po_uda_ag_template_usages.ATTRIBUTE_CATEGORY%TYPE;

132:
133: l_entity_code VARCHAR2(200);
134: l_base_table VARCHAR2(200);
135: l_idc_type VARCHAR2(200);
136: l_attr_category po_uda_ag_template_usages.ATTRIBUTE_CATEGORY%TYPE;
137:
138: l_contract_type VARCHAR2(200);
139: d_progress NUMBER;
140: l_context EGO_COL_NAME_VALUE_PAIR_ARRAY;

Line 218: FROM po_uda_ag_template_usages

214:
215: --bug11872637 Start : Determine Attribute Category
216: SELECT DISTINCT(ATTRIBUTE_CATEGORY)
217: INTO l_attr_category
218: FROM po_uda_ag_template_usages
219: WHERE template_id = p_template_id
220: AND attribute_group_id = p_attr_grp_id;
221: --bug11872637 End
222:

Line 367: FROM po_uda_ag_template_usages

363: IS
364:
365: CURSOR c_get_usages(p_template_id NUMBER) IS
366: SELECT DISTINCT(ATTRIBUTE_CATEGORY)
367: FROM po_uda_ag_template_usages
368: WHERE template_id = p_template_id;
369:
370: CURSOR c_get_usage_context1(p_line_id NUMBER, p_draft_id NUMBER) IS
371: SELECT CLM_IDC_TYPE, CONTRACT_TYPE

Line 1026: AND EXISTS ( SELECT 1 FROM EGO_ACTION_DISPLAYS_B actdisp , ego_actions_b act , po_uda_ag_template_usages pousage

1022: SELECT PO_LINE_ID, ITEM_ID, LINE_TYPE_ID
1023: FROM po_lines_merge_v pll
1024: WHERE PO_HEADER_ID = p_po_header_id
1025: AND DRAFT_ID = p_draft_id
1026: AND EXISTS ( SELECT 1 FROM EGO_ACTION_DISPLAYS_B actdisp , ego_actions_b act , po_uda_ag_template_usages pousage
1027: WHERE act.action_id = actdisp.action_id
1028: AND pousage.template_id = pll.uda_template_id
1029: AND pousage.attribute_group_id = act.attr_group_id
1030: AND To_Char(pousage.template_id) = act.classification_code

Line 1043: AND EXISTS ( SELECT 1 FROM EGO_ACTION_DISPLAYS_B actdisp , ego_actions_b act , po_uda_ag_template_usages pousage

1039: FROM po_line_locations_merge_v pll
1040: WHERE PO_HEADER_ID = p_po_header_id
1041: AND PO_LINE_ID = p_line_id
1042: AND DRAFT_ID = p_draft_id
1043: AND EXISTS ( SELECT 1 FROM EGO_ACTION_DISPLAYS_B actdisp , ego_actions_b act , po_uda_ag_template_usages pousage
1044: WHERE act.action_id = actdisp.action_id
1045: AND pousage.template_id = pll.uda_template_id
1046: AND pousage.attribute_group_id = act.attr_group_id
1047: AND To_Char(pousage.template_id) = act.classification_code

Line 2672: AND EXISTS ( SELECT 1 FROM EGO_ACTION_DISPLAYS_B actdisp , ego_actions_b act , po_uda_ag_template_usages pousage

2668: CURSOR c_get_lines(p_po_header_id NUMBER) IS
2669: SELECT PO_LINE_ID
2670: FROM po_lines_all pll
2671: WHERE PO_HEADER_ID = p_po_header_id
2672: AND EXISTS ( SELECT 1 FROM EGO_ACTION_DISPLAYS_B actdisp , ego_actions_b act , po_uda_ag_template_usages pousage
2673: WHERE act.action_id = actdisp.action_id
2674: AND pousage.template_id = pll.uda_template_id
2675: AND pousage.attribute_group_id = act.attr_group_id
2676: AND To_Char(pousage.template_id) = act.classification_code

Line 2688: AND EXISTS ( SELECT 1 FROM EGO_ACTION_DISPLAYS_B actdisp , ego_actions_b act , po_uda_ag_template_usages pousage

2684: SELECT LINE_LOCATION_ID
2685: FROM PO_LINE_LOCATIONS_all pll
2686: WHERE PO_HEADER_ID = p_po_header_id
2687: AND PO_LINE_ID = p_line_id
2688: AND EXISTS ( SELECT 1 FROM EGO_ACTION_DISPLAYS_B actdisp , ego_actions_b act , po_uda_ag_template_usages pousage
2689: WHERE act.action_id = actdisp.action_id
2690: AND pousage.template_id = pll.uda_template_id
2691: AND pousage.attribute_group_id = act.attr_group_id
2692: AND To_Char(pousage.template_id) = act.classification_code