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

Line 42: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,

38: -- End of Comments
39:
40: TYPE REL_ITEM_Rec_Type IS RECORD
41: (
42: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
43: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
44: RELATED_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
45: RELATIONSHIP_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
46: RECIPROCAL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 43: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,

39:
40: TYPE REL_ITEM_Rec_Type IS RECORD
41: (
42: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
43: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
44: RELATED_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
45: RELATIONSHIP_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
46: RECIPROCAL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
47: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

Line 44: RELATED_ITEM_ID NUMBER := FND_API.G_MISS_NUM,

40: TYPE REL_ITEM_Rec_Type IS RECORD
41: (
42: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
43: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
44: RELATED_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
45: RELATIONSHIP_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
46: RECIPROCAL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
47: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
48: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

Line 45: RELATIONSHIP_TYPE_ID NUMBER := FND_API.G_MISS_NUM,

41: (
42: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
43: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
44: RELATED_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
45: RELATIONSHIP_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
46: RECIPROCAL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
47: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
48: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
49: CREATION_DATE DATE := FND_API.G_MISS_DATE,

Line 46: RECIPROCAL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,

42: INVENTORY_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
43: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
44: RELATED_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
45: RELATIONSHIP_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
46: RECIPROCAL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
47: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
48: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
49: CREATION_DATE DATE := FND_API.G_MISS_DATE,
50: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

Line 47: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

43: ORGANIZATION_ID NUMBER := FND_API.G_MISS_NUM,
44: RELATED_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
45: RELATIONSHIP_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
46: RECIPROCAL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
47: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
48: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
49: CREATION_DATE DATE := FND_API.G_MISS_DATE,
50: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
51: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

Line 48: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

44: RELATED_ITEM_ID NUMBER := FND_API.G_MISS_NUM,
45: RELATIONSHIP_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
46: RECIPROCAL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
47: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
48: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
49: CREATION_DATE DATE := FND_API.G_MISS_DATE,
50: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
51: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
52: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,

Line 49: CREATION_DATE DATE := FND_API.G_MISS_DATE,

45: RELATIONSHIP_TYPE_ID NUMBER := FND_API.G_MISS_NUM,
46: RECIPROCAL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
47: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
48: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
49: CREATION_DATE DATE := FND_API.G_MISS_DATE,
50: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
51: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
52: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
53: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,

Line 50: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

46: RECIPROCAL_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
47: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
48: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
49: CREATION_DATE DATE := FND_API.G_MISS_DATE,
50: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
51: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
52: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
53: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
54: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,

Line 51: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,

47: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
48: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
49: CREATION_DATE DATE := FND_API.G_MISS_DATE,
50: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
51: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
52: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
53: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
54: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
55: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE

Line 52: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,

48: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
49: CREATION_DATE DATE := FND_API.G_MISS_DATE,
50: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
51: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
52: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
53: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
54: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
55: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
56: );

Line 53: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,

49: CREATION_DATE DATE := FND_API.G_MISS_DATE,
50: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
51: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
52: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
53: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
54: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
55: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
56: );
57:

Line 54: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,

50: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
51: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
52: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
53: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
54: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
55: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
56: );
57:
58: G_MISS_REL_ITEM_REC REL_ITEM_Rec_Type;

Line 55: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE

51: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
52: REQUEST_ID NUMBER := FND_API.G_MISS_NUM,
53: PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM,
54: PROGRAM_ID NUMBER := FND_API.G_MISS_NUM,
55: PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
56: );
57:
58: G_MISS_REL_ITEM_REC REL_ITEM_Rec_Type;
59: TYPE REL_ITEM_Tbl_Type IS TABLE OF REL_ITEM_Rec_Type

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

68: -- Pre-Req :
69: -- Parameters:
70: -- IN
71: -- p_api_version_number IN NUMBER Required
72: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
73: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
74: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
75: -- P_REL_ITEM_Rec IN REL_ITEM_Rec_Type Required
76: --

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

69: -- Parameters:
70: -- IN
71: -- p_api_version_number IN NUMBER Required
72: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
73: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
74: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
75: -- P_REL_ITEM_Rec IN REL_ITEM_Rec_Type Required
76: --
77: -- OUT:

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

70: -- IN
71: -- p_api_version_number IN NUMBER Required
72: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
73: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
74: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
75: -- P_REL_ITEM_Rec IN REL_ITEM_Rec_Type Required
76: --
77: -- OUT:
78: -- x_return_status OUT VARCHAR2

Line 89: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

