[Home] [Help]
2733: l_api_version CONSTANT NUMBER := 1.0;
2734: l_stock_markets_rec STOCK_MARKETS_REC_TYPE := p_stock_markets_rec;
2735:
2736: BEGIN
2737: --Standard start of API savepoint
2738: SAVEPOINT create_stock_markets_pub;
2739: --Standard call to check for call compatibility.
2740: IF NOT FND_API.Compatible_API_Call(
2741: l_api_version,
2735:
2736: BEGIN
2737: --Standard start of API savepoint
2738: SAVEPOINT create_stock_markets_pub;
2739: --Standard call to check for call compatibility.
2740: IF NOT FND_API.Compatible_API_Call(
2741: l_api_version,
2742: p_api_version,
2743: l_api_name,
2812: hz_business_event_v2pvt.create_stock_markets_event(l_stock_markets_rec);
2813: END IF;
2814: END IF;
2815:
2816: --Standard check of p_commit.
2817: IF FND_API.to_Boolean(p_commit) THEN
2818: Commit;
2819: END IF;
2820:
2817: IF FND_API.to_Boolean(p_commit) THEN
2818: Commit;
2819: END IF;
2820:
2821: --Standard call to get message count and if count is 1, get message info.
2822: FND_MSG_PUB.Count_And_Get(
2823: p_encoded => FND_API.G_FALSE,
2824: p_count => x_msg_count,
2825: p_data => x_msg_data);
2903: l_api_version CONSTANT NUMBER := 1.0;
2904: l_stock_markets_rec STOCK_MARKETS_REC_TYPE := p_stock_markets_rec;
2905: l_old_stock_markets_rec STOCK_MARKETS_REC_TYPE;
2906: BEGIN
2907: --Standard start of API savepoint
2908: SAVEPOINT update_stock_markets_pub;
2909: --Standard call to check for call compatibility.
2910: IF NOT FND_API.Compatible_API_Call(
2911: l_api_version,
2905: l_old_stock_markets_rec STOCK_MARKETS_REC_TYPE;
2906: BEGIN
2907: --Standard start of API savepoint
2908: SAVEPOINT update_stock_markets_pub;
2909: --Standard call to check for call compatibility.
2910: IF NOT FND_API.Compatible_API_Call(
2911: l_api_version,
2912: p_api_version,
2913: l_api_name,
2997: hz_business_event_v2pvt.update_stock_markets_event(l_stock_markets_rec);
2998: END IF;
2999: END IF;
3000:
3001: --Standard check of p_commit.
3002: IF FND_API.to_Boolean(p_commit) THEN
3003: Commit;
3004: END IF;
3005:
3002: IF FND_API.to_Boolean(p_commit) THEN
3003: Commit;
3004: END IF;
3005:
3006: --Standard call to get message count and if count is 1, get message info.
3007: FND_MSG_PUB.Count_And_Get(
3008: p_encoded => FND_API.G_FALSE,
3009: p_count => x_msg_count,
3010: p_data => x_msg_data);
3087: l_api_version CONSTANT NUMBER := 1.0;
3088: l_security_issued_rec SECURITY_ISSUED_REC_TYPE := p_security_issued_rec;
3089:
3090: BEGIN
3091: --Standard start of API savepoint
3092: SAVEPOINT create_security_issued_pub;
3093: --Standard call to check for call compatibility.
3094: IF NOT FND_API.Compatible_API_Call(
3095: l_api_version,
3089:
3090: BEGIN
3091: --Standard start of API savepoint
3092: SAVEPOINT create_security_issued_pub;
3093: --Standard call to check for call compatibility.
3094: IF NOT FND_API.Compatible_API_Call(
3095: l_api_version,
3096: p_api_version,
3097: l_api_name,
3166: hz_business_event_v2pvt.create_sec_issued_event(l_security_issued_rec);
3167: END IF;
3168: END IF;
3169:
3170: --Standard check of p_commit.
3171: IF FND_API.to_Boolean(p_commit) THEN
3172: Commit;
3173: END IF;
3174:
3171: IF FND_API.to_Boolean(p_commit) THEN
3172: Commit;
3173: END IF;
3174:
3175: --Standard call to get message count and if count is 1, get message info.
3176: FND_MSG_PUB.Count_And_Get(
3177: p_encoded => FND_API.G_FALSE,
3178: p_count => x_msg_count,
3179: p_data => x_msg_data);
3257: l_api_version CONSTANT NUMBER := 1.0;
3258: l_security_issued_rec SECURITY_ISSUED_REC_TYPE := p_security_issued_rec;
3259: l_old_security_issued_rec SECURITY_ISSUED_REC_TYPE;
3260: BEGIN
3261: --Standard start of API savepoint
3262: SAVEPOINT update_security_issued_pub;
3263: --Standard call to check for call compatibility.
3264: IF NOT FND_API.Compatible_API_Call(
3265: l_api_version,
3259: l_old_security_issued_rec SECURITY_ISSUED_REC_TYPE;
3260: BEGIN
3261: --Standard start of API savepoint
3262: SAVEPOINT update_security_issued_pub;
3263: --Standard call to check for call compatibility.
3264: IF NOT FND_API.Compatible_API_Call(
3265: l_api_version,
3266: p_api_version,
3267: l_api_name,
3351: hz_business_event_v2pvt.update_sec_issued_event(l_security_issued_rec);
3352: END IF;
3353: END IF;
3354:
3355: --Standard check of p_commit.
3356: IF FND_API.to_Boolean(p_commit) THEN
3357: Commit;
3358: END IF;
3359:
3356: IF FND_API.to_Boolean(p_commit) THEN
3357: Commit;
3358: END IF;
3359:
3360: --Standard call to get message count and if count is 1, get message info.
3361: FND_MSG_PUB.Count_And_Get(
3362: p_encoded => FND_API.G_FALSE,
3363: p_count => x_msg_count,
3364: p_data => x_msg_data);
3446: l_financial_reports_rec FINANCIAL_REPORTS_REC_TYPE := p_financial_reports_rec;
3447:
3448: BEGIN
3449:
3450: --Standard start of API savepoint
3451: SAVEPOINT create_financial_reports_pub;
3452:
3453: --Standard call to check for call compatibility.
3454: IF NOT FND_API.Compatible_API_Call(
3449:
3450: --Standard start of API savepoint
3451: SAVEPOINT create_financial_reports_pub;
3452:
3453: --Standard call to check for call compatibility.
3454: IF NOT FND_API.Compatible_API_Call(
3455: l_api_version,
3456: p_api_version,
3457: l_api_name,
3529: THEN
3530: HZ_BUSINESS_EVENT_V2PVT.create_fin_reports_event(l_financial_reports_rec);
3531: END IF;
3532: *
3533: --Standard check of p_commit.
3534: IF FND_API.to_Boolean(p_commit) THEN
3535: Commit;
3536: END IF;
3537:
3534: IF FND_API.to_Boolean(p_commit) THEN
3535: Commit;
3536: END IF;
3537:
3538: --Standard call to get message count and if count is 1, get message info.
3539: FND_MSG_PUB.Count_And_Get(
3540: p_encoded => FND_API.G_FALSE,
3541: p_count => x_msg_count,
3542: p_data => x_msg_data);
3630: l_old_financial_reports_rec FINANCIAL_REPORTS_REC_TYPE;
3631:
3632: BEGIN
3633:
3634: --Standard start of API savepoint
3635: SAVEPOINT update_financial_reports_pub;
3636:
3637: --Standard call to check for call compatibility.
3638: IF NOT FND_API.Compatible_API_Call(
3633:
3634: --Standard start of API savepoint
3635: SAVEPOINT update_financial_reports_pub;
3636:
3637: --Standard call to check for call compatibility.
3638: IF NOT FND_API.Compatible_API_Call(
3639: l_api_version,
3640: p_api_version,
3641: l_api_name,
3719: THEN
3720: HZ_BUSINESS_EVENT_V2PVT.update_fin_reports_event(l_financial_reports_rec);
3721: END IF;
3722: *
3723: --Standard check of p_commit.
3724: IF FND_API.to_Boolean(p_commit) THEN
3725: Commit;
3726: END IF;
3727:
3724: IF FND_API.to_Boolean(p_commit) THEN
3725: Commit;
3726: END IF;
3727:
3728: --Standard call to get message count and if count is 1, get message info.
3729: FND_MSG_PUB.Count_And_Get(
3730: p_encoded => FND_API.G_FALSE,
3731: p_count => x_msg_count,
3732: p_data => x_msg_data);
3819: l_financial_numbers_rec FINANCIAL_NUMBERS_REC_TYPE := p_financial_numbers_rec;
3820:
3821: BEGIN
3822:
3823: --Standard start of API savepoint
3824: SAVEPOINT create_financial_numbers_pub;
3825:
3826: --Standard call to check for call compatibility.
3827: IF NOT FND_API.Compatible_API_Call(
3822:
3823: --Standard start of API savepoint
3824: SAVEPOINT create_financial_numbers_pub;
3825:
3826: --Standard call to check for call compatibility.
3827: IF NOT FND_API.Compatible_API_Call(
3828: l_api_version,
3829: p_api_version,
3830: l_api_name,
3882: HZ_BUSINESS_EVENT_V2PVT.create_fin_numbers_event(l_financial_numbers_rec);
3883: END IF;
3884: *
3885:
3886: --Standard check of p_commit.
3887: IF FND_API.to_Boolean(p_commit) THEN
3888: Commit;
3889: END IF;
3890:
3887: IF FND_API.to_Boolean(p_commit) THEN
3888: Commit;
3889: END IF;
3890:
3891: --Standard call to get message count and if count is 1, get message info.
3892: FND_MSG_PUB.Count_And_Get(
3893: p_encoded => FND_API.G_FALSE,
3894: p_count => x_msg_count,
3895: p_data => x_msg_data);
3983: l_old_financial_numbers_rec FINANCIAL_NUMBERS_REC_TYPE;
3984:
3985: BEGIN
3986:
3987: --Standard start of API savepoint
3988: SAVEPOINT update_financial_numbers_pub;
3989:
3990: --Standard call to check for call compatibility.
3991: IF NOT FND_API.Compatible_API_Call(
3986:
3987: --Standard start of API savepoint
3988: SAVEPOINT update_financial_numbers_pub;
3989:
3990: --Standard call to check for call compatibility.
3991: IF NOT FND_API.Compatible_API_Call(
3992: l_api_version,
3993: p_api_version,
3994: l_api_name,
4061: HZ_BUSINESS_EVENT_V2PVT.update_fin_numbers_event(l_financial_numbers_rec);
4062: END IF;
4063: *
4064:
4065: --Standard check of p_commit.
4066: IF FND_API.to_Boolean(p_commit) THEN
4067: Commit;
4068: END IF;
4069:
4066: IF FND_API.to_Boolean(p_commit) THEN
4067: Commit;
4068: END IF;
4069:
4070: --Standard call to get message count and if count is 1, get message info.
4071: FND_MSG_PUB.Count_And_Get(
4072: p_encoded => FND_API.G_FALSE,
4073: p_count => x_msg_count,
4074: p_data => x_msg_data);
4155: l_api_version CONSTANT NUMBER := 1.0;
4156: l_certifications_rec CERTIFICATIONS_REC_TYPE := p_certifications_rec;
4157:
4158: BEGIN
4159: --Standard start of API savepoint
4160: SAVEPOINT create_certifications_pub;
4161: --Standard call to check for call compatibility.
4162: IF NOT FND_API.Compatible_API_Call(
4163: l_api_version,
4157:
4158: BEGIN
4159: --Standard start of API savepoint
4160: SAVEPOINT create_certifications_pub;
4161: --Standard call to check for call compatibility.
4162: IF NOT FND_API.Compatible_API_Call(
4163: l_api_version,
4164: p_api_version,
4165: l_api_name,
4240: p_certification_id => x_certification_id);
4241: END IF;
4242: END IF;
4243:
4244: --Standard check of p_commit.
4245: IF FND_API.to_Boolean(p_commit) THEN
4246: Commit;
4247: END IF;
4248:
4245: IF FND_API.to_Boolean(p_commit) THEN
4246: Commit;
4247: END IF;
4248:
4249: --Standard call to get message count and if count is 1, get message info.
4250: FND_MSG_PUB.Count_And_Get(
4251: p_encoded => FND_API.G_FALSE,
4252: p_count => x_msg_count,
4253: p_data => x_msg_data);
4329: l_certifications_rec CERTIFICATIONS_REC_TYPE := p_certifications_rec;
4330: l_old_certifications_rec CERTIFICATIONS_REC_TYPE ;
4331:
4332: BEGIN
4333: --Standard start of API savepoint
4334: SAVEPOINT update_certifications_pub;
4335: --Standard call to check for call compatibility.
4336: IF NOT FND_API.Compatible_API_Call(
4337: l_api_version,
4331:
4332: BEGIN
4333: --Standard start of API savepoint
4334: SAVEPOINT update_certifications_pub;
4335: --Standard call to check for call compatibility.
4336: IF NOT FND_API.Compatible_API_Call(
4337: l_api_version,
4338: p_api_version,
4339: l_api_name,
4430: p_certification_id => l_certifications_rec.certification_id);
4431: END IF;
4432: END IF;
4433:
4434: --Standard check of p_commit.
4435: IF FND_API.to_Boolean(p_commit) THEN
4436: Commit;
4437: END IF;
4438:
4435: IF FND_API.to_Boolean(p_commit) THEN
4436: Commit;
4437: END IF;
4438:
4439: --Standard call to get message count and if count is 1, get message info.
4440: FND_MSG_PUB.Count_And_Get(
4441: p_encoded => FND_API.G_FALSE,
4442: p_count => x_msg_count,
4443: p_data => x_msg_data);
4520: l_api_version CONSTANT NUMBER := 1.0;
4521: l_industrial_reference_rec INDUSTRIAL_REFERENCE_REC_TYPE := p_industrial_reference_rec;
4522:
4523: BEGIN
4524: --Standard start of API savepoint
4525: SAVEPOINT create_industrial_ref_pub;
4526: --Standard call to check for call compatibility.
4527: IF NOT FND_API.Compatible_API_Call(
4528: l_api_version,
4522:
4523: BEGIN
4524: --Standard start of API savepoint
4525: SAVEPOINT create_industrial_ref_pub;
4526: --Standard call to check for call compatibility.
4527: IF NOT FND_API.Compatible_API_Call(
4528: l_api_version,
4529: p_api_version,
4530: l_api_name,
4593: END IF;
4594: */
4595:
4596:
4597: --Standard check of p_commit.
4598: IF FND_API.to_Boolean(p_commit) THEN
4599: Commit;
4600: END IF;
4601:
4598: IF FND_API.to_Boolean(p_commit) THEN
4599: Commit;
4600: END IF;
4601:
4602: --Standard call to get message count and if count is 1, get message info.
4603: FND_MSG_PUB.Count_And_Get(
4604: p_encoded => FND_API.G_FALSE,
4605: p_count => x_msg_count,
4606: p_data => x_msg_data);
4682: l_api_name CONSTANT VARCHAR2(30) := 'update industrial reference';
4683: l_api_version CONSTANT NUMBER := 1.0;
4684: l_industrial_reference_rec INDUSTRIAL_REFERENCE_REC_TYPE := p_industrial_reference_rec;
4685: BEGIN
4686: --Standard start of API savepoint
4687: SAVEPOINT update_industrial_ref_pub;
4688: --Standard call to check for call compatibility.
4689: IF NOT FND_API.Compatible_API_Call(
4690: l_api_version,
4684: l_industrial_reference_rec INDUSTRIAL_REFERENCE_REC_TYPE := p_industrial_reference_rec;
4685: BEGIN
4686: --Standard start of API savepoint
4687: SAVEPOINT update_industrial_ref_pub;
4688: --Standard call to check for call compatibility.
4689: IF NOT FND_API.Compatible_API_Call(
4690: l_api_version,
4691: p_api_version,
4692: l_api_name,
4753:
4754: END IF;
4755: */
4756:
4757: --Standard check of p_commit.
4758: IF FND_API.to_Boolean(p_commit) THEN
4759: Commit;
4760: END IF;
4761:
4758: IF FND_API.to_Boolean(p_commit) THEN
4759: Commit;
4760: END IF;
4761:
4762: --Standard call to get message count and if count is 1, get message info.
4763: FND_MSG_PUB.Count_And_Get(
4764: p_encoded => FND_API.G_FALSE,
4765: p_count => x_msg_count,
4766: p_data => x_msg_data);
4842: l_api_name CONSTANT VARCHAR2(30) := 'create industrial classes';
4843: l_api_version CONSTANT NUMBER := 1.0;
4844: l_industrial_classes_rec INDUSTRIAL_CLASSES_REC_TYPE := p_industrial_classes_rec;
4845: BEGIN
4846: --Standard start of API savepoint
4847: SAVEPOINT create_industrial_classes_pub;
4848: --Standard call to check for call compatibility.
4849: IF NOT FND_API.Compatible_API_Call(
4850: l_api_version,
4844: l_industrial_classes_rec INDUSTRIAL_CLASSES_REC_TYPE := p_industrial_classes_rec;
4845: BEGIN
4846: --Standard start of API savepoint
4847: SAVEPOINT create_industrial_classes_pub;
4848: --Standard call to check for call compatibility.
4849: IF NOT FND_API.Compatible_API_Call(
4850: l_api_version,
4851: p_api_version,
4852: l_api_name,
4913:
4914: END IF;
4915: */
4916:
4917: --Standard check of p_commit.
4918: IF FND_API.to_Boolean(p_commit) THEN
4919: Commit;
4920: END IF;
4921:
4918: IF FND_API.to_Boolean(p_commit) THEN
4919: Commit;
4920: END IF;
4921:
4922: --Standard call to get message count and if count is 1, get message info.
4923: FND_MSG_PUB.Count_And_Get(
4924: p_encoded => FND_API.G_FALSE,
4925: p_count => x_msg_count,
4926: p_data => x_msg_data);
5004: l_api_version CONSTANT NUMBER := 1.0;
5005: l_industrial_classes_rec INDUSTRIAL_CLASSES_REC_TYPE := p_industrial_classes_rec;
5006: l_old_industrial_classes_rec INDUSTRIAL_CLASSES_REC_TYPE;
5007: BEGIN
5008: --Standard start of API savepoint
5009: SAVEPOINT update_industrial_classes_pub;
5010: --Standard call to check for call compatibility.
5011: IF NOT FND_API.Compatible_API_Call(
5012: l_api_version,
5006: l_old_industrial_classes_rec INDUSTRIAL_CLASSES_REC_TYPE;
5007: BEGIN
5008: --Standard start of API savepoint
5009: SAVEPOINT update_industrial_classes_pub;
5010: --Standard call to check for call compatibility.
5011: IF NOT FND_API.Compatible_API_Call(
5012: l_api_version,
5013: p_api_version,
5014: l_api_name,
5087:
5088: END IF;
5089: */
5090:
5091: --Standard check of p_commit.
5092: IF FND_API.to_Boolean(p_commit) THEN
5093: Commit;
5094: END IF;
5095:
5092: IF FND_API.to_Boolean(p_commit) THEN
5093: Commit;
5094: END IF;
5095:
5096: --Standard call to get message count and if count is 1, get message info.
5097: FND_MSG_PUB.Count_And_Get(
5098: p_encoded => FND_API.G_FALSE,
5099: p_count => x_msg_count,
5100: p_data => x_msg_data);
5176: l_api_name CONSTANT VARCHAR2(30) := 'create industrial class app';
5177: l_api_version CONSTANT NUMBER := 1.0;
5178: l_industrial_class_app_rec INDUSTRIAL_CLASS_APP_REC_TYPE := p_industrial_class_app_rec;
5179: BEGIN
5180: --Standard start of API savepoint
5181: SAVEPOINT create_indus_class_app_pub;
5182: --Standard call to check for call compatibility.
5183: IF NOT FND_API.Compatible_API_Call(
5184: l_api_version,
5178: l_industrial_class_app_rec INDUSTRIAL_CLASS_APP_REC_TYPE := p_industrial_class_app_rec;
5179: BEGIN
5180: --Standard start of API savepoint
5181: SAVEPOINT create_indus_class_app_pub;
5182: --Standard call to check for call compatibility.
5183: IF NOT FND_API.Compatible_API_Call(
5184: l_api_version,
5185: p_api_version,
5186: l_api_name,
5248:
5249: END IF;
5250: */
5251:
5252: --Standard check of p_commit.
5253: IF FND_API.to_Boolean(p_commit) THEN
5254: Commit;
5255: END IF;
5256:
5253: IF FND_API.to_Boolean(p_commit) THEN
5254: Commit;
5255: END IF;
5256:
5257: --Standard call to get message count and if count is 1, get message info.
5258: FND_MSG_PUB.Count_And_Get(
5259: p_encoded => FND_API.G_FALSE,
5260: p_count => x_msg_count,
5261: p_data => x_msg_data);
5337: l_api_name CONSTANT VARCHAR2(30) := 'update industrial class app';
5338: l_api_version CONSTANT NUMBER := 1.0;
5339: l_industrial_class_app_rec INDUSTRIAL_CLASS_APP_REC_TYPE := p_industrial_class_app_rec;
5340: BEGIN
5341: --Standard start of API savepoint
5342: SAVEPOINT update_indus_class_app_pub;
5343: --Standard call to check for call compatibility.
5344: IF NOT FND_API.Compatible_API_Call(
5345: l_api_version,
5339: l_industrial_class_app_rec INDUSTRIAL_CLASS_APP_REC_TYPE := p_industrial_class_app_rec;
5340: BEGIN
5341: --Standard start of API savepoint
5342: SAVEPOINT update_indus_class_app_pub;
5343: --Standard call to check for call compatibility.
5344: IF NOT FND_API.Compatible_API_Call(
5345: l_api_version,
5346: p_api_version,
5347: l_api_name,
5409:
5410: END IF;
5411: */
5412:
5413: --Standard check of p_commit.
5414: IF FND_API.to_Boolean(p_commit) THEN
5415: Commit;
5416: END IF;
5417:
5414: IF FND_API.to_Boolean(p_commit) THEN
5415: Commit;
5416: END IF;
5417:
5418: --Standard call to get message count and if count is 1, get message info.
5419: FND_MSG_PUB.Count_And_Get(
5420: p_encoded => FND_API.G_FALSE,
5421: p_count => x_msg_count,
5422: p_data => x_msg_data);
5466: l_api_version CONSTANT NUMBER := 1.0;
5467:
5468: BEGIN
5469:
5470: --Standard call to check for call compatibility.
5471: IF NOT FND_API.Compatible_API_Call(
5472: l_api_version,
5473: p_api_version,
5474: l_api_name,
5562: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_financial_report_id));
5563: FND_MSG_PUB.ADD;
5564: RAISE FND_API.G_EXC_ERROR;
5565: END;
5566: --Standard call to get message count and if count is 1, get message info.
5567: FND_MSG_PUB.Count_And_Get(
5568: p_encoded => FND_API.G_FALSE,
5569: p_count => x_msg_count,
5570: p_data => x_msg_data);
5611: l_api_version CONSTANT NUMBER := 1.0;
5612:
5613: BEGIN
5614:
5615: --Standard call to check for call compatibility.
5616: IF NOT FND_API.Compatible_API_Call(
5617: l_api_version,
5618: p_api_version,
5619: l_api_name,
5674: FND_MESSAGE.SET_TOKEN('VALUE', to_char(p_financial_number_id));
5675: FND_MSG_PUB.ADD;
5676: RAISE FND_API.G_EXC_ERROR;
5677: END;
5678: --Standard call to get message count and if count is 1, get message info.
5679: FND_MSG_PUB.Count_And_Get(
5680: p_encoded => FND_API.G_FALSE,
5681: p_count => x_msg_count,
5682: p_data => x_msg_data);