eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IEC_VALIDATE_PVT dependencies on NUMBER_TBL_TYPE

Line 3078: , p_subset_id_col IN SYSTEM.number_tbl_type

3074: , p_schedule_id IN NUMBER
3075:
3076: , p_list_id IN NUMBER
3077:
3078: , p_subset_id_col IN SYSTEM.number_tbl_type
3079:
3080: , p_sub_rec_loaded_incr_col IN SYSTEM.number_tbl_type)
3081:
3082: IS

Line 3080: , p_sub_rec_loaded_incr_col IN SYSTEM.number_tbl_type)

3076: , p_list_id IN NUMBER
3077:
3078: , p_subset_id_col IN SYSTEM.number_tbl_type
3079:
3080: , p_sub_rec_loaded_incr_col IN SYSTEM.number_tbl_type)
3081:
3082: IS
3083:
3084: l_rec_count NUMBER;

Line 5038: , p_subset_id_col IN SYSTEM.number_tbl_type

5034: ( p_schedule_id IN NUMBER
5035:
5036: , p_list_id IN NUMBER
5037:
5038: , p_subset_id_col IN SYSTEM.number_tbl_type
5039:
5040: , p_incr_amount_col IN SYSTEM.number_tbl_type
5041:
5042: )

Line 5040: , p_incr_amount_col IN SYSTEM.number_tbl_type

5036: , p_list_id IN NUMBER
5037:
5038: , p_subset_id_col IN SYSTEM.number_tbl_type
5039:
5040: , p_incr_amount_col IN SYSTEM.number_tbl_type
5041:
5042: )
5043:
5044: IS

Line 5090: ( p_callable_zone_id_col IN SYSTEM.number_tbl_type

5086:
5087:
5088: PROCEDURE Incr_CallableZoneCounts
5089:
5090: ( p_callable_zone_id_col IN SYSTEM.number_tbl_type
5091:
5092: , p_incr_amount_col IN SYSTEM.number_tbl_type
5093:
5094: )

Line 5092: , p_incr_amount_col IN SYSTEM.number_tbl_type

5088: PROCEDURE Incr_CallableZoneCounts
5089:
5090: ( p_callable_zone_id_col IN SYSTEM.number_tbl_type
5091:
5092: , p_incr_amount_col IN SYSTEM.number_tbl_type
5093:
5094: )
5095:
5096: IS

Line 5138: ( p_callable_zone_id_col IN SYSTEM.number_tbl_type

5134:
5135:
5136: PROCEDURE Incr_CallableZoneCounts_Cache
5137:
5138: ( p_callable_zone_id_col IN SYSTEM.number_tbl_type
5139:
5140: , p_incr_amount_col IN SYSTEM.number_tbl_type
5141:
5142: )

Line 5140: , p_incr_amount_col IN SYSTEM.number_tbl_type

5136: PROCEDURE Incr_CallableZoneCounts_Cache
5137:
5138: ( p_callable_zone_id_col IN SYSTEM.number_tbl_type
5139:
5140: , p_incr_amount_col IN SYSTEM.number_tbl_type
5141:
5142: )
5143:
5144: IS

Line 5440: l_subset_id_col SYSTEM.number_tbl_type;

5436: , p_campaign_schedule_id IN NUMBER)
5437:
5438: IS
5439:
5440: l_subset_id_col SYSTEM.number_tbl_type;
5441:
5442: l_territory_code_col SYSTEM.varchar_tbl_type;
5443:
5444: l_region_col SYSTEM.varchar_tbl_type;

Line 5446: l_timezone_col SYSTEM.number_tbl_type;

5442: l_territory_code_col SYSTEM.varchar_tbl_type;
5443:
5444: l_region_col SYSTEM.varchar_tbl_type;
5445:
5446: l_timezone_col SYSTEM.number_tbl_type;
5447:
5448: l_tc_tz_pair_id_col SYSTEM.number_tbl_type;
5449:
5450: l_record_count_col SYSTEM.number_tbl_type;

Line 5448: l_tc_tz_pair_id_col SYSTEM.number_tbl_type;

5444: l_region_col SYSTEM.varchar_tbl_type;
5445:
5446: l_timezone_col SYSTEM.number_tbl_type;
5447:
5448: l_tc_tz_pair_id_col SYSTEM.number_tbl_type;
5449:
5450: l_record_count_col SYSTEM.number_tbl_type;
5451:
5452:

Line 5450: l_record_count_col SYSTEM.number_tbl_type;

5446: l_timezone_col SYSTEM.number_tbl_type;
5447:
5448: l_tc_tz_pair_id_col SYSTEM.number_tbl_type;
5449:
5450: l_record_count_col SYSTEM.number_tbl_type;
5451:
5452:
5453:
5454: BEGIN

Line 5948: , x_subset_id_col OUT NOCOPY SYSTEM.number_tbl_type -- OUT

5944: ( p_list_id IN NUMBER
5945:
5946: , p_source_type_view IN VARCHAR2
5947:
5948: , x_subset_id_col OUT NOCOPY SYSTEM.number_tbl_type -- OUT
5949:
5950: , x_subset_view_col OUT NOCOPY SYSTEM.varchar_tbl_type) -- OUT
5951:
5952: IS

Line 5964: x_subset_id_col := SYSTEM.number_tbl_type();

5960: BEGIN
5961:
5962:
5963:
5964: x_subset_id_col := SYSTEM.number_tbl_type();
5965:
5966: x_subset_view_col := SYSTEM.varchar_tbl_type();
5967:
5968:

Line 6176: , p_subset_id_col IN SYSTEM.number_tbl_type

6172: PROCEDURE Partition_SubsetEntries
6173:
6174: ( p_list_id IN NUMBER
6175:
6176: , p_subset_id_col IN SYSTEM.number_tbl_type
6177:
6178: , p_subset_view_col IN SYSTEM.varchar_tbl_type
6179:
6180: , x_subset_rec_loaded_col OUT NOCOPY SYSTEM.number_tbl_type) -- OUT

Line 6180: , x_subset_rec_loaded_col OUT NOCOPY SYSTEM.number_tbl_type) -- OUT

6176: , p_subset_id_col IN SYSTEM.number_tbl_type
6177:
6178: , p_subset_view_col IN SYSTEM.varchar_tbl_type
6179:
6180: , x_subset_rec_loaded_col OUT NOCOPY SYSTEM.number_tbl_type) -- OUT
6181:
6182: IS
6183:
6184: BEGIN

Line 6188: x_subset_rec_loaded_col := SYSTEM.number_tbl_type();

6184: BEGIN
6185:
6186:
6187:
6188: x_subset_rec_loaded_col := SYSTEM.number_tbl_type();
6189:
6190:
6191:
6192: IF p_subset_id_col IS NOT NULL AND p_subset_id_col.COUNT > 1 THEN

Line 8270: , p_returns_id_col IN SYSTEM.number_tbl_type

8266: ( p_list_id IN NUMBER
8267:
8268: , p_schedule_id IN NUMBER
8269:
8270: , p_returns_id_col IN SYSTEM.number_tbl_type
8271:
8272: )
8273:
8274: IS

Line 8276: l_returns_id_col SYSTEM.number_tbl_type;

8272: )
8273:
8274: IS
8275:
8276: l_returns_id_col SYSTEM.number_tbl_type;
8277:
8278: l_subset_id_col SYSTEM.number_tbl_type;
8279:
8280: l_list_entry_id_col SYSTEM.number_tbl_type;

Line 8278: l_subset_id_col SYSTEM.number_tbl_type;

8274: IS
8275:
8276: l_returns_id_col SYSTEM.number_tbl_type;
8277:
8278: l_subset_id_col SYSTEM.number_tbl_type;
8279:
8280: l_list_entry_id_col SYSTEM.number_tbl_type;
8281:
8282: l_callable_zone_id_col SYSTEM.number_tbl_type;

Line 8280: l_list_entry_id_col SYSTEM.number_tbl_type;

8276: l_returns_id_col SYSTEM.number_tbl_type;
8277:
8278: l_subset_id_col SYSTEM.number_tbl_type;
8279:
8280: l_list_entry_id_col SYSTEM.number_tbl_type;
8281:
8282: l_callable_zone_id_col SYSTEM.number_tbl_type;
8283:
8284: l_do_not_use_col SYSTEM.varchar_tbl_type;

Line 8282: l_callable_zone_id_col SYSTEM.number_tbl_type;

8278: l_subset_id_col SYSTEM.number_tbl_type;
8279:
8280: l_list_entry_id_col SYSTEM.number_tbl_type;
8281:
8282: l_callable_zone_id_col SYSTEM.number_tbl_type;
8283:
8284: l_do_not_use_col SYSTEM.varchar_tbl_type;
8285:
8286: l_rl_incr_amount_col SYSTEM.number_tbl_type;

Line 8286: l_rl_incr_amount_col SYSTEM.number_tbl_type;

8282: l_callable_zone_id_col SYSTEM.number_tbl_type;
8283:
8284: l_do_not_use_col SYSTEM.varchar_tbl_type;
8285:
8286: l_rl_incr_amount_col SYSTEM.number_tbl_type;
8287:
8288: l_cz_incr_amount_col SYSTEM.number_tbl_type;
8289:
8290: BEGIN

Line 8288: l_cz_incr_amount_col SYSTEM.number_tbl_type;

8284: l_do_not_use_col SYSTEM.varchar_tbl_type;
8285:
8286: l_rl_incr_amount_col SYSTEM.number_tbl_type;
8287:
8288: l_cz_incr_amount_col SYSTEM.number_tbl_type;
8289:
8290: BEGIN
8291:
8292:

Line 8302: AND A.RETURNS_ID IN (SELECT * FROM TABLE(CAST(p_returns_id_col AS SYSTEM.NUMBER_TBL_TYPE)))

8298: DELETE IEC_G_RETURN_ENTRIES A
8299:
8300: WHERE A.LIST_HEADER_ID = p_list_id
8301:
8302: AND A.RETURNS_ID IN (SELECT * FROM TABLE(CAST(p_returns_id_col AS SYSTEM.NUMBER_TBL_TYPE)))
8303: RETURNING A.RETURNS_ID, A.SUBSET_ID, A.LIST_ENTRY_ID, A.ITM_CC_TZ_ID, A.DO_NOT_USE_FLAG
8304: BULK COLLECT INTO l_returns_id_col, l_subset_id_col, l_list_entry_id_col, l_callable_zone_id_col, l_do_not_use_col;
8305:
8306:

Line 8360: l_cz_incr_amount_col := SYSTEM.number_tbl_type();

8356: , IN l_list_entry_id_col;
8357:
8358:
8359:
8360: l_cz_incr_amount_col := SYSTEM.number_tbl_type();
8361:
8362: l_rl_incr_amount_col := SYSTEM.number_tbl_type();
8363:
8364: FOR i IN 1..l_do_not_use_col.LAST LOOP

Line 8362: l_rl_incr_amount_col := SYSTEM.number_tbl_type();

8358:
8359:
8360: l_cz_incr_amount_col := SYSTEM.number_tbl_type();
8361:
8362: l_rl_incr_amount_col := SYSTEM.number_tbl_type();
8363:
8364: FOR i IN 1..l_do_not_use_col.LAST LOOP
8365:
8366: l_cz_incr_amount_col.EXTEND;

Line 8440: l_returns_id_col SYSTEM.number_tbl_type;

8436: )
8437:
8438: IS
8439:
8440: l_returns_id_col SYSTEM.number_tbl_type;
8441:
8442: BEGIN
8443:
8444:

Line 8574: l_returns_id_col SYSTEM.number_tbl_type;

8570: l_api_initiated BOOLEAN;
8571:
8572: l_list_id NUMBER(15);
8573:
8574: l_returns_id_col SYSTEM.number_tbl_type;
8575:
8576: l_list_entry_id_col SYSTEM.number_tbl_type;
8577:
8578: l_status_code VARCHAR2(30);

Line 8576: l_list_entry_id_col SYSTEM.number_tbl_type;

8572: l_list_id NUMBER(15);
8573:
8574: l_returns_id_col SYSTEM.number_tbl_type;
8575:
8576: l_list_entry_id_col SYSTEM.number_tbl_type;
8577:
8578: l_status_code VARCHAR2(30);
8579:
8580: BEGIN

Line 8740: AND LIST_ENTRY_ID IN (SELECT * FROM TABLE(CAST(:list_entry_id_col AS SYSTEM.NUMBER_TBL_TYPE)));

8736: , REASON_CODE_S6 = NULL
8737:
8738: WHERE LIST_HEADER_ID = :list_id
8739:
8740: AND LIST_ENTRY_ID IN (SELECT * FROM TABLE(CAST(:list_entry_id_col AS SYSTEM.NUMBER_TBL_TYPE)));
8741: END;'
8742: USING IN l_list_id
8743:
8744: , IN l_list_entry_id_col;

Line 8914: l_subset_id_col SYSTEM.number_tbl_type;

8910: l_entry_count NUMBER;
8911:
8912:
8913:
8914: l_subset_id_col SYSTEM.number_tbl_type;
8915:
8916: l_subset_view_col SYSTEM.varchar_tbl_type;
8917:
8918: l_subset_rec_loaded_col SYSTEM.number_tbl_type;

Line 8918: l_subset_rec_loaded_col SYSTEM.number_tbl_type;

8914: l_subset_id_col SYSTEM.number_tbl_type;
8915:
8916: l_subset_view_col SYSTEM.varchar_tbl_type;
8917:
8918: l_subset_rec_loaded_col SYSTEM.number_tbl_type;
8919:
8920:
8921:
8922: l_callable_zone_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();

Line 8922: l_callable_zone_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();

8918: l_subset_rec_loaded_col SYSTEM.number_tbl_type;
8919:
8920:
8921:
8922: l_callable_zone_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
8923:
8924: l_callable_zone_incr_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
8925:
8926: l_subset_rec_loaded_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();

Line 8924: l_callable_zone_incr_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();

8920:
8921:
8922: l_callable_zone_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
8923:
8924: l_callable_zone_incr_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
8925:
8926: l_subset_rec_loaded_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
8927:
8928: l_subset_rec_loaded_incr_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();

Line 8926: l_subset_rec_loaded_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();

8922: l_callable_zone_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
8923:
8924: l_callable_zone_incr_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
8925:
8926: l_subset_rec_loaded_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
8927:
8928: l_subset_rec_loaded_incr_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
8929:
8930:

Line 8928: l_subset_rec_loaded_incr_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();

8924: l_callable_zone_incr_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
8925:
8926: l_subset_rec_loaded_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
8927:
8928: l_subset_rec_loaded_incr_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
8929:
8930:
8931:
8932: BEGIN

Line 10534: l_source_type_count_col SYSTEM.number_tbl_type;

10530: l_found_list_source_type BOOLEAN := FALSE;
10531:
10532: l_source_type_col SYSTEM.varchar_tbl_type;
10533:
10534: l_source_type_count_col SYSTEM.number_tbl_type;
10535:
10536: l_list_source_type VARCHAR2(32);
10537:
10538: BEGIN

Line 11040: ( p_from_list_entry_id_col IN SYSTEM.number_tbl_type

11036:
11037:
11038: PROCEDURE Copy_AmsListEntries
11039:
11040: ( p_from_list_entry_id_col IN SYSTEM.number_tbl_type
11041:
11042: , p_from_list_id_col IN SYSTEM.number_tbl_type
11043:
11044: , x_to_list_entry_id_col OUT NOCOPY SYSTEM.number_tbl_type -- OUT

Line 11042: , p_from_list_id_col IN SYSTEM.number_tbl_type

11038: PROCEDURE Copy_AmsListEntries
11039:
11040: ( p_from_list_entry_id_col IN SYSTEM.number_tbl_type
11041:
11042: , p_from_list_id_col IN SYSTEM.number_tbl_type
11043:
11044: , x_to_list_entry_id_col OUT NOCOPY SYSTEM.number_tbl_type -- OUT
11045:
11046: , p_to_list_id IN NUMBER)

Line 11044: , x_to_list_entry_id_col OUT NOCOPY SYSTEM.number_tbl_type -- OUT

11040: ( p_from_list_entry_id_col IN SYSTEM.number_tbl_type
11041:
11042: , p_from_list_id_col IN SYSTEM.number_tbl_type
11043:
11044: , x_to_list_entry_id_col OUT NOCOPY SYSTEM.number_tbl_type -- OUT
11045:
11046: , p_to_list_id IN NUMBER)
11047: IS
11048: l_api_version CONSTANT NUMBER := 1.0;

Line 11057: x_to_list_entry_id_col := SYSTEM.number_tbl_type();

11053: l_listentry_rec AMS_LISTENTRY_PVT.entry_rec_type;
11054: BEGIN
11055: l_init_msg_list :=FND_API.G_TRUE;
11056:
11057: x_to_list_entry_id_col := SYSTEM.number_tbl_type();
11058:
11059: x_to_list_entry_id_col.EXTEND(p_from_list_entry_id_col.COUNT);
11060:
11061: FOR i IN 1..x_to_list_entry_id_col.COUNT

Line 11432: ( p_returns_id_col IN SYSTEM.number_tbl_type

11428:
11429:
11430: PROCEDURE Mark_EntriesDoNotUse
11431:
11432: ( p_returns_id_col IN SYSTEM.number_tbl_type
11433:
11434: , x_returns_id_col OUT NOCOPY SYSTEM.number_tbl_type
11435:
11436: , x_list_entry_id_col OUT NOCOPY SYSTEM.number_tbl_type

Line 11434: , x_returns_id_col OUT NOCOPY SYSTEM.number_tbl_type

11430: PROCEDURE Mark_EntriesDoNotUse
11431:
11432: ( p_returns_id_col IN SYSTEM.number_tbl_type
11433:
11434: , x_returns_id_col OUT NOCOPY SYSTEM.number_tbl_type
11435:
11436: , x_list_entry_id_col OUT NOCOPY SYSTEM.number_tbl_type
11437:
11438: , x_list_id_col OUT NOCOPY SYSTEM.number_tbl_type

Line 11436: , x_list_entry_id_col OUT NOCOPY SYSTEM.number_tbl_type

11432: ( p_returns_id_col IN SYSTEM.number_tbl_type
11433:
11434: , x_returns_id_col OUT NOCOPY SYSTEM.number_tbl_type
11435:
11436: , x_list_entry_id_col OUT NOCOPY SYSTEM.number_tbl_type
11437:
11438: , x_list_id_col OUT NOCOPY SYSTEM.number_tbl_type
11439:
11440: )

Line 11438: , x_list_id_col OUT NOCOPY SYSTEM.number_tbl_type

11434: , x_returns_id_col OUT NOCOPY SYSTEM.number_tbl_type
11435:
11436: , x_list_entry_id_col OUT NOCOPY SYSTEM.number_tbl_type
11437:
11438: , x_list_id_col OUT NOCOPY SYSTEM.number_tbl_type
11439:
11440: )
11441:
11442: IS

Line 11444: l_callable_zone_id_col SYSTEM.number_tbl_type;

11440: )
11441:
11442: IS
11443:
11444: l_callable_zone_id_col SYSTEM.number_tbl_type;
11445:
11446: l_do_not_use_col SYSTEM.varchar_tbl_type;
11447:
11448: l_decr_count_col SYSTEM.number_tbl_type;

Line 11448: l_decr_count_col SYSTEM.number_tbl_type;

11444: l_callable_zone_id_col SYSTEM.number_tbl_type;
11445:
11446: l_do_not_use_col SYSTEM.varchar_tbl_type;
11447:
11448: l_decr_count_col SYSTEM.number_tbl_type;
11449:
11450: BEGIN
11451:
11452:

Line 11454: x_returns_id_col := SYSTEM.number_tbl_type();

11450: BEGIN
11451:
11452:
11453:
11454: x_returns_id_col := SYSTEM.number_tbl_type();
11455:
11456: x_list_entry_id_col := SYSTEM.number_tbl_type();
11457:
11458: x_list_id_col := SYSTEM.number_tbl_type();

Line 11456: x_list_entry_id_col := SYSTEM.number_tbl_type();

11452:
11453:
11454: x_returns_id_col := SYSTEM.number_tbl_type();
11455:
11456: x_list_entry_id_col := SYSTEM.number_tbl_type();
11457:
11458: x_list_id_col := SYSTEM.number_tbl_type();
11459:
11460: l_callable_zone_id_col := SYSTEM.number_tbl_type();

Line 11458: x_list_id_col := SYSTEM.number_tbl_type();

11454: x_returns_id_col := SYSTEM.number_tbl_type();
11455:
11456: x_list_entry_id_col := SYSTEM.number_tbl_type();
11457:
11458: x_list_id_col := SYSTEM.number_tbl_type();
11459:
11460: l_callable_zone_id_col := SYSTEM.number_tbl_type();
11461:
11462: l_do_not_use_col := SYSTEM.varchar_tbl_type();

Line 11460: l_callable_zone_id_col := SYSTEM.number_tbl_type();

11456: x_list_entry_id_col := SYSTEM.number_tbl_type();
11457:
11458: x_list_id_col := SYSTEM.number_tbl_type();
11459:
11460: l_callable_zone_id_col := SYSTEM.number_tbl_type();
11461:
11462: l_do_not_use_col := SYSTEM.varchar_tbl_type();
11463:
11464: l_decr_count_col := SYSTEM.number_tbl_type();

Line 11464: l_decr_count_col := SYSTEM.number_tbl_type();

11460: l_callable_zone_id_col := SYSTEM.number_tbl_type();
11461:
11462: l_do_not_use_col := SYSTEM.varchar_tbl_type();
11463:
11464: l_decr_count_col := SYSTEM.number_tbl_type();
11465:
11466:
11467:
11468: -- Get all records that need to be marked as dnu

Line 11486: WHERE RETURNS_ID IN (SELECT * FROM TABLE(CAST(:p_returns_id_col AS SYSTEM.NUMBER_TBL_TYPE)));

11482: BULK COLLECT INTO :returns_id_col, :list_entry_id_col, :list_id_col, :callable_zone_id_col, :do_not_use_col
11483:
11484: FROM IEC_G_RETURN_ENTRIES
11485:
11486: WHERE RETURNS_ID IN (SELECT * FROM TABLE(CAST(:p_returns_id_col AS SYSTEM.NUMBER_TBL_TYPE)));
11487:
11488: END;'
11489:
11490: USING OUT x_returns_id_col

Line 11566: ( p_returns_id_col IN SYSTEM.number_tbl_type

11562:
11563:
11564: PROCEDURE Mark_EntriesDoNotUse
11565:
11566: ( p_returns_id_col IN SYSTEM.number_tbl_type
11567:
11568: , p_to_list_id IN NUMBER
11569:
11570: , x_returns_id_col OUT NOCOPY SYSTEM.number_tbl_type -- OUT

Line 11570: , x_returns_id_col OUT NOCOPY SYSTEM.number_tbl_type -- OUT

11566: ( p_returns_id_col IN SYSTEM.number_tbl_type
11567:
11568: , p_to_list_id IN NUMBER
11569:
11570: , x_returns_id_col OUT NOCOPY SYSTEM.number_tbl_type -- OUT
11571:
11572: , x_list_entry_id_col OUT NOCOPY SYSTEM.number_tbl_type -- OUT
11573:
11574: , x_list_id_col OUT NOCOPY SYSTEM.number_tbl_type) -- OUT

Line 11572: , x_list_entry_id_col OUT NOCOPY SYSTEM.number_tbl_type -- OUT

11568: , p_to_list_id IN NUMBER
11569:
11570: , x_returns_id_col OUT NOCOPY SYSTEM.number_tbl_type -- OUT
11571:
11572: , x_list_entry_id_col OUT NOCOPY SYSTEM.number_tbl_type -- OUT
11573:
11574: , x_list_id_col OUT NOCOPY SYSTEM.number_tbl_type) -- OUT
11575:
11576: IS

Line 11574: , x_list_id_col OUT NOCOPY SYSTEM.number_tbl_type) -- OUT

11570: , x_returns_id_col OUT NOCOPY SYSTEM.number_tbl_type -- OUT
11571:
11572: , x_list_entry_id_col OUT NOCOPY SYSTEM.number_tbl_type -- OUT
11573:
11574: , x_list_id_col OUT NOCOPY SYSTEM.number_tbl_type) -- OUT
11575:
11576: IS
11577:
11578: l_temp_returns_id_col SYSTEM.number_tbl_type;

Line 11578: l_temp_returns_id_col SYSTEM.number_tbl_type;

11574: , x_list_id_col OUT NOCOPY SYSTEM.number_tbl_type) -- OUT
11575:
11576: IS
11577:
11578: l_temp_returns_id_col SYSTEM.number_tbl_type;
11579:
11580: BEGIN
11581:
11582:

Line 11598: WHERE A.RETURNS_ID IN (SELECT * FROM TABLE(CAST(:p_returns_id_col AS SYSTEM.NUMBER_TBL_TYPE)))

11594: BULK COLLECT INTO :returns_id_col
11595:
11596: FROM IEC_G_RETURN_ENTRIES A
11597:
11598: WHERE A.RETURNS_ID IN (SELECT * FROM TABLE(CAST(:p_returns_id_col AS SYSTEM.NUMBER_TBL_TYPE)))
11599:
11600: AND A.LIST_ENTRY_ID IN (SELECT LIST_ENTRY_ID
11601:
11602: FROM AMS_LIST_ENTRIES

Line 11660: ( p_from_returns_id_col IN SYSTEM.number_tbl_type

11656:
11657:
11658: PROCEDURE Move_CallHistory
11659:
11660: ( p_from_returns_id_col IN SYSTEM.number_tbl_type
11661:
11662: , p_to_list_entry_id_col IN SYSTEM.number_tbl_type
11663:
11664: , p_to_list_id IN NUMBER)

Line 11662: , p_to_list_entry_id_col IN SYSTEM.number_tbl_type

11658: PROCEDURE Move_CallHistory
11659:
11660: ( p_from_returns_id_col IN SYSTEM.number_tbl_type
11661:
11662: , p_to_list_entry_id_col IN SYSTEM.number_tbl_type
11663:
11664: , p_to_list_id IN NUMBER)
11665:
11666: IS

Line 11670: l_new_returns_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();

11666: IS
11667:
11668:
11669:
11670: l_new_returns_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
11671:
11672:
11673:
11674: l_cp_index_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();

Line 11674: l_cp_index_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();

11670: l_new_returns_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
11671:
11672:
11673:
11674: l_cp_index_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
11675:
11676: l_cp_postfix_col SYSTEM.varchar_tbl_type := SYSTEM.varchar_tbl_type();
11677:
11678: l_callback_flag_col SYSTEM.varchar_tbl_type := SYSTEM.varchar_tbl_type();

Line 11898: ( p_list_entry_id_col IN SYSTEM.number_tbl_type

11894: -- Loads a collection of new/recycled entries into AO system
11895:
11896: PROCEDURE Load_Entries_Pvt
11897:
11898: ( p_list_entry_id_col IN SYSTEM.number_tbl_type
11899:
11900: , p_list_id IN NUMBER
11901:
11902: , p_enable_val_rules_flag IN VARCHAR2

Line 11966: AND A.LIST_ENTRY_ID IN (SELECT * FROM TABLE(CAST(:list_entry_id_col AS SYSTEM.NUMBER_TBL_TYPE)))'

11962: AND A.LIST_ENTRY_ID = B.LIST_ENTRY_ID(+)
11963:
11964: AND A.LIST_HEADER_ID = :list_id
11965:
11966: AND A.LIST_ENTRY_ID IN (SELECT * FROM TABLE(CAST(:list_entry_id_col AS SYSTEM.NUMBER_TBL_TYPE)))'
11967: USING p_list_id, p_list_entry_id_col;
11968: EXCEPTION
11969: WHEN OTHERS THEN
11970: IF SQLCODE = -904 THEN

Line 12041: l_to_list_entry_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type(0);

12037:
12038: )
12039:
12040: IS
12041: l_to_list_entry_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type(0);
12042: l_from_returns_id_col SYSTEM.number_tbl_type;
12043: l_ignore1 SYSTEM.number_tbl_type;
12044: l_ignore2 SYSTEM.number_tbl_type;
12045: l_ignore3 SYSTEM.number_tbl_type;

Line 12042: l_from_returns_id_col SYSTEM.number_tbl_type;

12038: )
12039:
12040: IS
12041: l_to_list_entry_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type(0);
12042: l_from_returns_id_col SYSTEM.number_tbl_type;
12043: l_ignore1 SYSTEM.number_tbl_type;
12044: l_ignore2 SYSTEM.number_tbl_type;
12045: l_ignore3 SYSTEM.number_tbl_type;
12046: l_num NUMBER := 1;

Line 12043: l_ignore1 SYSTEM.number_tbl_type;

12039:
12040: IS
12041: l_to_list_entry_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type(0);
12042: l_from_returns_id_col SYSTEM.number_tbl_type;
12043: l_ignore1 SYSTEM.number_tbl_type;
12044: l_ignore2 SYSTEM.number_tbl_type;
12045: l_ignore3 SYSTEM.number_tbl_type;
12046: l_num NUMBER := 1;
12047:

Line 12044: l_ignore2 SYSTEM.number_tbl_type;

12040: IS
12041: l_to_list_entry_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type(0);
12042: l_from_returns_id_col SYSTEM.number_tbl_type;
12043: l_ignore1 SYSTEM.number_tbl_type;
12044: l_ignore2 SYSTEM.number_tbl_type;
12045: l_ignore3 SYSTEM.number_tbl_type;
12046: l_num NUMBER := 1;
12047:
12048: Cursor c_listentryrec IS

Line 12045: l_ignore3 SYSTEM.number_tbl_type;

12041: l_to_list_entry_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type(0);
12042: l_from_returns_id_col SYSTEM.number_tbl_type;
12043: l_ignore1 SYSTEM.number_tbl_type;
12044: l_ignore2 SYSTEM.number_tbl_type;
12045: l_ignore3 SYSTEM.number_tbl_type;
12046: l_num NUMBER := 1;
12047:
12048: Cursor c_listentryrec IS
12049: SELECT B.list_entry_id, B.list_header_id, A.LAST_UPDATE_DATE, A.LAST_UPDATED_BY, A.CREATION_DATE, A.CREATED_BY, A.LAST_UPDATE_LOGIN, A.OBJECT_VERSION_NUMBER

Line 12737: ( p_from_returns_id_col IN SYSTEM.number_tbl_type

12733:
12734:
12735: PROCEDURE Log_DuplicateEntries
12736:
12737: ( p_from_returns_id_col IN SYSTEM.number_tbl_type
12738:
12739: , p_to_list_id IN NUMBER
12740:
12741: , p_to_schedule_id IN NUMBER

Line 12749: l_from_returns_id_col SYSTEM.number_tbl_type; -- will only contain duplicates

12745: )
12746:
12747: IS
12748:
12749: l_from_returns_id_col SYSTEM.number_tbl_type; -- will only contain duplicates
12750:
12751: l_from_list_id_col SYSTEM.number_tbl_type;
12752:
12753: l_from_list_entry_id_col SYSTEM.number_tbl_type;

Line 12751: l_from_list_id_col SYSTEM.number_tbl_type;

12747: IS
12748:
12749: l_from_returns_id_col SYSTEM.number_tbl_type; -- will only contain duplicates
12750:
12751: l_from_list_id_col SYSTEM.number_tbl_type;
12752:
12753: l_from_list_entry_id_col SYSTEM.number_tbl_type;
12754:
12755: l_from_schedule_id_col SYSTEM.number_tbl_type;

Line 12753: l_from_list_entry_id_col SYSTEM.number_tbl_type;

12749: l_from_returns_id_col SYSTEM.number_tbl_type; -- will only contain duplicates
12750:
12751: l_from_list_id_col SYSTEM.number_tbl_type;
12752:
12753: l_from_list_entry_id_col SYSTEM.number_tbl_type;
12754:
12755: l_from_schedule_id_col SYSTEM.number_tbl_type;
12756:
12757: l_party_id_col SYSTEM.number_tbl_type;

Line 12755: l_from_schedule_id_col SYSTEM.number_tbl_type;

12751: l_from_list_id_col SYSTEM.number_tbl_type;
12752:
12753: l_from_list_entry_id_col SYSTEM.number_tbl_type;
12754:
12755: l_from_schedule_id_col SYSTEM.number_tbl_type;
12756:
12757: l_party_id_col SYSTEM.number_tbl_type;
12758:
12759:

Line 12757: l_party_id_col SYSTEM.number_tbl_type;

12753: l_from_list_entry_id_col SYSTEM.number_tbl_type;
12754:
12755: l_from_schedule_id_col SYSTEM.number_tbl_type;
12756:
12757: l_party_id_col SYSTEM.number_tbl_type;
12758:
12759:
12760:
12761: l_error_msg VARCHAR2(4000);

Line 12779: AND A.RETURNS_ID IN (SELECT * FROM TABLE(CAST(p_from_returns_id_col AS SYSTEM.NUMBER_TBL_TYPE)))

12775: WHERE A.LIST_HEADER_ID = B.LIST_HEADER_ID
12776:
12777: AND A.LIST_ENTRY_ID = B.LIST_ENTRY_ID
12778:
12779: AND A.RETURNS_ID IN (SELECT * FROM TABLE(CAST(p_from_returns_id_col AS SYSTEM.NUMBER_TBL_TYPE)))
12780:
12781: AND B.PARTY_ID IN (SELECT PARTY_ID FROM AMS_LIST_ENTRIES WHERE LIST_HEADER_ID = p_to_list_id);
12782:
12783:

Line 12852: l_returns_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();

12848: , p_to_list_id IN NUMBER)
12849:
12850: IS
12851:
12852: l_returns_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
12853:
12854: BEGIN
12855:
12856: IF p_returns_id IS NULL OR p_to_list_id IS NULL THEN

Line 12884: ( p_returns_id_col IN SYSTEM.number_tbl_type

12880: -- Called by Recycling plugin to move recycled entries
12881:
12882: PROCEDURE Move_RecycledEntries
12883:
12884: ( p_returns_id_col IN SYSTEM.number_tbl_type
12885:
12886: , p_to_list_id IN NUMBER)
12887:
12888: IS

Line 12890: l_from_returns_id_col SYSTEM.number_tbl_type;

12886: , p_to_list_id IN NUMBER)
12887:
12888: IS
12889:
12890: l_from_returns_id_col SYSTEM.number_tbl_type;
12891:
12892: l_from_list_entry_id_col SYSTEM.number_tbl_type;
12893:
12894: l_from_list_id_col SYSTEM.number_tbl_type;

Line 12892: l_from_list_entry_id_col SYSTEM.number_tbl_type;

12888: IS
12889:
12890: l_from_returns_id_col SYSTEM.number_tbl_type;
12891:
12892: l_from_list_entry_id_col SYSTEM.number_tbl_type;
12893:
12894: l_from_list_id_col SYSTEM.number_tbl_type;
12895:
12896: l_to_list_entry_id_col SYSTEM.number_tbl_type;

Line 12894: l_from_list_id_col SYSTEM.number_tbl_type;

12890: l_from_returns_id_col SYSTEM.number_tbl_type;
12891:
12892: l_from_list_entry_id_col SYSTEM.number_tbl_type;
12893:
12894: l_from_list_id_col SYSTEM.number_tbl_type;
12895:
12896: l_to_list_entry_id_col SYSTEM.number_tbl_type;
12897:
12898: l_schedule_id NUMBER(15) := 0;

Line 12896: l_to_list_entry_id_col SYSTEM.number_tbl_type;

12892: l_from_list_entry_id_col SYSTEM.number_tbl_type;
12893:
12894: l_from_list_id_col SYSTEM.number_tbl_type;
12895:
12896: l_to_list_entry_id_col SYSTEM.number_tbl_type;
12897:
12898: l_schedule_id NUMBER(15) := 0;
12899:
12900: l_list_duplicate_incr NUMBER := 0;

Line 13051: l_returns_id_col SYSTEM.number_tbl_type;

13047: l_records_updated NUMBER;
13048:
13049:
13050:
13051: l_returns_id_col SYSTEM.number_tbl_type;
13052:
13053:
13054:
13055: l_src_returns_id_col SYSTEM.number_tbl_type;

Line 13055: l_src_returns_id_col SYSTEM.number_tbl_type;

13051: l_returns_id_col SYSTEM.number_tbl_type;
13052:
13053:
13054:
13055: l_src_returns_id_col SYSTEM.number_tbl_type;
13056:
13057: l_src_list_entry_id_col SYSTEM.number_tbl_type;
13058:
13059: l_src_list_id_col SYSTEM.number_tbl_type;

Line 13057: l_src_list_entry_id_col SYSTEM.number_tbl_type;

13053:
13054:
13055: l_src_returns_id_col SYSTEM.number_tbl_type;
13056:
13057: l_src_list_entry_id_col SYSTEM.number_tbl_type;
13058:
13059: l_src_list_id_col SYSTEM.number_tbl_type;
13060:
13061: l_dest_list_entry_id_col SYSTEM.number_tbl_type;

Line 13059: l_src_list_id_col SYSTEM.number_tbl_type;

13055: l_src_returns_id_col SYSTEM.number_tbl_type;
13056:
13057: l_src_list_entry_id_col SYSTEM.number_tbl_type;
13058:
13059: l_src_list_id_col SYSTEM.number_tbl_type;
13060:
13061: l_dest_list_entry_id_col SYSTEM.number_tbl_type;
13062:
13063:

Line 13061: l_dest_list_entry_id_col SYSTEM.number_tbl_type;

13057: l_src_list_entry_id_col SYSTEM.number_tbl_type;
13058:
13059: l_src_list_id_col SYSTEM.number_tbl_type;
13060:
13061: l_dest_list_entry_id_col SYSTEM.number_tbl_type;
13062:
13063:
13064:
13065: -- Cursor to retrieve non-duplicate records

Line 13449: l_from_returns_id_col SYSTEM.number_tbl_type;

13445: , p_commit_flag IN BOOLEAN)
13446:
13447: IS
13448:
13449: l_from_returns_id_col SYSTEM.number_tbl_type;
13450:
13451: l_from_list_entry_id_col SYSTEM.number_tbl_type;
13452:
13453: l_from_list_id_col SYSTEM.number_tbl_type;

Line 13451: l_from_list_entry_id_col SYSTEM.number_tbl_type;

13447: IS
13448:
13449: l_from_returns_id_col SYSTEM.number_tbl_type;
13450:
13451: l_from_list_entry_id_col SYSTEM.number_tbl_type;
13452:
13453: l_from_list_id_col SYSTEM.number_tbl_type;
13454:
13455: l_to_list_entry_id_col SYSTEM.number_tbl_type;

Line 13453: l_from_list_id_col SYSTEM.number_tbl_type;

13449: l_from_returns_id_col SYSTEM.number_tbl_type;
13450:
13451: l_from_list_entry_id_col SYSTEM.number_tbl_type;
13452:
13453: l_from_list_id_col SYSTEM.number_tbl_type;
13454:
13455: l_to_list_entry_id_col SYSTEM.number_tbl_type;
13456:
13457:

Line 13455: l_to_list_entry_id_col SYSTEM.number_tbl_type;

13451: l_from_list_entry_id_col SYSTEM.number_tbl_type;
13452:
13453: l_from_list_id_col SYSTEM.number_tbl_type;
13454:
13455: l_to_list_entry_id_col SYSTEM.number_tbl_type;
13456:
13457:
13458:
13459: l_api_initiated BOOLEAN;

Line 14009: l_list_entry_id_col SYSTEM.NUMBER_TBL_TYPE := SYSTEM.NUMBER_TBL_TYPE();

14005: , p_list_id IN NUMBER)
14006:
14007: IS
14008:
14009: l_list_entry_id_col SYSTEM.NUMBER_TBL_TYPE := SYSTEM.NUMBER_TBL_TYPE();
14010:
14011: BEGIN
14012:
14013:

Line 14077: ( p_list_entry_id_col IN SYSTEM.number_tbl_type

14073:
14074:
14075: PROCEDURE Load_NewEntries
14076:
14077: ( p_list_entry_id_col IN SYSTEM.number_tbl_type
14078:
14079: , p_list_id IN NUMBER)
14080:
14081: IS

Line 15198: l_list_entry_id_col SYSTEM.NUMBER_TBL_TYPE := SYSTEM.NUMBER_TBL_TYPE();

15194: l_list_entry_id NUMBER(15);
15195:
15196: l_party_id NUMBER(15);
15197:
15198: l_list_entry_id_col SYSTEM.NUMBER_TBL_TYPE := SYSTEM.NUMBER_TBL_TYPE();
15199:
15200:
15201:
15202: BEGIN

Line 15800: l_subset_id_col SYSTEM.number_tbl_type;

15796: IS
15797:
15798:
15799:
15800: l_subset_id_col SYSTEM.number_tbl_type;
15801:
15802: l_subset_view_col SYSTEM.varchar_tbl_type;
15803:
15804: l_subset_rec_loaded_col SYSTEM.number_tbl_type;

Line 15804: l_subset_rec_loaded_col SYSTEM.number_tbl_type;

15800: l_subset_id_col SYSTEM.number_tbl_type;
15801:
15802: l_subset_view_col SYSTEM.varchar_tbl_type;
15803:
15804: l_subset_rec_loaded_col SYSTEM.number_tbl_type;
15805:
15806:
15807:
15808: l_list_entry_csr ListEntryCsrType;