85: -- End of Comments
86: --
87: PROCEDURE Create_rel_item(
88: P_Api_Version_Number IN NUMBER,
89: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
90: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
91: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
92:
93: X_Return_Status OUT NOCOPY VARCHAR2,

Line 90: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

86: --
87: PROCEDURE Create_rel_item(
88: P_Api_Version_Number IN NUMBER,
89: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
90: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
91: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
92:
93: X_Return_Status OUT NOCOPY VARCHAR2,
94: X_Msg_Count OUT NOCOPY NUMBER,

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

87: PROCEDURE Create_rel_item(
88: P_Api_Version_Number IN NUMBER,
89: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
90: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
91: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
92:
93: X_Return_Status OUT NOCOPY VARCHAR2,
94: X_Msg_Count OUT NOCOPY NUMBER,
95: X_Msg_Data OUT NOCOPY VARCHAR2,

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

105: -- Pre-Req :
106: -- Parameters:
107: -- IN
108: -- p_api_version_number IN NUMBER Required
109: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
110: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
111: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
112: -- P_REL_ITEM_Rec IN REL_ITEM_Rec_Type Required
113: --

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

106: -- Parameters:
107: -- IN
108: -- p_api_version_number IN NUMBER Required
109: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
110: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
111: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
112: -- P_REL_ITEM_Rec IN REL_ITEM_Rec_Type Required
113: --
114: -- OUT:

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

107: -- IN
108: -- p_api_version_number IN NUMBER Required
109: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
110: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
111: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
112: -- P_REL_ITEM_Rec IN REL_ITEM_Rec_Type Required
113: --
114: -- OUT:
115: -- x_return_status OUT NOCOPY VARCHAR2

Line 126: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

122: -- End of Comments
123: --
124: PROCEDURE Update_rel_item(
125: P_Api_Version_Number IN NUMBER,
126: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
127: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
128: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
129:
130: X_Return_Status OUT NOCOPY VARCHAR2,

Line 127: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

123: --
124: PROCEDURE Update_rel_item(
125: P_Api_Version_Number IN NUMBER,
126: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
127: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
128: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
129:
130: X_Return_Status OUT NOCOPY VARCHAR2,
131: X_Msg_Count OUT NOCOPY NUMBER,

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

124: PROCEDURE Update_rel_item(
125: P_Api_Version_Number IN NUMBER,
126: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
127: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
128: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
129:
130: X_Return_Status OUT NOCOPY VARCHAR2,
131: X_Msg_Count OUT NOCOPY NUMBER,
132: X_Msg_Data OUT NOCOPY VARCHAR2,

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

142: -- Pre-Req :
143: -- Parameters:
144: -- IN
145: -- p_api_version_number IN NUMBER Required
146: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
147: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
148: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
149: -- p_RELATED_ITEM_ID IN NUMBER
150: -- p_object_version_number IN NUMBER Optional Default = NULL

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

143: -- Parameters:
144: -- IN
145: -- p_api_version_number IN NUMBER Required
146: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
147: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
148: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
149: -- p_RELATED_ITEM_ID IN NUMBER
150: -- p_object_version_number IN NUMBER Optional Default = NULL
151: --

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

144: -- IN
145: -- p_api_version_number IN NUMBER Required
146: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
147: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
148: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
149: -- p_RELATED_ITEM_ID IN NUMBER
150: -- p_object_version_number IN NUMBER Optional Default = NULL
151: --
152: -- OUT:

Line 164: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

160: -- End of Comments
161: --
162: PROCEDURE Delete_rel_item(
163: P_Api_Version_Number IN NUMBER,
164: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
165: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
166: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
167: X_Return_Status OUT NOCOPY VARCHAR2,
168: X_Msg_Count OUT NOCOPY NUMBER,

Line 165: P_Commit IN VARCHAR2 := FND_API.G_FALSE,

161: --
162: PROCEDURE Delete_rel_item(
163: P_Api_Version_Number IN NUMBER,
164: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
165: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
166: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
167: X_Return_Status OUT NOCOPY VARCHAR2,
168: X_Msg_Count OUT NOCOPY NUMBER,
169: X_Msg_Data OUT NOCOPY VARCHAR2,

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

162: PROCEDURE Delete_rel_item(
163: P_Api_Version_Number IN NUMBER,
164: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
165: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
166: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
167: X_Return_Status OUT NOCOPY VARCHAR2,
168: X_Msg_Count OUT NOCOPY NUMBER,
169: X_Msg_Data OUT NOCOPY VARCHAR2,
170: P_REL_ITEM_Rec IN REL_ITEM_Rec_Type

Line 187: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

183: -- End of Comments
184:
185: PROCEDURE Validate_REL_ITEM_rec(
186: P_Api_Version_Number IN NUMBER,
187: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
188: X_Return_Status OUT NOCOPY VARCHAR2,
189: X_Msg_Count OUT NOCOPY NUMBER,
190: X_Msg_Data OUT NOCOPY VARCHAR2,
191: P_REL_ITEM_Rec IN REL_ITEM_Rec_Type

Line 207: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,

203: -- End of Comments
204:
205: PROCEDURE Validate_rel_item(
206: P_Api_Version_Number IN NUMBER,
207: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
208: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
209: P_REL_ITEM_Rec IN REL_ITEM_Rec_Type,
210: X_Return_Status OUT NOCOPY VARCHAR2,
211: X_Msg_Count OUT NOCOPY NUMBER,

Line 208: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

204:
205: PROCEDURE Validate_rel_item(
206: P_Api_Version_Number IN NUMBER,
207: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
208: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
209: P_REL_ITEM_Rec IN REL_ITEM_Rec_Type,
210: X_Return_Status OUT NOCOPY VARCHAR2,
211: X_Msg_Count OUT NOCOPY NUMBER,
212: X_Msg_Data OUT NOCOPY VARCHAR2