DBA Data[Home] [Help]

APPS.CSI_COUNTER_TEMPLATE_PVT dependencies on STANDARD

Line 551: -- Standard Start of API savepoint

547: l_SOURCE_COUNTER_GROUP_ID NUMBER;
548: l_SECURITY_GROUP_ID NUMBER;
549: l_UPGRADED_STATUS_FLAG VARCHAR2(1);
550: BEGIN
551: -- Standard Start of API savepoint
552: SAVEPOINT create_counter_group_pvt;
553:
554: -- Standard call to check for call compatibility.
555: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 554: -- Standard call to check for call compatibility.

550: BEGIN
551: -- Standard Start of API savepoint
552: SAVEPOINT create_counter_group_pvt;
553:
554: -- Standard call to check for call compatibility.
555: IF NOT FND_API.Compatible_API_Call (l_api_version,
556: p_api_version,
557: l_api_name ,
558: G_PKG_NAME ) THEN

Line 791: -- Standard call to get message count and IF count is get message info.

787: IF FND_API.to_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
788: COMMIT WORK;
789: END IF;
790:
791: -- Standard call to get message count and IF count is get message info.
792: FND_MSG_PUB.Count_And_Get
793: ( p_count => x_msg_count,
794: p_data => x_msg_data
795: );

Line 902: -- Standard Start of API savepoint

898: from csi_counter_template_b
899: where counter_id = p_counter_id;
900:
901: BEGIN
902: -- Standard Start of API savepoint
903: SAVEPOINT create_item_association_pvt;
904:
905: -- Standard call to check for call compatibility.
906: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 905: -- Standard call to check for call compatibility.

901: BEGIN
902: -- Standard Start of API savepoint
903: SAVEPOINT create_item_association_pvt;
904:
905: -- Standard call to check for call compatibility.
906: IF NOT FND_API.Compatible_API_Call (l_api_version,
907: p_api_version,
908: l_api_name ,
909: G_PKG_NAME ) THEN

Line 1290: -- Standard call to get message count and IF count is get message info.

1286: IF FND_API.to_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
1287: COMMIT WORK;
1288: END IF;
1289:
1290: -- Standard call to get message count and IF count is get message info.
1291: FND_MSG_PUB.Count_And_Get
1292: ( p_count => x_msg_count,
1293: p_data => x_msg_data
1294: );

Line 1429: -- Standard Start of API savepoint

1425: from cs_csi_counter_groups
1426: where counter_group_id = p_group_id;
1427:
1428: BEGIN
1429: -- Standard Start of API savepoint
1430: SAVEPOINT create_counter_template_pvt;
1431:
1432: -- Standard call to check for call compatibility.
1433: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 1432: -- Standard call to check for call compatibility.

1428: BEGIN
1429: -- Standard Start of API savepoint
1430: SAVEPOINT create_counter_template_pvt;
1431:
1432: -- Standard call to check for call compatibility.
1433: IF NOT FND_API.Compatible_API_Call (l_api_version,
1434: p_api_version,
1435: l_api_name ,
1436: G_PKG_NAME ) THEN

Line 2021: -- Standard call to get message count and IF count is get message info.

2017: IF FND_API.to_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
2018: COMMIT WORK;
2019: END IF;
2020:
2021: -- Standard call to get message count and IF count is get message info.
2022: FND_MSG_PUB.Count_And_Get
2023: ( p_count => x_msg_count,
2024: p_data => x_msg_data
2025: );

Line 2118: -- Standard Start of API savepoint

2114: l_MIGRATED_FLAG VARCHAR2(1);
2115: l_NAME VARCHAR2(50);
2116: l_DESCRIPTION VARCHAR2(240);
2117: BEGIN
2118: -- Standard Start of API savepoint
2119: SAVEPOINT create_ctr_property_tmpl_pvt;
2120:
2121: -- Standard call to check for call compatibility.
2122: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 2121: -- Standard call to check for call compatibility.

2117: BEGIN
2118: -- Standard Start of API savepoint
2119: SAVEPOINT create_ctr_property_tmpl_pvt;
2120:
2121: -- Standard call to check for call compatibility.
2122: IF NOT FND_API.Compatible_API_Call (l_api_version,
2123: p_api_version,
2124: l_api_name ,
2125: G_PKG_NAME ) THEN

Line 2405: -- Standard call to get message count and IF count is get message info.

2401: IF FND_API.to_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
2402: COMMIT WORK;
2403: END IF;
2404:
2405: -- Standard call to get message count and IF count is get message info.
2406: FND_MSG_PUB.Count_And_Get
2407: ( p_count => x_msg_count,
2408: p_data => x_msg_data
2409: );

Line 2512: -- Standard Start of API savepoint

2508: SELECT max(value_timestamp)
2509: FROM csi_counter_readings
2510: WHERE counter_id = p_counter_id;
2511: BEGIN
2512: -- Standard Start of API savepoint
2513: SAVEPOINT create_ctr_relationship_pvt;
2514:
2515: -- Standard call to check for call compatibility.
2516: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 2515: -- Standard call to check for call compatibility.

2511: BEGIN
2512: -- Standard Start of API savepoint
2513: SAVEPOINT create_ctr_relationship_pvt;
2514:
2515: -- Standard call to check for call compatibility.
2516: IF NOT FND_API.Compatible_API_Call (l_api_version,
2517: p_api_version,
2518: l_api_name ,
2519: G_PKG_NAME ) THEN

Line 2830: -- Standard call to get message count and IF count is get message info.

2826: IF FND_API.to_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
2827: COMMIT WORK;
2828: END IF;
2829:
2830: -- Standard call to get message count and IF count is get message info.
2831: FND_MSG_PUB.Count_And_Get
2832: ( p_count => x_msg_count,
2833: p_data => x_msg_data
2834: );

Line 2902: -- Standard Start of API savepoint

2898: l_return_status VARCHAR2(1);
2899: l_valid_flag VARCHAR2(1);
2900:
2901: BEGIN
2902: -- Standard Start of API savepoint
2903: SAVEPOINT create_derived_filters;
2904:
2905: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
2906:

Line 2909: -- Standard call to check for call compatibility.

2905: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
2906:
2907: -- csi_ctr_gen_utility_pvt.check_ib_active;
2908:
2909: -- Standard call to check for call compatibility.
2910: IF NOT FND_API.Compatible_API_Call (l_api_version,
2911: p_api_version,
2912: l_api_name ,
2913: G_PKG_NAME )

Line 3126: -- Standard check of p_commit.

3122: --l_ctr_derived_filters_rec.OBJECT_VERSION_NUMBER := 1;
3123:
3124: -- End of API body
3125:
3126: -- Standard check of p_commit.
3127: IF FND_API.To_Boolean( p_commit ) THEN
3128: COMMIT WORK;
3129: END IF;
3130:

Line 3238: -- Standard Start of API savepoint

3234: -- l_debug_level NUMBER;
3235:
3236: l_counter_groups_rec CSI_CTR_DATASTRUCTURES_PUB.counter_groups_rec;
3237: BEGIN
3238: -- Standard Start of API savepoint
3239: SAVEPOINT update_counter_group_pvt;
3240:
3241: -- Standard call to check for call compatibility.
3242: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 3241: -- Standard call to check for call compatibility.

3237: BEGIN
3238: -- Standard Start of API savepoint
3239: SAVEPOINT update_counter_group_pvt;
3240:
3241: -- Standard call to check for call compatibility.
3242: IF NOT FND_API.Compatible_API_Call (l_api_version,
3243: p_api_version,
3244: l_api_name ,
3245: G_PKG_NAME ) THEN

Line 3502: -- Standard call to get message count and IF count is get message info.

