DBA Data[Home] [Help]

APPS.IBE_ORDER_W1_PVT dependencies on JTF_DATE_TABLE

Line 216: p_l_REQUEST_DATE IN jtf_date_table :=NULL,

212: p_l_HEADER_ID IN jtf_number_table :=NULL,
213: p_l_LINE_TYPE_ID IN jtf_number_table :=NULL,
214: p_l_LINE_NUMBER IN jtf_number_table :=NULL,
215: p_l_ORDERED_ITEM IN jtf_varchar2_table_300 :=NULL,
216: p_l_REQUEST_DATE IN jtf_date_table :=NULL,
217: p_l_PROMISE_DATE IN jtf_date_table :=NULL,
218: p_l_SCHEDULE_SHIP_DATE IN jtf_date_table :=NULL,
219: p_l_ORDER_QUANTITY_UOM IN jtf_varchar2_table_100 :=NULL,
220: p_l_PRICING_QUANTITY IN jtf_number_table :=NULL,

Line 217: p_l_PROMISE_DATE IN jtf_date_table :=NULL,

213: p_l_LINE_TYPE_ID IN jtf_number_table :=NULL,
214: p_l_LINE_NUMBER IN jtf_number_table :=NULL,
215: p_l_ORDERED_ITEM IN jtf_varchar2_table_300 :=NULL,
216: p_l_REQUEST_DATE IN jtf_date_table :=NULL,
217: p_l_PROMISE_DATE IN jtf_date_table :=NULL,
218: p_l_SCHEDULE_SHIP_DATE IN jtf_date_table :=NULL,
219: p_l_ORDER_QUANTITY_UOM IN jtf_varchar2_table_100 :=NULL,
220: p_l_PRICING_QUANTITY IN jtf_number_table :=NULL,
221: p_l_PRICING_QUANTITY_UOM IN jtf_varchar2_table_300 :=NULL,

Line 218: p_l_SCHEDULE_SHIP_DATE IN jtf_date_table :=NULL,

214: p_l_LINE_NUMBER IN jtf_number_table :=NULL,
215: p_l_ORDERED_ITEM IN jtf_varchar2_table_300 :=NULL,
216: p_l_REQUEST_DATE IN jtf_date_table :=NULL,
217: p_l_PROMISE_DATE IN jtf_date_table :=NULL,
218: p_l_SCHEDULE_SHIP_DATE IN jtf_date_table :=NULL,
219: p_l_ORDER_QUANTITY_UOM IN jtf_varchar2_table_100 :=NULL,
220: p_l_PRICING_QUANTITY IN jtf_number_table :=NULL,
221: p_l_PRICING_QUANTITY_UOM IN jtf_varchar2_table_300 :=NULL,
222: p_l_CANCELLED_QUANTITY IN jtf_number_table :=NULL,

Line 254: p_l_TAX_DATE IN jtf_date_table :=NULL,

250: p_l_CUST_MODEL_SERIAL_NUMBER IN jtf_varchar2_table_100 :=NULL,
251: p_l_PROJECT_ID IN jtf_number_table :=NULL,
252: p_l_TASK_ID IN jtf_number_table :=NULL,
253: p_l_INVENTORY_ITEM_ID IN jtf_number_table :=NULL,
254: p_l_TAX_DATE IN jtf_date_table :=NULL,
255: p_l_TAX_CODE IN jtf_varchar2_table_100 :=NULL,
256: p_l_TAX_RATE IN jtf_number_table :=NULL,
257: -- p_l_INVOICE_INTERFACE_STATUS_CODE IN jtf_varchar2_table_100 :=NULL,
258: p_l_INVOICE_INTER_STATUS_CODE IN jtf_varchar2_table_100 :=NULL,

Line 261: p_l_PRICING_DATE IN jtf_date_table :=NULL,

257: -- p_l_INVOICE_INTERFACE_STATUS_CODE IN jtf_varchar2_table_100 :=NULL,
258: p_l_INVOICE_INTER_STATUS_CODE IN jtf_varchar2_table_100 :=NULL,
259: p_l_DEMAND_CLASS_CODE IN jtf_varchar2_table_100 :=NULL,
260: p_l_PRICE_LIST_ID IN jtf_number_table :=NULL,
261: p_l_PRICING_DATE IN jtf_date_table :=NULL,
262: p_l_SHIPMENT_NUMBER IN jtf_number_table :=NULL,
263: p_l_AGREEMENT_ID IN jtf_number_table :=NULL,
264: p_l_SHIPMENT_PRIORITY_CODE IN jtf_varchar2_table_100 :=NULL,
265: p_l_SHIPPING_METHOD_CODE IN jtf_varchar2_table_100 :=NULL,

Line 364: p_l_CREATION_DATE IN jtf_date_table :=NULL,

360: p_l_INDUSTRY_ATTRIBUTE27 IN jtf_varchar2_table_300 :=NULL,
361: p_l_INDUSTRY_ATTRIBUTE28 IN jtf_varchar2_table_300 :=NULL,
362: p_l_INDUSTRY_ATTRIBUTE29 IN jtf_varchar2_table_300 :=NULL,
363: p_l_INDUSTRY_ATTRIBUTE30 IN jtf_varchar2_table_300 :=NULL,
364: p_l_CREATION_DATE IN jtf_date_table :=NULL,
365: p_l_CREATED_BY IN jtf_number_table :=NULL,
366: p_l_LAST_UPDATE_DATE IN jtf_date_table :=NULL,
367: p_l_LAST_UPDATED_BY IN jtf_number_table :=NULL,
368: p_l_LAST_UPDATE_LOGIN IN jtf_number_table :=NULL,

Line 366: p_l_LAST_UPDATE_DATE IN jtf_date_table :=NULL,

362: p_l_INDUSTRY_ATTRIBUTE29 IN jtf_varchar2_table_300 :=NULL,
363: p_l_INDUSTRY_ATTRIBUTE30 IN jtf_varchar2_table_300 :=NULL,
364: p_l_CREATION_DATE IN jtf_date_table :=NULL,
365: p_l_CREATED_BY IN jtf_number_table :=NULL,
366: p_l_LAST_UPDATE_DATE IN jtf_date_table :=NULL,
367: p_l_LAST_UPDATED_BY IN jtf_number_table :=NULL,
368: p_l_LAST_UPDATE_LOGIN IN jtf_number_table :=NULL,
369: p_l_PROGRAM_APPLICATION_ID IN jtf_number_table :=NULL,
370: p_l_PROGRAM_ID IN jtf_number_table :=NULL,

Line 371: p_l_PROGRAM_UPDATE_DATE IN jtf_date_table :=NULL,

367: p_l_LAST_UPDATED_BY IN jtf_number_table :=NULL,
368: p_l_LAST_UPDATE_LOGIN IN jtf_number_table :=NULL,
369: p_l_PROGRAM_APPLICATION_ID IN jtf_number_table :=NULL,
370: p_l_PROGRAM_ID IN jtf_number_table :=NULL,
371: p_l_PROGRAM_UPDATE_DATE IN jtf_date_table :=NULL,
372: p_l_REQUEST_ID IN jtf_number_table :=NULL,
373: p_l_TOP_MODEL_LINE_ID IN jtf_number_table :=NULL,
374: p_l_LINK_TO_LINE_ID IN jtf_number_table :=NULL,
375: p_l_COMPONENT_SEQUENCE_ID IN jtf_number_table :=NULL,

Line 385: p_l_ACTUAL_SHIPMENT_DATE IN jtf_date_table :=NULL,

381: p_l_OPTION_FLAG IN jtf_varchar2_table_100 :=NULL,
382: p_l_DEP_PLAN_REQUIRED_FLAG IN jtf_varchar2_table_100 :=NULL,
383: p_l_VISIBLE_DEMAND_FLAG IN jtf_varchar2_table_100 :=NULL,
384: p_l_LINE_CATEGORY_CODE IN jtf_varchar2_table_100 :=NULL,
385: p_l_ACTUAL_SHIPMENT_DATE IN jtf_date_table :=NULL,
386: p_l_CUSTOMER_TRX_LINE_ID IN jtf_number_table :=NULL,
387: p_l_RETURN_CONTEXT IN jtf_varchar2_table_100 :=NULL,
388: p_l_RETURN_ATTRIBUTE1 IN jtf_varchar2_table_300 :=NULL,
389: p_l_RETURN_ATTRIBUTE2 IN jtf_varchar2_table_300 :=NULL,

Line 403: p_l_ACTUAL_ARRIVAL_DATE IN jtf_date_table :=NULL,

399: p_l_RETURN_ATTRIBUTE12 IN jtf_varchar2_table_300 :=NULL,
400: p_l_RETURN_ATTRIBUTE13 IN jtf_varchar2_table_300 :=NULL,
401: p_l_RETURN_ATTRIBUTE14 IN jtf_varchar2_table_300 :=NULL,
402: p_l_RETURN_ATTRIBUTE15 IN jtf_varchar2_table_300 :=NULL,
403: p_l_ACTUAL_ARRIVAL_DATE IN jtf_date_table :=NULL,
404: p_l_ATO_LINE_ID IN jtf_number_table :=NULL,
405: p_l_AUTO_SELECTED_QUANTITY IN jtf_number_table :=NULL,
406: p_l_COMPONENT_NUMBER IN jtf_number_table :=NULL,
407: p_l_EARLIEST_ACCEPTABLE_DATE IN jtf_date_table :=NULL,

