DBA Data[Home] [Help]

APPS.POR_UDA_PKG dependencies on PO_REQ_HEADERS_EXT_B

Line 272: FROM PO_REQ_HEADERS_EXT_B

268:
269:
270: CURSOR c_por_header_ext(po_rec_header_id NUMBER) IS
271: SELECT DISTINCT ATTR_GROUP_ID
272: FROM PO_REQ_HEADERS_EXT_B
273: WHERE REQUISITION_HEADER_ID = po_rec_header_id;
274:
275: CURSOR c_por_line_ext(po_rec_line_id NUMBER) IS
276: SELECT DISTINCT ATTR_GROUP_ID

Line 1183: FROM PO_REQ_HEADERS_EXT_B

1179:
1180:
1181: CURSOR po_req_headers_ext_cursor IS
1182: SELECT extension_id, EGO_EXTFWK_S.NEXTVAL
1183: FROM PO_REQ_HEADERS_EXT_B
1184: WHERE REQUISITION_HEADER_ID = p_old_header_id
1185: AND ATTR_GROUP_ID in ( SELECT ATTR_GROUP_ID FROM
1186: PO_UDA_AG_TEMPLATE_USAGES usages, ego_attr_groups_v ags
1187: WHERE usages.template_id = p_template_id

Line 1208: insert into PO_REQ_HEADERS_EXT_B(

1204: open po_req_headers_ext_cursor ;
1205: fetch po_req_headers_ext_cursor into l_old_hdr_ext_id,l_new_hdr_ext_id;
1206: CLOSE po_req_headers_ext_cursor;
1207:
1208: insert into PO_REQ_HEADERS_EXT_B(
1209: extension_id
1210: ,attr_group_id
1211: ,requisition_header_id
1212: ,data_level_id

Line 1422: from PO_REQ_HEADERS_EXT_B where extension_id = l_old_hdr_ext_id;

1418: ,d_ext_attr8
1419: ,d_ext_attr9
1420: ,d_ext_attr10
1421: ,p_template_id
1422: from PO_REQ_HEADERS_EXT_B where extension_id = l_old_hdr_ext_id;
1423:
1424:
1425: d_progress := 10 ;
1426: