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.

[Home] [Help]

APPS.IEC_VALIDATE_PVT dependencies on NUMBER_TBL_TYPE

Line 3100: , p_subset_id_col IN SYSTEM.number_tbl_type

3096: , p_schedule_id IN NUMBER
3097:
3098: , p_list_id IN NUMBER
3099:
3100: , p_subset_id_col IN SYSTEM.number_tbl_type
3101:
3102: , p_sub_rec_loaded_incr_col IN SYSTEM.number_tbl_type)
3103:
3104: IS

Line 3102: , p_sub_rec_loaded_incr_col IN SYSTEM.number_tbl_type)

3098: , p_list_id IN NUMBER
3099:
3100: , p_subset_id_col IN SYSTEM.number_tbl_type
3101:
3102: , p_sub_rec_loaded_incr_col IN SYSTEM.number_tbl_type)
3103:
3104: IS
3105:
3106: l_rec_count NUMBER;

Line 5060: , p_subset_id_col IN SYSTEM.number_tbl_type

5056: ( p_schedule_id IN NUMBER
5057:
5058: , p_list_id IN NUMBER
5059:
5060: , p_subset_id_col IN SYSTEM.number_tbl_type
5061:
5062: , p_incr_amount_col IN SYSTEM.number_tbl_type
5063:
5064: )

Line 5062: , p_incr_amount_col IN SYSTEM.number_tbl_type

5058: , p_list_id IN NUMBER
5059:
5060: , p_subset_id_col IN SYSTEM.number_tbl_type
5061:
5062: , p_incr_amount_col IN SYSTEM.number_tbl_type
5063:
5064: )
5065:
5066: IS

Line 5112: ( p_callable_zone_id_col IN SYSTEM.number_tbl_type

5108:
5109:
5110: PROCEDURE Incr_CallableZoneCounts
5111:
5112: ( p_callable_zone_id_col IN SYSTEM.number_tbl_type
5113:
5114: , p_incr_amount_col IN SYSTEM.number_tbl_type
5115:
5116: )

Line 5114: , p_incr_amount_col IN SYSTEM.number_tbl_type

5110: PROCEDURE Incr_CallableZoneCounts
5111:
5112: ( p_callable_zone_id_col IN SYSTEM.number_tbl_type
5113:
5114: , p_incr_amount_col IN SYSTEM.number_tbl_type
5115:
5116: )
5117:
5118: IS

Line 5160: ( p_callable_zone_id_col IN SYSTEM.number_tbl_type

5156:
5157:
5158: PROCEDURE Incr_CallableZoneCounts_Cache
5159:
5160: ( p_callable_zone_id_col IN SYSTEM.number_tbl_type
5161:
5162: , p_incr_amount_col IN SYSTEM.number_tbl_type
5163:
5164: )

Line 5162: , p_incr_amount_col IN SYSTEM.number_tbl_type

5158: PROCEDURE Incr_CallableZoneCounts_Cache
5159:
5160: ( p_callable_zone_id_col IN SYSTEM.number_tbl_type
5161:
5162: , p_incr_amount_col IN SYSTEM.number_tbl_type
5163:
5164: )
5165:
5166: IS

Line 5462: l_subset_id_col SYSTEM.number_tbl_type;

5458: , p_campaign_schedule_id IN NUMBER)
5459:
5460: IS
5461:
5462: l_subset_id_col SYSTEM.number_tbl_type;
5463:
5464: l_territory_code_col SYSTEM.varchar_tbl_type;
5465:
5466: l_region_col SYSTEM.varchar_tbl_type;

Line 5468: l_timezone_col SYSTEM.number_tbl_type;

5464: l_territory_code_col SYSTEM.varchar_tbl_type;
5465:
5466: l_region_col SYSTEM.varchar_tbl_type;
5467:
5468: l_timezone_col SYSTEM.number_tbl_type;
5469:
5470: l_tc_tz_pair_id_col SYSTEM.number_tbl_type;
5471:
5472: l_record_count_col SYSTEM.number_tbl_type;

Line 5470: l_tc_tz_pair_id_col SYSTEM.number_tbl_type;

5466: l_region_col SYSTEM.varchar_tbl_type;
5467:
5468: l_timezone_col SYSTEM.number_tbl_type;
5469:
5470: l_tc_tz_pair_id_col SYSTEM.number_tbl_type;
5471:
5472: l_record_count_col SYSTEM.number_tbl_type;
5473:
5474:

Line 5472: l_record_count_col SYSTEM.number_tbl_type;

5468: l_timezone_col SYSTEM.number_tbl_type;
5469:
5470: l_tc_tz_pair_id_col SYSTEM.number_tbl_type;
5471:
5472: l_record_count_col SYSTEM.number_tbl_type;
5473:
5474:
5475:
5476: BEGIN

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

5966: ( p_list_id IN NUMBER
5967:
5968: , p_source_type_view IN VARCHAR2
5969:
5970: , x_subset_id_col OUT NOCOPY SYSTEM.number_tbl_type -- OUT
5971:
5972: , x_subset_view_col OUT NOCOPY SYSTEM.varchar_tbl_type) -- OUT
5973:
5974: IS

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

5982: BEGIN
5983:
5984:
5985:
5986: x_subset_id_col := SYSTEM.number_tbl_type();
5987:
5988: x_subset_view_col := SYSTEM.varchar_tbl_type();
5989:
5990:

Line 6198: , p_subset_id_col IN SYSTEM.number_tbl_type

6194: PROCEDURE Partition_SubsetEntries
6195:
6196: ( p_list_id IN NUMBER
6197:
6198: , p_subset_id_col IN SYSTEM.number_tbl_type
6199:
6200: , p_subset_view_col IN SYSTEM.varchar_tbl_type
6201:
6202: , x_subset_rec_loaded_col OUT NOCOPY SYSTEM.number_tbl_type) -- OUT

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

6198: , p_subset_id_col IN SYSTEM.number_tbl_type
6199:
6200: , p_subset_view_col IN SYSTEM.varchar_tbl_type
6201:
6202: , x_subset_rec_loaded_col OUT NOCOPY SYSTEM.number_tbl_type) -- OUT
6203:
6204: IS
6205:
6206: BEGIN

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

6206: BEGIN
6207:
6208:
6209:
6210: x_subset_rec_loaded_col := SYSTEM.number_tbl_type();
6211:
6212:
6213:
6214: IF p_subset_id_col IS NOT NULL AND p_subset_id_col.COUNT > 1 THEN

Line 8292: , p_returns_id_col IN SYSTEM.number_tbl_type

8288: ( p_list_id IN NUMBER
8289:
8290: , p_schedule_id IN NUMBER
8291:
8292: , p_returns_id_col IN SYSTEM.number_tbl_type
8293:
8294: )
8295:
8296: IS

Line 8298: l_returns_id_col SYSTEM.number_tbl_type;

8294: )
8295:
8296: IS
8297:
8298: l_returns_id_col SYSTEM.number_tbl_type;
8299:
8300: l_subset_id_col SYSTEM.number_tbl_type;
8301:
8302: l_list_entry_id_col SYSTEM.number_tbl_type;

Line 8300: l_subset_id_col SYSTEM.number_tbl_type;

8296: IS
8297:
8298: l_returns_id_col SYSTEM.number_tbl_type;
8299:
8300: l_subset_id_col SYSTEM.number_tbl_type;
8301:
8302: l_list_entry_id_col SYSTEM.number_tbl_type;
8303:
8304: l_callable_zone_id_col SYSTEM.number_tbl_type;

Line 8302: l_list_entry_id_col SYSTEM.number_tbl_type;

8298: l_returns_id_col SYSTEM.number_tbl_type;
8299:
8300: l_subset_id_col SYSTEM.number_tbl_type;
8301:
8302: l_list_entry_id_col SYSTEM.number_tbl_type;
8303:
8304: l_callable_zone_id_col SYSTEM.number_tbl_type;
8305:
8306: l_do_not_use_col SYSTEM.varchar_tbl_type;

Line 8304: l_callable_zone_id_col SYSTEM.number_tbl_type;

8300: l_subset_id_col SYSTEM.number_tbl_type;
8301:
8302: l_list_entry_id_col SYSTEM.number_tbl_type;
8303:
8304: l_callable_zone_id_col SYSTEM.number_tbl_type;
8305:
8306: l_do_not_use_col SYSTEM.varchar_tbl_type;
8307:
8308: l_rl_incr_amount_col SYSTEM.number_tbl_type;

Line 8308: l_rl_incr_amount_col SYSTEM.number_tbl_type;

8304: l_callable_zone_id_col SYSTEM.number_tbl_type;
8305:
8306: l_do_not_use_col SYSTEM.varchar_tbl_type;
8307:
8308: l_rl_incr_amount_col SYSTEM.number_tbl_type;
8309:
8310: l_cz_incr_amount_col SYSTEM.number_tbl_type;
8311:
8312: BEGIN

Line 8310: l_cz_incr_amount_col SYSTEM.number_tbl_type;

8306: l_do_not_use_col SYSTEM.varchar_tbl_type;
8307:
8308: l_rl_incr_amount_col SYSTEM.number_tbl_type;
8309:
8310: l_cz_incr_amount_col SYSTEM.number_tbl_type;
8311:
8312: BEGIN
8313:
8314:

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

8320: DELETE IEC_G_RETURN_ENTRIES A
8321:
8322: WHERE A.LIST_HEADER_ID = p_list_id
8323:
8324: AND A.RETURNS_ID IN (SELECT * FROM TABLE(CAST(p_returns_id_col AS SYSTEM.NUMBER_TBL_TYPE)))
8325: RETURNING A.RETURNS_ID, A.SUBSET_ID, A.LIST_ENTRY_ID, A.ITM_CC_TZ_ID, A.DO_NOT_USE_FLAG
8326: 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;
8327:
8328:

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

8378: , IN l_list_entry_id_col;
8379:
8380:
8381:
8382: l_cz_incr_amount_col := SYSTEM.number_tbl_type();
8383:
8384: l_rl_incr_amount_col := SYSTEM.number_tbl_type();
8385:
8386: FOR i IN 1..l_do_not_use_col.LAST LOOP

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

8380:
8381:
8382: l_cz_incr_amount_col := SYSTEM.number_tbl_type();
8383:
8384: l_rl_incr_amount_col := SYSTEM.number_tbl_type();
8385:
8386: FOR i IN 1..l_do_not_use_col.LAST LOOP
8387:
8388: l_cz_incr_amount_col.EXTEND;

Line 8462: l_returns_id_col SYSTEM.number_tbl_type;

8458: )
8459:
8460: IS
8461:
8462: l_returns_id_col SYSTEM.number_tbl_type;
8463:
8464: BEGIN
8465:
8466:

Line 8596: l_returns_id_col SYSTEM.number_tbl_type;

8592: l_api_initiated BOOLEAN;
8593:
8594: l_list_id NUMBER(15);
8595:
8596: l_returns_id_col SYSTEM.number_tbl_type;
8597:
8598: l_list_entry_id_col SYSTEM.number_tbl_type;
8599:
8600: l_status_code VARCHAR2(30);

Line 8598: l_list_entry_id_col SYSTEM.number_tbl_type;

8594: l_list_id NUMBER(15);
8595:
8596: l_returns_id_col SYSTEM.number_tbl_type;
8597:
8598: l_list_entry_id_col SYSTEM.number_tbl_type;
8599:
8600: l_status_code VARCHAR2(30);
8601:
8602: BEGIN

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

8758: , REASON_CODE_S6 = NULL
8759:
8760: WHERE LIST_HEADER_ID = :list_id
8761:
8762: AND LIST_ENTRY_ID IN (SELECT * FROM TABLE(CAST(:list_entry_id_col AS SYSTEM.NUMBER_TBL_TYPE)));
8763: END;'
8764: USING IN l_list_id
8765:
8766: , IN l_list_entry_id_col;

Line 8936: l_subset_id_col SYSTEM.number_tbl_type;

8932: l_entry_count NUMBER;
8933:
8934:
8935:
8936: l_subset_id_col SYSTEM.number_tbl_type;
8937:
8938: l_subset_view_col SYSTEM.varchar_tbl_type;
8939:
8940: l_subset_rec_loaded_col SYSTEM.number_tbl_type;

Line 8940: l_subset_rec_loaded_col SYSTEM.number_tbl_type;

8936: l_subset_id_col SYSTEM.number_tbl_type;
8937:
8938: l_subset_view_col SYSTEM.varchar_tbl_type;
8939:
8940: l_subset_rec_loaded_col SYSTEM.number_tbl_type;
8941:
8942:
8943:
8944: l_callable_zone_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();

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

8940: l_subset_rec_loaded_col SYSTEM.number_tbl_type;
8941:
8942:
8943:
8944: l_callable_zone_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
8945:
8946: l_callable_zone_incr_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
8947:
8948: l_subset_rec_loaded_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();

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

8942:
8943:
8944: l_callable_zone_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
8945:
8946: l_callable_zone_incr_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
8947:
8948: l_subset_rec_loaded_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
8949:
8950: l_subset_rec_loaded_incr_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();

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

8944: l_callable_zone_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
8945:
8946: l_callable_zone_incr_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
8947:
8948: l_subset_rec_loaded_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
8949:
8950: l_subset_rec_loaded_incr_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
8951:
8952:

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

8946: l_callable_zone_incr_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
8947:
8948: l_subset_rec_loaded_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
8949:
8950: l_subset_rec_loaded_incr_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
8951:
8952:
8953:
8954: BEGIN

Line 10556: l_source_type_count_col SYSTEM.number_tbl_type;

10552: l_found_list_source_type BOOLEAN := FALSE;
10553:
10554: l_source_type_col SYSTEM.varchar_tbl_type;
10555:
10556: l_source_type_count_col SYSTEM.number_tbl_type;
10557:
10558: l_list_source_type VARCHAR2(32);
10559:
10560: BEGIN

