APPS.PON_COPY_UDAS_GRP dependencies on PO_LINES_ALL

Line 761: l_clm_contract_type po_lines_all.CONTRACT_TYPE%TYPE;

757: l_src_template_id NUMBER;
758: l_dest_template_id NUMBER;
759: l_module VARCHAR2(30) := 'COPY_PO_LINE_UDA';
760: attrGroups AttrGroupList;
761: l_clm_contract_type po_lines_all.CONTRACT_TYPE%TYPE;
762: l_clm_idc_type po_lines_all.CLM_IDC_TYPE%TYPE;
763:
764: CURSOR attr_groups_cursor(p_bid_number NUMBER,p_bid_line_number NUMBER) is
765: select distinct(ATTR_GROUP_NAME) ATTR_GROUP_NAME

Line 762: l_clm_idc_type po_lines_all.CLM_IDC_TYPE%TYPE;

758: l_dest_template_id NUMBER;
759: l_module VARCHAR2(30) := 'COPY_PO_LINE_UDA';
760: attrGroups AttrGroupList;
761: l_clm_contract_type po_lines_all.CONTRACT_TYPE%TYPE;
762: l_clm_idc_type po_lines_all.CLM_IDC_TYPE%TYPE;
763:
764: CURSOR attr_groups_cursor(p_bid_number NUMBER,p_bid_line_number NUMBER) is
765: select distinct(ATTR_GROUP_NAME) ATTR_GROUP_NAME
766: FROM ego_attr_groups_v ag_v, po_uda_ag_template_usages ag, pon_bid_item_prices bid_lines

Line 779: po_lines_all

775: BEGIN
776: select uda_template_id,contract_type,clm_idc_type
777: into l_src_template_id,l_clm_contract_type,l_clm_idc_type
778: from
779: po_lines_all
780: where
781: po_line_id = p_po_line_id;
782: LOG_MESSAGE(l_module,'PO Line Template Id : '||l_src_template_id);
783: