DBA Data[Home] [Help]

APPS.CSI_COUNTER_TEMPLATE_PVT dependencies on STANDARD

Line 552: -- Standard Start of API savepoint

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

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

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

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

795: IF FND_API.to_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
796: COMMIT WORK;
797: END IF;
798:
799: -- Standard call to get message count and IF count is get message info.
800: FND_MSG_PUB.Count_And_Get
801: ( p_count => x_msg_count,
802: p_data => x_msg_data
803: );

Line 910: -- Standard Start of API savepoint

906: from csi_counter_template_b
907: where counter_id = p_counter_id;
908:
909: BEGIN
910: -- Standard Start of API savepoint
911: SAVEPOINT create_item_association_pvt;
912:
913: -- Standard call to check for call compatibility.
914: IF NOT FND_API.Compatible_API_Call (l_api_version,

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

909: BEGIN
910: -- Standard Start of API savepoint
911: SAVEPOINT create_item_association_pvt;
912:
913: -- Standard call to check for call compatibility.
914: IF NOT FND_API.Compatible_API_Call (l_api_version,
915: p_api_version,
916: l_api_name ,
917: G_PKG_NAME ) THEN

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

1294: IF FND_API.to_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
1295: COMMIT WORK;
1296: END IF;
1297:
1298: -- Standard call to get message count and IF count is get message info.
1299: FND_MSG_PUB.Count_And_Get
1300: ( p_count => x_msg_count,
1301: p_data => x_msg_data
1302: );

Line 1437: -- Standard Start of API savepoint

1433: from cs_csi_counter_groups
1434: where counter_group_id = p_group_id;
1435:
1436: BEGIN
1437: -- Standard Start of API savepoint
1438: SAVEPOINT create_counter_template_pvt;
1439:
1440: -- Standard call to check for call compatibility.
1441: IF NOT FND_API.Compatible_API_Call (l_api_version,

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

1436: BEGIN
1437: -- Standard Start of API savepoint
1438: SAVEPOINT create_counter_template_pvt;
1439:
1440: -- Standard call to check for call compatibility.
1441: IF NOT FND_API.Compatible_API_Call (l_api_version,
1442: p_api_version,
1443: l_api_name ,
1444: G_PKG_NAME ) THEN

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

2025: IF FND_API.to_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
2026: COMMIT WORK;
2027: END IF;
2028:
2029: -- Standard call to get message count and IF count is get message info.
2030: FND_MSG_PUB.Count_And_Get
2031: ( p_count => x_msg_count,
2032: p_data => x_msg_data
2033: );

Line 2126: -- Standard Start of API savepoint

2122: l_MIGRATED_FLAG VARCHAR2(1);
2123: l_NAME VARCHAR2(50);
2124: l_DESCRIPTION VARCHAR2(240);
2125: BEGIN
2126: -- Standard Start of API savepoint
2127: SAVEPOINT create_ctr_property_tmpl_pvt;
2128:
2129: -- Standard call to check for call compatibility.
2130: IF NOT FND_API.Compatible_API_Call (l_api_version,

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

2125: BEGIN
2126: -- Standard Start of API savepoint
2127: SAVEPOINT create_ctr_property_tmpl_pvt;
2128:
2129: -- Standard call to check for call compatibility.
2130: IF NOT FND_API.Compatible_API_Call (l_api_version,
2131: p_api_version,
2132: l_api_name ,
2133: G_PKG_NAME ) THEN

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

2409: IF FND_API.to_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
2410: COMMIT WORK;
2411: END IF;
2412:
2413: -- Standard call to get message count and IF count is get message info.
2414: FND_MSG_PUB.Count_And_Get
2415: ( p_count => x_msg_count,
2416: p_data => x_msg_data
2417: );

Line 2520: -- Standard Start of API savepoint

2516: SELECT max(value_timestamp)
2517: FROM csi_counter_readings
2518: WHERE counter_id = p_counter_id;
2519: BEGIN
2520: -- Standard Start of API savepoint
2521: SAVEPOINT create_ctr_relationship_pvt;
2522:
2523: -- Standard call to check for call compatibility.
2524: IF NOT FND_API.Compatible_API_Call (l_api_version,

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

2519: BEGIN
2520: -- Standard Start of API savepoint
2521: SAVEPOINT create_ctr_relationship_pvt;
2522:
2523: -- Standard call to check for call compatibility.
2524: IF NOT FND_API.Compatible_API_Call (l_api_version,
2525: p_api_version,
2526: l_api_name ,
2527: G_PKG_NAME ) THEN

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

2839: IF FND_API.to_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
2840: COMMIT WORK;
2841: END IF;
2842:
2843: -- Standard call to get message count and IF count is get message info.
2844: FND_MSG_PUB.Count_And_Get
2845: ( p_count => x_msg_count,
2846: p_data => x_msg_data
2847: );

Line 2915: -- Standard Start of API savepoint

2911: l_return_status VARCHAR2(1);
2912: l_valid_flag VARCHAR2(1);
2913:
2914: BEGIN
2915: -- Standard Start of API savepoint
2916: SAVEPOINT create_derived_filters;
2917:
2918: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
2919:

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

2918: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
2919:
2920: -- csi_ctr_gen_utility_pvt.check_ib_active;
2921:
2922: -- Standard call to check for call compatibility.
2923: IF NOT FND_API.Compatible_API_Call (l_api_version,
2924: p_api_version,
2925: l_api_name ,
2926: G_PKG_NAME )

Line 3139: -- Standard check of p_commit.

3135: --l_ctr_derived_filters_rec.OBJECT_VERSION_NUMBER := 1;
3136:
3137: -- End of API body
3138:
3139: -- Standard check of p_commit.
3140: IF FND_API.To_Boolean( p_commit ) THEN
3141: COMMIT WORK;
3142: END IF;
3143:

Line 3251: -- Standard Start of API savepoint

3247: -- l_debug_level NUMBER;
3248:
3249: l_counter_groups_rec CSI_CTR_DATASTRUCTURES_PUB.counter_groups_rec;
3250: BEGIN
3251: -- Standard Start of API savepoint
3252: SAVEPOINT update_counter_group_pvt;
3253:
3254: -- Standard call to check for call compatibility.
3255: IF NOT FND_API.Compatible_API_Call (l_api_version,

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

3250: BEGIN
3251: -- Standard Start of API savepoint
3252: SAVEPOINT update_counter_group_pvt;
3253:
3254: -- Standard call to check for call compatibility.
3255: IF NOT FND_API.Compatible_API_Call (l_api_version,
3256: p_api_version,
3257: l_api_name ,
3258: G_PKG_NAME ) THEN

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

3511: IF FND_API.to_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
3512: COMMIT WORK;
3513: END IF;
3514:
3515: -- Standard call to get message count and IF count is get message info.
3516: FND_MSG_PUB.Count_And_Get
3517: ( p_count => x_msg_count,
3518: p_data => x_msg_data
3519: );

Line 3624: -- Standard Start of API savepoint

3620: l_item_found VARCHAR2(1);
3621: l_item_invalid VARCHAR2(1);
3622: l_item_associations_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_rec;
3623: BEGIN
3624: -- Standard Start of API savepoint
3625: SAVEPOINT update_item_association_pvt;
3626:
3627: -- Standard call to check for call compatibility.
3628: IF NOT FND_API.Compatible_API_Call (l_api_version,

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

3623: BEGIN
3624: -- Standard Start of API savepoint
3625: SAVEPOINT update_item_association_pvt;
3626:
3627: -- Standard call to check for call compatibility.
3628: IF NOT FND_API.Compatible_API_Call (l_api_version,
3629: p_api_version,
3630: l_api_name ,
3631: G_PKG_NAME ) THEN

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

3979: IF FND_API.to_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
3980: COMMIT WORK;
3981: END IF;
3982:
3983: -- Standard call to get message count and IF count is get message info.
3984: FND_MSG_PUB.Count_And_Get
3985: ( p_count => x_msg_count,
3986: p_data => x_msg_data
3987: );

Line 4149: -- Standard Start of API savepoint

4145: l_rdg_exists NUMBER;
4146: l_return_status VARCHAR2(1);
4147:
4148: BEGIN
4149: -- Standard Start of API savepoint
4150: SAVEPOINT update_counter_template_pvt;
4151:
4152: -- Standard call to check for call compatibility.
4153: IF NOT FND_API.Compatible_API_Call (l_api_version,

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

4148: BEGIN
4149: -- Standard Start of API savepoint
4150: SAVEPOINT update_counter_template_pvt;
4151:
4152: -- Standard call to check for call compatibility.
4153: IF NOT FND_API.Compatible_API_Call (l_api_version,
4154: p_api_version,
4155: l_api_name ,
4156: G_PKG_NAME ) THEN

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

4798: IF FND_API.to_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
4799: COMMIT WORK;
4800: END IF;
4801:
4802: -- Standard call to get message count and IF count is get message info.
4803: FND_MSG_PUB.Count_And_Get
4804: ( p_count => x_msg_count,
4805: p_data => x_msg_data
4806: );

Line 4907: -- Standard Start of API savepoint

4903: -- l_debug_level NUMBER;
4904:
4905: l_ctr_property_tmpl_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_rec;
4906: BEGIN
4907: -- Standard Start of API savepoint
4908: SAVEPOINT update_ctr_property_tmpl_pvt;
4909:
4910: -- Standard call to check for call compatibility.
4911: IF NOT FND_API.Compatible_API_Call (l_api_version,

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

4906: BEGIN
4907: -- Standard Start of API savepoint
4908: SAVEPOINT update_ctr_property_tmpl_pvt;
4909:
4910: -- Standard call to check for call compatibility.
4911: IF NOT FND_API.Compatible_API_Call (l_api_version,
4912: p_api_version,
4913: l_api_name ,
4914: G_PKG_NAME ) THEN

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

5207: IF FND_API.to_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
5208: COMMIT WORK;
5209: END IF;
5210:
5211: -- Standard call to get message count and IF count is get message info.
5212: FND_MSG_PUB.Count_And_Get
5213: ( p_count => x_msg_count,
5214: p_data => x_msg_data
5215: );

Line 5326: -- Standard Start of API savepoint

5322: FROM csi_counter_readings
5323: WHERE counter_id = p_counter_id;
5324:
5325: BEGIN
5326: -- Standard Start of API savepoint
5327: SAVEPOINT update_ctr_relationship_pvt;
5328:
5329: -- Standard call to check for call compatibility.
5330: IF NOT FND_API.Compatible_API_Call (l_api_version,

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

5325: BEGIN
5326: -- Standard Start of API savepoint
5327: SAVEPOINT update_ctr_relationship_pvt;
5328:
5329: -- Standard call to check for call compatibility.
5330: IF NOT FND_API.Compatible_API_Call (l_api_version,
5331: p_api_version,
5332: l_api_name ,
5333: G_PKG_NAME ) THEN

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

5659: IF FND_API.to_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
5660: COMMIT WORK;
5661: END IF;
5662:
5663: -- Standard call to get message count and IF count is get message info.
5664: FND_MSG_PUB.Count_And_Get
5665: ( p_count => x_msg_count,
5666: p_data => x_msg_data
5667: );

Line 5741: -- Standard Start of API savepoint

5737: l_return_status VARCHAR2(1);
5738: l_valid_flag VARCHAR2(1);
5739:
5740: BEGIN
5741: -- Standard Start of API savepoint
5742: SAVEPOINT update_derived_filters;
5743:
5744: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
5745:

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

5744: -- Check for freeze_flag in csi_install_parameters is set to 'Y'
5745:
5746: -- csi_ctr_gen_utility_pvt.check_ib_active;
5747:
5748: -- Standard call to check for call compatibility.
5749: IF NOT FND_API.Compatible_API_Call (l_api_version,
5750: p_api_version,
5751: l_api_name ,
5752: G_PKG_NAME )

Line 6048: -- Standard check of p_commit.

6044: END LOOP;
6045: END IF;
6046: -- End of API body
6047:
6048: -- Standard check of p_commit.
6049: IF FND_API.To_Boolean( p_commit ) THEN
6050: COMMIT WORK;
6051: END IF;
6052:

Line 6147: -- Standard Start of API savepoint

6143: l_OBJECT_VERSION_NUMBER NUMBER;
6144: l_MIGRATED_FLAG VARCHAR2(1);
6145: l_dummy VARCHAR2(1);
6146: BEGIN
6147: -- Standard Start of API savepoint
6148: SAVEPOINT create_estimation_method_pvt;
6149:
6150: -- Standard call to check for call compatibility.
6151: IF NOT FND_API.Compatible_API_Call (l_api_version,

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

6146: BEGIN
6147: -- Standard Start of API savepoint
6148: SAVEPOINT create_estimation_method_pvt;
6149:
6150: -- Standard call to check for call compatibility.
6151: IF NOT FND_API.Compatible_API_Call (l_api_version,
6152: p_api_version,
6153: l_api_name ,
6154: G_PKG_NAME ) THEN

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

6415: IF FND_API.to_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
6416: COMMIT WORK;
6417: END IF;
6418:
6419: -- Standard call to get message count and IF count is get message info.
6420: FND_MSG_PUB.Count_And_Get
6421: ( p_count => x_msg_count,
6422: p_data => x_msg_data
6423: );

Line 6513: -- Standard Start of API savepoint

6509: -- l_debug_level NUMBER;
6510:
6511: l_ctr_estimation_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_estimation_methods_rec;
6512: BEGIN
6513: -- Standard Start of API savepoint
6514: SAVEPOINT update_estimation_method_pvt;
6515:
6516: -- Standard call to check for call compatibility.
6517: IF NOT FND_API.Compatible_API_Call (l_api_version,

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

6512: BEGIN
6513: -- Standard Start of API savepoint
6514: SAVEPOINT update_estimation_method_pvt;
6515:
6516: -- Standard call to check for call compatibility.
6517: IF NOT FND_API.Compatible_API_Call (l_api_version,
6518: p_api_version,
6519: l_api_name ,
6520: G_PKG_NAME ) THEN

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

6775: IF FND_API.to_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
6776: COMMIT WORK;
6777: END IF;
6778:
6779: -- Standard call to get message count and IF count is get message info.
6780: FND_MSG_PUB.Count_And_Get
6781: ( p_count => x_msg_count,
6782: p_data => x_msg_data
6783: );

Line 7124: -- Standard Start of API savepoint

7120: FROM csi_counter_derived_filters
7121: WHERE counter_id = p_counter_id;
7122:
7123: BEGIN
7124: -- Standard Start of API savepoint
7125: SAVEPOINT instantiate_ctr_pvt;
7126:
7127: -- Standard call to check for call compatibility.
7128: IF NOT FND_API.Compatible_API_Call (l_api_version,

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

7123: BEGIN
7124: -- Standard Start of API savepoint
7125: SAVEPOINT instantiate_ctr_pvt;
7126:
7127: -- Standard call to check for call compatibility.
7128: IF NOT FND_API.Compatible_API_Call (l_api_version,
7129: p_api_version,
7130: l_api_name ,
7131: G_PKG_NAME ) THEN

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

7724: IF FND_API.to_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
7725: COMMIT WORK;
7726: END IF;
7727:
7728: -- Standard call to get message count and IF count is get message info.
7729: FND_MSG_PUB.Count_And_Get
7730: ( p_count => x_msg_count,
7731: p_data => x_msg_data
7732: );

Line 8058: -- Standard Start of API savepoint

8054: FROM csi_counter_derived_filters
8055: WHERE counter_id = p_counter_id;
8056:
8057: BEGIN
8058: -- Standard Start of API savepoint
8059: SAVEPOINT instantiate_grp_counters;
8060:
8061: -- Standard call to check for call compatibility.
8062: IF NOT FND_API.Compatible_API_Call (l_api_version,

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

8057: BEGIN
8058: -- Standard Start of API savepoint
8059: SAVEPOINT instantiate_grp_counters;
8060:
8061: -- Standard call to check for call compatibility.
8062: IF NOT FND_API.Compatible_API_Call (l_api_version,
8063: p_api_version,
8064: l_api_name ,
8065: G_PKG_NAME ) THEN

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

8627: IF FND_API.to_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
8628: COMMIT WORK;
8629: END IF;
8630:
8631: -- Standard call to get message count and IF count is get message info.
8632: FND_MSG_PUB.Count_And_Get
8633: ( p_count => x_msg_count,
8634: p_data => x_msg_data
8635: );

Line 8712: -- Standard Start of API savepoint

8708: SELECT counter_id instantiated_counter_id
8709: FROM csi_counters_b
8710: WHERE created_from_counter_tmpl_id = p_counter_id;
8711: BEGIN
8712: -- Standard Start of API savepoint
8713: SAVEPOINT delete_item_association_pvt;
8714:
8715: -- Standard call to check for call compatibility.
8716: IF NOT FND_API.Compatible_API_Call (l_api_version,

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

8711: BEGIN
8712: -- Standard Start of API savepoint
8713: SAVEPOINT delete_item_association_pvt;
8714:
8715: -- Standard call to check for call compatibility.
8716: IF NOT FND_API.Compatible_API_Call (l_api_version,
8717: p_api_version,
8718: l_api_name ,
8719: G_PKG_NAME ) THEN

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

8835: IF FND_API.to_Boolean(nvl(p_commit,FND_API.G_FALSE)) THEN
8836: COMMIT WORK;
8837: END IF;
8838:
8839: -- Standard call to get message count and IF count is get message info.
8840: FND_MSG_PUB.Count_And_Get
8841: ( p_count => x_msg_count,
8842: p_data => x_msg_data
8843: );