DBA Data[Home] [Help]

APPS.BIS_INDICATOR_REGION_PUB dependencies on FND_API

Line 45: Ind_Selection_ID NUMBER := FND_API.G_MISS_NUM,

41: );
42:
43: /*
44: TYPE Indicator_Region_Rec_Type IS RECORD (
45: Ind_Selection_ID NUMBER := FND_API.G_MISS_NUM,
46: Plug_ID NUMBER := FND_API.G_MISS_NUM,
47: User_ID NUMBER := FND_API.G_MISS_NUM,
48: User_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
49: Responsibility_ID NUMBER := FND_API.G_MISS_NUM,

Line 46: Plug_ID NUMBER := FND_API.G_MISS_NUM,

42:
43: /*
44: TYPE Indicator_Region_Rec_Type IS RECORD (
45: Ind_Selection_ID NUMBER := FND_API.G_MISS_NUM,
46: Plug_ID NUMBER := FND_API.G_MISS_NUM,
47: User_ID NUMBER := FND_API.G_MISS_NUM,
48: User_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
49: Responsibility_ID NUMBER := FND_API.G_MISS_NUM,
50: Responsibility_Short_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,

Line 47: User_ID NUMBER := FND_API.G_MISS_NUM,

43: /*
44: TYPE Indicator_Region_Rec_Type IS RECORD (
45: Ind_Selection_ID NUMBER := FND_API.G_MISS_NUM,
46: Plug_ID NUMBER := FND_API.G_MISS_NUM,
47: User_ID NUMBER := FND_API.G_MISS_NUM,
48: User_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
49: Responsibility_ID NUMBER := FND_API.G_MISS_NUM,
50: Responsibility_Short_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
51: Responsibility_Name VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 48: User_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,

44: TYPE Indicator_Region_Rec_Type IS RECORD (
45: Ind_Selection_ID NUMBER := FND_API.G_MISS_NUM,
46: Plug_ID NUMBER := FND_API.G_MISS_NUM,
47: User_ID NUMBER := FND_API.G_MISS_NUM,
48: User_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
49: Responsibility_ID NUMBER := FND_API.G_MISS_NUM,
50: Responsibility_Short_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
51: Responsibility_Name VARCHAR2(240) := FND_API.G_MISS_CHAR,
52: Target_Level_ID NUMBER := FND_API.G_MISS_NUM,

Line 49: Responsibility_ID NUMBER := FND_API.G_MISS_NUM,

45: Ind_Selection_ID NUMBER := FND_API.G_MISS_NUM,
46: Plug_ID NUMBER := FND_API.G_MISS_NUM,
47: User_ID NUMBER := FND_API.G_MISS_NUM,
48: User_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
49: Responsibility_ID NUMBER := FND_API.G_MISS_NUM,
50: Responsibility_Short_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
51: Responsibility_Name VARCHAR2(240) := FND_API.G_MISS_CHAR,
52: Target_Level_ID NUMBER := FND_API.G_MISS_NUM,
53: Target_Level_Short_Name VARCHAR2(80) := FND_API.G_MISS_CHAR,

Line 50: Responsibility_Short_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,

46: Plug_ID NUMBER := FND_API.G_MISS_NUM,
47: User_ID NUMBER := FND_API.G_MISS_NUM,
48: User_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
49: Responsibility_ID NUMBER := FND_API.G_MISS_NUM,
50: Responsibility_Short_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
51: Responsibility_Name VARCHAR2(240) := FND_API.G_MISS_CHAR,
52: Target_Level_ID NUMBER := FND_API.G_MISS_NUM,
53: Target_Level_Short_Name VARCHAR2(80) := FND_API.G_MISS_CHAR,
54: Target_Level_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,

Line 51: Responsibility_Name VARCHAR2(240) := FND_API.G_MISS_CHAR,

47: User_ID NUMBER := FND_API.G_MISS_NUM,
48: User_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
49: Responsibility_ID NUMBER := FND_API.G_MISS_NUM,
50: Responsibility_Short_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
51: Responsibility_Name VARCHAR2(240) := FND_API.G_MISS_CHAR,
52: Target_Level_ID NUMBER := FND_API.G_MISS_NUM,
53: Target_Level_Short_Name VARCHAR2(80) := FND_API.G_MISS_CHAR,
54: Target_Level_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
55: Label VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 52: Target_Level_ID NUMBER := FND_API.G_MISS_NUM,

48: User_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
49: Responsibility_ID NUMBER := FND_API.G_MISS_NUM,
50: Responsibility_Short_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
51: Responsibility_Name VARCHAR2(240) := FND_API.G_MISS_CHAR,
52: Target_Level_ID NUMBER := FND_API.G_MISS_NUM,
53: Target_Level_Short_Name VARCHAR2(80) := FND_API.G_MISS_CHAR,
54: Target_Level_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
55: Label VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: Org_Level_Value_ID VARCHAR2(80) := FND_API.G_MISS_CHAR,

Line 53: Target_Level_Short_Name VARCHAR2(80) := FND_API.G_MISS_CHAR,

49: Responsibility_ID NUMBER := FND_API.G_MISS_NUM,
50: Responsibility_Short_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
51: Responsibility_Name VARCHAR2(240) := FND_API.G_MISS_CHAR,
52: Target_Level_ID NUMBER := FND_API.G_MISS_NUM,
53: Target_Level_Short_Name VARCHAR2(80) := FND_API.G_MISS_CHAR,
54: Target_Level_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
55: Label VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: Org_Level_Value_ID VARCHAR2(80) := FND_API.G_MISS_CHAR,
57: Org_Level_Value_Name VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 54: Target_Level_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,

50: Responsibility_Short_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
51: Responsibility_Name VARCHAR2(240) := FND_API.G_MISS_CHAR,
52: Target_Level_ID NUMBER := FND_API.G_MISS_NUM,
53: Target_Level_Short_Name VARCHAR2(80) := FND_API.G_MISS_CHAR,
54: Target_Level_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
55: Label VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: Org_Level_Value_ID VARCHAR2(80) := FND_API.G_MISS_CHAR,
57: Org_Level_Value_Name VARCHAR2(60) := FND_API.G_MISS_CHAR,
58: Dim1_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,

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

51: Responsibility_Name VARCHAR2(240) := FND_API.G_MISS_CHAR,
52: Target_Level_ID NUMBER := FND_API.G_MISS_NUM,
53: Target_Level_Short_Name VARCHAR2(80) := FND_API.G_MISS_CHAR,
54: Target_Level_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
55: Label VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: Org_Level_Value_ID VARCHAR2(80) := FND_API.G_MISS_CHAR,
57: Org_Level_Value_Name VARCHAR2(60) := FND_API.G_MISS_CHAR,
58: Dim1_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
59: Dim1_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,

Line 56: Org_Level_Value_ID VARCHAR2(80) := FND_API.G_MISS_CHAR,

52: Target_Level_ID NUMBER := FND_API.G_MISS_NUM,
53: Target_Level_Short_Name VARCHAR2(80) := FND_API.G_MISS_CHAR,
54: Target_Level_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
55: Label VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: Org_Level_Value_ID VARCHAR2(80) := FND_API.G_MISS_CHAR,
57: Org_Level_Value_Name VARCHAR2(60) := FND_API.G_MISS_CHAR,
58: Dim1_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
59: Dim1_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
60: Dim2_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,

Line 57: Org_Level_Value_Name VARCHAR2(60) := FND_API.G_MISS_CHAR,

53: Target_Level_Short_Name VARCHAR2(80) := FND_API.G_MISS_CHAR,
54: Target_Level_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
55: Label VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: Org_Level_Value_ID VARCHAR2(80) := FND_API.G_MISS_CHAR,
57: Org_Level_Value_Name VARCHAR2(60) := FND_API.G_MISS_CHAR,
58: Dim1_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
59: Dim1_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
60: Dim2_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
61: Dim2_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,

Line 58: Dim1_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,

54: Target_Level_Name VARCHAR2(100) := FND_API.G_MISS_CHAR,
55: Label VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: Org_Level_Value_ID VARCHAR2(80) := FND_API.G_MISS_CHAR,
57: Org_Level_Value_Name VARCHAR2(60) := FND_API.G_MISS_CHAR,
58: Dim1_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
59: Dim1_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
60: Dim2_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
61: Dim2_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
62: Dim3_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,

Line 59: Dim1_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,

55: Label VARCHAR2(30) := FND_API.G_MISS_CHAR,
56: Org_Level_Value_ID VARCHAR2(80) := FND_API.G_MISS_CHAR,
57: Org_Level_Value_Name VARCHAR2(60) := FND_API.G_MISS_CHAR,
58: Dim1_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
59: Dim1_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
60: Dim2_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
61: Dim2_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
62: Dim3_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
63: Dim3_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,

Line 60: Dim2_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,

56: Org_Level_Value_ID VARCHAR2(80) := FND_API.G_MISS_CHAR,
57: Org_Level_Value_Name VARCHAR2(60) := FND_API.G_MISS_CHAR,
58: Dim1_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
59: Dim1_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
60: Dim2_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
61: Dim2_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
62: Dim3_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
63: Dim3_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
64: Dim4_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,

Line 61: Dim2_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,

57: Org_Level_Value_Name VARCHAR2(60) := FND_API.G_MISS_CHAR,
58: Dim1_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
59: Dim1_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
60: Dim2_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
61: Dim2_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
62: Dim3_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
63: Dim3_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
64: Dim4_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
65: Dim4_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,

Line 62: Dim3_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,

58: Dim1_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
59: Dim1_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
60: Dim2_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
61: Dim2_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
62: Dim3_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
63: Dim3_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
64: Dim4_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
65: Dim4_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
66: Dim5_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,

Line 63: Dim3_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,

59: Dim1_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
60: Dim2_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
61: Dim2_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
62: Dim3_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
63: Dim3_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
64: Dim4_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
65: Dim4_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
66: Dim5_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
67: Dim5_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,

Line 64: Dim4_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,

60: Dim2_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
61: Dim2_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
62: Dim3_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
63: Dim3_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
64: Dim4_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
65: Dim4_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
66: Dim5_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
67: Dim5_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
68: Plan_ID NUMBER := FND_API.G_MISS_NUM,

Line 65: Dim4_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,

61: Dim2_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
62: Dim3_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
63: Dim3_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
64: Dim4_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
65: Dim4_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
66: Dim5_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
67: Dim5_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
68: Plan_ID NUMBER := FND_API.G_MISS_NUM,
69: Plan_Short_Name VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 66: Dim5_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,

62: Dim3_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
63: Dim3_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
64: Dim4_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
65: Dim4_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
66: Dim5_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
67: Dim5_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
68: Plan_ID NUMBER := FND_API.G_MISS_NUM,
69: Plan_Short_Name VARCHAR2(30) := FND_API.G_MISS_CHAR,
70: Plan_Name VARCHAR2(80) := FND_API.G_MISS_CHAR);

Line 67: Dim5_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,

63: Dim3_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
64: Dim4_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
65: Dim4_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
66: Dim5_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
67: Dim5_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
68: Plan_ID NUMBER := FND_API.G_MISS_NUM,
69: Plan_Short_Name VARCHAR2(30) := FND_API.G_MISS_CHAR,
70: Plan_Name VARCHAR2(80) := FND_API.G_MISS_CHAR);
71: */

Line 68: Plan_ID NUMBER := FND_API.G_MISS_NUM,

64: Dim4_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
65: Dim4_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
66: Dim5_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
67: Dim5_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
68: Plan_ID NUMBER := FND_API.G_MISS_NUM,
69: Plan_Short_Name VARCHAR2(30) := FND_API.G_MISS_CHAR,
70: Plan_Name VARCHAR2(80) := FND_API.G_MISS_CHAR);
71: */
72:

Line 69: Plan_Short_Name VARCHAR2(30) := FND_API.G_MISS_CHAR,

65: Dim4_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
66: Dim5_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
67: Dim5_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
68: Plan_ID NUMBER := FND_API.G_MISS_NUM,
69: Plan_Short_Name VARCHAR2(30) := FND_API.G_MISS_CHAR,
70: Plan_Name VARCHAR2(80) := FND_API.G_MISS_CHAR);
71: */
72:
73: TYPE Indicator_Region_Tbl_Type IS TABLE of Indicator_Region_Rec_Type

Line 70: Plan_Name VARCHAR2(80) := FND_API.G_MISS_CHAR);

66: Dim5_Level_Value_ID VARCHAR2(250) := FND_API.G_MISS_CHAR,
67: Dim5_Level_Value_Name VARCHAR2(250) := FND_API.G_MISS_CHAR,
68: Plan_ID NUMBER := FND_API.G_MISS_NUM,
69: Plan_Short_Name VARCHAR2(30) := FND_API.G_MISS_CHAR,
70: Plan_Name VARCHAR2(80) := FND_API.G_MISS_CHAR);
71: */
72:
73: TYPE Indicator_Region_Tbl_Type IS TABLE of Indicator_Region_Rec_Type
74: INDEX BY BINARY_INTEGER;

Line 92: p_all_info IN VARCHAR2 Default FND_API.G_TRUE,

88: p_api_version IN NUMBER,
89: p_user_id IN NUMBER Default BIS_UTILITIES_PUB.G_NULL_NUM,
90: p_user_name IN VARCHAR2 Default BIS_UTILITIES_PUB.G_NULL_CHAR,
91: p_plug_id IN NUMBER,
92: p_all_info IN VARCHAR2 Default FND_API.G_TRUE,
93: x_Indicator_Region_Tbl
94: OUT NOCOPY BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type,
95: x_return_status OUT NOCOPY VARCHAR2,
96: x_error_Tbl OUT NOCOPY BIS_UTILITIES_PUB.Error_Tbl_Type);

Line 101: p_all_info IN VARCHAR2 Default FND_API.G_TRUE,

97:
98:
99: Procedure Retrieve_User_Ind_Selections(
100: p_api_version IN NUMBER,
101: p_all_info IN VARCHAR2 Default FND_API.G_TRUE,
102: p_Target_level_rec IN BIS_TARGET_LEVEL_PUB.Target_Level_Rec_Type,
103: x_Indicator_Region_Tbl
104: OUT NOCOPY BIS_INDICATOR_REGION_PUB.Indicator_Region_Tbl_Type,
105: x_return_status OUT NOCOPY VARCHAR2,