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.AMS_IMPORT_LIST_PVT dependencies on FND_API

Line 42: import_list_header_id NUMBER := FND_API.G_MISS_NUM,

38:
39: --===================================================================
40: TYPE ams_import_rec_type IS RECORD
41: (
42: import_list_header_id NUMBER := FND_API.G_MISS_NUM,
43: last_update_date DATE := FND_API.G_MISS_DATE,
44: last_updated_by NUMBER := FND_API.G_MISS_NUM,
45: creation_date DATE := FND_API.G_MISS_DATE,
46: created_by NUMBER := FND_API.G_MISS_NUM,

Line 43: last_update_date DATE := FND_API.G_MISS_DATE,

39: --===================================================================
40: TYPE ams_import_rec_type IS RECORD
41: (
42: import_list_header_id NUMBER := FND_API.G_MISS_NUM,
43: last_update_date DATE := FND_API.G_MISS_DATE,
44: last_updated_by NUMBER := FND_API.G_MISS_NUM,
45: creation_date DATE := FND_API.G_MISS_DATE,
46: created_by NUMBER := FND_API.G_MISS_NUM,
47: last_update_login NUMBER := FND_API.G_MISS_NUM,

Line 44: last_updated_by NUMBER := FND_API.G_MISS_NUM,

40: TYPE ams_import_rec_type IS RECORD
41: (
42: import_list_header_id NUMBER := FND_API.G_MISS_NUM,
43: last_update_date DATE := FND_API.G_MISS_DATE,
44: last_updated_by NUMBER := FND_API.G_MISS_NUM,
45: creation_date DATE := FND_API.G_MISS_DATE,
46: created_by NUMBER := FND_API.G_MISS_NUM,
47: last_update_login NUMBER := FND_API.G_MISS_NUM,
48: object_version_number NUMBER := FND_API.G_MISS_NUM,

Line 45: creation_date DATE := FND_API.G_MISS_DATE,

41: (
42: import_list_header_id NUMBER := FND_API.G_MISS_NUM,
43: last_update_date DATE := FND_API.G_MISS_DATE,
44: last_updated_by NUMBER := FND_API.G_MISS_NUM,
45: creation_date DATE := FND_API.G_MISS_DATE,
46: created_by NUMBER := FND_API.G_MISS_NUM,
47: last_update_login NUMBER := FND_API.G_MISS_NUM,
48: object_version_number NUMBER := FND_API.G_MISS_NUM,
49: view_application_id NUMBER := FND_API.G_MISS_NUM,

Line 46: created_by NUMBER := FND_API.G_MISS_NUM,

42: import_list_header_id NUMBER := FND_API.G_MISS_NUM,
43: last_update_date DATE := FND_API.G_MISS_DATE,
44: last_updated_by NUMBER := FND_API.G_MISS_NUM,
45: creation_date DATE := FND_API.G_MISS_DATE,
46: created_by NUMBER := FND_API.G_MISS_NUM,
47: last_update_login NUMBER := FND_API.G_MISS_NUM,
48: object_version_number NUMBER := FND_API.G_MISS_NUM,
49: view_application_id NUMBER := FND_API.G_MISS_NUM,
50: name VARCHAR2(120) := FND_API.G_MISS_CHAR,

Line 47: last_update_login NUMBER := FND_API.G_MISS_NUM,

43: last_update_date DATE := FND_API.G_MISS_DATE,
44: last_updated_by NUMBER := FND_API.G_MISS_NUM,
45: creation_date DATE := FND_API.G_MISS_DATE,
46: created_by NUMBER := FND_API.G_MISS_NUM,
47: last_update_login NUMBER := FND_API.G_MISS_NUM,
48: object_version_number NUMBER := FND_API.G_MISS_NUM,
49: view_application_id NUMBER := FND_API.G_MISS_NUM,
50: name VARCHAR2(120) := FND_API.G_MISS_CHAR,
51: version VARCHAR2(10) := FND_API.G_MISS_CHAR,

Line 48: object_version_number NUMBER := FND_API.G_MISS_NUM,

44: last_updated_by NUMBER := FND_API.G_MISS_NUM,
45: creation_date DATE := FND_API.G_MISS_DATE,
46: created_by NUMBER := FND_API.G_MISS_NUM,
47: last_update_login NUMBER := FND_API.G_MISS_NUM,
48: object_version_number NUMBER := FND_API.G_MISS_NUM,
49: view_application_id NUMBER := FND_API.G_MISS_NUM,
50: name VARCHAR2(120) := FND_API.G_MISS_CHAR,
51: version VARCHAR2(10) := FND_API.G_MISS_CHAR,
52: import_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 49: view_application_id NUMBER := FND_API.G_MISS_NUM,

45: creation_date DATE := FND_API.G_MISS_DATE,
46: created_by NUMBER := FND_API.G_MISS_NUM,
47: last_update_login NUMBER := FND_API.G_MISS_NUM,
48: object_version_number NUMBER := FND_API.G_MISS_NUM,
49: view_application_id NUMBER := FND_API.G_MISS_NUM,
50: name VARCHAR2(120) := FND_API.G_MISS_CHAR,
51: version VARCHAR2(10) := FND_API.G_MISS_CHAR,
52: import_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
53: owner_user_id NUMBER := FND_API.G_MISS_NUM,

Line 50: name VARCHAR2(120) := FND_API.G_MISS_CHAR,

46: created_by NUMBER := FND_API.G_MISS_NUM,
47: last_update_login NUMBER := FND_API.G_MISS_NUM,
48: object_version_number NUMBER := FND_API.G_MISS_NUM,
49: view_application_id NUMBER := FND_API.G_MISS_NUM,
50: name VARCHAR2(120) := FND_API.G_MISS_CHAR,
51: version VARCHAR2(10) := FND_API.G_MISS_CHAR,
52: import_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
53: owner_user_id NUMBER := FND_API.G_MISS_NUM,
54: list_source_type_id NUMBER := FND_API.G_MISS_NUM,

Line 51: version VARCHAR2(10) := FND_API.G_MISS_CHAR,

47: last_update_login NUMBER := FND_API.G_MISS_NUM,
48: object_version_number NUMBER := FND_API.G_MISS_NUM,
49: view_application_id NUMBER := FND_API.G_MISS_NUM,
50: name VARCHAR2(120) := FND_API.G_MISS_CHAR,
51: version VARCHAR2(10) := FND_API.G_MISS_CHAR,
52: import_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
53: owner_user_id NUMBER := FND_API.G_MISS_NUM,
54: list_source_type_id NUMBER := FND_API.G_MISS_NUM,
55: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 52: import_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

48: object_version_number NUMBER := FND_API.G_MISS_NUM,
49: view_application_id NUMBER := FND_API.G_MISS_NUM,
50: name VARCHAR2(120) := FND_API.G_MISS_CHAR,
51: version VARCHAR2(10) := FND_API.G_MISS_CHAR,
52: import_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
53: owner_user_id NUMBER := FND_API.G_MISS_NUM,
54: list_source_type_id NUMBER := FND_API.G_MISS_NUM,
55: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: status_date DATE := FND_API.G_MISS_DATE,

Line 53: owner_user_id NUMBER := FND_API.G_MISS_NUM,

49: view_application_id NUMBER := FND_API.G_MISS_NUM,
50: name VARCHAR2(120) := FND_API.G_MISS_CHAR,
51: version VARCHAR2(10) := FND_API.G_MISS_CHAR,
52: import_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
53: owner_user_id NUMBER := FND_API.G_MISS_NUM,
54: list_source_type_id NUMBER := FND_API.G_MISS_NUM,
55: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: status_date DATE := FND_API.G_MISS_DATE,
57: user_status_id NUMBER := FND_API.G_MISS_NUM,

Line 54: list_source_type_id NUMBER := FND_API.G_MISS_NUM,

50: name VARCHAR2(120) := FND_API.G_MISS_CHAR,
51: version VARCHAR2(10) := FND_API.G_MISS_CHAR,
52: import_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
53: owner_user_id NUMBER := FND_API.G_MISS_NUM,
54: list_source_type_id NUMBER := FND_API.G_MISS_NUM,
55: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: status_date DATE := FND_API.G_MISS_DATE,
57: user_status_id NUMBER := FND_API.G_MISS_NUM,
58: source_system VARCHAR2(4000) := FND_API.G_MISS_CHAR,

Line 55: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

51: version VARCHAR2(10) := FND_API.G_MISS_CHAR,
52: import_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
53: owner_user_id NUMBER := FND_API.G_MISS_NUM,
54: list_source_type_id NUMBER := FND_API.G_MISS_NUM,
55: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: status_date DATE := FND_API.G_MISS_DATE,
57: user_status_id NUMBER := FND_API.G_MISS_NUM,
58: source_system VARCHAR2(4000) := FND_API.G_MISS_CHAR,
59: vendor_id NUMBER := FND_API.G_MISS_NUM,

Line 56: status_date DATE := FND_API.G_MISS_DATE,

52: import_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
53: owner_user_id NUMBER := FND_API.G_MISS_NUM,
54: list_source_type_id NUMBER := FND_API.G_MISS_NUM,
55: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: status_date DATE := FND_API.G_MISS_DATE,
57: user_status_id NUMBER := FND_API.G_MISS_NUM,
58: source_system VARCHAR2(4000) := FND_API.G_MISS_CHAR,
59: vendor_id NUMBER := FND_API.G_MISS_NUM,
60: pin_id NUMBER := FND_API.G_MISS_NUM,

Line 57: user_status_id NUMBER := FND_API.G_MISS_NUM,

53: owner_user_id NUMBER := FND_API.G_MISS_NUM,
54: list_source_type_id NUMBER := FND_API.G_MISS_NUM,
55: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: status_date DATE := FND_API.G_MISS_DATE,
57: user_status_id NUMBER := FND_API.G_MISS_NUM,
58: source_system VARCHAR2(4000) := FND_API.G_MISS_CHAR,
59: vendor_id NUMBER := FND_API.G_MISS_NUM,
60: pin_id NUMBER := FND_API.G_MISS_NUM,
61: org_id NUMBER := FND_API.G_MISS_NUM,

Line 58: source_system VARCHAR2(4000) := FND_API.G_MISS_CHAR,

54: list_source_type_id NUMBER := FND_API.G_MISS_NUM,
55: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: status_date DATE := FND_API.G_MISS_DATE,
57: user_status_id NUMBER := FND_API.G_MISS_NUM,
58: source_system VARCHAR2(4000) := FND_API.G_MISS_CHAR,
59: vendor_id NUMBER := FND_API.G_MISS_NUM,
60: pin_id NUMBER := FND_API.G_MISS_NUM,
61: org_id NUMBER := FND_API.G_MISS_NUM,
62: scheduled_time DATE := FND_API.G_MISS_DATE,

Line 59: vendor_id NUMBER := FND_API.G_MISS_NUM,

55: status_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: status_date DATE := FND_API.G_MISS_DATE,
57: user_status_id NUMBER := FND_API.G_MISS_NUM,
58: source_system VARCHAR2(4000) := FND_API.G_MISS_CHAR,
59: vendor_id NUMBER := FND_API.G_MISS_NUM,
60: pin_id NUMBER := FND_API.G_MISS_NUM,
61: org_id NUMBER := FND_API.G_MISS_NUM,
62: scheduled_time DATE := FND_API.G_MISS_DATE,
63: loaded_no_of_rows NUMBER := FND_API.G_MISS_NUM,

Line 60: pin_id NUMBER := FND_API.G_MISS_NUM,

56: status_date DATE := FND_API.G_MISS_DATE,
57: user_status_id NUMBER := FND_API.G_MISS_NUM,
58: source_system VARCHAR2(4000) := FND_API.G_MISS_CHAR,
59: vendor_id NUMBER := FND_API.G_MISS_NUM,
60: pin_id NUMBER := FND_API.G_MISS_NUM,
61: org_id NUMBER := FND_API.G_MISS_NUM,
62: scheduled_time DATE := FND_API.G_MISS_DATE,
63: loaded_no_of_rows NUMBER := FND_API.G_MISS_NUM,
64: loaded_date DATE := FND_API.G_MISS_DATE,

Line 61: org_id NUMBER := FND_API.G_MISS_NUM,

57: user_status_id NUMBER := FND_API.G_MISS_NUM,
58: source_system VARCHAR2(4000) := FND_API.G_MISS_CHAR,
59: vendor_id NUMBER := FND_API.G_MISS_NUM,
60: pin_id NUMBER := FND_API.G_MISS_NUM,
61: org_id NUMBER := FND_API.G_MISS_NUM,
62: scheduled_time DATE := FND_API.G_MISS_DATE,
63: loaded_no_of_rows NUMBER := FND_API.G_MISS_NUM,
64: loaded_date DATE := FND_API.G_MISS_DATE,
65: rows_to_skip NUMBER := FND_API.G_MISS_NUM,

Line 62: scheduled_time DATE := FND_API.G_MISS_DATE,

58: source_system VARCHAR2(4000) := FND_API.G_MISS_CHAR,
59: vendor_id NUMBER := FND_API.G_MISS_NUM,
60: pin_id NUMBER := FND_API.G_MISS_NUM,
61: org_id NUMBER := FND_API.G_MISS_NUM,
62: scheduled_time DATE := FND_API.G_MISS_DATE,
63: loaded_no_of_rows NUMBER := FND_API.G_MISS_NUM,
64: loaded_date DATE := FND_API.G_MISS_DATE,
65: rows_to_skip NUMBER := FND_API.G_MISS_NUM,
66: processed_rows NUMBER := FND_API.G_MISS_NUM,

Line 63: loaded_no_of_rows NUMBER := FND_API.G_MISS_NUM,

59: vendor_id NUMBER := FND_API.G_MISS_NUM,
60: pin_id NUMBER := FND_API.G_MISS_NUM,
61: org_id NUMBER := FND_API.G_MISS_NUM,
62: scheduled_time DATE := FND_API.G_MISS_DATE,
63: loaded_no_of_rows NUMBER := FND_API.G_MISS_NUM,
64: loaded_date DATE := FND_API.G_MISS_DATE,
65: rows_to_skip NUMBER := FND_API.G_MISS_NUM,
66: processed_rows NUMBER := FND_API.G_MISS_NUM,
67: headings_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 64: loaded_date DATE := FND_API.G_MISS_DATE,

60: pin_id NUMBER := FND_API.G_MISS_NUM,
61: org_id NUMBER := FND_API.G_MISS_NUM,
62: scheduled_time DATE := FND_API.G_MISS_DATE,
63: loaded_no_of_rows NUMBER := FND_API.G_MISS_NUM,
64: loaded_date DATE := FND_API.G_MISS_DATE,
65: rows_to_skip NUMBER := FND_API.G_MISS_NUM,
66: processed_rows NUMBER := FND_API.G_MISS_NUM,
67: headings_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
68: expiry_date DATE := FND_API.G_MISS_DATE,

Line 65: rows_to_skip NUMBER := FND_API.G_MISS_NUM,

61: org_id NUMBER := FND_API.G_MISS_NUM,
62: scheduled_time DATE := FND_API.G_MISS_DATE,
63: loaded_no_of_rows NUMBER := FND_API.G_MISS_NUM,
64: loaded_date DATE := FND_API.G_MISS_DATE,
65: rows_to_skip NUMBER := FND_API.G_MISS_NUM,
66: processed_rows NUMBER := FND_API.G_MISS_NUM,
67: headings_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
68: expiry_date DATE := FND_API.G_MISS_DATE,
69: purge_date DATE := FND_API.G_MISS_DATE,

Line 66: processed_rows NUMBER := FND_API.G_MISS_NUM,

62: scheduled_time DATE := FND_API.G_MISS_DATE,
63: loaded_no_of_rows NUMBER := FND_API.G_MISS_NUM,
64: loaded_date DATE := FND_API.G_MISS_DATE,
65: rows_to_skip NUMBER := FND_API.G_MISS_NUM,
66: processed_rows NUMBER := FND_API.G_MISS_NUM,
67: headings_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
68: expiry_date DATE := FND_API.G_MISS_DATE,
69: purge_date DATE := FND_API.G_MISS_DATE,
70: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,

Line 67: headings_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

63: loaded_no_of_rows NUMBER := FND_API.G_MISS_NUM,
64: loaded_date DATE := FND_API.G_MISS_DATE,
65: rows_to_skip NUMBER := FND_API.G_MISS_NUM,
66: processed_rows NUMBER := FND_API.G_MISS_NUM,
67: headings_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
68: expiry_date DATE := FND_API.G_MISS_DATE,
69: purge_date DATE := FND_API.G_MISS_DATE,
70: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
71: keywords VARCHAR2(4000) := FND_API.G_MISS_CHAR,

Line 68: expiry_date DATE := FND_API.G_MISS_DATE,

64: loaded_date DATE := FND_API.G_MISS_DATE,
65: rows_to_skip NUMBER := FND_API.G_MISS_NUM,
66: processed_rows NUMBER := FND_API.G_MISS_NUM,
67: headings_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
68: expiry_date DATE := FND_API.G_MISS_DATE,
69: purge_date DATE := FND_API.G_MISS_DATE,
70: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
71: keywords VARCHAR2(4000) := FND_API.G_MISS_CHAR,
72: transactional_cost NUMBER := FND_API.G_MISS_NUM,

Line 69: purge_date DATE := FND_API.G_MISS_DATE,

65: rows_to_skip NUMBER := FND_API.G_MISS_NUM,
66: processed_rows NUMBER := FND_API.G_MISS_NUM,
67: headings_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
68: expiry_date DATE := FND_API.G_MISS_DATE,
69: purge_date DATE := FND_API.G_MISS_DATE,
70: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
71: keywords VARCHAR2(4000) := FND_API.G_MISS_CHAR,
72: transactional_cost NUMBER := FND_API.G_MISS_NUM,
73: transactional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,

Line 70: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,

66: processed_rows NUMBER := FND_API.G_MISS_NUM,
67: headings_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
68: expiry_date DATE := FND_API.G_MISS_DATE,
69: purge_date DATE := FND_API.G_MISS_DATE,
70: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
71: keywords VARCHAR2(4000) := FND_API.G_MISS_CHAR,
72: transactional_cost NUMBER := FND_API.G_MISS_NUM,
73: transactional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
74: functional_cost NUMBER := FND_API.G_MISS_NUM,

Line 71: keywords VARCHAR2(4000) := FND_API.G_MISS_CHAR,

67: headings_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
68: expiry_date DATE := FND_API.G_MISS_DATE,
69: purge_date DATE := FND_API.G_MISS_DATE,
70: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
71: keywords VARCHAR2(4000) := FND_API.G_MISS_CHAR,
72: transactional_cost NUMBER := FND_API.G_MISS_NUM,
73: transactional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
74: functional_cost NUMBER := FND_API.G_MISS_NUM,
75: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,

Line 72: transactional_cost NUMBER := FND_API.G_MISS_NUM,

68: expiry_date DATE := FND_API.G_MISS_DATE,
69: purge_date DATE := FND_API.G_MISS_DATE,
70: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
71: keywords VARCHAR2(4000) := FND_API.G_MISS_CHAR,
72: transactional_cost NUMBER := FND_API.G_MISS_NUM,
73: transactional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
74: functional_cost NUMBER := FND_API.G_MISS_NUM,
75: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
76: terminated_by VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 73: transactional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,

69: purge_date DATE := FND_API.G_MISS_DATE,
70: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
71: keywords VARCHAR2(4000) := FND_API.G_MISS_CHAR,
72: transactional_cost NUMBER := FND_API.G_MISS_NUM,
73: transactional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
74: functional_cost NUMBER := FND_API.G_MISS_NUM,
75: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
76: terminated_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: enclosed_by VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 74: functional_cost NUMBER := FND_API.G_MISS_NUM,

70: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
71: keywords VARCHAR2(4000) := FND_API.G_MISS_CHAR,
72: transactional_cost NUMBER := FND_API.G_MISS_NUM,
73: transactional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
74: functional_cost NUMBER := FND_API.G_MISS_NUM,
75: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
76: terminated_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: enclosed_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: data_filename VARCHAR2(1000) := FND_API.G_MISS_CHAR,

Line 75: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,

71: keywords VARCHAR2(4000) := FND_API.G_MISS_CHAR,
72: transactional_cost NUMBER := FND_API.G_MISS_NUM,
73: transactional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
74: functional_cost NUMBER := FND_API.G_MISS_NUM,
75: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
76: terminated_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: enclosed_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: data_filename VARCHAR2(1000) := FND_API.G_MISS_CHAR,
79: process_immed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 76: terminated_by VARCHAR2(30) := FND_API.G_MISS_CHAR,

72: transactional_cost NUMBER := FND_API.G_MISS_NUM,
73: transactional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
74: functional_cost NUMBER := FND_API.G_MISS_NUM,
75: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
76: terminated_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: enclosed_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: data_filename VARCHAR2(1000) := FND_API.G_MISS_CHAR,
79: process_immed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
80: dedupe_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 77: enclosed_by VARCHAR2(30) := FND_API.G_MISS_CHAR,

73: transactional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
74: functional_cost NUMBER := FND_API.G_MISS_NUM,
75: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
76: terminated_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: enclosed_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: data_filename VARCHAR2(1000) := FND_API.G_MISS_CHAR,
79: process_immed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
80: dedupe_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
81: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 78: data_filename VARCHAR2(1000) := FND_API.G_MISS_CHAR,

74: functional_cost NUMBER := FND_API.G_MISS_NUM,
75: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
76: terminated_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: enclosed_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: data_filename VARCHAR2(1000) := FND_API.G_MISS_CHAR,
79: process_immed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
80: dedupe_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
81: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
82: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 79: process_immed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

75: functional_currency_code VARCHAR2(15) := FND_API.G_MISS_CHAR,
76: terminated_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: enclosed_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: data_filename VARCHAR2(1000) := FND_API.G_MISS_CHAR,
79: process_immed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
80: dedupe_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
81: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
82: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 80: dedupe_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

76: terminated_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
77: enclosed_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: data_filename VARCHAR2(1000) := FND_API.G_MISS_CHAR,
79: process_immed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
80: dedupe_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
81: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
82: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 81: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,

77: enclosed_by VARCHAR2(30) := FND_API.G_MISS_CHAR,
78: data_filename VARCHAR2(1000) := FND_API.G_MISS_CHAR,
79: process_immed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
80: dedupe_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
81: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
82: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 82: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

78: data_filename VARCHAR2(1000) := FND_API.G_MISS_CHAR,
79: process_immed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
80: dedupe_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
81: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
82: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 83: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

79: process_immed_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
80: dedupe_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
81: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
82: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 84: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

80: dedupe_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
81: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
82: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 85: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

81: attribute_category VARCHAR2(30) := FND_API.G_MISS_CHAR,
82: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 86: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

82: attribute1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
83: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 87: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

83: attribute2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
84: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 88: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

84: attribute3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
85: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 89: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

85: attribute4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
86: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 90: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

86: attribute5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
87: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 91: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

87: attribute6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
88: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 92: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

88: attribute7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
89: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 93: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

89: attribute8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
90: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: custom_setup_id NUMBER := FND_API.G_MISS_NUM,

Line 94: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

90: attribute9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
91: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
98: country NUMBER := FND_API.G_MISS_NUM,

Line 95: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

91: attribute10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
92: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
98: country NUMBER := FND_API.G_MISS_NUM,
99: usage NUMBER := FND_API.G_MISS_NUM,

Line 96: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,

92: attribute11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
93: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
98: country NUMBER := FND_API.G_MISS_NUM,
99: usage NUMBER := FND_API.G_MISS_NUM,
100: number_of_records NUMBER := FND_API.G_MISS_NUM,

Line 97: custom_setup_id NUMBER := FND_API.G_MISS_NUM,

93: attribute12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
94: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
98: country NUMBER := FND_API.G_MISS_NUM,
99: usage NUMBER := FND_API.G_MISS_NUM,
100: number_of_records NUMBER := FND_API.G_MISS_NUM,
101: data_file_name VARCHAR2(1000) := FND_API.G_MISS_CHAR,

Line 98: country NUMBER := FND_API.G_MISS_NUM,

94: attribute13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
95: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
98: country NUMBER := FND_API.G_MISS_NUM,
99: usage NUMBER := FND_API.G_MISS_NUM,
100: number_of_records NUMBER := FND_API.G_MISS_NUM,
101: data_file_name VARCHAR2(1000) := FND_API.G_MISS_CHAR,
102: b2b_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 99: usage NUMBER := FND_API.G_MISS_NUM,

95: attribute14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
96: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
98: country NUMBER := FND_API.G_MISS_NUM,
99: usage NUMBER := FND_API.G_MISS_NUM,
100: number_of_records NUMBER := FND_API.G_MISS_NUM,
101: data_file_name VARCHAR2(1000) := FND_API.G_MISS_CHAR,
102: b2b_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
103: rented_list_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 100: number_of_records NUMBER := FND_API.G_MISS_NUM,

96: attribute15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
97: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
98: country NUMBER := FND_API.G_MISS_NUM,
99: usage NUMBER := FND_API.G_MISS_NUM,
100: number_of_records NUMBER := FND_API.G_MISS_NUM,
101: data_file_name VARCHAR2(1000) := FND_API.G_MISS_CHAR,
102: b2b_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
103: rented_list_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
104: server_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 101: data_file_name VARCHAR2(1000) := FND_API.G_MISS_CHAR,

97: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
98: country NUMBER := FND_API.G_MISS_NUM,
99: usage NUMBER := FND_API.G_MISS_NUM,
100: number_of_records NUMBER := FND_API.G_MISS_NUM,
101: data_file_name VARCHAR2(1000) := FND_API.G_MISS_CHAR,
102: b2b_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
103: rented_list_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
104: server_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
105: log_file_name NUMBER := FND_API.G_MISS_NUM,

Line 102: b2b_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

98: country NUMBER := FND_API.G_MISS_NUM,
99: usage NUMBER := FND_API.G_MISS_NUM,
100: number_of_records NUMBER := FND_API.G_MISS_NUM,
101: data_file_name VARCHAR2(1000) := FND_API.G_MISS_CHAR,
102: b2b_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
103: rented_list_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
104: server_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
105: log_file_name NUMBER := FND_API.G_MISS_NUM,
106: number_of_failed_records NUMBER := FND_API.G_MISS_NUM,

Line 103: rented_list_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

99: usage NUMBER := FND_API.G_MISS_NUM,
100: number_of_records NUMBER := FND_API.G_MISS_NUM,
101: data_file_name VARCHAR2(1000) := FND_API.G_MISS_CHAR,
102: b2b_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
103: rented_list_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
104: server_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
105: log_file_name NUMBER := FND_API.G_MISS_NUM,
106: number_of_failed_records NUMBER := FND_API.G_MISS_NUM,
107: number_of_duplicate_records NUMBER := FND_API.G_MISS_NUM,

Line 104: server_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

100: number_of_records NUMBER := FND_API.G_MISS_NUM,
101: data_file_name VARCHAR2(1000) := FND_API.G_MISS_CHAR,
102: b2b_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
103: rented_list_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
104: server_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
105: log_file_name NUMBER := FND_API.G_MISS_NUM,
106: number_of_failed_records NUMBER := FND_API.G_MISS_NUM,
107: number_of_duplicate_records NUMBER := FND_API.G_MISS_NUM,
108: enable_word_replacement_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 105: log_file_name NUMBER := FND_API.G_MISS_NUM,

101: data_file_name VARCHAR2(1000) := FND_API.G_MISS_CHAR,
102: b2b_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
103: rented_list_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
104: server_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
105: log_file_name NUMBER := FND_API.G_MISS_NUM,
106: number_of_failed_records NUMBER := FND_API.G_MISS_NUM,
107: number_of_duplicate_records NUMBER := FND_API.G_MISS_NUM,
108: enable_word_replacement_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
109: validate_file VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 106: number_of_failed_records NUMBER := FND_API.G_MISS_NUM,

102: b2b_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
103: rented_list_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
104: server_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
105: log_file_name NUMBER := FND_API.G_MISS_NUM,
106: number_of_failed_records NUMBER := FND_API.G_MISS_NUM,
107: number_of_duplicate_records NUMBER := FND_API.G_MISS_NUM,
108: enable_word_replacement_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
109: validate_file VARCHAR2(1) := FND_API.G_MISS_CHAR,
110: server_name AMS_IMP_LIST_HEADERS_ALL.SERVER_NAME%TYPE := FND_API.G_MISS_CHAR,

Line 107: number_of_duplicate_records NUMBER := FND_API.G_MISS_NUM,

103: rented_list_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
104: server_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
105: log_file_name NUMBER := FND_API.G_MISS_NUM,
106: number_of_failed_records NUMBER := FND_API.G_MISS_NUM,
107: number_of_duplicate_records NUMBER := FND_API.G_MISS_NUM,
108: enable_word_replacement_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
109: validate_file VARCHAR2(1) := FND_API.G_MISS_CHAR,
110: server_name AMS_IMP_LIST_HEADERS_ALL.SERVER_NAME%TYPE := FND_API.G_MISS_CHAR,
111: user_name AMS_IMP_LIST_HEADERS_ALL.USER_NAME%TYPE := FND_API.G_MISS_CHAR,

Line 108: enable_word_replacement_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

104: server_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
105: log_file_name NUMBER := FND_API.G_MISS_NUM,
106: number_of_failed_records NUMBER := FND_API.G_MISS_NUM,
107: number_of_duplicate_records NUMBER := FND_API.G_MISS_NUM,
108: enable_word_replacement_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
109: validate_file VARCHAR2(1) := FND_API.G_MISS_CHAR,
110: server_name AMS_IMP_LIST_HEADERS_ALL.SERVER_NAME%TYPE := FND_API.G_MISS_CHAR,
111: user_name AMS_IMP_LIST_HEADERS_ALL.USER_NAME%TYPE := FND_API.G_MISS_CHAR,
112: password AMS_IMP_LIST_HEADERS_ALL.PASSWORD%TYPE := FND_API.G_MISS_CHAR,

Line 109: validate_file VARCHAR2(1) := FND_API.G_MISS_CHAR,

105: log_file_name NUMBER := FND_API.G_MISS_NUM,
106: number_of_failed_records NUMBER := FND_API.G_MISS_NUM,
107: number_of_duplicate_records NUMBER := FND_API.G_MISS_NUM,
108: enable_word_replacement_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
109: validate_file VARCHAR2(1) := FND_API.G_MISS_CHAR,
110: server_name AMS_IMP_LIST_HEADERS_ALL.SERVER_NAME%TYPE := FND_API.G_MISS_CHAR,
111: user_name AMS_IMP_LIST_HEADERS_ALL.USER_NAME%TYPE := FND_API.G_MISS_CHAR,
112: password AMS_IMP_LIST_HEADERS_ALL.PASSWORD%TYPE := FND_API.G_MISS_CHAR,
113: upload_flag AMS_IMP_LIST_HEADERS_ALL.UPLOAD_FLAG%TYPE := FND_API.G_MISS_CHAR,

Line 110: server_name AMS_IMP_LIST_HEADERS_ALL.SERVER_NAME%TYPE := FND_API.G_MISS_CHAR,

106: number_of_failed_records NUMBER := FND_API.G_MISS_NUM,
107: number_of_duplicate_records NUMBER := FND_API.G_MISS_NUM,
108: enable_word_replacement_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
109: validate_file VARCHAR2(1) := FND_API.G_MISS_CHAR,
110: server_name AMS_IMP_LIST_HEADERS_ALL.SERVER_NAME%TYPE := FND_API.G_MISS_CHAR,
111: user_name AMS_IMP_LIST_HEADERS_ALL.USER_NAME%TYPE := FND_API.G_MISS_CHAR,
112: password AMS_IMP_LIST_HEADERS_ALL.PASSWORD%TYPE := FND_API.G_MISS_CHAR,
113: upload_flag AMS_IMP_LIST_HEADERS_ALL.UPLOAD_FLAG%TYPE := FND_API.G_MISS_CHAR,
114: parent_imp_header_id AMS_IMP_LIST_HEADERS_ALL.PARENT_IMP_HEADER_ID%TYPE := FND_API.G_MISS_NUM,

Line 111: user_name AMS_IMP_LIST_HEADERS_ALL.USER_NAME%TYPE := FND_API.G_MISS_CHAR,

107: number_of_duplicate_records NUMBER := FND_API.G_MISS_NUM,
108: enable_word_replacement_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
109: validate_file VARCHAR2(1) := FND_API.G_MISS_CHAR,
110: server_name AMS_IMP_LIST_HEADERS_ALL.SERVER_NAME%TYPE := FND_API.G_MISS_CHAR,
111: user_name AMS_IMP_LIST_HEADERS_ALL.USER_NAME%TYPE := FND_API.G_MISS_CHAR,
112: password AMS_IMP_LIST_HEADERS_ALL.PASSWORD%TYPE := FND_API.G_MISS_CHAR,
113: upload_flag AMS_IMP_LIST_HEADERS_ALL.UPLOAD_FLAG%TYPE := FND_API.G_MISS_CHAR,
114: parent_imp_header_id AMS_IMP_LIST_HEADERS_ALL.PARENT_IMP_HEADER_ID%TYPE := FND_API.G_MISS_NUM,
115: record_update_flag AMS_IMP_LIST_HEADERS_ALL.RECORD_UPDATE_FLAG%TYPE := FND_API.G_MISS_CHAR,

Line 112: password AMS_IMP_LIST_HEADERS_ALL.PASSWORD%TYPE := FND_API.G_MISS_CHAR,

108: enable_word_replacement_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
109: validate_file VARCHAR2(1) := FND_API.G_MISS_CHAR,
110: server_name AMS_IMP_LIST_HEADERS_ALL.SERVER_NAME%TYPE := FND_API.G_MISS_CHAR,
111: user_name AMS_IMP_LIST_HEADERS_ALL.USER_NAME%TYPE := FND_API.G_MISS_CHAR,
112: password AMS_IMP_LIST_HEADERS_ALL.PASSWORD%TYPE := FND_API.G_MISS_CHAR,
113: upload_flag AMS_IMP_LIST_HEADERS_ALL.UPLOAD_FLAG%TYPE := FND_API.G_MISS_CHAR,
114: parent_imp_header_id AMS_IMP_LIST_HEADERS_ALL.PARENT_IMP_HEADER_ID%TYPE := FND_API.G_MISS_NUM,
115: record_update_flag AMS_IMP_LIST_HEADERS_ALL.RECORD_UPDATE_FLAG%TYPE := FND_API.G_MISS_CHAR,
116: error_threshold AMS_IMP_LIST_HEADERS_ALL.ERROR_THRESHOLD%TYPE := FND_API.G_MISS_NUM,

Line 113: upload_flag AMS_IMP_LIST_HEADERS_ALL.UPLOAD_FLAG%TYPE := FND_API.G_MISS_CHAR,

109: validate_file VARCHAR2(1) := FND_API.G_MISS_CHAR,
110: server_name AMS_IMP_LIST_HEADERS_ALL.SERVER_NAME%TYPE := FND_API.G_MISS_CHAR,
111: user_name AMS_IMP_LIST_HEADERS_ALL.USER_NAME%TYPE := FND_API.G_MISS_CHAR,
112: password AMS_IMP_LIST_HEADERS_ALL.PASSWORD%TYPE := FND_API.G_MISS_CHAR,
113: upload_flag AMS_IMP_LIST_HEADERS_ALL.UPLOAD_FLAG%TYPE := FND_API.G_MISS_CHAR,
114: parent_imp_header_id AMS_IMP_LIST_HEADERS_ALL.PARENT_IMP_HEADER_ID%TYPE := FND_API.G_MISS_NUM,
115: record_update_flag AMS_IMP_LIST_HEADERS_ALL.RECORD_UPDATE_FLAG%TYPE := FND_API.G_MISS_CHAR,
116: error_threshold AMS_IMP_LIST_HEADERS_ALL.ERROR_THRESHOLD%TYPE := FND_API.G_MISS_NUM,
117: charset AMS_IMP_LIST_HEADERS_ALL.CHARSET%TYPE := FND_API.G_MISS_CHAR);

Line 114: parent_imp_header_id AMS_IMP_LIST_HEADERS_ALL.PARENT_IMP_HEADER_ID%TYPE := FND_API.G_MISS_NUM,

110: server_name AMS_IMP_LIST_HEADERS_ALL.SERVER_NAME%TYPE := FND_API.G_MISS_CHAR,
111: user_name AMS_IMP_LIST_HEADERS_ALL.USER_NAME%TYPE := FND_API.G_MISS_CHAR,
112: password AMS_IMP_LIST_HEADERS_ALL.PASSWORD%TYPE := FND_API.G_MISS_CHAR,
113: upload_flag AMS_IMP_LIST_HEADERS_ALL.UPLOAD_FLAG%TYPE := FND_API.G_MISS_CHAR,
114: parent_imp_header_id AMS_IMP_LIST_HEADERS_ALL.PARENT_IMP_HEADER_ID%TYPE := FND_API.G_MISS_NUM,
115: record_update_flag AMS_IMP_LIST_HEADERS_ALL.RECORD_UPDATE_FLAG%TYPE := FND_API.G_MISS_CHAR,
116: error_threshold AMS_IMP_LIST_HEADERS_ALL.ERROR_THRESHOLD%TYPE := FND_API.G_MISS_NUM,
117: charset AMS_IMP_LIST_HEADERS_ALL.CHARSET%TYPE := FND_API.G_MISS_CHAR);
118:

Line 115: record_update_flag AMS_IMP_LIST_HEADERS_ALL.RECORD_UPDATE_FLAG%TYPE := FND_API.G_MISS_CHAR,

111: user_name AMS_IMP_LIST_HEADERS_ALL.USER_NAME%TYPE := FND_API.G_MISS_CHAR,
112: password AMS_IMP_LIST_HEADERS_ALL.PASSWORD%TYPE := FND_API.G_MISS_CHAR,
113: upload_flag AMS_IMP_LIST_HEADERS_ALL.UPLOAD_FLAG%TYPE := FND_API.G_MISS_CHAR,
114: parent_imp_header_id AMS_IMP_LIST_HEADERS_ALL.PARENT_IMP_HEADER_ID%TYPE := FND_API.G_MISS_NUM,
115: record_update_flag AMS_IMP_LIST_HEADERS_ALL.RECORD_UPDATE_FLAG%TYPE := FND_API.G_MISS_CHAR,
116: error_threshold AMS_IMP_LIST_HEADERS_ALL.ERROR_THRESHOLD%TYPE := FND_API.G_MISS_NUM,
117: charset AMS_IMP_LIST_HEADERS_ALL.CHARSET%TYPE := FND_API.G_MISS_CHAR);
118:
119: g_miss_ams_import_rec ams_import_rec_type;

Line 116: error_threshold AMS_IMP_LIST_HEADERS_ALL.ERROR_THRESHOLD%TYPE := FND_API.G_MISS_NUM,

112: password AMS_IMP_LIST_HEADERS_ALL.PASSWORD%TYPE := FND_API.G_MISS_CHAR,
113: upload_flag AMS_IMP_LIST_HEADERS_ALL.UPLOAD_FLAG%TYPE := FND_API.G_MISS_CHAR,
114: parent_imp_header_id AMS_IMP_LIST_HEADERS_ALL.PARENT_IMP_HEADER_ID%TYPE := FND_API.G_MISS_NUM,
115: record_update_flag AMS_IMP_LIST_HEADERS_ALL.RECORD_UPDATE_FLAG%TYPE := FND_API.G_MISS_CHAR,
116: error_threshold AMS_IMP_LIST_HEADERS_ALL.ERROR_THRESHOLD%TYPE := FND_API.G_MISS_NUM,
117: charset AMS_IMP_LIST_HEADERS_ALL.CHARSET%TYPE := FND_API.G_MISS_CHAR);
118:
119: g_miss_ams_import_rec ams_import_rec_type;
120: TYPE ams_import_tbl_type IS TABLE OF ams_import_rec_type INDEX BY BINARY_INTEGER;

