[Home] [Help]
206: and organization_id = p_organization_id
207: order by resource_seq_num desc;
208:
209: BEGIN
210: -- Standard Start of API savepoint
211: l_stmt_num := 10;
212: SAVEPOINT get_resource_validate_pvt;
213:
214: l_stmt_num := 20;
211: l_stmt_num := 10;
212: SAVEPOINT get_resource_validate_pvt;
213:
214: l_stmt_num := 20;
215: -- Standard call to check for call compatibility.
216: IF NOT fnd_api.compatible_api_call(
217: l_api_version
218: ,p_api_version
219: ,l_api_name
537: x_charge_dept_id := l_actual_charge_dept_id;
538: x_instance_id := l_instance_id;
539:
540: -- End of API body.
541: -- Standard check of p_commit.
542: IF fnd_api.to_boolean(p_commit) THEN
543: COMMIT WORK;
544: END IF;
545:
543: COMMIT WORK;
544: END IF;
545:
546: l_stmt_num := 999;
547: -- Standard call to get message count and if count is 1, get message info.
548: fnd_msg_pub.count_and_get(
549: p_count => x_msg_count
550: ,p_data => x_msg_data);
551: EXCEPTION
630: l_usage_rate_or_amount NUMBER := 0;
631: l_basis_type NUMBER := 0;
632: l_activity_id NUMBER := 0;
633: l_activity_name VARCHAR2(10) ;
634: l_standard_rate_flag NUMBER := 0;
635: l_acct_period_id NUMBER := 0;
636: l_department_id NUMBER := 0;
637: l_department_code VARCHAR2(10) ;
638: l_reason_id NUMBER := 0;
657: operation_seq_num = l_operation_seq_num1 ;
658:
659:
660: BEGIN
661: -- Standard Start of API savepoint
662: l_stmt_num := 10;
663: SAVEPOINT get_insert_into_wcti_pvt;
664:
665: l_stmt_num := 20;
662: l_stmt_num := 10;
663: SAVEPOINT get_insert_into_wcti_pvt;
664:
665: l_stmt_num := 20;
666: -- Standard call to check for call compatibility.
667: IF NOT fnd_api.compatible_api_call(
668: l_api_version
669: ,p_api_version
670: ,l_api_name
760: if (p_reason_name is not null) then
761: select reason_id into l_reason_id from mtl_transaction_reasons where reason_name = p_reason_name;
762: end if;
763:
764: -- Get resource_id, resource_code, resource_type, uom, basis_type, activity_id, activity and standard_rate_flag
765:
766: if (p_resource_code is not null) then
767: l_stmt_num := 150;
768: select br.resource_id,
771: br.unit_of_measure uom_code,
772: br.default_basis_type basis_type,
773: ca.activity_id,
774: ca.activity,
775: br.standard_rate_flag
776: into
777: l_resource_id,
778: l_resource_code,
779: l_resource_type,
780: l_uom,
781: l_basis_type,
782: l_activity_id,
783: l_activity_name,
784: l_standard_rate_flag
785: from
786: cst_activities ca,
787: bom_department_resources bdr,
788: bom_resources br
895: ,ACTIVITY_ID
896: ,SCHEDULED_FLAG
897: ,ASSIGNED_UNITS
898: ,AUTOCHARGE_TYPE
899: ,STANDARD_RATE_FLAG
900: ,APPLIED_RESOURCE_UNITS
901: ,APPLIED_RESOURCE_VALUE
902: ,START_DATE
903: ,COMPLETION_DATE
957: ,null -- activity id
958: ,2 -- scheduled flag
959: ,1 -- assigned units
960: ,2 --autocharge type
961: ,2 -- standard rate flag
962: ,0 -- applied resource units
963: ,0 -- applied resource value
964: ,l_start_date
965: ,l_completion_date
1044: resource_type,
1045: usage_rate_or_amount,
1046: basis_type,
1047: autocharge_type,
1048: standard_rate_flag,
1049: transaction_quantity,
1050: transaction_uom,
1051: primary_quantity,
1052: primary_uom,
1131: l_resource_type,
1132: decode(l_usage_rate_or_amount,0,null,l_usage_rate_or_amount), --usage_rate_or_amount
1133: l_basis_type,
1134: 2, -- autocharge_type
1135: l_standard_rate_flag,
1136: p_transaction_qty,
1137: l_txn_uom,
1138: l_primary_qty,
1139: l_uom,
1205:
1206:
1207:
1208: -- End of API body.
1209: -- Standard check of p_commit.
1210: IF fnd_api.to_boolean(p_commit) THEN
1211: COMMIT WORK;
1212: END IF;
1213:
1211: COMMIT WORK;
1212: END IF;
1213:
1214: l_stmt_num := 999;
1215: -- Standard call to get message count and if count is 1, get message info.
1216: fnd_msg_pub.count_and_get(
1217: p_count => x_msg_count
1218: ,p_data => x_msg_data);
1219: EXCEPTION
1282: instance_id = p_instance_id ;
1283:
1284:
1285: BEGIN
1286: -- Standard Start of API savepoint
1287: l_stmt_num := 10;
1288: SAVEPOINT get_insert_into_wori_pvt;
1289:
1290: l_stmt_num := 20;
1287: l_stmt_num := 10;
1288: SAVEPOINT get_insert_into_wori_pvt;
1289:
1290: l_stmt_num := 20;
1291: -- Standard call to check for call compatibility.
1292: IF NOT fnd_api.compatible_api_call(
1293: l_api_version
1294: ,p_api_version
1295: ,l_api_name
1380:
1381: l_stmt_num := 800;
1382:
1383: -- End of API body.
1384: -- Standard check of p_commit.
1385: IF fnd_api.to_boolean(p_commit) THEN
1386: COMMIT WORK;
1387: END IF;
1388:
1386: COMMIT WORK;
1387: END IF;
1388:
1389: l_stmt_num := 999;
1390: -- Standard call to get message count and if count is 1, get message info.
1391: fnd_msg_pub.count_and_get(
1392: p_count => x_msg_count
1393: ,p_data => x_msg_data);
1394: EXCEPTION
1465:
1466:
1467: BEGIN
1468:
1469: -- Standard Start of API savepoint
1470: l_stmt_num := 10;
1471: SAVEPOINT wip_eamrcvdirectitem_pvt;
1472:
1473: l_stmt_num := 20;
1470: l_stmt_num := 10;
1471: SAVEPOINT wip_eamrcvdirectitem_pvt;
1472:
1473: l_stmt_num := 20;
1474: -- Standard call to check for call compatibility.
1475: IF NOT fnd_api.compatible_api_call(
1476: l_api_version
1477: ,p_api_version
1478: ,l_api_name
1805: end if; -- end of p_rcv_txn_id not null
1806:
1807:
1808: -- End of API body.
1809: -- Standard check of p_commit.
1810: IF fnd_api.to_boolean(p_commit) THEN
1811: COMMIT WORK;
1812: END IF;
1813:
1811: COMMIT WORK;
1812: END IF;
1813:
1814: l_stmt_num := 999;
1815: -- Standard call to get message count and if count is 1, get message info.
1816: fnd_msg_pub.count_and_get(
1817: p_encoded => fnd_api.g_false
1818: ,p_count => x_msg_count
1819: ,p_data => x_msg_data);