[Home] [Help]
1372: -- Extension record pertaing to Destination Attribute groups which are not
1373: -- there in target documents Template will be skipped.
1374: -----------------------------------------------------------------------------
1375:
1376: l_dynamic_sql := ' SELECT EXTENSION_ID, EGO_EXTFWK_S.NEXTVAL '||
1377: ' FROM '||l_from_object_cr.l_object_ext_b_table||
1378: ' WHERE '||l_from_where_pk_sql ||
1379: ' DATA_LEVEL_ID = ' || l_from_data_level_id ||
1380: ' AND EXISTS (SELECT 1 from PO_UDA_AG_TEMPLATE_USAGES where template_id = ' || to_template_id ||
2165: AND extension_id = amd_address_rows(row_b).extension_id;
2166:
2167:
2168: -- Updating the required information.
2169: SELECT EGO_EXTFWK_S.NEXTVAL
2170: INTO amd_address_rows(row_b).extension_id
2171: FROM sys.dual;
2172:
2173: amd_address_rows(row_b).requisition_header_id := x_requisition_header_id;
2257: AND extension_id = po_address_rows(row_b).extension_id;
2258:
2259:
2260: -- Updating the required information.
2261: SELECT EGO_EXTFWK_S.NEXTVAL
2262: INTO po_address_rows(row_b).extension_id
2263: FROM sys.dual;
2264:
2265: po_address_rows(row_b).po_header_id := p_po_header_id;
3143: DESTLINE.d_ext_attr10,
3144: DESTLINE.uda_template_id,
3145: DESTLINE.draft_id)
3146: SELECT
3147: EGO_EXTFWK_S.NEXTVAL,
3148: SRCLINE.attr_group_id,
3149: po_dest_line_ids_tbl(i),
3150: SRCLINE.data_level_id,
3151: SRCLINE.pk1_value,
3584: DESTLINE.d_ext_attr10,
3585: DESTLINE.uda_template_id,
3586: DESTLINE.draft_id)
3587: SELECT
3588: EGO_EXTFWK_S.NEXTVAL,
3589: SRCLINE.attr_group_id,
3590: po_dest_line_ids_tbl(i),
3591: SRCLINE.data_level_id,
3592: SRCLINE.pk1_value,
3918: DESTLINE.d_ext_attr10,
3919: DESTLINE.uda_template_id,
3920: DESTLINE.draft_id)
3921: SELECT
3922: EGO_EXTFWK_S.NEXTVAL,
3923: SRCLINE.attr_group_id,
3924: po_dest_line_location_ids_tbl(i),
3925: SRCLINE.data_level_id,
3926: SRCLINE.pk1_value,
4348: DESTLINE.d_ext_attr10,
4349: DESTLINE.uda_template_id,
4350: DESTLINE.draft_id)
4351: SELECT
4352: EGO_EXTFWK_S.NEXTVAL,
4353: SRCLINE.attr_group_id,
4354: po_dest_line_location_ids_tbl(i),
4355: SRCLINE.data_level_id,
4356: SRCLINE.pk1_value,