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 VARCHAR_TBL_TYPE

Line 821: ( p_list IN SYSTEM.varchar_tbl_type

817:
818:
819: FUNCTION Contains
820:
821: ( p_list IN SYSTEM.varchar_tbl_type
822:
823: , p_value IN VARCHAR2
824:
825: )

Line 875: l_columns SYSTEM.varchar_tbl_type;

871: IS
872:
873: l_curr VARCHAR2(32);
874:
875: l_columns SYSTEM.varchar_tbl_type;
876:
877: l_missing_cols VARCHAR2(4000);
878:
879: l_ignore VARCHAR2(4000);

Line 2370: l_data_code_col SYSTEM.varchar_tbl_type := SYSTEM.varchar_tbl_type();

2366: l_action_code VARCHAR2(500);
2367:
2368: l_data_code VARCHAR2(500);
2369:
2370: l_data_code_col SYSTEM.varchar_tbl_type := SYSTEM.varchar_tbl_type();
2371:
2372: l_data_value_col SYSTEM.varchar_tbl_type := SYSTEM.varchar_tbl_type();
2373:
2374:

Line 2372: l_data_value_col SYSTEM.varchar_tbl_type := SYSTEM.varchar_tbl_type();

2368: l_data_code VARCHAR2(500);
2369:
2370: l_data_code_col SYSTEM.varchar_tbl_type := SYSTEM.varchar_tbl_type();
2371:
2372: l_data_value_col SYSTEM.varchar_tbl_type := SYSTEM.varchar_tbl_type();
2373:
2374:
2375:
2376: l_count PLS_INTEGER;

Line 4510: l_cp_postfix SYSTEM.varchar_tbl_type := SYSTEM.varchar_tbl_type();

4506: (p_list_id IN NUMBER)
4507:
4508: IS
4509:
4510: l_cp_postfix SYSTEM.varchar_tbl_type := SYSTEM.varchar_tbl_type();
4511:
4512:
4513:
4514: TYPE ref_csr_type IS REF CURSOR;

Line 5464: l_territory_code_col SYSTEM.varchar_tbl_type;

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;
5467:
5468: l_timezone_col SYSTEM.number_tbl_type;

Line 5466: l_region_col SYSTEM.varchar_tbl_type;

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;
5467:
5468: l_timezone_col SYSTEM.number_tbl_type;
5469:
5470: l_tc_tz_pair_id_col SYSTEM.number_tbl_type;

Line 5972: , x_subset_view_col OUT NOCOPY SYSTEM.varchar_tbl_type) -- OUT

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
5975:
5976: l_subset_id NUMBER(15);

Line 5988: x_subset_view_col := SYSTEM.varchar_tbl_type();

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

Line 6200: , p_subset_view_col IN SYSTEM.varchar_tbl_type

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
6203:
6204: IS

Line 6352: l_country_code_col SYSTEM.varchar_tbl_type := SYSTEM.varchar_tbl_type();

6348: IS
6349:
6350: l_country_code VARCHAR2(9);
6351:
6352: l_country_code_col SYSTEM.varchar_tbl_type := SYSTEM.varchar_tbl_type();
6353:
6354: l_cc_substr VARCHAR2(500);
6355:
6356:

Line 6458: l_area_code_col SYSTEM.varchar_tbl_type := SYSTEM.varchar_tbl_type();

6454: l_area_code VARCHAR2(9);
6455:
6456: l_area_code_size NUMBER(9);
6457:
6458: l_area_code_col SYSTEM.varchar_tbl_type := SYSTEM.varchar_tbl_type();
6459:
6460: l_ac_substr VARCHAR2(500);
6461:
6462: BEGIN

Line 8306: l_do_not_use_col SYSTEM.varchar_tbl_type;

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;
8309:
8310: l_cz_incr_amount_col SYSTEM.number_tbl_type;

Line 8938: l_subset_view_col SYSTEM.varchar_tbl_type;

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;
8941:
8942:

Line 10042: l_columns SYSTEM.varchar_tbl_type;

10038: l_curr VARCHAR2(32);
10039:
10040: l_view_ok BOOLEAN := TRUE;
10041:
10042: l_columns SYSTEM.varchar_tbl_type;
10043:
10044: l_missing_cols VARCHAR2(4000);
10045:
10046: l_table_owner VARCHAR2(30);

Line 10554: l_source_type_col SYSTEM.varchar_tbl_type;

10550: l_str VARCHAR2(4000);
10551:
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);

Line 11468: l_do_not_use_col SYSTEM.varchar_tbl_type;

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;
11471:
11472: BEGIN

Line 11484: l_do_not_use_col := SYSTEM.varchar_tbl_type();

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();
11487:
11488:

Line 11698: l_cp_postfix_col SYSTEM.varchar_tbl_type := SYSTEM.varchar_tbl_type();

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();
11701:
11702: l_next_call_time_col SYSTEM.date_tbl_type := SYSTEM.date_tbl_type();

Line 11700: l_callback_flag_col SYSTEM.varchar_tbl_type := SYSTEM.varchar_tbl_type();

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();
11701:
11702: l_next_call_time_col SYSTEM.date_tbl_type := SYSTEM.date_tbl_type();
11703:
11704:

Line 14388: , p_col_names IN SYSTEM.varchar_tbl_type

14384: , p_list_entry_id IN NUMBER
14385:
14386: , p_source_type_view IN VARCHAR2
14387:
14388: , p_col_names IN SYSTEM.varchar_tbl_type
14389:
14390: , p_col_values IN SYSTEM.varchar_tbl_type
14391:
14392: )

Line 14390: , p_col_values IN SYSTEM.varchar_tbl_type

14386: , p_source_type_view IN VARCHAR2
14387:
14388: , p_col_names IN SYSTEM.varchar_tbl_type
14389:
14390: , p_col_values IN SYSTEM.varchar_tbl_type
14391:
14392: )
14393:
14394: IS

Line 14470: ( x_col_names OUT NOCOPY SYSTEM.varchar_tbl_type

14466: /*
14467:
14468: PROCEDURE Init_RequiredColumns
14469:
14470: ( x_col_names OUT NOCOPY SYSTEM.varchar_tbl_type
14471:
14472: , x_col_exists_flag OUT NOCOPY SYSTEM.varchar_tbl_type
14473:
14474: )

Line 14472: , x_col_exists_flag OUT NOCOPY SYSTEM.varchar_tbl_type

14468: PROCEDURE Init_RequiredColumns
14469:
14470: ( x_col_names OUT NOCOPY SYSTEM.varchar_tbl_type
14471:
14472: , x_col_exists_flag OUT NOCOPY SYSTEM.varchar_tbl_type
14473:
14474: )
14475:
14476: IS

Line 14480: x_col_names := SYSTEM.varchar_tbl_type();

14476: IS
14477:
14478: BEGIN
14479:
14480: x_col_names := SYSTEM.varchar_tbl_type();
14481:
14482: x_col_exists_flag := SYSTEM.varchar_tbl_type();
14483:
14484:

Line 14482: x_col_exists_flag := SYSTEM.varchar_tbl_type();

14478: BEGIN
14479:
14480: x_col_names := SYSTEM.varchar_tbl_type();
14481:
14482: x_col_exists_flag := SYSTEM.varchar_tbl_type();
14483:
14484:
14485:
14486: x_col_names.EXTEND(9);

Line 14522: ( p_col_names IN SYSTEM.varchar_tbl_type

14518:
14519:
14520: PROCEDURE Verify_RequiredColumns
14521:
14522: ( p_col_names IN SYSTEM.varchar_tbl_type
14523:
14524: x_missing_col_names OUT NOCOPY SYSTEM.varchar_tbl_type
14525:
14526: x_failure_code OUT NOCOPY VARCHAR2

Line 14524: x_missing_col_names OUT NOCOPY SYSTEM.varchar_tbl_type

14520: PROCEDURE Verify_RequiredColumns
14521:
14522: ( p_col_names IN SYSTEM.varchar_tbl_type
14523:
14524: x_missing_col_names OUT NOCOPY SYSTEM.varchar_tbl_type
14525:
14526: x_failure_code OUT NOCOPY VARCHAR2
14527:
14528: )

Line 14532: l_req_col_names SYSTEM.varchar_tbl_type;

14528: )
14529:
14530: IS
14531:
14532: l_req_col_names SYSTEM.varchar_tbl_type;
14533:
14534: l_req_col_exists_flag SYSTEM.varchar_tbl_type;
14535:
14536: BEGIN

Line 14534: l_req_col_exists_flag SYSTEM.varchar_tbl_type;

14530: IS
14531:
14532: l_req_col_names SYSTEM.varchar_tbl_type;
14533:
14534: l_req_col_exists_flag SYSTEM.varchar_tbl_type;
14535:
14536: BEGIN
14537:
14538:

Line 14572: x_missing_col_names := SYSTEM.varchar_tbl_type();

14568: IF l_req_col_exists_flag(i) <> 'Y' THEN
14569:
14570: IF x_missing_col_names IS NULL THEN
14571:
14572: x_missing_col_names := SYSTEM.varchar_tbl_type();
14573:
14574: END IF;
14575:
14576: x_missing_col_names.EXTEND;

Line 14594: ( p_col_names IN SYSTEM.varchar_tbl_type

14590:
14591:
14592: FUNCTION ToString_ColumnValuePairs
14593:
14594: ( p_col_names IN SYSTEM.varchar_tbl_type
14595:
14596: , p_col_values IN SYSTEM.varchar_tbl_type
14597:
14598: )

Line 14596: , p_col_values IN SYSTEM.varchar_tbl_type

14592: FUNCTION ToString_ColumnValuePairs
14593:
14594: ( p_col_names IN SYSTEM.varchar_tbl_type
14595:
14596: , p_col_values IN SYSTEM.varchar_tbl_type
14597:
14598: )
14599:
14600: RETURN VARCHAR2

Line 14636: ( p_col_names IN SYSTEM.varchar_tbl_type

14632: -- validate the record
14633:
14634: PROCEDURE Verify_AllRequiredColumns
14635:
14636: ( p_col_names IN SYSTEM.varchar_tbl_type
14637:
14638: , p_col_values IN SYSTEM.varchar_tbl_type
14639:
14640: , x_party_id OUT NOCOPY NUMBER

Line 14638: , p_col_values IN SYSTEM.varchar_tbl_type

14634: PROCEDURE Verify_AllRequiredColumns
14635:
14636: ( p_col_names IN SYSTEM.varchar_tbl_type
14637:
14638: , p_col_values IN SYSTEM.varchar_tbl_type
14639:
14640: , x_party_id OUT NOCOPY NUMBER
14641:
14642: , x_failure_code OUT NOCOPY VARCHAR2

Line 14830: ( p_col_names IN SYSTEM.varchar_tbl_type

14826: -- into AMS_LIST_ENTRIES with one contact point
14827:
14828: PROCEDURE Verify_MinRequiredColumns
14829:
14830: ( p_col_names IN SYSTEM.varchar_tbl_type
14831:
14832: , p_col_values IN SYSTEM.varchar_tbl_type
14833:
14834: , x_party_id OUT NOCOPY NUMBER

Line 14832: , p_col_values IN SYSTEM.varchar_tbl_type

14828: PROCEDURE Verify_MinRequiredColumns
14829:
14830: ( p_col_names IN SYSTEM.varchar_tbl_type
14831:
14832: , p_col_values IN SYSTEM.varchar_tbl_type
14833:
14834: , x_party_id OUT NOCOPY NUMBER
14835:
14836: , x_failure_code OUT NOCOPY VARCHAR2

Line 14912: , p_column_name IN SYSTEM.varchar_tbl_type

14908: PROCEDURE Create_NewEntry
14909:
14910: ( p_list_id IN NUMBER
14911:
14912: , p_column_name IN SYSTEM.varchar_tbl_type
14913:
14914: , p_column_value IN SYSTEM.varchar_tbl_type
14915:
14916: , x_party_id OUT NOCOPY NUMBER

Line 14914: , p_column_value IN SYSTEM.varchar_tbl_type

14910: ( p_list_id IN NUMBER
14911:
14912: , p_column_name IN SYSTEM.varchar_tbl_type
14913:
14914: , p_column_value IN SYSTEM.varchar_tbl_type
14915:
14916: , x_party_id OUT NOCOPY NUMBER
14917:
14918: , x_list_entry_id OUT NOCOPY NUMBER

Line 15198: , p_column_name IN SYSTEM.varchar_tbl_type

15194: PROCEDURE Add_Record_To_List_Pvt
15195:
15196: ( p_list_id IN NUMBER
15197:
15198: , p_column_name IN SYSTEM.varchar_tbl_type
15199:
15200: , p_column_value IN SYSTEM.varchar_tbl_type
15201:
15202: , p_callback_time IN DATE

Line 15200: , p_column_value IN SYSTEM.varchar_tbl_type

15196: ( p_list_id IN NUMBER
15197:
15198: , p_column_name IN SYSTEM.varchar_tbl_type
15199:
15200: , p_column_value IN SYSTEM.varchar_tbl_type
15201:
15202: , p_callback_time IN DATE
15203:
15204: , p_interactive_mode IN BOOLEAN

Line 15436: , p_column_name IN SYSTEM.varchar_tbl_type

15432: PROCEDURE Add_Record_To_List
15433:
15434: ( p_list_id IN NUMBER
15435:
15436: , p_column_name IN SYSTEM.varchar_tbl_type
15437:
15438: , p_column_value IN SYSTEM.varchar_tbl_type
15439:
15440: , p_callback_time IN DATE DEFAULT NULL

Line 15438: , p_column_value IN SYSTEM.varchar_tbl_type

15434: ( p_list_id IN NUMBER
15435:
15436: , p_column_name IN SYSTEM.varchar_tbl_type
15437:
15438: , p_column_value IN SYSTEM.varchar_tbl_type
15439:
15440: , p_callback_time IN DATE DEFAULT NULL
15441:
15442: , x_failure_code OUT NOCOPY VARCHAR2

Line 15482: , p_column_name IN SYSTEM.varchar_tbl_type

15478: PROCEDURE Add_Record_To_List_Interactive
15479:
15480: ( p_list_id IN NUMBER
15481:
15482: , p_column_name IN SYSTEM.varchar_tbl_type
15483:
15484: , p_column_value IN SYSTEM.varchar_tbl_type
15485:
15486: , p_callback_time IN DATE DEFAULT NULL

Line 15484: , p_column_value IN SYSTEM.varchar_tbl_type

15480: ( p_list_id IN NUMBER
15481:
15482: , p_column_name IN SYSTEM.varchar_tbl_type
15483:
15484: , p_column_value IN SYSTEM.varchar_tbl_type
15485:
15486: , p_callback_time IN DATE DEFAULT NULL
15487:
15488: , x_failure_code OUT NOCOPY VARCHAR2

Line 15824: l_subset_view_col SYSTEM.varchar_tbl_type;

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;
15827:
15828: