DBA Data[Home] [Help]

APPS.QA_SOLUTION_DISPOSITION_PKG dependencies on QLTDATE

Line 260: qltdate.any_to_date(p_job_start),

256: l_item_id,
257: l_group_id,
258: p_job_class,
259: p_job_name,
260: qltdate.any_to_date(p_job_start),
261: qltdate.any_to_date(p_job_end),
262: l_bill_id,
263: p_bom_revision,
264: l_routing_id,

Line 261: qltdate.any_to_date(p_job_end),

257: l_group_id,
258: p_job_class,
259: p_job_name,
260: qltdate.any_to_date(p_job_start),
261: qltdate.any_to_date(p_job_end),
262: l_bill_id,
263: p_bom_revision,
264: l_routing_id,
265: p_routing_revision,

Line 728: IF (qltdate.canon_to_date(p_txn_date) - trunc(sysdate)) = 0 THEN

724: -- the job/schedule'.l_txn_date in the following code will be passed to the
725: -- WIP_SCRAP_WIP_MOVE_INT instead of the p_txn_date.
726: -- Bug 2697724.suramasw.Mon Jan 20 06:21:03 PST 2003.
727:
728: IF (qltdate.canon_to_date(p_txn_date) - trunc(sysdate)) = 0 THEN
729: l_txn_date := sysdate;
730: ELSE
731: l_txn_date := qltdate.canon_to_date(p_txn_date);
732: END IF;

Line 731: l_txn_date := qltdate.canon_to_date(p_txn_date);

727:
728: IF (qltdate.canon_to_date(p_txn_date) - trunc(sysdate)) = 0 THEN
729: l_txn_date := sysdate;
730: ELSE
731: l_txn_date := qltdate.canon_to_date(p_txn_date);
732: END IF;
733:
734:
735: -- Call the wipscrap_int(). It spawns and returns back the concurrent request

Line 754: qltdate.any_to_date(l_txn_date),

750: nvl(p_to_op_code,NULL),
751: nvl(l_reason_id,0),
752: p_uom,
753: p_quantity,
754: qltdate.any_to_date(l_txn_date),
755: p_organization_code,
756: p_collection_id);
757:
758: IF (l_request = 0) THEN

Line 1136: l_transaction_date := qltdate.any_to_date(p_transaction_date);

1132:
1133: IF p_transaction_date IS NULL THEN
1134: l_transaction_date := sysdate;
1135: ELSE
1136: l_transaction_date := qltdate.any_to_date(p_transaction_date);
1137: END IF;
1138:
1139: -- Get the Inventory Item ID and Locator ID.
1140: l_item_id := qa_flex_util.get_item_id(l_organization_id, p_item);

Line 1606: qltdate.any_to_date (p_date_required),

1602: p_uom_code,
1603: p_quantity,
1604: p_to_subinventory,
1605: l_to_locator_id,
1606: qltdate.any_to_date (p_date_required),
1607: l_project_id,
1608: l_task_id,
1609: l_organization_id,
1610: l_request_number);

Line 1947: l_transaction_date := qltdate.any_to_date(p_transaction_date);

1943:
1944: IF p_transaction_date IS NULL THEN
1945: l_transaction_date := sysdate;
1946: ELSE
1947: l_transaction_date := qltdate.any_to_date(p_transaction_date);
1948: END IF;
1949:
1950: -- Update the Disposition Status to 'Pending'.
1951: UPDATE_STATUS(l_plan_id,p_collection_id,p_occurrence);

Line 2173: l_transaction_date := qltdate.any_to_date(p_transaction_date);

2169:
2170: IF p_transaction_date IS NULL THEN
2171: l_transaction_date := sysdate;
2172: ELSE
2173: l_transaction_date := qltdate.any_to_date(p_transaction_date);
2174: END IF;
2175:
2176: -- Update the Disposition Status to 'Pending'.
2177: UPDATE_STATUS(l_plan_id,p_collection_id,p_occurrence);

Line 2635: IF (qltdate.canon_to_date(p_txn_date) - trunc(sysdate)) = 0 THEN

2631:
2632: -- Bug 7395743 FP for bug 7394787.pdube Sun Dec 20 22:30:33 PST 2009
2633: -- The time part of the transaction date was truncating,
2634: -- making this code fix to handle it.
2635: IF (qltdate.canon_to_date(p_txn_date) - trunc(sysdate)) = 0 THEN
2636: l_txn_date := sysdate;
2637: ELSE
2638: l_txn_date := qltdate.canon_to_date(p_txn_date);
2639: END IF;

Line 2638: l_txn_date := qltdate.canon_to_date(p_txn_date);

2634: -- making this code fix to handle it.
2635: IF (qltdate.canon_to_date(p_txn_date) - trunc(sysdate)) = 0 THEN
2636: l_txn_date := sysdate;
2637: ELSE
2638: l_txn_date := qltdate.canon_to_date(p_txn_date);
2639: END IF;
2640:
2641: l_request := WIP_SCRAP_WIP_MOVE_INT(
2642: l_item_id,

Line 2655: qltdate.any_to_date(l_txn_date), -- Bug 7395743

2651: nvl(p_to_op_code,NULL),
2652: nvl(l_reason_id,0),
2653: p_uom,
2654: p_quantity,
2655: qltdate.any_to_date(l_txn_date), -- Bug 7395743
2656: p_organization_code,
2657: p_collection_id);
2658:
2659: IF (l_request = 0) THEN

Line 3096: qltdate.any_to_date(p_start_date),

3092: l_wip_entity_id,
3093: p_op_seq_num,
3094: l_operation_id,
3095: l_department_id,
3096: qltdate.any_to_date(p_start_date),
3097: qltdate.any_to_date(p_end_date),
3098: l_organization_id,
3099: l_status_type);
3100:

Line 3097: qltdate.any_to_date(p_end_date),

3093: p_op_seq_num,
3094: l_operation_id,
3095: l_department_id,
3096: qltdate.any_to_date(p_start_date),
3097: qltdate.any_to_date(p_end_date),
3098: l_organization_id,
3099: l_status_type);
3100:
3101: