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_CROSS_REFERENCES_PUB dependencies on FND_API

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

17: *
18: *

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

22: *
23: *

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

25: *

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

20: * removes any messages that may exist on the stack from prior processing in the
21: * same session). Valid values are FND_API.G_TRUE and FND_API.G_FALSE.
22: *
23: *

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

25: *
26: *

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

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

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

25: *
26: *

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

30: *
31: *

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

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

25: *
26: *

30: *
31: *

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

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

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

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

Line 42: * FND_API.G_MISS_DATE)

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

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

55: G_BO_Identifier CONSTANT VARCHAR2(30) := 'XRef';
56:
57: TYPE XRef_Rec_Type IS RECORD
58: (
59: Transaction_Type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
60: ,X_Return_Status VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR
61: -- Primary Key Columns
62: ,Inventory_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM
63: ,Organization_Id NUMBER DEFAULT FND_API.G_MISS_NUM

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

56:
57: TYPE XRef_Rec_Type IS RECORD
58: (
59: Transaction_Type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
60: ,X_Return_Status VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR
61: -- Primary Key Columns
62: ,Inventory_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM
63: ,Organization_Id NUMBER DEFAULT FND_API.G_MISS_NUM
64: ,Cross_Reference_Type VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR

Line 62: ,Inventory_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM

58: (
59: Transaction_Type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
60: ,X_Return_Status VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR
61: -- Primary Key Columns
62: ,Inventory_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM
63: ,Organization_Id NUMBER DEFAULT FND_API.G_MISS_NUM
64: ,Cross_Reference_Type VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR
65: ,Cross_Reference VARCHAR2(255) DEFAULT FND_API.G_MISS_CHAR
66: -- As cross_reference_id is present,for uniquely identifying

Line 63: ,Organization_Id NUMBER DEFAULT FND_API.G_MISS_NUM

59: Transaction_Type VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR
60: ,X_Return_Status VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR
61: -- Primary Key Columns
62: ,Inventory_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM
63: ,Organization_Id NUMBER DEFAULT FND_API.G_MISS_NUM
64: ,Cross_Reference_Type VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR
65: ,Cross_Reference VARCHAR2(255) DEFAULT FND_API.G_MISS_CHAR
66: -- As cross_reference_id is present,for uniquely identifying
67: -- the row we have to use this.(Must be populated for Update and Delete)

Line 64: ,Cross_Reference_Type VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR

60: ,X_Return_Status VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR
61: -- Primary Key Columns
62: ,Inventory_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM
63: ,Organization_Id NUMBER DEFAULT FND_API.G_MISS_NUM
64: ,Cross_Reference_Type VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR
65: ,Cross_Reference VARCHAR2(255) DEFAULT FND_API.G_MISS_CHAR
66: -- As cross_reference_id is present,for uniquely identifying
67: -- the row we have to use this.(Must be populated for Update and Delete)
68: ,Cross_Reference_Id NUMBER DEFAULT FND_API.G_MISS_NUM

Line 65: ,Cross_Reference VARCHAR2(255) DEFAULT FND_API.G_MISS_CHAR

61: -- Primary Key Columns
62: ,Inventory_Item_Id NUMBER DEFAULT FND_API.G_MISS_NUM
63: ,Organization_Id NUMBER DEFAULT FND_API.G_MISS_NUM
64: ,Cross_Reference_Type VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR
65: ,Cross_Reference VARCHAR2(255) DEFAULT FND_API.G_MISS_CHAR
66: -- As cross_reference_id is present,for uniquely identifying
67: -- the row we have to use this.(Must be populated for Update and Delete)
68: ,Cross_Reference_Id NUMBER DEFAULT FND_API.G_MISS_NUM
69: ,Description VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR

Line 68: ,Cross_Reference_Id NUMBER DEFAULT FND_API.G_MISS_NUM

64: ,Cross_Reference_Type VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR
65: ,Cross_Reference VARCHAR2(255) DEFAULT FND_API.G_MISS_CHAR
66: -- As cross_reference_id is present,for uniquely identifying
67: -- the row we have to use this.(Must be populated for Update and Delete)
68: ,Cross_Reference_Id NUMBER DEFAULT FND_API.G_MISS_NUM
69: ,Description VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR
70: ,Org_Independent_Flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR
71: --Who Columns
72: ,Last_Update_Date DATE DEFAULT FND_API.G_MISS_DATE

Line 69: ,Description VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR

65: ,Cross_Reference VARCHAR2(255) DEFAULT FND_API.G_MISS_CHAR
66: -- As cross_reference_id is present,for uniquely identifying
67: -- the row we have to use this.(Must be populated for Update and Delete)
68: ,Cross_Reference_Id NUMBER DEFAULT FND_API.G_MISS_NUM
69: ,Description VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR
70: ,Org_Independent_Flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR
71: --Who Columns
72: ,Last_Update_Date DATE DEFAULT FND_API.G_MISS_DATE
73: ,Last_Updated_By NUMBER DEFAULT FND_API.G_MISS_NUM

Line 70: ,Org_Independent_Flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR

66: -- As cross_reference_id is present,for uniquely identifying
67: -- the row we have to use this.(Must be populated for Update and Delete)
68: ,Cross_Reference_Id NUMBER DEFAULT FND_API.G_MISS_NUM
69: ,Description VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR
70: ,Org_Independent_Flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR
71: --Who Columns
72: ,Last_Update_Date DATE DEFAULT FND_API.G_MISS_DATE
73: ,Last_Updated_By NUMBER DEFAULT FND_API.G_MISS_NUM
74: ,Creation_Date DATE DEFAULT FND_API.G_MISS_DATE

Line 72: ,Last_Update_Date DATE DEFAULT FND_API.G_MISS_DATE

68: ,Cross_Reference_Id NUMBER DEFAULT FND_API.G_MISS_NUM
69: ,Description VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR
70: ,Org_Independent_Flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR
71: --Who Columns
72: ,Last_Update_Date DATE DEFAULT FND_API.G_MISS_DATE
73: ,Last_Updated_By NUMBER DEFAULT FND_API.G_MISS_NUM
74: ,Creation_Date DATE DEFAULT FND_API.G_MISS_DATE
75: ,Created_By NUMBER DEFAULT FND_API.G_MISS_NUM
76: ,Last_Update_Login NUMBER DEFAULT FND_API.G_MISS_NUM

Line 73: ,Last_Updated_By NUMBER DEFAULT FND_API.G_MISS_NUM

69: ,Description VARCHAR2(240) DEFAULT FND_API.G_MISS_CHAR
70: ,Org_Independent_Flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR
71: --Who Columns
72: ,Last_Update_Date DATE DEFAULT FND_API.G_MISS_DATE
73: ,Last_Updated_By NUMBER DEFAULT FND_API.G_MISS_NUM
74: ,Creation_Date DATE DEFAULT FND_API.G_MISS_DATE
75: ,Created_By NUMBER DEFAULT FND_API.G_MISS_NUM
76: ,Last_Update_Login NUMBER DEFAULT FND_API.G_MISS_NUM
77: ,Request_id NUMBER DEFAULT FND_API.G_MISS_NUM

Line 74: ,Creation_Date DATE DEFAULT FND_API.G_MISS_DATE

70: ,Org_Independent_Flag VARCHAR2(1) DEFAULT FND_API.G_MISS_CHAR
71: --Who Columns
72: ,Last_Update_Date DATE DEFAULT FND_API.G_MISS_DATE
73: ,Last_Updated_By NUMBER DEFAULT FND_API.G_MISS_NUM
74: ,Creation_Date DATE DEFAULT FND_API.G_MISS_DATE
75: ,Created_By NUMBER DEFAULT FND_API.G_MISS_NUM
76: ,Last_Update_Login NUMBER DEFAULT FND_API.G_MISS_NUM
77: ,Request_id NUMBER DEFAULT FND_API.G_MISS_NUM
78: ,Program_Application_Id NUMBER DEFAULT FND_API.G_MISS_NUM

Line 75: ,Created_By NUMBER DEFAULT FND_API.G_MISS_NUM

71: --Who Columns
72: ,Last_Update_Date DATE DEFAULT FND_API.G_MISS_DATE
73: ,Last_Updated_By NUMBER DEFAULT FND_API.G_MISS_NUM
74: ,Creation_Date DATE DEFAULT FND_API.G_MISS_DATE
75: ,Created_By NUMBER DEFAULT FND_API.G_MISS_NUM
76: ,Last_Update_Login NUMBER DEFAULT FND_API.G_MISS_NUM
77: ,Request_id NUMBER DEFAULT FND_API.G_MISS_NUM
78: ,Program_Application_Id NUMBER DEFAULT FND_API.G_MISS_NUM
79: ,Program_Id NUMBER DEFAULT FND_API.G_MISS_NUM

Line 76: ,Last_Update_Login NUMBER DEFAULT FND_API.G_MISS_NUM

72: ,Last_Update_Date DATE DEFAULT FND_API.G_MISS_DATE
73: ,Last_Updated_By NUMBER DEFAULT FND_API.G_MISS_NUM
74: ,Creation_Date DATE DEFAULT FND_API.G_MISS_DATE
75: ,Created_By NUMBER DEFAULT FND_API.G_MISS_NUM
76: ,Last_Update_Login NUMBER DEFAULT FND_API.G_MISS_NUM
77: ,Request_id NUMBER DEFAULT FND_API.G_MISS_NUM
78: ,Program_Application_Id NUMBER DEFAULT FND_API.G_MISS_NUM
79: ,Program_Id NUMBER DEFAULT FND_API.G_MISS_NUM
80: ,Program_Update_Date DATE DEFAULT FND_API.G_MISS_DATE

Line 77: ,Request_id NUMBER DEFAULT FND_API.G_MISS_NUM

73: ,Last_Updated_By NUMBER DEFAULT FND_API.G_MISS_NUM
74: ,Creation_Date DATE DEFAULT FND_API.G_MISS_DATE
75: ,Created_By NUMBER DEFAULT FND_API.G_MISS_NUM
76: ,Last_Update_Login NUMBER DEFAULT FND_API.G_MISS_NUM
77: ,Request_id NUMBER DEFAULT FND_API.G_MISS_NUM
78: ,Program_Application_Id NUMBER DEFAULT FND_API.G_MISS_NUM
79: ,Program_Id NUMBER DEFAULT FND_API.G_MISS_NUM
80: ,Program_Update_Date DATE DEFAULT FND_API.G_MISS_DATE
81: -- DFF

Line 78: ,Program_Application_Id NUMBER DEFAULT FND_API.G_MISS_NUM

74: ,Creation_Date DATE DEFAULT FND_API.G_MISS_DATE
75: ,Created_By NUMBER DEFAULT FND_API.G_MISS_NUM
76: ,Last_Update_Login NUMBER DEFAULT FND_API.G_MISS_NUM
77: ,Request_id NUMBER DEFAULT FND_API.G_MISS_NUM
78: ,Program_Application_Id NUMBER DEFAULT FND_API.G_MISS_NUM
79: ,Program_Id NUMBER DEFAULT FND_API.G_MISS_NUM
80: ,Program_Update_Date DATE DEFAULT FND_API.G_MISS_DATE
81: -- DFF
82: ,Attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

Line 79: ,Program_Id NUMBER DEFAULT FND_API.G_MISS_NUM

75: ,Created_By NUMBER DEFAULT FND_API.G_MISS_NUM
76: ,Last_Update_Login NUMBER DEFAULT FND_API.G_MISS_NUM
77: ,Request_id NUMBER DEFAULT FND_API.G_MISS_NUM
78: ,Program_Application_Id NUMBER DEFAULT FND_API.G_MISS_NUM
79: ,Program_Id NUMBER DEFAULT FND_API.G_MISS_NUM
80: ,Program_Update_Date DATE DEFAULT FND_API.G_MISS_DATE
81: -- DFF
82: ,Attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
83: ,Attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

Line 80: ,Program_Update_Date DATE DEFAULT FND_API.G_MISS_DATE

76: ,Last_Update_Login NUMBER DEFAULT FND_API.G_MISS_NUM
77: ,Request_id NUMBER DEFAULT FND_API.G_MISS_NUM
78: ,Program_Application_Id NUMBER DEFAULT FND_API.G_MISS_NUM
79: ,Program_Id NUMBER DEFAULT FND_API.G_MISS_NUM
80: ,Program_Update_Date DATE DEFAULT FND_API.G_MISS_DATE
81: -- DFF
82: ,Attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
83: ,Attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
84: ,Attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

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

78: ,Program_Application_Id NUMBER DEFAULT FND_API.G_MISS_NUM
79: ,Program_Id NUMBER DEFAULT FND_API.G_MISS_NUM
80: ,Program_Update_Date DATE DEFAULT FND_API.G_MISS_DATE
81: -- DFF
82: ,Attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
83: ,Attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
84: ,Attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
85: ,Attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
86: ,Attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

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

79: ,Program_Id NUMBER DEFAULT FND_API.G_MISS_NUM
80: ,Program_Update_Date DATE DEFAULT FND_API.G_MISS_DATE
81: -- DFF
82: ,Attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
83: ,Attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
84: ,Attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
85: ,Attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
86: ,Attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
87: ,Attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

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

80: ,Program_Update_Date DATE DEFAULT FND_API.G_MISS_DATE
81: -- DFF
82: ,Attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
83: ,Attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
84: ,Attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
85: ,Attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
86: ,Attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
87: ,Attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
88: ,Attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

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

81: -- DFF
82: ,Attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
83: ,Attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
84: ,Attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
85: ,Attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
86: ,Attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
87: ,Attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
88: ,Attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
89: ,Attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

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

82: ,Attribute1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
83: ,Attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
84: ,Attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
85: ,Attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
86: ,Attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
87: ,Attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
88: ,Attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
89: ,Attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
90: ,Attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

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

83: ,Attribute2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
84: ,Attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
85: ,Attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
86: ,Attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
87: ,Attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
88: ,Attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
89: ,Attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
90: ,Attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
91: ,Attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

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

84: ,Attribute3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
85: ,Attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
86: ,Attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
87: ,Attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
88: ,Attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
89: ,Attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
90: ,Attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
91: ,Attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
92: ,Attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

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

85: ,Attribute4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
86: ,Attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
87: ,Attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
88: ,Attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
89: ,Attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
90: ,Attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
91: ,Attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
92: ,Attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
93: ,Attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

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

86: ,Attribute5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
87: ,Attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
88: ,Attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
89: ,Attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
90: ,Attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
91: ,Attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
92: ,Attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
93: ,Attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
94: ,Attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

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

87: ,Attribute6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
88: ,Attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
89: ,Attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
90: ,Attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
91: ,Attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
92: ,Attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
93: ,Attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
94: ,Attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
95: ,Attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

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

88: ,Attribute7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
89: ,Attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
90: ,Attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
91: ,Attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
92: ,Attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
93: ,Attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
94: ,Attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
95: ,Attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
96: ,Attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

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

89: ,Attribute8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
90: ,Attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
91: ,Attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
92: ,Attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
93: ,Attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
94: ,Attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
95: ,Attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
96: ,Attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
97: ,Attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR

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

90: ,Attribute9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
91: ,Attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
92: ,Attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
93: ,Attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
94: ,Attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
95: ,Attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
96: ,Attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
97: ,Attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
98: ,Uom_Code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR

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

91: ,Attribute10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
92: ,Attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
93: ,Attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
94: ,Attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
95: ,Attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
96: ,Attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
97: ,Attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
98: ,Uom_Code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR
99: ,Revision_Id NUMBER DEFAULT FND_API.G_MISS_NUM

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

92: ,Attribute11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
93: ,Attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
94: ,Attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
95: ,Attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
96: ,Attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
97: ,Attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
98: ,Uom_Code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR
99: ,Revision_Id NUMBER DEFAULT FND_API.G_MISS_NUM
100: ,EPC_Gtin_Serial NUMBER DEFAULT FND_API.G_MISS_NUM);

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

93: ,Attribute12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
94: ,Attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
95: ,Attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
96: ,Attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
97: ,Attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
98: ,Uom_Code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR
99: ,Revision_Id NUMBER DEFAULT FND_API.G_MISS_NUM
100: ,EPC_Gtin_Serial NUMBER DEFAULT FND_API.G_MISS_NUM);
101:

Line 98: ,Uom_Code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR

94: ,Attribute13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
95: ,Attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
96: ,Attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
97: ,Attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
98: ,Uom_Code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR
99: ,Revision_Id NUMBER DEFAULT FND_API.G_MISS_NUM
100: ,EPC_Gtin_Serial NUMBER DEFAULT FND_API.G_MISS_NUM);
101:
102: TYPE XRef_Tbl_Type IS TABLE OF XRef_Rec_Type INDEX BY BINARY_INTEGER;

Line 99: ,Revision_Id NUMBER DEFAULT FND_API.G_MISS_NUM

95: ,Attribute14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
96: ,Attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
97: ,Attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
98: ,Uom_Code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR
99: ,Revision_Id NUMBER DEFAULT FND_API.G_MISS_NUM
100: ,EPC_Gtin_Serial NUMBER DEFAULT FND_API.G_MISS_NUM);
101:
102: TYPE XRef_Tbl_Type IS TABLE OF XRef_Rec_Type INDEX BY BINARY_INTEGER;
103: /*#

Line 100: ,EPC_Gtin_Serial NUMBER DEFAULT FND_API.G_MISS_NUM);

96: ,Attribute15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
97: ,Attribute_category VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR
98: ,Uom_Code VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR
99: ,Revision_Id NUMBER DEFAULT FND_API.G_MISS_NUM
100: ,EPC_Gtin_Serial NUMBER DEFAULT FND_API.G_MISS_NUM);
101:
102: TYPE XRef_Tbl_Type IS TABLE OF XRef_Rec_Type INDEX BY BINARY_INTEGER;
103: /*#
104: * Use this API to create,update and delete cross references associated with

Line 158: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE

154: * @rep:displayname Process XRef
155: */
156: PROCEDURE Process_XRef(
157: p_api_version IN NUMBER
158: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
159: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
160: ,p_XRef_Tbl IN OUT NOCOPY MTL_CROSS_REFERENCES_PUB.XRef_Tbl_Type
161: ,x_return_status OUT NOCOPY VARCHAR2
162: ,x_msg_count OUT NOCOPY NUMBER

Line 159: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE

155: */
156: PROCEDURE Process_XRef(
157: p_api_version IN NUMBER
158: ,p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE
159: ,p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE
160: ,p_XRef_Tbl IN OUT NOCOPY MTL_CROSS_REFERENCES_PUB.XRef_Tbl_Type
161: ,x_return_status OUT NOCOPY VARCHAR2
162: ,x_msg_count OUT NOCOPY NUMBER
163: ,x_message_list OUT NOCOPY Error_Handler.Error_Tbl_Type);