APPS.PON_SOURCING_OPENAPI_GRP dependencies on DUAL

Line 458: FROM dual;

454: 'Getting the document_number from sequence');
455: end if;
456:
457: SELECT pon_auction_headers_all_s.NEXTVAL INTO x_document_number
458: FROM dual;
459:
460: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
461: fnd_log.string(fnd_log.level_statement,
462: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

Line 1077: residual_quantity,

1073: category_id,
1074: category_name,
1075: ip_category_id,
1076: uom_code,
1077: residual_quantity,
1078: number_of_bids,
1079: creation_date,
1080: created_by,
1081: last_update_date,

Line 1124: Decode (order_type_lookup_code,'AMOUNT',1, quantity), -- residual quantity

1120: pon_auc_items_interface.category_id, -- category_id
1121: FND_FLEX_EXT.get_segs('INV', 'MCAT', mtl_categories_kfv.STRUCTURE_ID, mtl_categories_kfv.CATEGORY_ID), -- category_name from mtl_categories_kfv table
1122: pon_auc_items_interface.ip_category_id, -- ip_category_id
1123: Decode (order_type_lookup_code,'AMOUNT',v_uom_code, uom_code), -- uom_code
1124: Decode (order_type_lookup_code,'AMOUNT',1, quantity), -- residual quantity
1125: 0, -- number_of_bids
1126: Sysdate, -- creation_date
1127: g_header_rec.user_id, -- created_by
1128: Sysdate, -- last_update_date