DBA Data[Home] [Help]

APPS.CS_COUNTERS_PUB dependencies on CSI_CTR_DATASTRUCTURES_PUB

Line 291: l_ctr_groups_rec CSI_CTR_DATASTRUCTURES_PUB.counter_groups_rec;

287: ) IS
288: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_CTR_GRP_TEMPLATE';
289: l_api_version CONSTANT NUMBER := 1.0;
290:
291: l_ctr_groups_rec CSI_CTR_DATASTRUCTURES_PUB.counter_groups_rec;
292: l_ctr_item_associations_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl;
293: l_validation_level NUMBER;
294:
295: BEGIN

Line 292: l_ctr_item_associations_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl;

288: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_CTR_GRP_TEMPLATE';
289: l_api_version CONSTANT NUMBER := 1.0;
290:
291: l_ctr_groups_rec CSI_CTR_DATASTRUCTURES_PUB.counter_groups_rec;
292: l_ctr_item_associations_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl;
293: l_validation_level NUMBER;
294:
295: BEGIN
296:

Line 513: l_counter_template_rec CSI_CTR_DATASTRUCTURES_PUB.counter_template_rec;

509: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_COUNTER';
510: l_api_version CONSTANT NUMBER := 1.0;
511:
512: l_template_flag VARCHAR2(1);
513: l_counter_template_rec CSI_CTR_DATASTRUCTURES_PUB.counter_template_rec;
514: l_ctr_item_associations_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl;
515: l_ctr_property_template_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_tbl;
516: l_counter_relationships_tbl CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl;
517: l_ctr_derived_filters_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl;

Line 514: l_ctr_item_associations_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl;

510: l_api_version CONSTANT NUMBER := 1.0;
511:
512: l_template_flag VARCHAR2(1);
513: l_counter_template_rec CSI_CTR_DATASTRUCTURES_PUB.counter_template_rec;
514: l_ctr_item_associations_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl;
515: l_ctr_property_template_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_tbl;
516: l_counter_relationships_tbl CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl;
517: l_ctr_derived_filters_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl;
518: l_validation_level NUMBER;

Line 515: l_ctr_property_template_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_tbl;

511:
512: l_template_flag VARCHAR2(1);
513: l_counter_template_rec CSI_CTR_DATASTRUCTURES_PUB.counter_template_rec;
514: l_ctr_item_associations_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl;
515: l_ctr_property_template_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_tbl;
516: l_counter_relationships_tbl CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl;
517: l_ctr_derived_filters_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl;
518: l_validation_level NUMBER;
519: BEGIN

Line 516: l_counter_relationships_tbl CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl;

512: l_template_flag VARCHAR2(1);
513: l_counter_template_rec CSI_CTR_DATASTRUCTURES_PUB.counter_template_rec;
514: l_ctr_item_associations_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl;
515: l_ctr_property_template_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_tbl;
516: l_counter_relationships_tbl CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl;
517: l_ctr_derived_filters_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl;
518: l_validation_level NUMBER;
519: BEGIN
520:

Line 517: l_ctr_derived_filters_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl;

513: l_counter_template_rec CSI_CTR_DATASTRUCTURES_PUB.counter_template_rec;
514: l_ctr_item_associations_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl;
515: l_ctr_property_template_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_tbl;
516: l_counter_relationships_tbl CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl;
517: l_ctr_derived_filters_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl;
518: l_validation_level NUMBER;
519: BEGIN
520:
521: SAVEPOINT Create_Counter_PUB;

Line 742: l_ctr_property_template_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_rec;

738: ) is
739: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_CTR_PROP';
740: l_api_version CONSTANT NUMBER := 1.0;
741:
742: l_ctr_property_template_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_rec;
743: l_validation_level NUMBER;
744:
745: BEGIN
746:

Line 952: l_counter_relationships_rec CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_rec;

948: ) is
949: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_FORMULA_REF';
950: l_api_version CONSTANT NUMBER := 1.0;
951:
952: l_counter_relationships_rec CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_rec;
953: l_validation_level NUMBER;
954:
955: cursor ctr_associations IS
956: SELECT ctr_association_id, inventory_item_id

Line 1201: l_ctr_derived_filters_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl;

1197: ) is
1198: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_GRPOP_FILTER';
1199: l_api_version CONSTANT NUMBER := 1.0;
1200:
1201: l_ctr_derived_filters_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl;
1202: l_validation_level NUMBER;
1203:
1204: BEGIN
1205:

Line 1432: l_ctr_item_associations_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_rec;

1428: ) is
1429: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_CTR_ASSOCIATION';
1430: l_api_version CONSTANT NUMBER := 1.0;
1431: l_association_type VARCHAR2(30);
1432: l_ctr_item_associations_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_rec;
1433: l_validation_level NUMBER;
1434: BEGIN
1435: SAVEPOINT Create_Ctr_Association_PUB;
1436:

Line 2028: l_ctr_groups_rec CSI_CTR_DATASTRUCTURES_PUB.counter_groups_rec;

2024: ) is
2025: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CTR_GRP';
2026: l_api_version CONSTANT NUMBER := 1.0;
2027:
2028: l_ctr_groups_rec CSI_CTR_DATASTRUCTURES_PUB.counter_groups_rec;
2029: l_ctr_item_associations_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl;
2030: l_validation_level NUMBER;
2031:
2032: BEGIN