3498: IF FND_API.to_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
3499: COMMIT WORK;
3500: END IF;
3501:
3502: -- Standard call to get message count and IF count is get message info.
3503: FND_MSG_PUB.Count_And_Get
3504: ( p_count => x_msg_count,
3505: p_data => x_msg_data
3506: );

Line 3611: -- Standard Start of API savepoint

3607: l_item_found VARCHAR2(1);
3608: l_item_invalid VARCHAR2(1);
3609: l_item_associations_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_rec;
3610: BEGIN
3611: -- Standard Start of API savepoint
3612: SAVEPOINT update_item_association_pvt;
3613:
3614: -- Standard call to check for call compatibility.
3615: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 3614: -- Standard call to check for call compatibility.

3610: BEGIN
3611: -- Standard Start of API savepoint
3612: SAVEPOINT update_item_association_pvt;
3613:
3614: -- Standard call to check for call compatibility.
3615: IF NOT FND_API.Compatible_API_Call (l_api_version,
3616: p_api_version,
3617: l_api_name ,
3618: G_PKG_NAME ) THEN

Line 3970: -- Standard call to get message count and IF count is get message info.

3966: IF FND_API.to_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
3967: COMMIT WORK;
3968: END IF;
3969:
3970: -- Standard call to get message count and IF count is get message info.
3971: FND_MSG_PUB.Count_And_Get
3972: ( p_count => x_msg_count,
3973: p_data => x_msg_data
3974: );

Line 4136: -- Standard Start of API savepoint

4132: l_rdg_exists NUMBER;
4133: l_return_status VARCHAR2(1);
4134:
4135: BEGIN
4136: -- Standard Start of API savepoint
4137: SAVEPOINT update_counter_template_pvt;
4138:
4139: -- Standard call to check for call compatibility.
4140: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 4139: -- Standard call to check for call compatibility.

4135: BEGIN
4136: -- Standard Start of API savepoint
4137: SAVEPOINT update_counter_template_pvt;
4138:
4139: -- Standard call to check for call compatibility.
4140: IF NOT FND_API.Compatible_API_Call (l_api_version,
4141: p_api_version,
4142: l_api_name ,
4143: G_PKG_NAME ) THEN

Line 4781: -- Standard call to get message count and IF count is get message info.

4777: IF FND_API.to_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
4778: COMMIT WORK;
4779: END IF;
4780:
4781: -- Standard call to get message count and IF count is get message info.
4782: FND_MSG_PUB.Count_And_Get
4783: ( p_count => x_msg_count,
4784: p_data => x_msg_data
4785: );

Line 4886: -- Standard Start of API savepoint

4882: -- l_debug_level NUMBER;
4883:
4884: l_ctr_property_tmpl_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_rec;
4885: BEGIN
4886: -- Standard Start of API savepoint
4887: SAVEPOINT update_ctr_property_tmpl_pvt;
4888:
4889: -- Standard call to check for call compatibility.
4890: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 4889: -- Standard call to check for call compatibility.

4885: BEGIN
4886: -- Standard Start of API savepoint
4887: SAVEPOINT update_ctr_property_tmpl_pvt;
4888:
4889: -- Standard call to check for call compatibility.
4890: IF NOT FND_API.Compatible_API_Call (l_api_version,
4891: p_api_version,
4892: l_api_name ,
4893: G_PKG_NAME ) THEN

Line 5190: -- Standard call to get message count and IF count is get message info.

5186: IF FND_API.to_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
5187: COMMIT WORK;
5188: END IF;
5189:
5190: -- Standard call to get message count and IF count is get message info.
5191: FND_MSG_PUB.Count_And_Get
5192: ( p_count => x_msg_count,
5193: p_data => x_msg_data
5194: );

Line 5305: -- Standard Start of API savepoint

5301: FROM csi_counter_readings
5302: WHERE counter_id = p_counter_id;
5303:
5304: BEGIN
5305: -- Standard Start of API savepoint
5306: SAVEPOINT update_ctr_relationship_pvt;
5307:
5308: -- Standard call to check for call compatibility.
5309: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 5308: -- Standard call to check for call compatibility.

5304: BEGIN
5305: -- Standard Start of API savepoint
5306: SAVEPOINT update_ctr_relationship_pvt;
5307:
5308: -- Standard call to check for call compatibility.
5309: IF NOT FND_API.Compatible_API_Call (l_api_version,
5310: p_api_version,
5311: l_api_name ,
5312: G_PKG_NAME ) THEN

Line 5642: -- Standard call to get message count and IF count is get message info.

5638: IF FND_API.to_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
5639: COMMIT WORK;
5640: END IF;
5641:
5642: -- Standard call to get message count and IF count is get message info.
5643: FND_MSG_PUB.Count_And_Get
5644: ( p_count => x_msg_count,
5645: p_data => x_msg_data
5646: );

Line 5720: -- Standard Start of API savepoint

5716: l_return_status VARCHAR2(1);
5717: l_valid_flag VARCHAR2(1);
5718:
5719: BEGIN
5720: -- Standard Start of API savepoint
5721: SAVEPOINT update_derived_filters;
5722:
5723: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
5724:

Line 5727: -- Standard call to check for call compatibility.

5723: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
5724:
5725: -- csi_ctr_gen_utility_pvt.check_ib_active;
5726:
5727: -- Standard call to check for call compatibility.
5728: IF NOT FND_API.Compatible_API_Call (l_api_version,
5729: p_api_version,
5730: l_api_name ,
5731: G_PKG_NAME )

Line 6027: -- Standard check of p_commit.

6023: END LOOP;
6024: END IF;
6025: -- End of API body
6026:
6027: -- Standard check of p_commit.
6028: IF FND_API.To_Boolean( p_commit ) THEN
6029: COMMIT WORK;
6030: END IF;
6031:

Line 6126: -- Standard Start of API savepoint

6122: l_OBJECT_VERSION_NUMBER NUMBER;
6123: l_MIGRATED_FLAG VARCHAR2(1);
6124: l_dummy VARCHAR2(1);
6125: BEGIN
6126: -- Standard Start of API savepoint
6127: SAVEPOINT create_estimation_method_pvt;
6128:
6129: -- Standard call to check for call compatibility.
6130: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 6129: -- Standard call to check for call compatibility.

6125: BEGIN
6126: -- Standard Start of API savepoint
6127: SAVEPOINT create_estimation_method_pvt;
6128:
6129: -- Standard call to check for call compatibility.
6130: IF NOT FND_API.Compatible_API_Call (l_api_version,
6131: p_api_version,
6132: l_api_name ,
6133: G_PKG_NAME ) THEN

Line 6398: -- Standard call to get message count and IF count is get message info.

6394: IF FND_API.to_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
6395: COMMIT WORK;
6396: END IF;
6397:
6398: -- Standard call to get message count and IF count is get message info.
6399: FND_MSG_PUB.Count_And_Get
6400: ( p_count => x_msg_count,
6401: p_data => x_msg_data
6402: );

Line 6492: -- Standard Start of API savepoint

6488: -- l_debug_level NUMBER;
6489:
6490: l_ctr_estimation_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_estimation_methods_rec;
6491: BEGIN
6492: -- Standard Start of API savepoint
6493: SAVEPOINT update_estimation_method_pvt;
6494:
6495: -- Standard call to check for call compatibility.
6496: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 6495: -- Standard call to check for call compatibility.

6491: BEGIN
6492: -- Standard Start of API savepoint
6493: SAVEPOINT update_estimation_method_pvt;
6494:
6495: -- Standard call to check for call compatibility.
6496: IF NOT FND_API.Compatible_API_Call (l_api_version,
6497: p_api_version,
6498: l_api_name ,
6499: G_PKG_NAME ) THEN

Line 6758: -- Standard call to get message count and IF count is get message info.

6754: IF FND_API.to_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
6755: COMMIT WORK;
6756: END IF;
6757:
6758: -- Standard call to get message count and IF count is get message info.
6759: FND_MSG_PUB.Count_And_Get
6760: ( p_count => x_msg_count,
6761: p_data => x_msg_data
6762: );

Line 7102: -- Standard Start of API savepoint

7098: FROM csi_counter_derived_filters
7099: WHERE counter_id = p_counter_id;
7100:
7101: BEGIN
7102: -- Standard Start of API savepoint
7103: SAVEPOINT instantiate_ctr_pvt;
7104:
7105: -- Standard call to check for call compatibility.
7106: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 7105: -- Standard call to check for call compatibility.

7101: BEGIN
7102: -- Standard Start of API savepoint
7103: SAVEPOINT instantiate_ctr_pvt;
7104:
7105: -- Standard call to check for call compatibility.
7106: IF NOT FND_API.Compatible_API_Call (l_api_version,
7107: p_api_version,
7108: l_api_name ,
7109: G_PKG_NAME ) THEN

Line 7685: -- Standard call to get message count and IF count is get message info.

7681: IF FND_API.to_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
7682: COMMIT WORK;
7683: END IF;
7684:
7685: -- Standard call to get message count and IF count is get message info.
7686: FND_MSG_PUB.Count_And_Get
7687: ( p_count => x_msg_count,
7688: p_data => x_msg_data
7689: );

Line 8014: -- Standard Start of API savepoint

8010: FROM csi_counter_derived_filters
8011: WHERE counter_id = p_counter_id;
8012:
8013: BEGIN
8014: -- Standard Start of API savepoint
8015: SAVEPOINT instantiate_grp_counters;
8016:
8017: -- Standard call to check for call compatibility.
8018: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 8017: -- Standard call to check for call compatibility.

8013: BEGIN
8014: -- Standard Start of API savepoint
8015: SAVEPOINT instantiate_grp_counters;
8016:
8017: -- Standard call to check for call compatibility.
8018: IF NOT FND_API.Compatible_API_Call (l_api_version,
8019: p_api_version,
8020: l_api_name ,
8021: G_PKG_NAME ) THEN

Line 8558: -- Standard call to get message count and IF count is get message info.

8554: IF FND_API.to_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
8555: COMMIT WORK;
8556: END IF;
8557:
8558: -- Standard call to get message count and IF count is get message info.
8559: FND_MSG_PUB.Count_And_Get
8560: ( p_count => x_msg_count,
8561: p_data => x_msg_data
8562: );

Line 8637: -- Standard Start of API savepoint

8633: SELECT counter_id instantiated_counter_id
8634: FROM csi_counters_b
8635: WHERE created_from_counter_tmpl_id = p_counter_id;
8636: BEGIN
8637: -- Standard Start of API savepoint
8638: SAVEPOINT delete_item_association_pvt;
8639:
8640: -- Standard call to check for call compatibility.
8641: IF NOT FND_API.Compatible_API_Call (l_api_version,

Line 8640: -- Standard call to check for call compatibility.

8636: BEGIN
8637: -- Standard Start of API savepoint
8638: SAVEPOINT delete_item_association_pvt;
8639:
8640: -- Standard call to check for call compatibility.
8641: IF NOT FND_API.Compatible_API_Call (l_api_version,
8642: p_api_version,
8643: l_api_name ,
8644: G_PKG_NAME ) THEN

Line 8761: -- Standard call to get message count and IF count is get message info.

8757: IF FND_API.to_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
8758: COMMIT WORK;
8759: END IF;
8760:
8761: -- Standard call to get message count and IF count is get message info.
8762: FND_MSG_PUB.Count_And_Get
8763: ( p_count => x_msg_count,
8764: p_data => x_msg_data
8765: );