[Home] [Help]
202: and organization_id = p_organization_id
203: order by resource_seq_num desc;
204:
205: BEGIN
206: -- Standard Start of API savepoint
207: l_stmt_num := 10;
208: SAVEPOINT get_resource_validate_pvt;
209:
210: l_stmt_num := 20;
207: l_stmt_num := 10;
208: SAVEPOINT get_resource_validate_pvt;
209:
210: l_stmt_num := 20;
211: -- Standard call to check for call compatibility.
212: IF NOT fnd_api.compatible_api_call(
213: l_api_version
214: ,p_api_version
215: ,l_api_name
533: x_charge_dept_id := l_actual_charge_dept_id;
534: x_instance_id := l_instance_id;
535:
536: -- End of API body.
537: -- Standard check of p_commit.
538: IF fnd_api.to_boolean(p_commit) THEN
539: COMMIT WORK;
540: END IF;
541:
539: COMMIT WORK;
540: END IF;
541:
542: l_stmt_num := 999;
543: -- Standard call to get message count and if count is 1, get message info.
544: fnd_msg_pub.count_and_get(
545: p_count => x_msg_count
546: ,p_data => x_msg_data);
547: EXCEPTION
642: l_usage_rate_or_amount NUMBER := 0;
643: l_basis_type NUMBER := 0;
644: l_activity_id NUMBER := 0;
645: l_activity_name VARCHAR2(10) ;
646: l_standard_rate_flag NUMBER := 0;
647: l_acct_period_id NUMBER := 0;
648: l_department_id NUMBER := 0;
649: l_department_code VARCHAR2(10) ;
650: l_reason_id NUMBER := 0;
689: operation_seq_num = l_operation_seq_num1 ;
690:
691:
692: BEGIN
693: -- Standard Start of API savepoint
694: l_stmt_num := 10;
695: SAVEPOINT get_insert_into_wcti_pvt;
696:
697: l_stmt_num := 20;
694: l_stmt_num := 10;
695: SAVEPOINT get_insert_into_wcti_pvt;
696:
697: l_stmt_num := 20;
698: -- Standard call to check for call compatibility.
699: IF NOT fnd_api.compatible_api_call(
700: l_api_version
701: ,p_api_version
702: ,l_api_name
827: if (p_reason_name is not null) then
828: select reason_id into l_reason_id from mtl_transaction_reasons where reason_name = p_reason_name;
829: end if;
830:
831: -- Get resource_id, resource_code, resource_type, uom, basis_type, activity_id, activity and standard_rate_flag
832:
833: if (p_resource_code is not null) then
834: l_stmt_num := 150;
835: select br.resource_id,
838: br.unit_of_measure uom_code,
839: br.default_basis_type basis_type,
840: ca.activity_id,
841: ca.activity,
842: br.standard_rate_flag
843: into
844: l_resource_id,
845: l_resource_code,
846: l_resource_type,
847: l_uom,
848: l_basis_type,
849: l_activity_id,
850: l_activity_name,
851: l_standard_rate_flag
852: from
853: cst_activities ca,
854: bom_department_resources bdr,
855: bom_resources br
962: ,ACTIVITY_ID
963: ,SCHEDULED_FLAG
964: ,ASSIGNED_UNITS
965: ,AUTOCHARGE_TYPE
966: ,STANDARD_RATE_FLAG
967: ,APPLIED_RESOURCE_UNITS
968: ,APPLIED_RESOURCE_VALUE
969: ,START_DATE
970: ,COMPLETION_DATE
1024: ,null -- activity id
1025: ,2 -- scheduled flag
1026: ,1 -- assigned units
1027: ,2 --autocharge type
1028: ,2 -- standard rate flag
1029: ,0 -- applied resource units
1030: ,0 -- applied resource value
1031: ,l_start_date
1032: ,l_completion_date
1113: resource_type,
1114: usage_rate_or_amount,
1115: basis_type,
1116: autocharge_type,
1117: standard_rate_flag,
1118: transaction_quantity,
1119: transaction_uom,
1120: primary_quantity,
1121: primary_uom,
1200: l_resource_type,
1201: decode(l_usage_rate_or_amount,0,null,l_usage_rate_or_amount), --usage_rate_or_amount
1202: l_basis_type,
1203: 2, -- autocharge_type
1204: l_standard_rate_flag,
1205: p_transaction_qty,
1206: l_txn_uom,
1207: l_primary_qty,
1208: l_uom,
1274:
1275:
1276:
1277: -- End of API body.
1278: -- Standard check of p_commit.
1279: IF fnd_api.to_boolean(p_commit) THEN
1280: COMMIT WORK;
1281: END IF;
1282:
1280: COMMIT WORK;
1281: END IF;
1282:
1283: l_stmt_num := 999;
1284: -- Standard call to get message count and if count is 1, get message info.
1285: fnd_msg_pub.count_and_get(
1286: p_count => x_msg_count
1287: ,p_data => x_msg_data);
1288: EXCEPTION
1351: instance_id = p_instance_id ;
1352:
1353:
1354: BEGIN
1355: -- Standard Start of API savepoint
1356: l_stmt_num := 10;
1357: SAVEPOINT get_insert_into_wori_pvt;
1358:
1359: l_stmt_num := 20;
1356: l_stmt_num := 10;
1357: SAVEPOINT get_insert_into_wori_pvt;
1358:
1359: l_stmt_num := 20;
1360: -- Standard call to check for call compatibility.
1361: IF NOT fnd_api.compatible_api_call(
1362: l_api_version
1363: ,p_api_version
1364: ,l_api_name
1449:
1450: l_stmt_num := 800;
1451:
1452: -- End of API body.
1453: -- Standard check of p_commit.
1454: IF fnd_api.to_boolean(p_commit) THEN
1455: COMMIT WORK;
1456: END IF;
1457:
1455: COMMIT WORK;
1456: END IF;
1457:
1458: l_stmt_num := 999;
1459: -- Standard call to get message count and if count is 1, get message info.
1460: fnd_msg_pub.count_and_get(
1461: p_count => x_msg_count
1462: ,p_data => x_msg_data);
1463: EXCEPTION
1534:
1535:
1536: BEGIN
1537:
1538: -- Standard Start of API savepoint
1539: l_stmt_num := 10;
1540: SAVEPOINT wip_eamrcvdirectitem_pvt;
1541:
1542: l_stmt_num := 20;
1539: l_stmt_num := 10;
1540: SAVEPOINT wip_eamrcvdirectitem_pvt;
1541:
1542: l_stmt_num := 20;
1543: -- Standard call to check for call compatibility.
1544: IF NOT fnd_api.compatible_api_call(
1545: l_api_version
1546: ,p_api_version
1547: ,l_api_name
1632: pol.po_line_id = pd.po_line_id
1633: AND pol.line_type_id = plt.line_type_id
1634: AND upper(nvl(plt.outside_operation_flag, 'N')) = 'N'
1635: AND pd.destination_type_code = 'SHOP FLOOR'
1636: AND( pd.PO_RELEASE_ID IS NOT NULL OR pd.DISTRIBUTION_TYPE = 'STANDARD')
1637: AND upper(nvl(pol.cancel_flag, 'N')) <> 'Y'
1638: AND pd.wip_entity_id = l_wip_entity_id
1639: AND pd.wip_operation_seq_num = l_operation_seq_num
1640: AND pd.destination_organization_id = l_organization_id
1761: uom_code,l_uom, NULL,NULL),3))
1762: into l_quantity_received
1763: from (SELECT uom.uom_code, sum(pda.quantity_delivered) quantity_received
1764: FROM po_line_types plt, mtl_units_of_measure uom, po_lines_all pla, po_distributions_all pda
1765: WHERE pda.destination_type_code = 'SHOP FLOOR' AND (pda.PO_RELEASE_ID IS NOT NULL OR pda.DISTRIBUTION_TYPE = 'STANDARD')
1766: AND pla.line_type_id = plt.line_type_id
1767: AND upper(nvl(plt.outside_operation_flag, 'N')) = 'N' AND pla.po_line_id = pda.po_line_id
1768: AND pla.unit_meas_lookup_code = uom.unit_of_measure (+)
1769: AND upper(nvl(pla.cancel_flag, 'N')) <> 'Y' AND pla.item_description = l_item_description
1873: end if; -- end of p_rcv_txn_id not null
1874:
1875:
1876: -- End of API body.
1877: -- Standard check of p_commit.
1878: IF fnd_api.to_boolean(p_commit) THEN
1879: COMMIT WORK;
1880: END IF;
1881:
1879: COMMIT WORK;
1880: END IF;
1881:
1882: l_stmt_num := 999;
1883: -- Standard call to get message count and if count is 1, get message info.
1884: fnd_msg_pub.count_and_get(
1885: p_encoded => fnd_api.g_false
1886: ,p_count => x_msg_count
1887: ,p_data => x_msg_data);