Line 407: p_l_EARLIEST_ACCEPTABLE_DATE IN jtf_date_table :=NULL,

403: p_l_ACTUAL_ARRIVAL_DATE IN jtf_date_table :=NULL,
404: p_l_ATO_LINE_ID IN jtf_number_table :=NULL,
405: p_l_AUTO_SELECTED_QUANTITY IN jtf_number_table :=NULL,
406: p_l_COMPONENT_NUMBER IN jtf_number_table :=NULL,
407: p_l_EARLIEST_ACCEPTABLE_DATE IN jtf_date_table :=NULL,
408: p_l_EXPLOSION_DATE IN jtf_date_table :=NULL,
409: p_l_LATEST_ACCEPTABLE_DATE IN jtf_date_table :=NULL,
410: p_l_MODEL_GROUP_NUMBER IN jtf_number_table :=NULL,
411: p_l_SCHEDULE_ARRIVAL_DATE IN jtf_date_table :=NULL,

Line 408: p_l_EXPLOSION_DATE IN jtf_date_table :=NULL,

404: p_l_ATO_LINE_ID IN jtf_number_table :=NULL,
405: p_l_AUTO_SELECTED_QUANTITY IN jtf_number_table :=NULL,
406: p_l_COMPONENT_NUMBER IN jtf_number_table :=NULL,
407: p_l_EARLIEST_ACCEPTABLE_DATE IN jtf_date_table :=NULL,
408: p_l_EXPLOSION_DATE IN jtf_date_table :=NULL,
409: p_l_LATEST_ACCEPTABLE_DATE IN jtf_date_table :=NULL,
410: p_l_MODEL_GROUP_NUMBER IN jtf_number_table :=NULL,
411: p_l_SCHEDULE_ARRIVAL_DATE IN jtf_date_table :=NULL,
412: p_l_SHIP_MODEL_COMPLETE_FLAG IN jtf_varchar2_table_100 :=NULL,

Line 409: p_l_LATEST_ACCEPTABLE_DATE IN jtf_date_table :=NULL,

405: p_l_AUTO_SELECTED_QUANTITY IN jtf_number_table :=NULL,
406: p_l_COMPONENT_NUMBER IN jtf_number_table :=NULL,
407: p_l_EARLIEST_ACCEPTABLE_DATE IN jtf_date_table :=NULL,
408: p_l_EXPLOSION_DATE IN jtf_date_table :=NULL,
409: p_l_LATEST_ACCEPTABLE_DATE IN jtf_date_table :=NULL,
410: p_l_MODEL_GROUP_NUMBER IN jtf_number_table :=NULL,
411: p_l_SCHEDULE_ARRIVAL_DATE IN jtf_date_table :=NULL,
412: p_l_SHIP_MODEL_COMPLETE_FLAG IN jtf_varchar2_table_100 :=NULL,
413: p_l_SCHEDULE_STATUS_CODE IN jtf_varchar2_table_100 :=NULL,

Line 411: p_l_SCHEDULE_ARRIVAL_DATE IN jtf_date_table :=NULL,

407: p_l_EARLIEST_ACCEPTABLE_DATE IN jtf_date_table :=NULL,
408: p_l_EXPLOSION_DATE IN jtf_date_table :=NULL,
409: p_l_LATEST_ACCEPTABLE_DATE IN jtf_date_table :=NULL,
410: p_l_MODEL_GROUP_NUMBER IN jtf_number_table :=NULL,
411: p_l_SCHEDULE_ARRIVAL_DATE IN jtf_date_table :=NULL,
412: p_l_SHIP_MODEL_COMPLETE_FLAG IN jtf_varchar2_table_100 :=NULL,
413: p_l_SCHEDULE_STATUS_CODE IN jtf_varchar2_table_100 :=NULL,
414: p_l_SOURCE_TYPE_CODE IN jtf_varchar2_table_100 :=NULL,
415: p_l_CANCELLED_FLAG IN jtf_varchar2_table_100 :=NULL,

Line 434: p_l_FIRST_ACK_DATE IN jtf_date_table :=NULL,

430: p_l_COMMITMENT_ID IN jtf_number_table :=NULL,
431: p_l_SHIPPING_INTERFACED_FLAG IN jtf_varchar2_table_100 :=NULL,
432: p_l_CREDIT_INVOICE_LINE_ID IN jtf_number_table :=NULL,
433: p_l_FIRST_ACK_CODE IN jtf_varchar2_table_100 :=NULL,
434: p_l_FIRST_ACK_DATE IN jtf_date_table :=NULL,
435: p_l_LAST_ACK_CODE IN jtf_varchar2_table_100 :=NULL,
436: p_l_LAST_ACK_DATE IN jtf_date_table :=NULL,
437: p_l_PLANNING_PRIORITY IN jtf_number_table :=NULL,
438: p_l_ORDER_SOURCE_ID IN jtf_number_table :=NULL,

Line 436: p_l_LAST_ACK_DATE IN jtf_date_table :=NULL,

432: p_l_CREDIT_INVOICE_LINE_ID IN jtf_number_table :=NULL,
433: p_l_FIRST_ACK_CODE IN jtf_varchar2_table_100 :=NULL,
434: p_l_FIRST_ACK_DATE IN jtf_date_table :=NULL,
435: p_l_LAST_ACK_CODE IN jtf_varchar2_table_100 :=NULL,
436: p_l_LAST_ACK_DATE IN jtf_date_table :=NULL,
437: p_l_PLANNING_PRIORITY IN jtf_number_table :=NULL,
438: p_l_ORDER_SOURCE_ID IN jtf_number_table :=NULL,
439: p_l_ORIG_SYS_SHIPMENT_REF IN jtf_varchar2_table_100 :=NULL,
440: p_l_CHANGE_SEQUENCE IN jtf_varchar2_table_100 :=NULL,

Line 461: p_l_SERVICE_START_DATE IN jtf_date_table :=NULL,

457: p_l_LINE_SET_ID IN jtf_number_table :=NULL,
458: p_l_SERVICE_TXN_REASON_CODE IN jtf_varchar2_table_100 :=NULL,
459: p_l_SERVICE_TXN_COMMENTS IN jtf_varchar2_table_300 :=NULL,
460: p_l_SERVICE_DURATION IN jtf_number_table :=NULL,
461: p_l_SERVICE_START_DATE IN jtf_date_table :=NULL,
462: p_l_SERVICE_END_DATE IN jtf_date_table :=NULL,
463: p_l_SERVICE_COTERMINATE_FLAG IN jtf_varchar2_table_100 :=NULL,
464: p_l_UNIT_LIST_PERCENT IN jtf_number_table :=NULL,
465: p_l_UNIT_SELLING_PERCENT IN jtf_number_table :=NULL,

Line 462: p_l_SERVICE_END_DATE IN jtf_date_table :=NULL,

458: p_l_SERVICE_TXN_REASON_CODE IN jtf_varchar2_table_100 :=NULL,
459: p_l_SERVICE_TXN_COMMENTS IN jtf_varchar2_table_300 :=NULL,
460: p_l_SERVICE_DURATION IN jtf_number_table :=NULL,
461: p_l_SERVICE_START_DATE IN jtf_date_table :=NULL,
462: p_l_SERVICE_END_DATE IN jtf_date_table :=NULL,
463: p_l_SERVICE_COTERMINATE_FLAG IN jtf_varchar2_table_100 :=NULL,
464: p_l_UNIT_LIST_PERCENT IN jtf_number_table :=NULL,
465: p_l_UNIT_SELLING_PERCENT IN jtf_number_table :=NULL,
466: p_l_UNIT_PERCENT_BASE_PRICE IN jtf_number_table :=NULL,

Line 499: p_l_FULFILLMENT_DATE IN jtf_date_table :=NULL,

495: p_l_SERVICE_REF_SYSTEM_ID IN jtf_number_table :=NULL,
496: p_l_CALCULATE_PRICE_FLAG IN jtf_varchar2_table_100 :=NULL,
497: p_l_UPGRADED_FLAG IN jtf_varchar2_table_100 :=NULL,
498: p_l_REVENUE_AMOUNT IN jtf_number_table :=NULL,
499: p_l_FULFILLMENT_DATE IN jtf_date_table :=NULL,
500: p_l_PREFERRED_GRADE IN jtf_varchar2_table_100 :=NULL,
501: p_l_ORDERED_QUANTITY2 IN jtf_number_table :=NULL,
502: p_l_ORDERED_QUANTITY_UOM2 IN jtf_varchar2_table_100 :=NULL,
503: p_l_SHIPPING_QUANTITY2 IN jtf_number_table :=NULL,