[Home] [Help]
2583: IF p_level = 'HEADER' THEN
2584:
2585: SELECT distinct pudat.attribute_group_id
2586: BULK COLLECT INTO x_attr_group_id_tbl
2587: FROM po_headers_draft_all poh,
2588: po_uda_ag_template_usages pudat,
2589: EGO_ACTION_DISPLAYS_B ead,
2590: EGO_ACTIONS_B ea
2591: WHERE ea.action_id = ead.action_id
2599: ELSIF p_level = 'LINE' THEN
2600:
2601: SELECT distinct pudat.attribute_group_id
2602: BULK COLLECT INTO x_attr_group_id_tbl
2603: FROM po_headers_draft_all poh,
2604: po_uda_ag_template_usages pudat,
2605: EGO_ACTION_DISPLAYS_B ead,
2606: EGO_ACTIONS_B ea
2607: WHERE ea.action_id = ead.action_id
2618: ELSIF p_level = 'SHIPMENT' THEN
2619:
2620: SELECT distinct pudat.attribute_group_id
2621: BULK COLLECT INTO x_attr_group_id_tbl
2622: FROM po_headers_draft_all poh,
2623: po_uda_ag_template_usages pudat,
2624: EGO_ACTION_DISPLAYS_B ead,
2625: EGO_ACTIONS_B ea
2626: WHERE ea.action_id = ead.action_id