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 1602: qltdate.any_to_date (p_date_required),

1598: p_uom_code,
1599: p_quantity,
1600: p_to_subinventory,
1601: l_to_locator_id,
1602: qltdate.any_to_date (p_date_required),
1603: l_project_id,
1604: l_task_id,
1605: l_organization_id,
1606: l_request_number);

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

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

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

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

Line 2639: qltdate.any_to_date(p_txn_date),

2635: nvl(p_to_op_code,NULL),
2636: nvl(l_reason_id,0),
2637: p_uom,
2638: p_quantity,
2639: qltdate.any_to_date(p_txn_date),
2640: p_organization_code,
2641: p_collection_id);
2642:
2643: IF (l_request = 0) THEN

Line 3080: qltdate.any_to_date(p_start_date),

3076: l_wip_entity_id,
3077: p_op_seq_num,
3078: l_operation_id,
3079: l_department_id,
3080: qltdate.any_to_date(p_start_date),
3081: qltdate.any_to_date(p_end_date),
3082: l_organization_id,
3083: l_status_type);
3084:

Line 3081: qltdate.any_to_date(p_end_date),

3077: p_op_seq_num,
3078: l_operation_id,
3079: l_department_id,
3080: qltdate.any_to_date(p_start_date),
3081: qltdate.any_to_date(p_end_date),
3082: l_organization_id,
3083: l_status_type);
3084:
3085: