APPS.OPIMPDAT dependencies on WIP_TRANSACTIONS

Line 117: from wip_transactions wt

113:
114: l_stmt_num := 30;
115: select trunc (min(wt.transaction_date)) --Dinkar 10/11/02
116: into l_wip_from_date
117: from wip_transactions wt
118: where organization_id = i_org_id;
119: end if; -- end 'from' date is null
120: l_prev_push_inv_txn_id := 0;
121: l_prev_push_wip_txn_id := 0;

Line 463: from wip_transactions wt

459: -- Get the first date that have transactions, including the last push date.
460: l_stmt_num := 150;
461: select trunc (min(wt.transaction_date))
462: into l_wip_txn_date
463: from wip_transactions wt
464: where wt.organization_id = i_org_id
465: and wt.transaction_date >= l_from_date;
466: */
467: /*

Line 472: from wip_transactions wt

468: -- Get the last transaction of that first date
469: l_stmt_num := 160;
470: select max(wt.transaction_id)
471: into l_wip_txn_id
472: from wip_transactions wt
473: where wt.organization_id = i_org_id
474: and wt.transaction_date BETWEEN trunc(l_wip_txn_date) and
475: trunc (l_wip_txn_date) + 0.99999;
476: */

Line 494: from wip_transactions wt

490: -- Get the first transaction id of the start date
491: l_stmt_num := 170;
492: Select min(wt.transaction_id)
493: into l_push_wip_start_txn_id
494: from wip_transactions wt
495: where wt.organization_id = i_org_id
496: and wt.transaction_date >= l_push_wip_start_date;
497: */
498: /*-------------------------------------------------

Line 526: from wip_transactions wt

522: l_stmt_num := 190;
523: l_wip_txn_date := null;
524: select trunc (min(wt.transaction_date)) -- Dinkar 10/11/02
525: into l_wip_txn_date
526: from wip_transactions wt
527: where wt.organization_id = i_org_id
528: and wt.transaction_id >= l_push_wip_start_txn_id;
529:
530: if l_wip_txn_date < l_prev_push_wip_txn_date

Line 562: from wip_transactions wt

558:
559: select min(wt.transaction_id), max(wt.transaction_id)
560: into l_push_wip_start_txn_id,
561: l_push_wip_end_txn_id
562: from wip_transactions wt
563: where wt.organization_id = i_org_id
564: and wt.transaction_date between l_look_for_txn_id
565: and trunc (l_push_wip_end_date) + 0.99999;
566:

Line 579: -- If there are no WIP transactions for date range

575: o_err_num := l_err_num;
576: o_err_code := l_err_code;
577: o_err_msg := l_err_msg;
578:
579: -- If there are no WIP transactions for date range
580: -- set transaction flag and set last tranx id to the previous push's
581: -- last trxn id.
582:
583: if (l_push_wip_start_txn_id = 0 or

Line 587: || 'No WIP transactions for date range');

583: if (l_push_wip_start_txn_id = 0 or
584: l_push_wip_start_txn_id is null) then
585: o_push_last_wip_txn_id := l_prev_push_wip_txn_id;
586: EDW_LOG.PUT_LINE('OPIMPDAT.get_push_dates - '
587: || 'No WIP transactions for date range');
588: if o_txn_flag = 0 then -- reset flag to process MMT only
589: o_txn_flag := 1;
590: end if;
591: end if;

Line 594: -- let user know that there are no wip transactions to process

590: end if;
591: end if;
592:
593: -- If the start date is beyond the user-entered end date,
594: -- let user know that there are no wip transactions to process
595: -- and move the start date back to the calculated from date
596:
597: if (o_push_start_wip_txn_date > trunc (i_to_date)) -- Dinkar 10/11/02
598: or (o_push_start_wip_txn_date is null) then

Line 601: EDW_LOG.PUT_LINE('OPIMPDAT.get_push_dates - no WIP transactions to process');

597: if (o_push_start_wip_txn_date > trunc (i_to_date)) -- Dinkar 10/11/02
598: or (o_push_start_wip_txn_date is null) then
599: o_push_start_wip_txn_date := trunc (l_from_date); -- Dinkar 10/11/02
600:
601: EDW_LOG.PUT_LINE('OPIMPDAT.get_push_dates - no WIP transactions to process');
602: EDW_LOG.PUT_LINE('Org id: ' || to_char(i_org_id));
603: EDW_LOG.PUT_LINE('Start WIP Push Date :'
604: || to_char(o_push_start_wip_txn_date,
605: 'DD-MON-YYYY HH24:MI:SS'));