Line 2029: l_ctr_item_associations_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl;

2025: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CTR_GRP';
2026: l_api_version CONSTANT NUMBER := 1.0;
2027:
2028: l_ctr_groups_rec CSI_CTR_DATASTRUCTURES_PUB.counter_groups_rec;
2029: l_ctr_item_associations_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl;
2030: l_validation_level NUMBER;
2031:
2032: BEGIN
2033:

Line 2239: l_counter_template_rec CSI_CTR_DATASTRUCTURES_PUB.counter_template_rec;

2235: ) is
2236: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_COUNTER';
2237: l_api_version CONSTANT NUMBER := 1.0;
2238:
2239: l_counter_template_rec CSI_CTR_DATASTRUCTURES_PUB.counter_template_rec;
2240: l_ctr_item_associations_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl;
2241: l_ctr_property_template_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_tbl;
2242: l_counter_relationships_tbl CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl;
2243: l_ctr_derived_filters_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl;

Line 2240: l_ctr_item_associations_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl;

2236: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_COUNTER';
2237: l_api_version CONSTANT NUMBER := 1.0;
2238:
2239: l_counter_template_rec CSI_CTR_DATASTRUCTURES_PUB.counter_template_rec;
2240: l_ctr_item_associations_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl;
2241: l_ctr_property_template_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_tbl;
2242: l_counter_relationships_tbl CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl;
2243: l_ctr_derived_filters_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl;
2244: l_validation_level NUMBER;

Line 2241: l_ctr_property_template_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_tbl;

2237: l_api_version CONSTANT NUMBER := 1.0;
2238:
2239: l_counter_template_rec CSI_CTR_DATASTRUCTURES_PUB.counter_template_rec;
2240: l_ctr_item_associations_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl;
2241: l_ctr_property_template_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_tbl;
2242: l_counter_relationships_tbl CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl;
2243: l_ctr_derived_filters_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl;
2244: l_validation_level NUMBER;
2245:

Line 2242: l_counter_relationships_tbl CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl;

2238:
2239: l_counter_template_rec CSI_CTR_DATASTRUCTURES_PUB.counter_template_rec;
2240: l_ctr_item_associations_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl;
2241: l_ctr_property_template_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_tbl;
2242: l_counter_relationships_tbl CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl;
2243: l_ctr_derived_filters_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl;
2244: l_validation_level NUMBER;
2245:
2246: BEGIN

Line 2243: l_ctr_derived_filters_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl;

2239: l_counter_template_rec CSI_CTR_DATASTRUCTURES_PUB.counter_template_rec;
2240: l_ctr_item_associations_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_tbl;
2241: l_ctr_property_template_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_tbl;
2242: l_counter_relationships_tbl CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_tbl;
2243: l_ctr_derived_filters_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl;
2244: l_validation_level NUMBER;
2245:
2246: BEGIN
2247:

Line 2477: l_ctr_property_template_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_rec;

2473: ) is
2474: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CTR_PROP';
2475: l_api_version CONSTANT NUMBER := 1.0;
2476:
2477: l_ctr_property_template_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_property_template_rec;
2478: l_validation_level NUMBER;
2479:
2480: BEGIN
2481:

Line 2698: l_counter_relationships_rec CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_rec;

2694: ) is
2695: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_FORMULA_REF';
2696: l_api_version CONSTANT NUMBER := 1.0;
2697:
2698: l_counter_relationships_rec CSI_CTR_DATASTRUCTURES_PUB.counter_relationships_rec;
2699: l_validation_level NUMBER;
2700:
2701: BEGIN
2702:

Line 2932: l_ctr_derived_filters_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl;

2928: ) is
2929: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_GRPOP_FILTER';
2930: l_api_version CONSTANT NUMBER := 1.0;
2931:
2932: l_ctr_derived_filters_tbl CSI_CTR_DATASTRUCTURES_PUB.ctr_derived_filters_tbl;
2933: l_validation_level NUMBER;
2934:
2935: BEGIN
2936:

Line 3173: l_ctr_item_associations_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_rec;

3169: ) is
3170: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_CTR_ASSOCIATION';
3171: l_api_version CONSTANT NUMBER := 1.0;
3172:
3173: l_ctr_item_associations_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_item_associations_rec;
3174: l_validation_level NUMBER;
3175:
3176: BEGIN
3177:

Line 3688: l_ctr_estimation_methods_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_estimation_methods_rec;

3684: ) IS
3685: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_ESTIMATION_METHOD';
3686: l_api_version CONSTANT NUMBER := 1.0;
3687:
3688: l_ctr_estimation_methods_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_estimation_methods_rec;
3689: l_validation_level NUMBER;
3690:
3691: BEGIN
3692: SAVEPOINT Create_Ctr_Estimation_PUB;

Line 3809: l_ctr_estimation_methods_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_estimation_methods_rec;

3805: ) is
3806: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_ESTIMATION_METHOD';
3807: l_api_version CONSTANT NUMBER := 1.0;
3808:
3809: l_ctr_estimation_methods_rec CSI_CTR_DATASTRUCTURES_PUB.ctr_estimation_methods_rec;
3810: l_validation_level NUMBER;
3811: BEGIN
3812:
3813: SAVEPOINT Update_Estimation_Method_PUB;