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 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 2348: l_data_code_col SYSTEM.varchar_tbl_type := SYSTEM.varchar_tbl_type();

2344: l_action_code VARCHAR2(500);
2345:
2346: l_data_code VARCHAR2(500);
2347:
2348: l_data_code_col SYSTEM.varchar_tbl_type := SYSTEM.varchar_tbl_type();
2349:
2350: l_data_value_col SYSTEM.varchar_tbl_type := SYSTEM.varchar_tbl_type();
2351:
2352:

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

2346: l_data_code VARCHAR2(500);
2347:
2348: l_data_code_col SYSTEM.varchar_tbl_type := SYSTEM.varchar_tbl_type();
2349:
2350: l_data_value_col SYSTEM.varchar_tbl_type := SYSTEM.varchar_tbl_type();
2351:
2352:
2353:
2354: l_count PLS_INTEGER;

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

4484: (p_list_id IN NUMBER)
4485:
4486: IS
4487:
4488: l_cp_postfix SYSTEM.varchar_tbl_type := SYSTEM.varchar_tbl_type();
4489:
4490:
4491:
4492: TYPE ref_csr_type IS REF CURSOR;

Line 5442: l_territory_code_col SYSTEM.varchar_tbl_type;

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;
5445:
5446: l_timezone_col SYSTEM.number_tbl_type;

Line 5444: l_region_col SYSTEM.varchar_tbl_type;

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;
5445:
5446: l_timezone_col SYSTEM.number_tbl_type;
5447:
5448: l_tc_tz_pair_id_col SYSTEM.number_tbl_type;

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

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
5953:
5954: l_subset_id NUMBER(15);

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

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

Line 6178: , p_subset_view_col IN SYSTEM.varchar_tbl_type

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
6181:
6182: IS

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

6326: IS
6327:
6328: l_country_code VARCHAR2(9);
6329:
6330: l_country_code_col SYSTEM.varchar_tbl_type := SYSTEM.varchar_tbl_type();
6331:
6332: l_cc_substr VARCHAR2(500);
6333:
6334:

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

6432: l_area_code VARCHAR2(9);
6433:
6434: l_area_code_size NUMBER(9);
6435:
6436: l_area_code_col SYSTEM.varchar_tbl_type := SYSTEM.varchar_tbl_type();
6437:
6438: l_ac_substr VARCHAR2(500);
6439:
6440: BEGIN

Line 8284: l_do_not_use_col SYSTEM.varchar_tbl_type;

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;
8287:
8288: l_cz_incr_amount_col SYSTEM.number_tbl_type;

Line 8916: l_subset_view_col SYSTEM.varchar_tbl_type;

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;
8919:
8920:

Line 10020: l_columns SYSTEM.varchar_tbl_type;

10016: l_curr VARCHAR2(32);
10017:
10018: l_view_ok BOOLEAN := TRUE;
10019:
10020: l_columns SYSTEM.varchar_tbl_type;
10021:
10022: l_missing_cols VARCHAR2(4000);
10023:
10024: l_table_owner VARCHAR2(30);

Line 10532: l_source_type_col SYSTEM.varchar_tbl_type;

10528: l_str VARCHAR2(4000);
10529:
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);

Line 11446: l_do_not_use_col SYSTEM.varchar_tbl_type;

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;
11449:
11450: BEGIN

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

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();
11465:
11466:

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

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

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

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();
11679:
11680: l_next_call_time_col SYSTEM.date_tbl_type := SYSTEM.date_tbl_type();
11681:
11682:

Line 14366: , p_col_names IN SYSTEM.varchar_tbl_type

14362: , p_list_entry_id IN NUMBER
14363:
14364: , p_source_type_view IN VARCHAR2
14365:
14366: , p_col_names IN SYSTEM.varchar_tbl_type
14367:
14368: , p_col_values IN SYSTEM.varchar_tbl_type
14369:
14370: )

Line 14368: , p_col_values IN SYSTEM.varchar_tbl_type

14364: , p_source_type_view IN VARCHAR2
14365:
14366: , p_col_names IN SYSTEM.varchar_tbl_type
14367:
14368: , p_col_values IN SYSTEM.varchar_tbl_type
14369:
14370: )
14371:
14372: IS

Line 14448: ( x_col_names OUT NOCOPY SYSTEM.varchar_tbl_type

14444: /*
14445:
14446: PROCEDURE Init_RequiredColumns
14447:
14448: ( x_col_names OUT NOCOPY SYSTEM.varchar_tbl_type
14449:
14450: , x_col_exists_flag OUT NOCOPY SYSTEM.varchar_tbl_type
14451:
14452: )

Line 14450: , x_col_exists_flag OUT NOCOPY SYSTEM.varchar_tbl_type

14446: PROCEDURE Init_RequiredColumns
14447:
14448: ( x_col_names OUT NOCOPY SYSTEM.varchar_tbl_type
14449:
14450: , x_col_exists_flag OUT NOCOPY SYSTEM.varchar_tbl_type
14451:
14452: )
14453:
14454: IS

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

14454: IS
14455:
14456: BEGIN
14457:
14458: x_col_names := SYSTEM.varchar_tbl_type();
14459:
14460: x_col_exists_flag := SYSTEM.varchar_tbl_type();
14461:
14462:

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

14456: BEGIN
14457:
14458: x_col_names := SYSTEM.varchar_tbl_type();
14459:
14460: x_col_exists_flag := SYSTEM.varchar_tbl_type();
14461:
14462:
14463:
14464: x_col_names.EXTEND(9);

Line 14500: ( p_col_names IN SYSTEM.varchar_tbl_type

14496:
14497:
14498: PROCEDURE Verify_RequiredColumns
14499:
14500: ( p_col_names IN SYSTEM.varchar_tbl_type
14501:
14502: x_missing_col_names OUT NOCOPY SYSTEM.varchar_tbl_type
14503:
14504: x_failure_code OUT NOCOPY VARCHAR2

Line 14502: x_missing_col_names OUT NOCOPY SYSTEM.varchar_tbl_type

14498: PROCEDURE Verify_RequiredColumns
14499:
14500: ( p_col_names IN SYSTEM.varchar_tbl_type
14501:
14502: x_missing_col_names OUT NOCOPY SYSTEM.varchar_tbl_type
14503:
14504: x_failure_code OUT NOCOPY VARCHAR2
14505:
14506: )

Line 14510: l_req_col_names SYSTEM.varchar_tbl_type;

14506: )
14507:
14508: IS
14509:
14510: l_req_col_names SYSTEM.varchar_tbl_type;
14511:
14512: l_req_col_exists_flag SYSTEM.varchar_tbl_type;
14513:
14514: BEGIN

Line 14512: l_req_col_exists_flag SYSTEM.varchar_tbl_type;

14508: IS
14509:
14510: l_req_col_names SYSTEM.varchar_tbl_type;
14511:
14512: l_req_col_exists_flag SYSTEM.varchar_tbl_type;
14513:
14514: BEGIN
14515:
14516:

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

14546: IF l_req_col_exists_flag(i) <> 'Y' THEN
14547:
14548: IF x_missing_col_names IS NULL THEN
14549:
14550: x_missing_col_names := SYSTEM.varchar_tbl_type();
14551:
14552: END IF;
14553:
14554: x_missing_col_names.EXTEND;

Line 14572: ( p_col_names IN SYSTEM.varchar_tbl_type

14568:
14569:
14570: FUNCTION ToString_ColumnValuePairs
14571:
14572: ( p_col_names IN SYSTEM.varchar_tbl_type
14573:
14574: , p_col_values IN SYSTEM.varchar_tbl_type
14575:
14576: )

Line 14574: , p_col_values IN SYSTEM.varchar_tbl_type

14570: FUNCTION ToString_ColumnValuePairs
14571:
14572: ( p_col_names IN SYSTEM.varchar_tbl_type
14573:
14574: , p_col_values IN SYSTEM.varchar_tbl_type
14575:
14576: )
14577:
14578: RETURN VARCHAR2

Line 14614: ( p_col_names IN SYSTEM.varchar_tbl_type

14610: -- validate the record
14611:
14612: PROCEDURE Verify_AllRequiredColumns
14613:
14614: ( p_col_names IN SYSTEM.varchar_tbl_type
14615:
14616: , p_col_values IN SYSTEM.varchar_tbl_type
14617:
14618: , x_party_id OUT NOCOPY NUMBER

Line 14616: , p_col_values IN SYSTEM.varchar_tbl_type

14612: PROCEDURE Verify_AllRequiredColumns
14613:
14614: ( p_col_names IN SYSTEM.varchar_tbl_type
14615:
14616: , p_col_values IN SYSTEM.varchar_tbl_type
14617:
14618: , x_party_id OUT NOCOPY NUMBER
14619:
14620: , x_failure_code OUT NOCOPY VARCHAR2

Line 14808: ( p_col_names IN SYSTEM.varchar_tbl_type

14804: -- into AMS_LIST_ENTRIES with one contact point
14805:
14806: PROCEDURE Verify_MinRequiredColumns
14807:
14808: ( p_col_names IN SYSTEM.varchar_tbl_type
14809:
14810: , p_col_values IN SYSTEM.varchar_tbl_type
14811:
14812: , x_party_id OUT NOCOPY NUMBER

Line 14810: , p_col_values IN SYSTEM.varchar_tbl_type

14806: PROCEDURE Verify_MinRequiredColumns
14807:
14808: ( p_col_names IN SYSTEM.varchar_tbl_type
14809:
14810: , p_col_values IN SYSTEM.varchar_tbl_type
14811:
14812: , x_party_id OUT NOCOPY NUMBER
14813:
14814: , x_failure_code OUT NOCOPY VARCHAR2

Line 14890: , p_column_name IN SYSTEM.varchar_tbl_type

14886: PROCEDURE Create_NewEntry
14887:
14888: ( p_list_id IN NUMBER
14889:
14890: , p_column_name IN SYSTEM.varchar_tbl_type
14891:
14892: , p_column_value IN SYSTEM.varchar_tbl_type
14893:
14894: , x_party_id OUT NOCOPY NUMBER

Line 14892: , p_column_value IN SYSTEM.varchar_tbl_type

14888: ( p_list_id IN NUMBER
14889:
14890: , p_column_name IN SYSTEM.varchar_tbl_type
14891:
14892: , p_column_value IN SYSTEM.varchar_tbl_type
14893:
14894: , x_party_id OUT NOCOPY NUMBER
14895:
14896: , x_list_entry_id OUT NOCOPY NUMBER

Line 15176: , p_column_name IN SYSTEM.varchar_tbl_type

15172: PROCEDURE Add_Record_To_List_Pvt
15173:
15174: ( p_list_id IN NUMBER
15175:
15176: , p_column_name IN SYSTEM.varchar_tbl_type
15177:
15178: , p_column_value IN SYSTEM.varchar_tbl_type
15179:
15180: , p_callback_time IN DATE

Line 15178: , p_column_value IN SYSTEM.varchar_tbl_type

15174: ( p_list_id IN NUMBER
15175:
15176: , p_column_name IN SYSTEM.varchar_tbl_type
15177:
15178: , p_column_value IN SYSTEM.varchar_tbl_type
15179:
15180: , p_callback_time IN DATE
15181:
15182: , p_interactive_mode IN BOOLEAN

Line 15414: , p_column_name IN SYSTEM.varchar_tbl_type

15410: PROCEDURE Add_Record_To_List
15411:
15412: ( p_list_id IN NUMBER
15413:
15414: , p_column_name IN SYSTEM.varchar_tbl_type
15415:
15416: , p_column_value IN SYSTEM.varchar_tbl_type
15417:
15418: , p_callback_time IN DATE DEFAULT NULL

Line 15416: , p_column_value IN SYSTEM.varchar_tbl_type

15412: ( p_list_id IN NUMBER
15413:
15414: , p_column_name IN SYSTEM.varchar_tbl_type
15415:
15416: , p_column_value IN SYSTEM.varchar_tbl_type
15417:
15418: , p_callback_time IN DATE DEFAULT NULL
15419:
15420: , x_failure_code OUT NOCOPY VARCHAR2

Line 15460: , p_column_name IN SYSTEM.varchar_tbl_type

15456: PROCEDURE Add_Record_To_List_Interactive
15457:
15458: ( p_list_id IN NUMBER
15459:
15460: , p_column_name IN SYSTEM.varchar_tbl_type
15461:
15462: , p_column_value IN SYSTEM.varchar_tbl_type
15463:
15464: , p_callback_time IN DATE DEFAULT NULL

Line 15462: , p_column_value IN SYSTEM.varchar_tbl_type

15458: ( p_list_id IN NUMBER
15459:
15460: , p_column_name IN SYSTEM.varchar_tbl_type
15461:
15462: , p_column_value IN SYSTEM.varchar_tbl_type
15463:
15464: , p_callback_time IN DATE DEFAULT NULL
15465:
15466: , x_failure_code OUT NOCOPY VARCHAR2

Line 15802: l_subset_view_col SYSTEM.varchar_tbl_type;

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;
15805:
15806: