APPS.PON_SOURCING_OPENAPI_GRP dependencies on DUAL

Line 497: FROM dual;

493: 'Getting the document_number from sequence');
494: end if;
495:
496: SELECT pon_auction_headers_all_s.NEXTVAL INTO x_document_number
497: FROM dual;
498:
499: if (fnd_log.level_statement >= fnd_log.g_current_runtime_level) then
500: fnd_log.string(fnd_log.level_statement,
501: 'pon.plsql.pon_sourcing_openapi_grp.create_draft_neg_interface_pvt',

Line 1326: residual_quantity,

1322: category_id,
1323: category_name,
1324: ip_category_id,
1325: uom_code,
1326: residual_quantity,
1327: number_of_bids,
1328: creation_date,
1329: created_by,
1330: last_update_date,

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

1383: pon_auc_items_interface.category_id, -- category_id
1384: FND_FLEX_EXT.get_segs('INV', 'MCAT', mtl_categories_kfv.STRUCTURE_ID, mtl_categories_kfv.CATEGORY_ID), -- category_name from mtl_categories_kfv table
1385: pon_auc_items_interface.ip_category_id, -- ip_category_id
1386: Decode (order_type_lookup_code,'AMOUNT',v_uom_code, uom_code), -- uom_code
1387: Decode (order_type_lookup_code,'AMOUNT',1, quantity), -- residual quantity
1388: 0, -- number_of_bids
1389: Sysdate, -- creation_date
1390: g_header_rec.user_id, -- created_by
1391: Sysdate, -- last_update_date