Line 117: charset AMS_IMP_LIST_HEADERS_ALL.CHARSET%TYPE := FND_API.G_MISS_CHAR);

113: upload_flag AMS_IMP_LIST_HEADERS_ALL.UPLOAD_FLAG%TYPE := FND_API.G_MISS_CHAR,
114: parent_imp_header_id AMS_IMP_LIST_HEADERS_ALL.PARENT_IMP_HEADER_ID%TYPE := FND_API.G_MISS_NUM,
115: record_update_flag AMS_IMP_LIST_HEADERS_ALL.RECORD_UPDATE_FLAG%TYPE := FND_API.G_MISS_CHAR,
116: error_threshold AMS_IMP_LIST_HEADERS_ALL.ERROR_THRESHOLD%TYPE := FND_API.G_MISS_NUM,
117: charset AMS_IMP_LIST_HEADERS_ALL.CHARSET%TYPE := FND_API.G_MISS_CHAR);
118:
119: g_miss_ams_import_rec ams_import_rec_type;
120: TYPE ams_import_tbl_type IS TABLE OF ams_import_rec_type INDEX BY BINARY_INTEGER;
121: g_miss_ams_import_tbl ams_import_tbl_type;

Line 145: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

141: --
142: /*
143: PROCEDURE Do_Recurring (
144: p_api_version_number IN NUMBER,
145: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
146: p_commit IN VARCHAR2 := FND_API.G_FALSE,
147: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
148:
149: x_return_status OUT NOCOPY VARCHAR2,

Line 146: p_commit IN VARCHAR2 := FND_API.G_FALSE,

142: /*
143: PROCEDURE Do_Recurring (
144: p_api_version_number IN NUMBER,
145: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
146: p_commit IN VARCHAR2 := FND_API.G_FALSE,
147: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
148:
149: x_return_status OUT NOCOPY VARCHAR2,
150: x_msg_count OUT NOCOPY NUMBER,

Line 147: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

143: PROCEDURE Do_Recurring (
144: p_api_version_number IN NUMBER,
145: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
146: p_commit IN VARCHAR2 := FND_API.G_FALSE,
147: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
148:
149: x_return_status OUT NOCOPY VARCHAR2,
150: x_msg_count OUT NOCOPY NUMBER,
151: x_msg_data OUT NOCOPY VARCHAR2,

Line 175: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

171: -- Parameters
172: --
173: -- IN
174: -- p_api_version_number IN NUMBER Required
175: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
176: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
177: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
178: -- p_import_list_header_id IN NUMBER Required
179: --

Line 176: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

172: --
173: -- IN
174: -- p_api_version_number IN NUMBER Required
175: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
176: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
177: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
178: -- p_import_list_header_id IN NUMBER Required
179: --
180: -- OUT

Line 177: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

173: -- IN
174: -- p_api_version_number IN NUMBER Required
175: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
176: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
177: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
178: -- p_import_list_header_id IN NUMBER Required
179: --
180: -- OUT
181: -- x_return_status OUT VARCHAR2

Line 195: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

191: --
192:
193: PROCEDURE Duplicate_Import_List (
194: p_api_version_number IN NUMBER,
195: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
196: p_commit IN VARCHAR2 := FND_API.G_FALSE,
197: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
198:
199: x_return_status OUT NOCOPY VARCHAR2,

Line 196: p_commit IN VARCHAR2 := FND_API.G_FALSE,

192:
193: PROCEDURE Duplicate_Import_List (
194: p_api_version_number IN NUMBER,
195: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
196: p_commit IN VARCHAR2 := FND_API.G_FALSE,
197: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
198:
199: x_return_status OUT NOCOPY VARCHAR2,
200: x_msg_count OUT NOCOPY NUMBER,

Line 197: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

193: PROCEDURE Duplicate_Import_List (
194: p_api_version_number IN NUMBER,
195: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
196: p_commit IN VARCHAR2 := FND_API.G_FALSE,
197: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
198:
199: x_return_status OUT NOCOPY VARCHAR2,
200: x_msg_count OUT NOCOPY NUMBER,
201: x_msg_data OUT NOCOPY VARCHAR2,

Line 220: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

216: -- Parameters
217: --
218: -- IN
219: -- p_api_version_number IN NUMBER Required
220: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
221: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
222: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
223: -- p_ams_import_rec IN ams_import_rec_type Required
224: --

Line 221: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

217: --
218: -- IN
219: -- p_api_version_number IN NUMBER Required
220: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
221: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
222: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
223: -- p_ams_import_rec IN ams_import_rec_type Required
224: --
225: -- OUT

Line 222: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

218: -- IN
219: -- p_api_version_number IN NUMBER Required
220: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
221: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
222: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
223: -- p_ams_import_rec IN ams_import_rec_type Required
224: --
225: -- OUT
226: -- x_return_status OUT VARCHAR2

Line 239: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

235: --
236:
237: PROCEDURE Create_Import_List(
238: p_api_version_number IN NUMBER,
239: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
240: p_commit IN VARCHAR2 := FND_API.G_FALSE,
241: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
242:
243: x_return_status OUT NOCOPY VARCHAR2,

Line 240: p_commit IN VARCHAR2 := FND_API.G_FALSE,

236:
237: PROCEDURE Create_Import_List(
238: p_api_version_number IN NUMBER,
239: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
240: p_commit IN VARCHAR2 := FND_API.G_FALSE,
241: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
242:
243: x_return_status OUT NOCOPY VARCHAR2,
244: x_msg_count OUT NOCOPY NUMBER,

Line 241: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

237: PROCEDURE Create_Import_List(
238: p_api_version_number IN NUMBER,
239: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
240: p_commit IN VARCHAR2 := FND_API.G_FALSE,
241: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
242:
243: x_return_status OUT NOCOPY VARCHAR2,
244: x_msg_count OUT NOCOPY NUMBER,
245: x_msg_data OUT NOCOPY VARCHAR2,

Line 264: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

260: -- Parameters
261: --
262: -- IN
263: -- p_api_version_number IN NUMBER Required
264: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
265: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
266: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
267: -- p_ams_import_rec IN ams_import_rec_type Required
268: --

Line 265: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

261: --
262: -- IN
263: -- p_api_version_number IN NUMBER Required
264: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
265: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
266: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
267: -- p_ams_import_rec IN ams_import_rec_type Required
268: --
269: -- OUT

Line 266: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

262: -- IN
263: -- p_api_version_number IN NUMBER Required
264: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
265: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
266: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
267: -- p_ams_import_rec IN ams_import_rec_type Required
268: --
269: -- OUT
270: -- x_return_status OUT VARCHAR2

Line 283: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

279: --
280:
281: PROCEDURE Update_Import_List(
282: p_api_version_number IN NUMBER,
283: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
284: p_commit IN VARCHAR2 := FND_API.G_FALSE,
285: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
286:
287: x_return_status OUT NOCOPY VARCHAR2,

Line 284: p_commit IN VARCHAR2 := FND_API.G_FALSE,

280:
281: PROCEDURE Update_Import_List(
282: p_api_version_number IN NUMBER,
283: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
284: p_commit IN VARCHAR2 := FND_API.G_FALSE,
285: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
286:
287: x_return_status OUT NOCOPY VARCHAR2,
288: x_msg_count OUT NOCOPY NUMBER,

Line 285: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

281: PROCEDURE Update_Import_List(
282: p_api_version_number IN NUMBER,
283: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
284: p_commit IN VARCHAR2 := FND_API.G_FALSE,
285: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
286:
287: x_return_status OUT NOCOPY VARCHAR2,
288: x_msg_count OUT NOCOPY NUMBER,
289: x_msg_data OUT NOCOPY VARCHAR2,

Line 308: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

304: -- Parameters
305: --
306: -- IN
307: -- p_api_version_number IN NUMBER Required
308: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
309: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
310: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
311: -- p_IMPORT_LIST_HEADER_ID IN NUMBER
312: -- p_object_version_number IN NUMBER Optional Default = NULL

Line 309: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

305: --
306: -- IN
307: -- p_api_version_number IN NUMBER Required
308: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
309: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
310: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
311: -- p_IMPORT_LIST_HEADER_ID IN NUMBER
312: -- p_object_version_number IN NUMBER Optional Default = NULL
313: --

Line 310: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

306: -- IN
307: -- p_api_version_number IN NUMBER Required
308: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
309: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
310: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
311: -- p_IMPORT_LIST_HEADER_ID IN NUMBER
312: -- p_object_version_number IN NUMBER Optional Default = NULL
313: --
314: -- OUT

Line 328: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

324: --
325:
326: PROCEDURE Delete_Import_List(
327: p_api_version_number IN NUMBER,
328: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
329: p_commit IN VARCHAR2 := FND_API.G_FALSE,
330: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
331: x_return_status OUT NOCOPY VARCHAR2,
332: x_msg_count OUT NOCOPY NUMBER,

Line 329: p_commit IN VARCHAR2 := FND_API.G_FALSE,

325:
326: PROCEDURE Delete_Import_List(
327: p_api_version_number IN NUMBER,
328: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
329: p_commit IN VARCHAR2 := FND_API.G_FALSE,
330: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
331: x_return_status OUT NOCOPY VARCHAR2,
332: x_msg_count OUT NOCOPY NUMBER,
333: x_msg_data OUT NOCOPY VARCHAR2,

Line 330: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

326: PROCEDURE Delete_Import_List(
327: p_api_version_number IN NUMBER,
328: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
329: p_commit IN VARCHAR2 := FND_API.G_FALSE,
330: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
331: x_return_status OUT NOCOPY VARCHAR2,
332: x_msg_count OUT NOCOPY NUMBER,
333: x_msg_data OUT NOCOPY VARCHAR2,
334: p_import_list_header_id IN NUMBER,

Line 351: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE

347: -- Parameters
348: --
349: -- IN
350: -- p_api_version_number IN NUMBER Required
351: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
352: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
353: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
354: -- p_ams_import_rec IN ams_import_rec_type Required
355: --

Line 352: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

348: --
349: -- IN
350: -- p_api_version_number IN NUMBER Required
351: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
352: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
353: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
354: -- p_ams_import_rec IN ams_import_rec_type Required
355: --
356: -- OUT

Line 353: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL

349: -- IN
350: -- p_api_version_number IN NUMBER Required
351: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
352: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
353: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
354: -- p_ams_import_rec IN ams_import_rec_type Required
355: --
356: -- OUT
357: -- x_return_status OUT VARCHAR2

Line 370: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

366: --
367:
368: PROCEDURE Lock_Import_List(
369: p_api_version_number IN NUMBER,
370: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
371:
372: x_return_status OUT NOCOPY VARCHAR2,
373: x_msg_count OUT NOCOPY NUMBER,
374: x_msg_data OUT NOCOPY VARCHAR2,

Line 394: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

390: -- End of Comments
391:
392: PROCEDURE Validate_import_list(
393: p_api_version_number IN NUMBER,
394: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
395: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
396: p_ams_import_rec IN ams_import_rec_type,
397: x_return_status OUT NOCOPY VARCHAR2,
398: x_msg_count OUT NOCOPY NUMBER,

Line 395: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

391:
392: PROCEDURE Validate_import_list(
393: p_api_version_number IN NUMBER,
394: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
395: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
396: p_ams_import_rec IN ams_import_rec_type,
397: x_return_status OUT NOCOPY VARCHAR2,
398: x_msg_count OUT NOCOPY NUMBER,
399: x_msg_data OUT NOCOPY VARCHAR2

Line 432: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

428: -- End of Comments
429:
430: PROCEDURE Validate_ams_import_rec(
431: p_api_version_number IN NUMBER,
432: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
433: x_return_status OUT NOCOPY VARCHAR2,
434: x_msg_count OUT NOCOPY NUMBER,
435: x_msg_data OUT NOCOPY VARCHAR2,
436: p_ams_import_rec IN ams_import_rec_type