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

Line 16: * same session). Valid values are FND_API.G_TRUE and FND_API.G_FALSE.

12: *

p_init_msg_list: A one-character flag indicating whether to initialize the
14: * FND_MSG_PUB package's message stack at the beginning of API processing(which
15: * removes any messages that may exist on the stack from prior processing in the
16: * same session). Valid values are FND_API.G_TRUE and FND_API.G_FALSE.

p_commit: A one-character flag indicating whether to commit work at the end
19: * of API processing. Valid values are FND_API.G_TRUE and FND_API.G_FALSE.

Line 19: * of API processing. Valid values are FND_API.G_TRUE and FND_API.G_FALSE.

15: * removes any messages that may exist on the stack from prior processing in the
16: * same session). Valid values are FND_API.G_TRUE and FND_API.G_FALSE.
17: *
18: *

p_commit: A one-character flag indicating whether to commit work at the end
19: * of API processing. Valid values are FND_API.G_TRUE and FND_API.G_FALSE.

x_return_status: A one-character code indicating whether any errors occurred
22: * during processing (in which case error messages will be present on the
23: * FND_MSG_PUB package's message stack).Valid values are FND_API.G_RET_STS_SUCCESS,

Line 23: * FND_MSG_PUB package's message stack).Valid values are FND_API.G_RET_STS_SUCCESS,

19: * of API processing. Valid values are FND_API.G_TRUE and FND_API.G_FALSE.

x_return_status: A one-character code indicating whether any errors occurred
22: * during processing (in which case error messages will be present on the
23: * FND_MSG_PUB package's message stack).Valid values are FND_API.G_RET_STS_SUCCESS,
24: * FND_API.G_RET_STS_ERROR, and FND_API.G_RET_STS_UNEXP_ERROR.

x_msg_count: An integer indicating the number of messages on the FND_MSG_PUB
27: * package's message stack at the end of API processing. For information about

Line 24: * FND_API.G_RET_STS_ERROR, and FND_API.G_RET_STS_UNEXP_ERROR.

20: *
21: *

x_return_status: A one-character code indicating whether any errors occurred
22: * during processing (in which case error messages will be present on the
23: * FND_MSG_PUB package's message stack).Valid values are FND_API.G_RET_STS_SUCCESS,
24: * FND_API.G_RET_STS_ERROR, and FND_API.G_RET_STS_UNEXP_ERROR.

x_msg_count: An integer indicating the number of messages on the FND_MSG_PUB
27: * package's message stack at the end of API processing. For information about
28: * how to retrieve messages from the message stack, refer to FND_MSG_PUB

Line 36: * (FND_API.G_MISS_NUM, FND_API.G_MISS_CHAR,

32: * messsage list to get the exact error messages occured.

34: *
35: * G_MISS_* values: In addition, three standard default values
36: * (FND_API.G_MISS_NUM, FND_API.G_MISS_CHAR,
37: * FND_API.G_MISS_DATE)
38: * are used throughout the APIs below. These default values are used
39: * to differentiate between a value not passed at all (represented
40: * by the G_MISS_* default value) and a value explicitly passed

Line 37: * FND_API.G_MISS_DATE)

33: *
34: *
35: * G_MISS_* values: In addition, three standard default values
36: * (FND_API.G_MISS_NUM, FND_API.G_MISS_CHAR,
37: * FND_API.G_MISS_DATE)
38: * are used throughout the APIs below. These default values are used
39: * to differentiate between a value not passed at all (represented
40: * by the G_MISS_* default value) and a value explicitly passed
41: * as NULL. This convention avoids unintentional nullification

Line 54: Transaction_Type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR

50: G_BO_Identifier CONSTANT VARCHAR2(30) := 'RelItem';
51:
52: TYPE Rel_Item_Rec_Type IS RECORD
53: (
54: Transaction_Type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
55: ,X_Return_Status VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR
56: -- Primary Key Columns
57: ,Inventory_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM
58: ,Organization_Id NUMBER DEFAULT FND_API.G_MISS_NUM

Line 55: ,X_Return_Status VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR

51:
52: TYPE Rel_Item_Rec_Type IS RECORD
53: (
54: Transaction_Type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
55: ,X_Return_Status VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR
56: -- Primary Key Columns
57: ,Inventory_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM
58: ,Organization_Id NUMBER DEFAULT FND_API.G_MISS_NUM
59: ,Related_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM

Line 57: ,Inventory_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM

53: (
54: Transaction_Type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
55: ,X_Return_Status VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR
56: -- Primary Key Columns
57: ,Inventory_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM
58: ,Organization_Id NUMBER DEFAULT FND_API.G_MISS_NUM
59: ,Related_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM
60: ,Relationship_Type_Id NUMBER DEFAULT FND_API.G_MISS_NUM
61: -- to take new values of rel item and type in update mode.

Line 58: ,Organization_Id NUMBER DEFAULT FND_API.G_MISS_NUM

54: Transaction_Type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
55: ,X_Return_Status VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR
56: -- Primary Key Columns
57: ,Inventory_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM
58: ,Organization_Id NUMBER DEFAULT FND_API.G_MISS_NUM
59: ,Related_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM
60: ,Relationship_Type_Id NUMBER DEFAULT FND_API.G_MISS_NUM
61: -- to take new values of rel item and type in update mode.
62: ,Related_Item_Id_Upd_Val NUMBER DEFAULT FND_API.G_MISS_NUM

Line 59: ,Related_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM

55: ,X_Return_Status VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR
56: -- Primary Key Columns
57: ,Inventory_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM
58: ,Organization_Id NUMBER DEFAULT FND_API.G_MISS_NUM
59: ,Related_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM
60: ,Relationship_Type_Id NUMBER DEFAULT FND_API.G_MISS_NUM
61: -- to take new values of rel item and type in update mode.
62: ,Related_Item_Id_Upd_Val NUMBER DEFAULT FND_API.G_MISS_NUM
63: ,Relationship_Type_Id_Upd_Val NUMBER DEFAULT FND_API.G_MISS_NUM

Line 60: ,Relationship_Type_Id NUMBER DEFAULT FND_API.G_MISS_NUM

56: -- Primary Key Columns
57: ,Inventory_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM
58: ,Organization_Id NUMBER DEFAULT FND_API.G_MISS_NUM
59: ,Related_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM
60: ,Relationship_Type_Id NUMBER DEFAULT FND_API.G_MISS_NUM
61: -- to take new values of rel item and type in update mode.
62: ,Related_Item_Id_Upd_Val NUMBER DEFAULT FND_API.G_MISS_NUM
63: ,Relationship_Type_Id_Upd_Val NUMBER DEFAULT FND_API.G_MISS_NUM
64:

Line 62: ,Related_Item_Id_Upd_Val NUMBER DEFAULT FND_API.G_MISS_NUM

58: ,Organization_Id NUMBER DEFAULT FND_API.G_MISS_NUM
59: ,Related_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM
60: ,Relationship_Type_Id NUMBER DEFAULT FND_API.G_MISS_NUM
61: -- to take new values of rel item and type in update mode.
62: ,Related_Item_Id_Upd_Val NUMBER DEFAULT FND_API.G_MISS_NUM
63: ,Relationship_Type_Id_Upd_Val NUMBER DEFAULT FND_API.G_MISS_NUM
64:
65: ,Reciprocal_Flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR
66: ,Start_Date DATE DEFAULT FND_API.G_MISS_DATE

Line 63: ,Relationship_Type_Id_Upd_Val NUMBER DEFAULT FND_API.G_MISS_NUM

59: ,Related_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM
60: ,Relationship_Type_Id NUMBER DEFAULT FND_API.G_MISS_NUM
61: -- to take new values of rel item and type in update mode.
62: ,Related_Item_Id_Upd_Val NUMBER DEFAULT FND_API.G_MISS_NUM
63: ,Relationship_Type_Id_Upd_Val NUMBER DEFAULT FND_API.G_MISS_NUM
64:
65: ,Reciprocal_Flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR
66: ,Start_Date DATE DEFAULT FND_API.G_MISS_DATE
67: ,End_Date DATE DEFAULT FND_API.G_MISS_DATE

Line 65: ,Reciprocal_Flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR

61: -- to take new values of rel item and type in update mode.
62: ,Related_Item_Id_Upd_Val NUMBER DEFAULT FND_API.G_MISS_NUM
63: ,Relationship_Type_Id_Upd_Val NUMBER DEFAULT FND_API.G_MISS_NUM
64:
65: ,Reciprocal_Flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR
66: ,Start_Date DATE DEFAULT FND_API.G_MISS_DATE
67: ,End_Date DATE DEFAULT FND_API.G_MISS_DATE
68: -- DFF
69: ,ATTR_CONTEXT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR

Line 66: ,Start_Date DATE DEFAULT FND_API.G_MISS_DATE

62: ,Related_Item_Id_Upd_Val NUMBER DEFAULT FND_API.G_MISS_NUM
63: ,Relationship_Type_Id_Upd_Val NUMBER DEFAULT FND_API.G_MISS_NUM
64:
65: ,Reciprocal_Flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR
66: ,Start_Date DATE DEFAULT FND_API.G_MISS_DATE
67: ,End_Date DATE DEFAULT FND_API.G_MISS_DATE
68: -- DFF
69: ,ATTR_CONTEXT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
70: ,ATTR_CHAR1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

Line 67: ,End_Date DATE DEFAULT FND_API.G_MISS_DATE

63: ,Relationship_Type_Id_Upd_Val NUMBER DEFAULT FND_API.G_MISS_NUM
64:
65: ,Reciprocal_Flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR
66: ,Start_Date DATE DEFAULT FND_API.G_MISS_DATE
67: ,End_Date DATE DEFAULT FND_API.G_MISS_DATE
68: -- DFF
69: ,ATTR_CONTEXT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
70: ,ATTR_CHAR1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
71: ,ATTR_CHAR2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

Line 69: ,ATTR_CONTEXT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR

65: ,Reciprocal_Flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR
66: ,Start_Date DATE DEFAULT FND_API.G_MISS_DATE
67: ,End_Date DATE DEFAULT FND_API.G_MISS_DATE
68: -- DFF
69: ,ATTR_CONTEXT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
70: ,ATTR_CHAR1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
71: ,ATTR_CHAR2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
72: ,ATTR_CHAR3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
73: ,ATTR_CHAR4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

Line 70: ,ATTR_CHAR1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

66: ,Start_Date DATE DEFAULT FND_API.G_MISS_DATE
67: ,End_Date DATE DEFAULT FND_API.G_MISS_DATE
68: -- DFF
69: ,ATTR_CONTEXT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
70: ,ATTR_CHAR1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
71: ,ATTR_CHAR2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
72: ,ATTR_CHAR3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
73: ,ATTR_CHAR4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
74: ,ATTR_CHAR5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

Line 71: ,ATTR_CHAR2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

67: ,End_Date DATE DEFAULT FND_API.G_MISS_DATE
68: -- DFF
69: ,ATTR_CONTEXT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
70: ,ATTR_CHAR1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
71: ,ATTR_CHAR2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
72: ,ATTR_CHAR3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
73: ,ATTR_CHAR4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
74: ,ATTR_CHAR5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
75: ,ATTR_CHAR6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

Line 72: ,ATTR_CHAR3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

68: -- DFF
69: ,ATTR_CONTEXT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
70: ,ATTR_CHAR1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
71: ,ATTR_CHAR2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
72: ,ATTR_CHAR3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
73: ,ATTR_CHAR4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
74: ,ATTR_CHAR5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
75: ,ATTR_CHAR6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
76: ,ATTR_CHAR7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

Line 73: ,ATTR_CHAR4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

69: ,ATTR_CONTEXT VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
70: ,ATTR_CHAR1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
71: ,ATTR_CHAR2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
72: ,ATTR_CHAR3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
73: ,ATTR_CHAR4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
74: ,ATTR_CHAR5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
75: ,ATTR_CHAR6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
76: ,ATTR_CHAR7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
77: ,ATTR_CHAR8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

Line 74: ,ATTR_CHAR5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

70: ,ATTR_CHAR1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
71: ,ATTR_CHAR2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
72: ,ATTR_CHAR3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
73: ,ATTR_CHAR4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
74: ,ATTR_CHAR5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
75: ,ATTR_CHAR6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
76: ,ATTR_CHAR7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
77: ,ATTR_CHAR8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
78: ,ATTR_CHAR9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

Line 75: ,ATTR_CHAR6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

71: ,ATTR_CHAR2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
72: ,ATTR_CHAR3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
73: ,ATTR_CHAR4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
74: ,ATTR_CHAR5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
75: ,ATTR_CHAR6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
76: ,ATTR_CHAR7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
77: ,ATTR_CHAR8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
78: ,ATTR_CHAR9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
79: ,ATTR_CHAR10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

Line 76: ,ATTR_CHAR7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

72: ,ATTR_CHAR3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
73: ,ATTR_CHAR4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
74: ,ATTR_CHAR5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
75: ,ATTR_CHAR6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
76: ,ATTR_CHAR7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
77: ,ATTR_CHAR8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
78: ,ATTR_CHAR9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
79: ,ATTR_CHAR10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
80: ,ATTR_NUM1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

Line 77: ,ATTR_CHAR8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

73: ,ATTR_CHAR4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
74: ,ATTR_CHAR5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
75: ,ATTR_CHAR6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
76: ,ATTR_CHAR7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
77: ,ATTR_CHAR8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
78: ,ATTR_CHAR9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
79: ,ATTR_CHAR10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
80: ,ATTR_NUM1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
81: ,ATTR_NUM2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

Line 78: ,ATTR_CHAR9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

74: ,ATTR_CHAR5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
75: ,ATTR_CHAR6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
76: ,ATTR_CHAR7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
77: ,ATTR_CHAR8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
78: ,ATTR_CHAR9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
79: ,ATTR_CHAR10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
80: ,ATTR_NUM1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
81: ,ATTR_NUM2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
82: ,ATTR_NUM3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

Line 79: ,ATTR_CHAR10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

75: ,ATTR_CHAR6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
76: ,ATTR_CHAR7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
77: ,ATTR_CHAR8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
78: ,ATTR_CHAR9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
79: ,ATTR_CHAR10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
80: ,ATTR_NUM1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
81: ,ATTR_NUM2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
82: ,ATTR_NUM3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
83: ,ATTR_NUM4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

Line 80: ,ATTR_NUM1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

76: ,ATTR_CHAR7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
77: ,ATTR_CHAR8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
78: ,ATTR_CHAR9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
79: ,ATTR_CHAR10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
80: ,ATTR_NUM1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
81: ,ATTR_NUM2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
82: ,ATTR_NUM3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
83: ,ATTR_NUM4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
84: ,ATTR_NUM5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

Line 81: ,ATTR_NUM2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

77: ,ATTR_CHAR8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
78: ,ATTR_CHAR9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
79: ,ATTR_CHAR10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
80: ,ATTR_NUM1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
81: ,ATTR_NUM2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
82: ,ATTR_NUM3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
83: ,ATTR_NUM4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
84: ,ATTR_NUM5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
85: ,ATTR_NUM6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

Line 82: ,ATTR_NUM3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

78: ,ATTR_CHAR9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
79: ,ATTR_CHAR10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
80: ,ATTR_NUM1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
81: ,ATTR_NUM2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
82: ,ATTR_NUM3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
83: ,ATTR_NUM4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
84: ,ATTR_NUM5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
85: ,ATTR_NUM6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
86: ,ATTR_NUM7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

Line 83: ,ATTR_NUM4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

79: ,ATTR_CHAR10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
80: ,ATTR_NUM1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
81: ,ATTR_NUM2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
82: ,ATTR_NUM3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
83: ,ATTR_NUM4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
84: ,ATTR_NUM5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
85: ,ATTR_NUM6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
86: ,ATTR_NUM7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
87: ,ATTR_NUM8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

Line 84: ,ATTR_NUM5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

80: ,ATTR_NUM1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
81: ,ATTR_NUM2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
82: ,ATTR_NUM3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
83: ,ATTR_NUM4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
84: ,ATTR_NUM5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
85: ,ATTR_NUM6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
86: ,ATTR_NUM7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
87: ,ATTR_NUM8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
88: ,ATTR_NUM9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

Line 85: ,ATTR_NUM6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

81: ,ATTR_NUM2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
82: ,ATTR_NUM3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
83: ,ATTR_NUM4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
84: ,ATTR_NUM5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
85: ,ATTR_NUM6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
86: ,ATTR_NUM7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
87: ,ATTR_NUM8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
88: ,ATTR_NUM9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
89: ,ATTR_NUM10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

Line 86: ,ATTR_NUM7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

82: ,ATTR_NUM3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
83: ,ATTR_NUM4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
84: ,ATTR_NUM5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
85: ,ATTR_NUM6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
86: ,ATTR_NUM7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
87: ,ATTR_NUM8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
88: ,ATTR_NUM9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
89: ,ATTR_NUM10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
90: ,ATTR_DATE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

Line 87: ,ATTR_NUM8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

83: ,ATTR_NUM4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
84: ,ATTR_NUM5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
85: ,ATTR_NUM6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
86: ,ATTR_NUM7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
87: ,ATTR_NUM8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
88: ,ATTR_NUM9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
89: ,ATTR_NUM10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
90: ,ATTR_DATE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
91: ,ATTR_DATE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

Line 88: ,ATTR_NUM9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

84: ,ATTR_NUM5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
85: ,ATTR_NUM6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
86: ,ATTR_NUM7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
87: ,ATTR_NUM8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
88: ,ATTR_NUM9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
89: ,ATTR_NUM10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
90: ,ATTR_DATE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
91: ,ATTR_DATE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
92: ,ATTR_DATE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

Line 89: ,ATTR_NUM10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

85: ,ATTR_NUM6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
86: ,ATTR_NUM7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
87: ,ATTR_NUM8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
88: ,ATTR_NUM9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
89: ,ATTR_NUM10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
90: ,ATTR_DATE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
91: ,ATTR_DATE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
92: ,ATTR_DATE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
93: ,ATTR_DATE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

Line 90: ,ATTR_DATE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

86: ,ATTR_NUM7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
87: ,ATTR_NUM8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
88: ,ATTR_NUM9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
89: ,ATTR_NUM10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
90: ,ATTR_DATE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
91: ,ATTR_DATE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
92: ,ATTR_DATE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
93: ,ATTR_DATE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
94: ,ATTR_DATE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

Line 91: ,ATTR_DATE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

87: ,ATTR_NUM8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
88: ,ATTR_NUM9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
89: ,ATTR_NUM10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
90: ,ATTR_DATE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
91: ,ATTR_DATE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
92: ,ATTR_DATE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
93: ,ATTR_DATE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
94: ,ATTR_DATE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
95: ,ATTR_DATE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

Line 92: ,ATTR_DATE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

88: ,ATTR_NUM9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
89: ,ATTR_NUM10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
90: ,ATTR_DATE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
91: ,ATTR_DATE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
92: ,ATTR_DATE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
93: ,ATTR_DATE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
94: ,ATTR_DATE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
95: ,ATTR_DATE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
96: ,ATTR_DATE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

Line 93: ,ATTR_DATE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

89: ,ATTR_NUM10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
90: ,ATTR_DATE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
91: ,ATTR_DATE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
92: ,ATTR_DATE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
93: ,ATTR_DATE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
94: ,ATTR_DATE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
95: ,ATTR_DATE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
96: ,ATTR_DATE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
97: ,ATTR_DATE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

Line 94: ,ATTR_DATE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

90: ,ATTR_DATE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
91: ,ATTR_DATE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
92: ,ATTR_DATE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
93: ,ATTR_DATE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
94: ,ATTR_DATE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
95: ,ATTR_DATE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
96: ,ATTR_DATE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
97: ,ATTR_DATE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
98: ,ATTR_DATE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

Line 95: ,ATTR_DATE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

91: ,ATTR_DATE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
92: ,ATTR_DATE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
93: ,ATTR_DATE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
94: ,ATTR_DATE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
95: ,ATTR_DATE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
96: ,ATTR_DATE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
97: ,ATTR_DATE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
98: ,ATTR_DATE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
99: ,ATTR_DATE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

Line 96: ,ATTR_DATE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

92: ,ATTR_DATE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
93: ,ATTR_DATE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
94: ,ATTR_DATE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
95: ,ATTR_DATE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
96: ,ATTR_DATE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
97: ,ATTR_DATE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
98: ,ATTR_DATE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
99: ,ATTR_DATE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
100: ,PLANNING_ENABLED_FLAG VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR);

Line 97: ,ATTR_DATE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

93: ,ATTR_DATE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
94: ,ATTR_DATE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
95: ,ATTR_DATE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
96: ,ATTR_DATE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
97: ,ATTR_DATE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
98: ,ATTR_DATE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
99: ,ATTR_DATE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
100: ,PLANNING_ENABLED_FLAG VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR);
101: -- ,LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE

Line 98: ,ATTR_DATE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

94: ,ATTR_DATE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
95: ,ATTR_DATE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
96: ,ATTR_DATE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
97: ,ATTR_DATE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
98: ,ATTR_DATE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
99: ,ATTR_DATE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
100: ,PLANNING_ENABLED_FLAG VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR);
101: -- ,LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE
102: -- ,LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM

Line 99: ,ATTR_DATE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

95: ,ATTR_DATE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
96: ,ATTR_DATE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
97: ,ATTR_DATE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
98: ,ATTR_DATE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
99: ,ATTR_DATE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
100: ,PLANNING_ENABLED_FLAG VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR);
101: -- ,LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE
102: -- ,LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM
103: -- ,CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE

Line 100: ,PLANNING_ENABLED_FLAG VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR);

96: ,ATTR_DATE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
97: ,ATTR_DATE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
98: ,ATTR_DATE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
99: ,ATTR_DATE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
100: ,PLANNING_ENABLED_FLAG VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR);
101: -- ,LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE
102: -- ,LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM
103: -- ,CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE
104: -- ,CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM

Line 101: -- ,LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE

97: ,ATTR_DATE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
98: ,ATTR_DATE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
99: ,ATTR_DATE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
100: ,PLANNING_ENABLED_FLAG VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR);
101: -- ,LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE
102: -- ,LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM
103: -- ,CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE
104: -- ,CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM
105: -- ,LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM);

Line 102: -- ,LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM

98: ,ATTR_DATE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
99: ,ATTR_DATE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
100: ,PLANNING_ENABLED_FLAG VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR);
101: -- ,LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE
102: -- ,LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM
103: -- ,CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE
104: -- ,CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM
105: -- ,LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM);
106:

Line 103: -- ,CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE

99: ,ATTR_DATE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
100: ,PLANNING_ENABLED_FLAG VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR);
101: -- ,LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE
102: -- ,LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM
103: -- ,CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE
104: -- ,CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM
105: -- ,LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM);
106:
107: TYPE Rel_Item_Tbl_Type IS TABLE OF Rel_Item_Rec_Type INDEX BY BINARY_INTEGER;

Line 104: -- ,CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM

100: ,PLANNING_ENABLED_FLAG VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR);
101: -- ,LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE
102: -- ,LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM
103: -- ,CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE
104: -- ,CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM
105: -- ,LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM);
106:
107: TYPE Rel_Item_Tbl_Type IS TABLE OF Rel_Item_Rec_Type INDEX BY BINARY_INTEGER;
108:

Line 105: -- ,LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM);

101: -- ,LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE
102: -- ,LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM
103: -- ,CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE
104: -- ,CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM
105: -- ,LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM);
106:
107: TYPE Rel_Item_Tbl_Type IS TABLE OF Rel_Item_Rec_Type INDEX BY BINARY_INTEGER;
108:
109: TYPE Pln_Info_Rec_Type IS RECORD

Line 111: Transaction_Type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR

107: TYPE Rel_Item_Tbl_Type IS TABLE OF Rel_Item_Rec_Type INDEX BY BINARY_INTEGER;
108:
109: TYPE Pln_Info_Rec_Type IS RECORD
110: (
111: Transaction_Type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
112: ,Inventory_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM
113: ,Organization_Id NUMBER DEFAULT FND_API.G_MISS_NUM
114: ,Related_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM
115: ,Relationship_Type_Id NUMBER DEFAULT FND_API.G_MISS_NUM

Line 112: ,Inventory_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM

108:
109: TYPE Pln_Info_Rec_Type IS RECORD
110: (
111: Transaction_Type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
112: ,Inventory_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM
113: ,Organization_Id NUMBER DEFAULT FND_API.G_MISS_NUM
114: ,Related_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM
115: ,Relationship_Type_Id NUMBER DEFAULT FND_API.G_MISS_NUM
116: ,Pln_Info_Id NUMBER DEFAULT FND_API.G_MISS_NUM

Line 113: ,Organization_Id NUMBER DEFAULT FND_API.G_MISS_NUM

109: TYPE Pln_Info_Rec_Type IS RECORD
110: (
111: Transaction_Type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
112: ,Inventory_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM
113: ,Organization_Id NUMBER DEFAULT FND_API.G_MISS_NUM
114: ,Related_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM
115: ,Relationship_Type_Id NUMBER DEFAULT FND_API.G_MISS_NUM
116: ,Pln_Info_Id NUMBER DEFAULT FND_API.G_MISS_NUM
117: ,Substitution_Set VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR

Line 114: ,Related_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM

110: (
111: Transaction_Type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
112: ,Inventory_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM
113: ,Organization_Id NUMBER DEFAULT FND_API.G_MISS_NUM
114: ,Related_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM
115: ,Relationship_Type_Id NUMBER DEFAULT FND_API.G_MISS_NUM
116: ,Pln_Info_Id NUMBER DEFAULT FND_API.G_MISS_NUM
117: ,Substitution_Set VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
118: ,Partial_Fulfillment_Flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR

Line 115: ,Relationship_Type_Id NUMBER DEFAULT FND_API.G_MISS_NUM

111: Transaction_Type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
112: ,Inventory_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM
113: ,Organization_Id NUMBER DEFAULT FND_API.G_MISS_NUM
114: ,Related_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM
115: ,Relationship_Type_Id NUMBER DEFAULT FND_API.G_MISS_NUM
116: ,Pln_Info_Id NUMBER DEFAULT FND_API.G_MISS_NUM
117: ,Substitution_Set VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
118: ,Partial_Fulfillment_Flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR
119: ,Start_Date DATE DEFAULT FND_API.G_MISS_DATE

Line 116: ,Pln_Info_Id NUMBER DEFAULT FND_API.G_MISS_NUM

112: ,Inventory_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM
113: ,Organization_Id NUMBER DEFAULT FND_API.G_MISS_NUM
114: ,Related_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM
115: ,Relationship_Type_Id NUMBER DEFAULT FND_API.G_MISS_NUM
116: ,Pln_Info_Id NUMBER DEFAULT FND_API.G_MISS_NUM
117: ,Substitution_Set VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
118: ,Partial_Fulfillment_Flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR
119: ,Start_Date DATE DEFAULT FND_API.G_MISS_DATE
120: ,End_Date DATE DEFAULT FND_API.G_MISS_DATE

Line 117: ,Substitution_Set VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR

113: ,Organization_Id NUMBER DEFAULT FND_API.G_MISS_NUM
114: ,Related_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM
115: ,Relationship_Type_Id NUMBER DEFAULT FND_API.G_MISS_NUM
116: ,Pln_Info_Id NUMBER DEFAULT FND_API.G_MISS_NUM
117: ,Substitution_Set VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
118: ,Partial_Fulfillment_Flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR
119: ,Start_Date DATE DEFAULT FND_API.G_MISS_DATE
120: ,End_Date DATE DEFAULT FND_API.G_MISS_DATE
121: ,All_Customers_Flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR);

Line 118: ,Partial_Fulfillment_Flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR

114: ,Related_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM
115: ,Relationship_Type_Id NUMBER DEFAULT FND_API.G_MISS_NUM
116: ,Pln_Info_Id NUMBER DEFAULT FND_API.G_MISS_NUM
117: ,Substitution_Set VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
118: ,Partial_Fulfillment_Flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR
119: ,Start_Date DATE DEFAULT FND_API.G_MISS_DATE
120: ,End_Date DATE DEFAULT FND_API.G_MISS_DATE
121: ,All_Customers_Flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR);
122:

Line 119: ,Start_Date DATE DEFAULT FND_API.G_MISS_DATE

115: ,Relationship_Type_Id NUMBER DEFAULT FND_API.G_MISS_NUM
116: ,Pln_Info_Id NUMBER DEFAULT FND_API.G_MISS_NUM
117: ,Substitution_Set VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
118: ,Partial_Fulfillment_Flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR
119: ,Start_Date DATE DEFAULT FND_API.G_MISS_DATE
120: ,End_Date DATE DEFAULT FND_API.G_MISS_DATE
121: ,All_Customers_Flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR);
122:
123: TYPE Pln_Info_Tbl_Type IS TABLE OF Pln_Info_Rec_Type INDEX BY BINARY_INTEGER;

Line 120: ,End_Date DATE DEFAULT FND_API.G_MISS_DATE

116: ,Pln_Info_Id NUMBER DEFAULT FND_API.G_MISS_NUM
117: ,Substitution_Set VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
118: ,Partial_Fulfillment_Flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR
119: ,Start_Date DATE DEFAULT FND_API.G_MISS_DATE
120: ,End_Date DATE DEFAULT FND_API.G_MISS_DATE
121: ,All_Customers_Flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR);
122:
123: TYPE Pln_Info_Tbl_Type IS TABLE OF Pln_Info_Rec_Type INDEX BY BINARY_INTEGER;
124:

Line 121: ,All_Customers_Flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR);

117: ,Substitution_Set VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
118: ,Partial_Fulfillment_Flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR
119: ,Start_Date DATE DEFAULT FND_API.G_MISS_DATE
120: ,End_Date DATE DEFAULT FND_API.G_MISS_DATE
121: ,All_Customers_Flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR);
122:
123: TYPE Pln_Info_Tbl_Type IS TABLE OF Pln_Info_Rec_Type INDEX BY BINARY_INTEGER;
124:
125: TYPE Cust_Ref_Rec_Type IS RECORD

Line 127: Transaction_Type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR

123: TYPE Pln_Info_Tbl_Type IS TABLE OF Pln_Info_Rec_Type INDEX BY BINARY_INTEGER;
124:
125: TYPE Cust_Ref_Rec_Type IS RECORD
126: (
127: Transaction_Type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
128: ,Inventory_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM
129: ,Organization_Id NUMBER DEFAULT FND_API.G_MISS_NUM
130: ,Related_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM
131: ,Relationship_Type_Id NUMBER DEFAULT FND_API.G_MISS_NUM

Line 128: ,Inventory_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM

124:
125: TYPE Cust_Ref_Rec_Type IS RECORD
126: (
127: Transaction_Type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
128: ,Inventory_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM
129: ,Organization_Id NUMBER DEFAULT FND_API.G_MISS_NUM
130: ,Related_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM
131: ,Relationship_Type_Id NUMBER DEFAULT FND_API.G_MISS_NUM
132: ,Pln_Info_Id NUMBER DEFAULT FND_API.G_MISS_NUM

Line 129: ,Organization_Id NUMBER DEFAULT FND_API.G_MISS_NUM

125: TYPE Cust_Ref_Rec_Type IS RECORD
126: (
127: Transaction_Type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
128: ,Inventory_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM
129: ,Organization_Id NUMBER DEFAULT FND_API.G_MISS_NUM
130: ,Related_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM
131: ,Relationship_Type_Id NUMBER DEFAULT FND_API.G_MISS_NUM
132: ,Pln_Info_Id NUMBER DEFAULT FND_API.G_MISS_NUM
133: ,Customer_Id NUMBER DEFAULT FND_API.G_MISS_NUM

Line 130: ,Related_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM

126: (
127: Transaction_Type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
128: ,Inventory_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM
129: ,Organization_Id NUMBER DEFAULT FND_API.G_MISS_NUM
130: ,Related_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM
131: ,Relationship_Type_Id NUMBER DEFAULT FND_API.G_MISS_NUM
132: ,Pln_Info_Id NUMBER DEFAULT FND_API.G_MISS_NUM
133: ,Customer_Id NUMBER DEFAULT FND_API.G_MISS_NUM
134: ,Site_Use_Id NUMBER DEFAULT FND_API.G_MISS_NUM

Line 131: ,Relationship_Type_Id NUMBER DEFAULT FND_API.G_MISS_NUM

127: Transaction_Type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
128: ,Inventory_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM
129: ,Organization_Id NUMBER DEFAULT FND_API.G_MISS_NUM
130: ,Related_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM
131: ,Relationship_Type_Id NUMBER DEFAULT FND_API.G_MISS_NUM
132: ,Pln_Info_Id NUMBER DEFAULT FND_API.G_MISS_NUM
133: ,Customer_Id NUMBER DEFAULT FND_API.G_MISS_NUM
134: ,Site_Use_Id NUMBER DEFAULT FND_API.G_MISS_NUM
135: ,Start_Date DATE DEFAULT FND_API.G_MISS_DATE

Line 132: ,Pln_Info_Id NUMBER DEFAULT FND_API.G_MISS_NUM

128: ,Inventory_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM
129: ,Organization_Id NUMBER DEFAULT FND_API.G_MISS_NUM
130: ,Related_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM
131: ,Relationship_Type_Id NUMBER DEFAULT FND_API.G_MISS_NUM
132: ,Pln_Info_Id NUMBER DEFAULT FND_API.G_MISS_NUM
133: ,Customer_Id NUMBER DEFAULT FND_API.G_MISS_NUM
134: ,Site_Use_Id NUMBER DEFAULT FND_API.G_MISS_NUM
135: ,Start_Date DATE DEFAULT FND_API.G_MISS_DATE
136: ,End_Date DATE DEFAULT FND_API.G_MISS_DATE);

Line 133: ,Customer_Id NUMBER DEFAULT FND_API.G_MISS_NUM

129: ,Organization_Id NUMBER DEFAULT FND_API.G_MISS_NUM
130: ,Related_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM
131: ,Relationship_Type_Id NUMBER DEFAULT FND_API.G_MISS_NUM
132: ,Pln_Info_Id NUMBER DEFAULT FND_API.G_MISS_NUM
133: ,Customer_Id NUMBER DEFAULT FND_API.G_MISS_NUM
134: ,Site_Use_Id NUMBER DEFAULT FND_API.G_MISS_NUM
135: ,Start_Date DATE DEFAULT FND_API.G_MISS_DATE
136: ,End_Date DATE DEFAULT FND_API.G_MISS_DATE);
137:

Line 134: ,Site_Use_Id NUMBER DEFAULT FND_API.G_MISS_NUM

130: ,Related_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM
131: ,Relationship_Type_Id NUMBER DEFAULT FND_API.G_MISS_NUM
132: ,Pln_Info_Id NUMBER DEFAULT FND_API.G_MISS_NUM
133: ,Customer_Id NUMBER DEFAULT FND_API.G_MISS_NUM
134: ,Site_Use_Id NUMBER DEFAULT FND_API.G_MISS_NUM
135: ,Start_Date DATE DEFAULT FND_API.G_MISS_DATE
136: ,End_Date DATE DEFAULT FND_API.G_MISS_DATE);
137:
138: TYPE Cust_Ref_Tbl_Type IS TABLE OF Cust_Ref_Rec_Type INDEX BY BINARY_INTEGER;

Line 135: ,Start_Date DATE DEFAULT FND_API.G_MISS_DATE

131: ,Relationship_Type_Id NUMBER DEFAULT FND_API.G_MISS_NUM
132: ,Pln_Info_Id NUMBER DEFAULT FND_API.G_MISS_NUM
133: ,Customer_Id NUMBER DEFAULT FND_API.G_MISS_NUM
134: ,Site_Use_Id NUMBER DEFAULT FND_API.G_MISS_NUM
135: ,Start_Date DATE DEFAULT FND_API.G_MISS_DATE
136: ,End_Date DATE DEFAULT FND_API.G_MISS_DATE);
137:
138: TYPE Cust_Ref_Tbl_Type IS TABLE OF Cust_Ref_Rec_Type INDEX BY BINARY_INTEGER;
139: /*#

Line 136: ,End_Date DATE DEFAULT FND_API.G_MISS_DATE);

132: ,Pln_Info_Id NUMBER DEFAULT FND_API.G_MISS_NUM
133: ,Customer_Id NUMBER DEFAULT FND_API.G_MISS_NUM
134: ,Site_Use_Id NUMBER DEFAULT FND_API.G_MISS_NUM
135: ,Start_Date DATE DEFAULT FND_API.G_MISS_DATE
136: ,End_Date DATE DEFAULT FND_API.G_MISS_DATE);
137:
138: TYPE Cust_Ref_Tbl_Type IS TABLE OF Cust_Ref_Rec_Type INDEX BY BINARY_INTEGER;
139: /*#
140: * Use this API to insert,update and delete realated items associated with

Line 199: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

195: * @rep:lifecycle active
196: * @rep:displayname Process Related Items
197: */
198: PROCEDURE Process_Rel_Item(
199: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
200: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
201: ,p_Rel_Item_Rec IN OUT NOCOPY MTL_RELATED_ITEMS_PUB.Rel_Item_Rec_Type
202: ,p_Pln_Info_Tbl IN OUT NOCOPY MTL_RELATED_ITEMS_PUB.Pln_Info_Tbl_Type
203: ,p_Cust_Ref_Tbl IN OUT NOCOPY MTL_RELATED_ITEMS_PUB.Cust_Ref_Tbl_Type

Line 200: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

196: * @rep:displayname Process Related Items
197: */
198: PROCEDURE Process_Rel_Item(
199: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
200: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
201: ,p_Rel_Item_Rec IN OUT NOCOPY MTL_RELATED_ITEMS_PUB.Rel_Item_Rec_Type
202: ,p_Pln_Info_Tbl IN OUT NOCOPY MTL_RELATED_ITEMS_PUB.Pln_Info_Tbl_Type
203: ,p_Cust_Ref_Tbl IN OUT NOCOPY MTL_RELATED_ITEMS_PUB.Cust_Ref_Tbl_Type
204: ,x_return_status OUT NOCOPY VARCHAR2