Line 11062: ( p_from_list_entry_id_col IN SYSTEM.number_tbl_type

11058:
11059:
11060: PROCEDURE Copy_AmsListEntries
11061:
11062: ( p_from_list_entry_id_col IN SYSTEM.number_tbl_type
11063:
11064: , p_from_list_id_col IN SYSTEM.number_tbl_type
11065:
11066: , x_to_list_entry_id_col OUT NOCOPY SYSTEM.number_tbl_type -- OUT

Line 11064: , p_from_list_id_col IN SYSTEM.number_tbl_type

11060: PROCEDURE Copy_AmsListEntries
11061:
11062: ( p_from_list_entry_id_col IN SYSTEM.number_tbl_type
11063:
11064: , p_from_list_id_col IN SYSTEM.number_tbl_type
11065:
11066: , x_to_list_entry_id_col OUT NOCOPY SYSTEM.number_tbl_type -- OUT
11067:
11068: , p_to_list_id IN NUMBER)

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

11062: ( p_from_list_entry_id_col IN SYSTEM.number_tbl_type
11063:
11064: , p_from_list_id_col IN SYSTEM.number_tbl_type
11065:
11066: , x_to_list_entry_id_col OUT NOCOPY SYSTEM.number_tbl_type -- OUT
11067:
11068: , p_to_list_id IN NUMBER)
11069: IS
11070: l_api_version CONSTANT NUMBER := 1.0;

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

11075: l_listentry_rec AMS_LISTENTRY_PVT.entry_rec_type;
11076: BEGIN
11077: l_init_msg_list :=FND_API.G_TRUE;
11078:
11079: x_to_list_entry_id_col := SYSTEM.number_tbl_type();
11080:
11081: x_to_list_entry_id_col.EXTEND(p_from_list_entry_id_col.COUNT);
11082:
11083: FOR i IN 1..x_to_list_entry_id_col.COUNT

Line 11454: ( p_returns_id_col IN SYSTEM.number_tbl_type

11450:
11451:
11452: PROCEDURE Mark_EntriesDoNotUse
11453:
11454: ( p_returns_id_col IN SYSTEM.number_tbl_type
11455:
11456: , x_returns_id_col OUT NOCOPY SYSTEM.number_tbl_type
11457:
11458: , x_list_entry_id_col OUT NOCOPY SYSTEM.number_tbl_type

Line 11456: , x_returns_id_col OUT NOCOPY SYSTEM.number_tbl_type

11452: PROCEDURE Mark_EntriesDoNotUse
11453:
11454: ( p_returns_id_col IN SYSTEM.number_tbl_type
11455:
11456: , x_returns_id_col OUT NOCOPY SYSTEM.number_tbl_type
11457:
11458: , x_list_entry_id_col OUT NOCOPY SYSTEM.number_tbl_type
11459:
11460: , x_list_id_col OUT NOCOPY SYSTEM.number_tbl_type

Line 11458: , x_list_entry_id_col OUT NOCOPY SYSTEM.number_tbl_type

11454: ( p_returns_id_col IN SYSTEM.number_tbl_type
11455:
11456: , x_returns_id_col OUT NOCOPY SYSTEM.number_tbl_type
11457:
11458: , x_list_entry_id_col OUT NOCOPY SYSTEM.number_tbl_type
11459:
11460: , x_list_id_col OUT NOCOPY SYSTEM.number_tbl_type
11461:
11462: )

Line 11460: , x_list_id_col OUT NOCOPY SYSTEM.number_tbl_type

11456: , x_returns_id_col OUT NOCOPY SYSTEM.number_tbl_type
11457:
11458: , x_list_entry_id_col OUT NOCOPY SYSTEM.number_tbl_type
11459:
11460: , x_list_id_col OUT NOCOPY SYSTEM.number_tbl_type
11461:
11462: )
11463:
11464: IS

Line 11466: l_callable_zone_id_col SYSTEM.number_tbl_type;

11462: )
11463:
11464: IS
11465:
11466: l_callable_zone_id_col SYSTEM.number_tbl_type;
11467:
11468: l_do_not_use_col SYSTEM.varchar_tbl_type;
11469:
11470: l_decr_count_col SYSTEM.number_tbl_type;

Line 11470: l_decr_count_col SYSTEM.number_tbl_type;

11466: l_callable_zone_id_col SYSTEM.number_tbl_type;
11467:
11468: l_do_not_use_col SYSTEM.varchar_tbl_type;
11469:
11470: l_decr_count_col SYSTEM.number_tbl_type;
11471:
11472: BEGIN
11473:
11474:

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

11472: BEGIN
11473:
11474:
11475:
11476: x_returns_id_col := SYSTEM.number_tbl_type();
11477:
11478: x_list_entry_id_col := SYSTEM.number_tbl_type();
11479:
11480: x_list_id_col := SYSTEM.number_tbl_type();

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

11474:
11475:
11476: x_returns_id_col := SYSTEM.number_tbl_type();
11477:
11478: x_list_entry_id_col := SYSTEM.number_tbl_type();
11479:
11480: x_list_id_col := SYSTEM.number_tbl_type();
11481:
11482: l_callable_zone_id_col := SYSTEM.number_tbl_type();

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

11476: x_returns_id_col := SYSTEM.number_tbl_type();
11477:
11478: x_list_entry_id_col := SYSTEM.number_tbl_type();
11479:
11480: x_list_id_col := SYSTEM.number_tbl_type();
11481:
11482: l_callable_zone_id_col := SYSTEM.number_tbl_type();
11483:
11484: l_do_not_use_col := SYSTEM.varchar_tbl_type();

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

11478: x_list_entry_id_col := SYSTEM.number_tbl_type();
11479:
11480: x_list_id_col := SYSTEM.number_tbl_type();
11481:
11482: l_callable_zone_id_col := SYSTEM.number_tbl_type();
11483:
11484: l_do_not_use_col := SYSTEM.varchar_tbl_type();
11485:
11486: l_decr_count_col := SYSTEM.number_tbl_type();

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

11482: l_callable_zone_id_col := SYSTEM.number_tbl_type();
11483:
11484: l_do_not_use_col := SYSTEM.varchar_tbl_type();
11485:
11486: l_decr_count_col := SYSTEM.number_tbl_type();
11487:
11488:
11489:
11490: -- Get all records that need to be marked as dnu

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

11504: BULK COLLECT INTO :returns_id_col, :list_entry_id_col, :list_id_col, :callable_zone_id_col, :do_not_use_col
11505:
11506: FROM IEC_G_RETURN_ENTRIES
11507:
11508: WHERE RETURNS_ID IN (SELECT * FROM TABLE(CAST(:p_returns_id_col AS SYSTEM.NUMBER_TBL_TYPE)));
11509:
11510: END;'
11511:
11512: USING OUT x_returns_id_col

Line 11588: ( p_returns_id_col IN SYSTEM.number_tbl_type

11584:
11585:
11586: PROCEDURE Mark_EntriesDoNotUse
11587:
11588: ( p_returns_id_col IN SYSTEM.number_tbl_type
11589:
11590: , p_to_list_id IN NUMBER
11591:
11592: , x_returns_id_col OUT NOCOPY SYSTEM.number_tbl_type -- OUT

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

11588: ( p_returns_id_col IN SYSTEM.number_tbl_type
11589:
11590: , p_to_list_id IN NUMBER
11591:
11592: , x_returns_id_col OUT NOCOPY SYSTEM.number_tbl_type -- OUT
11593:
11594: , x_list_entry_id_col OUT NOCOPY SYSTEM.number_tbl_type -- OUT
11595:
11596: , x_list_id_col OUT NOCOPY SYSTEM.number_tbl_type) -- OUT

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

11590: , p_to_list_id IN NUMBER
11591:
11592: , x_returns_id_col OUT NOCOPY SYSTEM.number_tbl_type -- OUT
11593:
11594: , x_list_entry_id_col OUT NOCOPY SYSTEM.number_tbl_type -- OUT
11595:
11596: , x_list_id_col OUT NOCOPY SYSTEM.number_tbl_type) -- OUT
11597:
11598: IS

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

11592: , x_returns_id_col OUT NOCOPY SYSTEM.number_tbl_type -- OUT
11593:
11594: , x_list_entry_id_col OUT NOCOPY SYSTEM.number_tbl_type -- OUT
11595:
11596: , x_list_id_col OUT NOCOPY SYSTEM.number_tbl_type) -- OUT
11597:
11598: IS
11599:
11600: l_temp_returns_id_col SYSTEM.number_tbl_type;

Line 11600: l_temp_returns_id_col SYSTEM.number_tbl_type;

11596: , x_list_id_col OUT NOCOPY SYSTEM.number_tbl_type) -- OUT
11597:
11598: IS
11599:
11600: l_temp_returns_id_col SYSTEM.number_tbl_type;
11601:
11602: BEGIN
11603:
11604:

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

11616: BULK COLLECT INTO :returns_id_col
11617:
11618: FROM IEC_G_RETURN_ENTRIES A
11619:
11620: WHERE A.RETURNS_ID IN (SELECT * FROM TABLE(CAST(:p_returns_id_col AS SYSTEM.NUMBER_TBL_TYPE)))
11621:
11622: AND A.LIST_ENTRY_ID IN (SELECT LIST_ENTRY_ID
11623:
11624: FROM AMS_LIST_ENTRIES

Line 11682: ( p_from_returns_id_col IN SYSTEM.number_tbl_type

11678:
11679:
11680: PROCEDURE Move_CallHistory
11681:
11682: ( p_from_returns_id_col IN SYSTEM.number_tbl_type
11683:
11684: , p_to_list_entry_id_col IN SYSTEM.number_tbl_type
11685:
11686: , p_to_list_id IN NUMBER)

Line 11684: , p_to_list_entry_id_col IN SYSTEM.number_tbl_type

11680: PROCEDURE Move_CallHistory
11681:
11682: ( p_from_returns_id_col IN SYSTEM.number_tbl_type
11683:
11684: , p_to_list_entry_id_col IN SYSTEM.number_tbl_type
11685:
11686: , p_to_list_id IN NUMBER)
11687:
11688: IS

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

11688: IS
11689:
11690:
11691:
11692: l_new_returns_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
11693:
11694:
11695:
11696: l_cp_index_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();

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

11692: l_new_returns_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
11693:
11694:
11695:
11696: l_cp_index_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
11697:
11698: l_cp_postfix_col SYSTEM.varchar_tbl_type := SYSTEM.varchar_tbl_type();
11699:
11700: l_callback_flag_col SYSTEM.varchar_tbl_type := SYSTEM.varchar_tbl_type();

Line 11920: ( p_list_entry_id_col IN SYSTEM.number_tbl_type

11916: -- Loads a collection of new/recycled entries into AO system
11917:
11918: PROCEDURE Load_Entries_Pvt
11919:
11920: ( p_list_entry_id_col IN SYSTEM.number_tbl_type
11921:
11922: , p_list_id IN NUMBER
11923:
11924: , p_enable_val_rules_flag IN VARCHAR2

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

11984: AND A.LIST_ENTRY_ID = B.LIST_ENTRY_ID(+)
11985:
11986: AND A.LIST_HEADER_ID = :list_id
11987:
11988: AND A.LIST_ENTRY_ID IN (SELECT * FROM TABLE(CAST(:list_entry_id_col AS SYSTEM.NUMBER_TBL_TYPE)))'
11989: USING p_list_id, p_list_entry_id_col;
11990: EXCEPTION
11991: WHEN OTHERS THEN
11992: IF SQLCODE = -904 THEN

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

12059:
12060: )
12061:
12062: IS
12063: l_to_list_entry_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type(0);
12064: l_from_returns_id_col SYSTEM.number_tbl_type;
12065: l_ignore1 SYSTEM.number_tbl_type;
12066: l_ignore2 SYSTEM.number_tbl_type;
12067: l_ignore3 SYSTEM.number_tbl_type;

Line 12064: l_from_returns_id_col SYSTEM.number_tbl_type;

12060: )
12061:
12062: IS
12063: l_to_list_entry_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type(0);
12064: l_from_returns_id_col SYSTEM.number_tbl_type;
12065: l_ignore1 SYSTEM.number_tbl_type;
12066: l_ignore2 SYSTEM.number_tbl_type;
12067: l_ignore3 SYSTEM.number_tbl_type;
12068: l_num NUMBER := 1;

Line 12065: l_ignore1 SYSTEM.number_tbl_type;

12061:
12062: IS
12063: l_to_list_entry_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type(0);
12064: l_from_returns_id_col SYSTEM.number_tbl_type;
12065: l_ignore1 SYSTEM.number_tbl_type;
12066: l_ignore2 SYSTEM.number_tbl_type;
12067: l_ignore3 SYSTEM.number_tbl_type;
12068: l_num NUMBER := 1;
12069:

Line 12066: l_ignore2 SYSTEM.number_tbl_type;

12062: IS
12063: l_to_list_entry_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type(0);
12064: l_from_returns_id_col SYSTEM.number_tbl_type;
12065: l_ignore1 SYSTEM.number_tbl_type;
12066: l_ignore2 SYSTEM.number_tbl_type;
12067: l_ignore3 SYSTEM.number_tbl_type;
12068: l_num NUMBER := 1;
12069:
12070: Cursor c_listentryrec IS

Line 12067: l_ignore3 SYSTEM.number_tbl_type;

12063: l_to_list_entry_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type(0);
12064: l_from_returns_id_col SYSTEM.number_tbl_type;
12065: l_ignore1 SYSTEM.number_tbl_type;
12066: l_ignore2 SYSTEM.number_tbl_type;
12067: l_ignore3 SYSTEM.number_tbl_type;
12068: l_num NUMBER := 1;
12069:
12070: Cursor c_listentryrec IS
12071: 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 12759: ( p_from_returns_id_col IN SYSTEM.number_tbl_type

12755:
12756:
12757: PROCEDURE Log_DuplicateEntries
12758:
12759: ( p_from_returns_id_col IN SYSTEM.number_tbl_type
12760:
12761: , p_to_list_id IN NUMBER
12762:
12763: , p_to_schedule_id IN NUMBER

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

12767: )
12768:
12769: IS
12770:
12771: l_from_returns_id_col SYSTEM.number_tbl_type; -- will only contain duplicates
12772:
12773: l_from_list_id_col SYSTEM.number_tbl_type;
12774:
12775: l_from_list_entry_id_col SYSTEM.number_tbl_type;

Line 12773: l_from_list_id_col SYSTEM.number_tbl_type;

12769: IS
12770:
12771: l_from_returns_id_col SYSTEM.number_tbl_type; -- will only contain duplicates
12772:
12773: l_from_list_id_col SYSTEM.number_tbl_type;
12774:
12775: l_from_list_entry_id_col SYSTEM.number_tbl_type;
12776:
12777: l_from_schedule_id_col SYSTEM.number_tbl_type;

Line 12775: l_from_list_entry_id_col SYSTEM.number_tbl_type;

12771: l_from_returns_id_col SYSTEM.number_tbl_type; -- will only contain duplicates
12772:
12773: l_from_list_id_col SYSTEM.number_tbl_type;
12774:
12775: l_from_list_entry_id_col SYSTEM.number_tbl_type;
12776:
12777: l_from_schedule_id_col SYSTEM.number_tbl_type;
12778:
12779: l_party_id_col SYSTEM.number_tbl_type;

Line 12777: l_from_schedule_id_col SYSTEM.number_tbl_type;

12773: l_from_list_id_col SYSTEM.number_tbl_type;
12774:
12775: l_from_list_entry_id_col SYSTEM.number_tbl_type;
12776:
12777: l_from_schedule_id_col SYSTEM.number_tbl_type;
12778:
12779: l_party_id_col SYSTEM.number_tbl_type;
12780:
12781:

Line 12779: l_party_id_col SYSTEM.number_tbl_type;

12775: l_from_list_entry_id_col SYSTEM.number_tbl_type;
12776:
12777: l_from_schedule_id_col SYSTEM.number_tbl_type;
12778:
12779: l_party_id_col SYSTEM.number_tbl_type;
12780:
12781:
12782:
12783: l_error_msg VARCHAR2(4000);

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

12797: WHERE A.LIST_HEADER_ID = B.LIST_HEADER_ID
12798:
12799: AND A.LIST_ENTRY_ID = B.LIST_ENTRY_ID
12800:
12801: AND A.RETURNS_ID IN (SELECT * FROM TABLE(CAST(p_from_returns_id_col AS SYSTEM.NUMBER_TBL_TYPE)))
12802:
12803: AND B.PARTY_ID IN (SELECT PARTY_ID FROM AMS_LIST_ENTRIES WHERE LIST_HEADER_ID = p_to_list_id);
12804:
12805:

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

12870: , p_to_list_id IN NUMBER)
12871:
12872: IS
12873:
12874: l_returns_id_col SYSTEM.number_tbl_type := SYSTEM.number_tbl_type();
12875:
12876: BEGIN
12877:
12878: IF p_returns_id IS NULL OR p_to_list_id IS NULL THEN

Line 12906: ( p_returns_id_col IN SYSTEM.number_tbl_type

12902: -- Called by Recycling plugin to move recycled entries
12903:
12904: PROCEDURE Move_RecycledEntries
12905:
12906: ( p_returns_id_col IN SYSTEM.number_tbl_type
12907:
12908: , p_to_list_id IN NUMBER)
12909:
12910: IS

Line 12912: l_from_returns_id_col SYSTEM.number_tbl_type;

12908: , p_to_list_id IN NUMBER)
12909:
12910: IS
12911:
12912: l_from_returns_id_col SYSTEM.number_tbl_type;
12913:
12914: l_from_list_entry_id_col SYSTEM.number_tbl_type;
12915:
12916: l_from_list_id_col SYSTEM.number_tbl_type;

Line 12914: l_from_list_entry_id_col SYSTEM.number_tbl_type;

12910: IS
12911:
12912: l_from_returns_id_col SYSTEM.number_tbl_type;
12913:
12914: l_from_list_entry_id_col SYSTEM.number_tbl_type;
12915:
12916: l_from_list_id_col SYSTEM.number_tbl_type;
12917:
12918: l_to_list_entry_id_col SYSTEM.number_tbl_type;

Line 12916: l_from_list_id_col SYSTEM.number_tbl_type;

12912: l_from_returns_id_col SYSTEM.number_tbl_type;
12913:
12914: l_from_list_entry_id_col SYSTEM.number_tbl_type;
12915:
12916: l_from_list_id_col SYSTEM.number_tbl_type;
12917:
12918: l_to_list_entry_id_col SYSTEM.number_tbl_type;
12919:
12920: l_schedule_id NUMBER(15) := 0;

Line 12918: l_to_list_entry_id_col SYSTEM.number_tbl_type;

12914: l_from_list_entry_id_col SYSTEM.number_tbl_type;
12915:
12916: l_from_list_id_col SYSTEM.number_tbl_type;
12917:
12918: l_to_list_entry_id_col SYSTEM.number_tbl_type;
12919:
12920: l_schedule_id NUMBER(15) := 0;
12921:
12922: l_list_duplicate_incr NUMBER := 0;

Line 13073: l_returns_id_col SYSTEM.number_tbl_type;

13069: l_records_updated NUMBER;
13070:
13071:
13072:
13073: l_returns_id_col SYSTEM.number_tbl_type;
13074:
13075:
13076:
13077: l_src_returns_id_col SYSTEM.number_tbl_type;

Line 13077: l_src_returns_id_col SYSTEM.number_tbl_type;

13073: l_returns_id_col SYSTEM.number_tbl_type;
13074:
13075:
13076:
13077: l_src_returns_id_col SYSTEM.number_tbl_type;
13078:
13079: l_src_list_entry_id_col SYSTEM.number_tbl_type;
13080:
13081: l_src_list_id_col SYSTEM.number_tbl_type;

Line 13079: l_src_list_entry_id_col SYSTEM.number_tbl_type;

13075:
13076:
13077: l_src_returns_id_col SYSTEM.number_tbl_type;
13078:
13079: l_src_list_entry_id_col SYSTEM.number_tbl_type;
13080:
13081: l_src_list_id_col SYSTEM.number_tbl_type;
13082:
13083: l_dest_list_entry_id_col SYSTEM.number_tbl_type;

Line 13081: l_src_list_id_col SYSTEM.number_tbl_type;

13077: l_src_returns_id_col SYSTEM.number_tbl_type;
13078:
13079: l_src_list_entry_id_col SYSTEM.number_tbl_type;
13080:
13081: l_src_list_id_col SYSTEM.number_tbl_type;
13082:
13083: l_dest_list_entry_id_col SYSTEM.number_tbl_type;
13084:
13085:

Line 13083: l_dest_list_entry_id_col SYSTEM.number_tbl_type;

13079: l_src_list_entry_id_col SYSTEM.number_tbl_type;
13080:
13081: l_src_list_id_col SYSTEM.number_tbl_type;
13082:
13083: l_dest_list_entry_id_col SYSTEM.number_tbl_type;
13084:
13085:
13086:
13087: -- Cursor to retrieve non-duplicate records

Line 13471: l_from_returns_id_col SYSTEM.number_tbl_type;

13467: , p_commit_flag IN BOOLEAN)
13468:
13469: IS
13470:
13471: l_from_returns_id_col SYSTEM.number_tbl_type;
13472:
13473: l_from_list_entry_id_col SYSTEM.number_tbl_type;
13474:
13475: l_from_list_id_col SYSTEM.number_tbl_type;

Line 13473: l_from_list_entry_id_col SYSTEM.number_tbl_type;

13469: IS
13470:
13471: l_from_returns_id_col SYSTEM.number_tbl_type;
13472:
13473: l_from_list_entry_id_col SYSTEM.number_tbl_type;
13474:
13475: l_from_list_id_col SYSTEM.number_tbl_type;
13476:
13477: l_to_list_entry_id_col SYSTEM.number_tbl_type;

Line 13475: l_from_list_id_col SYSTEM.number_tbl_type;

13471: l_from_returns_id_col SYSTEM.number_tbl_type;
13472:
13473: l_from_list_entry_id_col SYSTEM.number_tbl_type;
13474:
13475: l_from_list_id_col SYSTEM.number_tbl_type;
13476:
13477: l_to_list_entry_id_col SYSTEM.number_tbl_type;
13478:
13479:

Line 13477: l_to_list_entry_id_col SYSTEM.number_tbl_type;

13473: l_from_list_entry_id_col SYSTEM.number_tbl_type;
13474:
13475: l_from_list_id_col SYSTEM.number_tbl_type;
13476:
13477: l_to_list_entry_id_col SYSTEM.number_tbl_type;
13478:
13479:
13480:
13481: l_api_initiated BOOLEAN;

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

14027: , p_list_id IN NUMBER)
14028:
14029: IS
14030:
14031: l_list_entry_id_col SYSTEM.NUMBER_TBL_TYPE := SYSTEM.NUMBER_TBL_TYPE();
14032:
14033: BEGIN
14034:
14035:

Line 14099: ( p_list_entry_id_col IN SYSTEM.number_tbl_type

14095:
14096:
14097: PROCEDURE Load_NewEntries
14098:
14099: ( p_list_entry_id_col IN SYSTEM.number_tbl_type
14100:
14101: , p_list_id IN NUMBER)
14102:
14103: IS

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

15216: l_list_entry_id NUMBER(15);
15217:
15218: l_party_id NUMBER(15);
15219:
15220: l_list_entry_id_col SYSTEM.NUMBER_TBL_TYPE := SYSTEM.NUMBER_TBL_TYPE();
15221:
15222:
15223:
15224: BEGIN

Line 15822: l_subset_id_col SYSTEM.number_tbl_type;

15818: IS
15819:
15820:
15821:
15822: l_subset_id_col SYSTEM.number_tbl_type;
15823:
15824: l_subset_view_col SYSTEM.varchar_tbl_type;
15825:
15826: l_subset_rec_loaded_col SYSTEM.number_tbl_type;

Line 15826: l_subset_rec_loaded_col SYSTEM.number_tbl_type;

15822: l_subset_id_col SYSTEM.number_tbl_type;
15823:
15824: l_subset_view_col SYSTEM.varchar_tbl_type;
15825:
15826: l_subset_rec_loaded_col SYSTEM.number_tbl_type;
15827:
15828:
15829:
15830: l_list_entry_csr ListEntryCsrType;