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

Line 40: WORK_ITEM_ID NUMBER := FND_API.G_MISS_NUM

36: -- End of Comments
37:
38: TYPE strategy_work_item_Rec_Type IS RECORD
39: (
40: WORK_ITEM_ID NUMBER := FND_API.G_MISS_NUM
41: , STRATEGY_ID NUMBER := FND_API.G_MISS_NUM
42: , RESOURCE_ID NUMBER := FND_API.G_MISS_NUM
43: , STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
44: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM

Line 41: , STRATEGY_ID NUMBER := FND_API.G_MISS_NUM

37:
38: TYPE strategy_work_item_Rec_Type IS RECORD
39: (
40: WORK_ITEM_ID NUMBER := FND_API.G_MISS_NUM
41: , STRATEGY_ID NUMBER := FND_API.G_MISS_NUM
42: , RESOURCE_ID NUMBER := FND_API.G_MISS_NUM
43: , STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
44: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
45: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM

Line 42: , RESOURCE_ID NUMBER := FND_API.G_MISS_NUM

38: TYPE strategy_work_item_Rec_Type IS RECORD
39: (
40: WORK_ITEM_ID NUMBER := FND_API.G_MISS_NUM
41: , STRATEGY_ID NUMBER := FND_API.G_MISS_NUM
42: , RESOURCE_ID NUMBER := FND_API.G_MISS_NUM
43: , STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
44: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
45: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
46: , CREATION_DATE DATE := FND_API.G_MISS_DATE

Line 43: , STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR

39: (
40: WORK_ITEM_ID NUMBER := FND_API.G_MISS_NUM
41: , STRATEGY_ID NUMBER := FND_API.G_MISS_NUM
42: , RESOURCE_ID NUMBER := FND_API.G_MISS_NUM
43: , STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
44: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
45: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
46: , CREATION_DATE DATE := FND_API.G_MISS_DATE
47: , CREATED_BY NUMBER := FND_API.G_MISS_NUM

Line 44: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM

40: WORK_ITEM_ID NUMBER := FND_API.G_MISS_NUM
41: , STRATEGY_ID NUMBER := FND_API.G_MISS_NUM
42: , RESOURCE_ID NUMBER := FND_API.G_MISS_NUM
43: , STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
44: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
45: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
46: , CREATION_DATE DATE := FND_API.G_MISS_DATE
47: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
48: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM

Line 45: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM

41: , STRATEGY_ID NUMBER := FND_API.G_MISS_NUM
42: , RESOURCE_ID NUMBER := FND_API.G_MISS_NUM
43: , STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
44: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
45: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
46: , CREATION_DATE DATE := FND_API.G_MISS_DATE
47: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
48: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
49: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM

Line 46: , CREATION_DATE DATE := FND_API.G_MISS_DATE

42: , RESOURCE_ID NUMBER := FND_API.G_MISS_NUM
43: , STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
44: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
45: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
46: , CREATION_DATE DATE := FND_API.G_MISS_DATE
47: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
48: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
49: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
50: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM

Line 47: , CREATED_BY NUMBER := FND_API.G_MISS_NUM

43: , STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR
44: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
45: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
46: , CREATION_DATE DATE := FND_API.G_MISS_DATE
47: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
48: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
49: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
50: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
51: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE

Line 48: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM

44: , LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM
45: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
46: , CREATION_DATE DATE := FND_API.G_MISS_DATE
47: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
48: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
49: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
50: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
51: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
52: , WORK_ITEM_TEMPLATE_ID NUMBER := FND_API.G_MISS_NUM

Line 49: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM

45: , LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
46: , CREATION_DATE DATE := FND_API.G_MISS_DATE
47: , CREATED_BY NUMBER := FND_API.G_MISS_NUM
48: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
49: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
50: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
51: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
52: , WORK_ITEM_TEMPLATE_ID NUMBER := FND_API.G_MISS_NUM
53: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM

Line 50: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM

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

Line 51: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE

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

Line 52: , WORK_ITEM_TEMPLATE_ID NUMBER := FND_API.G_MISS_NUM

48: , PROGRAM_ID NUMBER := FND_API.G_MISS_NUM
49: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
50: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
51: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
52: , WORK_ITEM_TEMPLATE_ID NUMBER := FND_API.G_MISS_NUM
53: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
54: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
55: , EXECUTE_START DATE := FND_API.G_MISS_DATE
56: , EXECUTE_END DATE := FND_API.G_MISS_DATE

Line 53: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM

49: , OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM
50: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
51: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
52: , WORK_ITEM_TEMPLATE_ID NUMBER := FND_API.G_MISS_NUM
53: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
54: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
55: , EXECUTE_START DATE := FND_API.G_MISS_DATE
56: , EXECUTE_END DATE := FND_API.G_MISS_DATE
57: , SCHEDULE_START DATE := FND_API.G_MISS_DATE

Line 54: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE

50: , REQUEST_ID NUMBER := FND_API.G_MISS_NUM
51: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
52: , WORK_ITEM_TEMPLATE_ID NUMBER := FND_API.G_MISS_NUM
53: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
54: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
55: , EXECUTE_START DATE := FND_API.G_MISS_DATE
56: , EXECUTE_END DATE := FND_API.G_MISS_DATE
57: , SCHEDULE_START DATE := FND_API.G_MISS_DATE
58: , SCHEDULE_END DATE := FND_API.G_MISS_DATE

Line 55: , EXECUTE_START DATE := FND_API.G_MISS_DATE

51: , LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE
52: , WORK_ITEM_TEMPLATE_ID NUMBER := FND_API.G_MISS_NUM
53: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
54: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
55: , EXECUTE_START DATE := FND_API.G_MISS_DATE
56: , EXECUTE_END DATE := FND_API.G_MISS_DATE
57: , SCHEDULE_START DATE := FND_API.G_MISS_DATE
58: , SCHEDULE_END DATE := FND_API.G_MISS_DATE
59: , STRATEGY_TEMP_ID NUMBER := FND_API.G_MISS_NUM

Line 56: , EXECUTE_END DATE := FND_API.G_MISS_DATE

52: , WORK_ITEM_TEMPLATE_ID NUMBER := FND_API.G_MISS_NUM
53: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
54: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
55: , EXECUTE_START DATE := FND_API.G_MISS_DATE
56: , EXECUTE_END DATE := FND_API.G_MISS_DATE
57: , SCHEDULE_START DATE := FND_API.G_MISS_DATE
58: , SCHEDULE_END DATE := FND_API.G_MISS_DATE
59: , STRATEGY_TEMP_ID NUMBER := FND_API.G_MISS_NUM
60: , WORK_ITEM_ORDER NUMBER := FND_API.G_MISS_NUM

Line 57: , SCHEDULE_START DATE := FND_API.G_MISS_DATE

53: , PROGRAM_APPLICATION_ID NUMBER := FND_API.G_MISS_NUM
54: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
55: , EXECUTE_START DATE := FND_API.G_MISS_DATE
56: , EXECUTE_END DATE := FND_API.G_MISS_DATE
57: , SCHEDULE_START DATE := FND_API.G_MISS_DATE
58: , SCHEDULE_END DATE := FND_API.G_MISS_DATE
59: , STRATEGY_TEMP_ID NUMBER := FND_API.G_MISS_NUM
60: , WORK_ITEM_ORDER NUMBER := FND_API.G_MISS_NUM
61: , ESCALATED_YN CHAR := FND_API.G_MISS_CHAR

Line 58: , SCHEDULE_END DATE := FND_API.G_MISS_DATE

54: , PROGRAM_UPDATE_DATE DATE := FND_API.G_MISS_DATE
55: , EXECUTE_START DATE := FND_API.G_MISS_DATE
56: , EXECUTE_END DATE := FND_API.G_MISS_DATE
57: , SCHEDULE_START DATE := FND_API.G_MISS_DATE
58: , SCHEDULE_END DATE := FND_API.G_MISS_DATE
59: , STRATEGY_TEMP_ID NUMBER := FND_API.G_MISS_NUM
60: , WORK_ITEM_ORDER NUMBER := FND_API.G_MISS_NUM
61: , ESCALATED_YN CHAR := FND_API.G_MISS_CHAR
62: );

Line 59: , STRATEGY_TEMP_ID NUMBER := FND_API.G_MISS_NUM

55: , EXECUTE_START DATE := FND_API.G_MISS_DATE
56: , EXECUTE_END DATE := FND_API.G_MISS_DATE
57: , SCHEDULE_START DATE := FND_API.G_MISS_DATE
58: , SCHEDULE_END DATE := FND_API.G_MISS_DATE
59: , STRATEGY_TEMP_ID NUMBER := FND_API.G_MISS_NUM
60: , WORK_ITEM_ORDER NUMBER := FND_API.G_MISS_NUM
61: , ESCALATED_YN CHAR := FND_API.G_MISS_CHAR
62: );
63:

Line 60: , WORK_ITEM_ORDER NUMBER := FND_API.G_MISS_NUM

56: , EXECUTE_END DATE := FND_API.G_MISS_DATE
57: , SCHEDULE_START DATE := FND_API.G_MISS_DATE
58: , SCHEDULE_END DATE := FND_API.G_MISS_DATE
59: , STRATEGY_TEMP_ID NUMBER := FND_API.G_MISS_NUM
60: , WORK_ITEM_ORDER NUMBER := FND_API.G_MISS_NUM
61: , ESCALATED_YN CHAR := FND_API.G_MISS_CHAR
62: );
63:
64: G_MISS_strategy_work_item_REC strategy_work_item_Rec_Type;

Line 61: , ESCALATED_YN CHAR := FND_API.G_MISS_CHAR

57: , SCHEDULE_START DATE := FND_API.G_MISS_DATE
58: , SCHEDULE_END DATE := FND_API.G_MISS_DATE
59: , STRATEGY_TEMP_ID NUMBER := FND_API.G_MISS_NUM
60: , WORK_ITEM_ORDER NUMBER := FND_API.G_MISS_NUM
61: , ESCALATED_YN CHAR := FND_API.G_MISS_CHAR
62: );
63:
64: G_MISS_strategy_work_item_REC strategy_work_item_Rec_Type;
65: TYPE strategy_work_item_Tbl_Type IS TABLE OF strategy_work_item_Rec_Type

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

74: -- Pre-Req :
75: -- Parameters:
76: -- IN
77: -- p_api_version_number IN NUMBER Required
78: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
79: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
80: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
81: -- P_strategy_work_item_Rec IN strategy_work_item_Rec_Type Required
82: --

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

75: -- Parameters:
76: -- IN
77: -- p_api_version_number IN NUMBER Required
78: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
79: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
80: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
81: -- P_strategy_work_item_Rec IN strategy_work_item_Rec_Type Required
82: --
83: -- OUT:

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

76: -- IN
77: -- p_api_version_number IN NUMBER Required
78: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
79: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
80: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
81: -- P_strategy_work_item_Rec IN strategy_work_item_Rec_Type Required
82: --
83: -- OUT:
84: -- x_return_status OUT NOCOPY VARCHAR2

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

88: -- End of Comments
89: --
90: PROCEDURE Create_strategy_work_items(
91: P_Api_Version_Number IN NUMBER,
92: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
93: P_Commit IN VARCHAR2 := FND_API.G_TRUE,
94: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
95: P_strategy_work_item_Rec IN strategy_work_item_Rec_Type := G_MISS_strategy_work_item_REC,
96: X_WORK_ITEM_ID OUT NOCOPY NUMBER,

Line 93: P_Commit IN VARCHAR2 := FND_API.G_TRUE,

89: --
90: PROCEDURE Create_strategy_work_items(
91: P_Api_Version_Number IN NUMBER,
92: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
93: P_Commit IN VARCHAR2 := FND_API.G_TRUE,
94: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
95: P_strategy_work_item_Rec IN strategy_work_item_Rec_Type := G_MISS_strategy_work_item_REC,
96: X_WORK_ITEM_ID OUT NOCOPY NUMBER,
97: X_Return_Status OUT NOCOPY VARCHAR2,

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

90: PROCEDURE Create_strategy_work_items(
91: P_Api_Version_Number IN NUMBER,
92: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
93: P_Commit IN VARCHAR2 := FND_API.G_TRUE,
94: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
95: P_strategy_work_item_Rec IN strategy_work_item_Rec_Type := G_MISS_strategy_work_item_REC,
96: X_WORK_ITEM_ID OUT NOCOPY NUMBER,
97: X_Return_Status OUT NOCOPY VARCHAR2,
98: X_Msg_Count OUT NOCOPY NUMBER,

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

107: -- Pre-Req :
108: -- Parameters:
109: -- IN
110: -- p_api_version_number IN NUMBER Required
111: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
112: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
113: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
114: -- P_strategy_work_item_Rec IN strategy_work_item_Rec_Type Required
115: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required

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

108: -- Parameters:
109: -- IN
110: -- p_api_version_number IN NUMBER Required
111: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
112: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
113: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
114: -- P_strategy_work_item_Rec IN strategy_work_item_Rec_Type Required
115: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
116: --

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

109: -- IN
110: -- p_api_version_number IN NUMBER Required
111: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
112: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
113: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
114: -- P_strategy_work_item_Rec IN strategy_work_item_Rec_Type Required
115: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
116: --
117: -- OUT:

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

123: --
124: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
125: PROCEDURE Update_strategy_work_items(
126: P_Api_Version_Number IN NUMBER,
127: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
128: P_Commit IN VARCHAR2 := FND_API.G_TRUE,
129: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
130: P_strategy_work_item_Rec IN strategy_work_item_Rec_Type,
131: X_Return_Status OUT NOCOPY VARCHAR2,

Line 128: P_Commit IN VARCHAR2 := FND_API.G_TRUE,

124: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
125: PROCEDURE Update_strategy_work_items(
126: P_Api_Version_Number IN NUMBER,
127: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
128: P_Commit IN VARCHAR2 := FND_API.G_TRUE,
129: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
130: P_strategy_work_item_Rec IN strategy_work_item_Rec_Type,
131: X_Return_Status OUT NOCOPY VARCHAR2,
132: X_Msg_Count OUT NOCOPY NUMBER,

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

125: PROCEDURE Update_strategy_work_items(
126: P_Api_Version_Number IN NUMBER,
127: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
128: P_Commit IN VARCHAR2 := FND_API.G_TRUE,
129: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
130: P_strategy_work_item_Rec IN strategy_work_item_Rec_Type,
131: X_Return_Status OUT NOCOPY VARCHAR2,
132: X_Msg_Count OUT NOCOPY NUMBER,
133: 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_strategy_work_item_Rec IN strategy_work_item_Rec_Type Required
150:

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_strategy_work_item_Rec IN strategy_work_item_Rec_Type Required
150:
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_strategy_work_item_Rec IN strategy_work_item_Rec_Type Required
150:
151: --
152: -- OUT:

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

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

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

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

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

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