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: , pre_execution_wait NUMBER := FND_API.G_MISS_NUM

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: , pre_execution_wait NUMBER := FND_API.G_MISS_NUM
63: , pre_execution_time_uom VARCHAR2(100) := FND_API.G_MISS_CHAR

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: , pre_execution_wait NUMBER := FND_API.G_MISS_NUM
63: , pre_execution_time_uom VARCHAR2(100) := FND_API.G_MISS_CHAR
64: , post_execution_wait NUMBER := FND_API.G_MISS_NUM

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: , pre_execution_wait NUMBER := FND_API.G_MISS_NUM
63: , pre_execution_time_uom VARCHAR2(100) := FND_API.G_MISS_CHAR
64: , post_execution_wait NUMBER := FND_API.G_MISS_NUM
65: , execution_time_uom VARCHAR2(100) := FND_API.G_MISS_CHAR

Line 62: , pre_execution_wait NUMBER := FND_API.G_MISS_NUM

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: , pre_execution_wait NUMBER := FND_API.G_MISS_NUM
63: , pre_execution_time_uom VARCHAR2(100) := FND_API.G_MISS_CHAR
64: , post_execution_wait NUMBER := FND_API.G_MISS_NUM
65: , execution_time_uom VARCHAR2(100) := FND_API.G_MISS_CHAR
66: , xdo_temp_id NUMBER := FND_API.G_MISS_NUM

Line 63: , pre_execution_time_uom VARCHAR2(100) := FND_API.G_MISS_CHAR

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: , pre_execution_wait NUMBER := FND_API.G_MISS_NUM
63: , pre_execution_time_uom VARCHAR2(100) := FND_API.G_MISS_CHAR
64: , post_execution_wait NUMBER := FND_API.G_MISS_NUM
65: , execution_time_uom VARCHAR2(100) := FND_API.G_MISS_CHAR
66: , xdo_temp_id NUMBER := FND_API.G_MISS_NUM
67: , optional_yn VARCHAR2(5) := FND_API.G_MISS_CHAR

Line 64: , post_execution_wait 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: , pre_execution_wait NUMBER := FND_API.G_MISS_NUM
63: , pre_execution_time_uom VARCHAR2(100) := FND_API.G_MISS_CHAR
64: , post_execution_wait NUMBER := FND_API.G_MISS_NUM
65: , execution_time_uom VARCHAR2(100) := FND_API.G_MISS_CHAR
66: , xdo_temp_id NUMBER := FND_API.G_MISS_NUM
67: , optional_yn VARCHAR2(5) := FND_API.G_MISS_CHAR
68: , optional_wait_time NUMBER := FND_API.G_MISS_NUM

Line 65: , execution_time_uom VARCHAR2(100) := FND_API.G_MISS_CHAR

61: , ESCALATED_YN CHAR := FND_API.G_MISS_CHAR
62: , pre_execution_wait NUMBER := FND_API.G_MISS_NUM
63: , pre_execution_time_uom VARCHAR2(100) := FND_API.G_MISS_CHAR
64: , post_execution_wait NUMBER := FND_API.G_MISS_NUM
65: , execution_time_uom VARCHAR2(100) := FND_API.G_MISS_CHAR
66: , xdo_temp_id NUMBER := FND_API.G_MISS_NUM
67: , optional_yn VARCHAR2(5) := FND_API.G_MISS_CHAR
68: , optional_wait_time NUMBER := FND_API.G_MISS_NUM
69: , optional_wait_time_uom VARCHAR2(60) := FND_API.G_MISS_CHAR

Line 66: , xdo_temp_id NUMBER := FND_API.G_MISS_NUM

62: , pre_execution_wait NUMBER := FND_API.G_MISS_NUM
63: , pre_execution_time_uom VARCHAR2(100) := FND_API.G_MISS_CHAR
64: , post_execution_wait NUMBER := FND_API.G_MISS_NUM
65: , execution_time_uom VARCHAR2(100) := FND_API.G_MISS_CHAR
66: , xdo_temp_id NUMBER := FND_API.G_MISS_NUM
67: , optional_yn VARCHAR2(5) := FND_API.G_MISS_CHAR
68: , optional_wait_time NUMBER := FND_API.G_MISS_NUM
69: , optional_wait_time_uom VARCHAR2(60) := FND_API.G_MISS_CHAR
70: , notify_yn VARCHAR2(3) := FND_API.G_MISS_CHAR

Line 67: , optional_yn VARCHAR2(5) := FND_API.G_MISS_CHAR

63: , pre_execution_time_uom VARCHAR2(100) := FND_API.G_MISS_CHAR
64: , post_execution_wait NUMBER := FND_API.G_MISS_NUM
65: , execution_time_uom VARCHAR2(100) := FND_API.G_MISS_CHAR
66: , xdo_temp_id NUMBER := FND_API.G_MISS_NUM
67: , optional_yn VARCHAR2(5) := FND_API.G_MISS_CHAR
68: , optional_wait_time NUMBER := FND_API.G_MISS_NUM
69: , optional_wait_time_uom VARCHAR2(60) := FND_API.G_MISS_CHAR
70: , notify_yn VARCHAR2(3) := FND_API.G_MISS_CHAR
71: , escalate_yn CHAR := FND_API.G_MISS_CHAR

Line 68: , optional_wait_time NUMBER := FND_API.G_MISS_NUM

64: , post_execution_wait NUMBER := FND_API.G_MISS_NUM
65: , execution_time_uom VARCHAR2(100) := FND_API.G_MISS_CHAR
66: , xdo_temp_id NUMBER := FND_API.G_MISS_NUM
67: , optional_yn VARCHAR2(5) := FND_API.G_MISS_CHAR
68: , optional_wait_time NUMBER := FND_API.G_MISS_NUM
69: , optional_wait_time_uom VARCHAR2(60) := FND_API.G_MISS_CHAR
70: , notify_yn VARCHAR2(3) := FND_API.G_MISS_CHAR
71: , escalate_yn CHAR := FND_API.G_MISS_CHAR
72: , escalate_wait_time NUMBER := FND_API.G_MISS_NUM

Line 69: , optional_wait_time_uom VARCHAR2(60) := FND_API.G_MISS_CHAR

65: , execution_time_uom VARCHAR2(100) := FND_API.G_MISS_CHAR
66: , xdo_temp_id NUMBER := FND_API.G_MISS_NUM
67: , optional_yn VARCHAR2(5) := FND_API.G_MISS_CHAR
68: , optional_wait_time NUMBER := FND_API.G_MISS_NUM
69: , optional_wait_time_uom VARCHAR2(60) := FND_API.G_MISS_CHAR
70: , notify_yn VARCHAR2(3) := FND_API.G_MISS_CHAR
71: , escalate_yn CHAR := FND_API.G_MISS_CHAR
72: , escalate_wait_time NUMBER := FND_API.G_MISS_NUM
73: , escalate_wait_time_uom VARCHAR2(60) := FND_API.G_MISS_CHAR

Line 70: , notify_yn VARCHAR2(3) := FND_API.G_MISS_CHAR

66: , xdo_temp_id NUMBER := FND_API.G_MISS_NUM
67: , optional_yn VARCHAR2(5) := FND_API.G_MISS_CHAR
68: , optional_wait_time NUMBER := FND_API.G_MISS_NUM
69: , optional_wait_time_uom VARCHAR2(60) := FND_API.G_MISS_CHAR
70: , notify_yn VARCHAR2(3) := FND_API.G_MISS_CHAR
71: , escalate_yn CHAR := FND_API.G_MISS_CHAR
72: , escalate_wait_time NUMBER := FND_API.G_MISS_NUM
73: , escalate_wait_time_uom VARCHAR2(60) := FND_API.G_MISS_CHAR
74: , custom_workflow_type VARCHAR2(240) := FND_API.G_MISS_CHAR

Line 71: , escalate_yn CHAR := FND_API.G_MISS_CHAR

67: , optional_yn VARCHAR2(5) := FND_API.G_MISS_CHAR
68: , optional_wait_time NUMBER := FND_API.G_MISS_NUM
69: , optional_wait_time_uom VARCHAR2(60) := FND_API.G_MISS_CHAR
70: , notify_yn VARCHAR2(3) := FND_API.G_MISS_CHAR
71: , escalate_yn CHAR := FND_API.G_MISS_CHAR
72: , escalate_wait_time NUMBER := FND_API.G_MISS_NUM
73: , escalate_wait_time_uom VARCHAR2(60) := FND_API.G_MISS_CHAR
74: , custom_workflow_type VARCHAR2(240) := FND_API.G_MISS_CHAR
75: );

Line 72: , escalate_wait_time NUMBER := FND_API.G_MISS_NUM

68: , optional_wait_time NUMBER := FND_API.G_MISS_NUM
69: , optional_wait_time_uom VARCHAR2(60) := FND_API.G_MISS_CHAR
70: , notify_yn VARCHAR2(3) := FND_API.G_MISS_CHAR
71: , escalate_yn CHAR := FND_API.G_MISS_CHAR
72: , escalate_wait_time NUMBER := FND_API.G_MISS_NUM
73: , escalate_wait_time_uom VARCHAR2(60) := FND_API.G_MISS_CHAR
74: , custom_workflow_type VARCHAR2(240) := FND_API.G_MISS_CHAR
75: );
76:

Line 73: , escalate_wait_time_uom VARCHAR2(60) := FND_API.G_MISS_CHAR

69: , optional_wait_time_uom VARCHAR2(60) := FND_API.G_MISS_CHAR
70: , notify_yn VARCHAR2(3) := FND_API.G_MISS_CHAR
71: , escalate_yn CHAR := FND_API.G_MISS_CHAR
72: , escalate_wait_time NUMBER := FND_API.G_MISS_NUM
73: , escalate_wait_time_uom VARCHAR2(60) := FND_API.G_MISS_CHAR
74: , custom_workflow_type VARCHAR2(240) := FND_API.G_MISS_CHAR
75: );
76:
77: G_MISS_strategy_work_item_REC strategy_work_item_Rec_Type;

Line 74: , custom_workflow_type VARCHAR2(240) := FND_API.G_MISS_CHAR

70: , notify_yn VARCHAR2(3) := FND_API.G_MISS_CHAR
71: , escalate_yn CHAR := FND_API.G_MISS_CHAR
72: , escalate_wait_time NUMBER := FND_API.G_MISS_NUM
73: , escalate_wait_time_uom VARCHAR2(60) := FND_API.G_MISS_CHAR
74: , custom_workflow_type VARCHAR2(240) := FND_API.G_MISS_CHAR
75: );
76:
77: G_MISS_strategy_work_item_REC strategy_work_item_Rec_Type;
78: TYPE strategy_work_item_Tbl_Type IS TABLE OF strategy_work_item_Rec_Type

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

87: -- Pre-Req :
88: -- Parameters:
89: -- IN
90: -- p_api_version_number IN NUMBER Required
91: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
92: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
93: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
94: -- P_strategy_work_item_Rec IN strategy_work_item_Rec_Type Required
95: --

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

88: -- Parameters:
89: -- IN
90: -- p_api_version_number IN NUMBER Required
91: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
92: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
93: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
94: -- P_strategy_work_item_Rec IN strategy_work_item_Rec_Type Required
95: --
96: -- OUT:

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

89: -- IN
90: -- p_api_version_number IN NUMBER Required
91: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
92: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
93: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
94: -- P_strategy_work_item_Rec IN strategy_work_item_Rec_Type Required
95: --
96: -- OUT:
97: -- x_return_status OUT NOCOPY VARCHAR2

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

101: -- End of Comments
102: --
103: PROCEDURE Create_strategy_work_items(
104: P_Api_Version_Number IN NUMBER,
105: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
106: P_Commit IN VARCHAR2 := FND_API.G_TRUE,
107: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
108: P_strategy_work_item_Rec IN strategy_work_item_Rec_Type := G_MISS_strategy_work_item_REC,
109: X_WORK_ITEM_ID OUT NOCOPY NUMBER,

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

102: --
103: PROCEDURE Create_strategy_work_items(
104: P_Api_Version_Number IN NUMBER,
105: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
106: P_Commit IN VARCHAR2 := FND_API.G_TRUE,
107: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
108: P_strategy_work_item_Rec IN strategy_work_item_Rec_Type := G_MISS_strategy_work_item_REC,
109: X_WORK_ITEM_ID OUT NOCOPY NUMBER,
110: X_Return_Status OUT NOCOPY VARCHAR2,

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

103: PROCEDURE Create_strategy_work_items(
104: P_Api_Version_Number IN NUMBER,
105: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
106: P_Commit IN VARCHAR2 := FND_API.G_TRUE,
107: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
108: P_strategy_work_item_Rec IN strategy_work_item_Rec_Type := G_MISS_strategy_work_item_REC,
109: X_WORK_ITEM_ID OUT NOCOPY NUMBER,
110: X_Return_Status OUT NOCOPY VARCHAR2,
111: X_Msg_Count OUT NOCOPY NUMBER,

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

120: -- Pre-Req :
121: -- Parameters:
122: -- IN
123: -- p_api_version_number IN NUMBER Required
124: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
125: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
126: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
127: -- P_strategy_work_item_Rec IN strategy_work_item_Rec_Type Required
128: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required

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

121: -- Parameters:
122: -- IN
123: -- p_api_version_number IN NUMBER Required
124: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
125: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
126: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
127: -- P_strategy_work_item_Rec IN strategy_work_item_Rec_Type Required
128: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
129: --

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

122: -- IN
123: -- p_api_version_number IN NUMBER Required
124: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
125: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
126: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
127: -- P_strategy_work_item_Rec IN strategy_work_item_Rec_Type Required
128: -- p_profile_tbl IN AS_UTILITY_PUB.PROFILE_TBL_TYPE Required
129: --
130: -- OUT:

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

136: --
137: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
138: PROCEDURE Update_strategy_work_items(
139: P_Api_Version_Number IN NUMBER,
140: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
141: P_Commit IN VARCHAR2 := FND_API.G_TRUE,
142: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
143: P_strategy_work_item_Rec IN strategy_work_item_Rec_Type,
144: X_Return_Status OUT NOCOPY VARCHAR2,

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

137: -- Hint: Add corresponding update detail table procedures if it's master-detail relationship.
138: PROCEDURE Update_strategy_work_items(
139: P_Api_Version_Number IN NUMBER,
140: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
141: P_Commit IN VARCHAR2 := FND_API.G_TRUE,
142: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
143: P_strategy_work_item_Rec IN strategy_work_item_Rec_Type,
144: X_Return_Status OUT NOCOPY VARCHAR2,
145: X_Msg_Count OUT NOCOPY NUMBER,

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

138: PROCEDURE Update_strategy_work_items(
139: P_Api_Version_Number IN NUMBER,
140: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
141: P_Commit IN VARCHAR2 := FND_API.G_TRUE,
142: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
143: P_strategy_work_item_Rec IN strategy_work_item_Rec_Type,
144: X_Return_Status OUT NOCOPY VARCHAR2,
145: X_Msg_Count OUT NOCOPY NUMBER,
146: X_Msg_Data OUT NOCOPY VARCHAR2,

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

155: -- Pre-Req :
156: -- Parameters:
157: -- IN
158: -- p_api_version_number IN NUMBER Required
159: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
160: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
161: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
162: -- P_strategy_work_item_Rec IN strategy_work_item_Rec_Type Required
163:

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

156: -- Parameters:
157: -- IN
158: -- p_api_version_number IN NUMBER Required
159: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
160: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
161: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
162: -- P_strategy_work_item_Rec IN strategy_work_item_Rec_Type Required
163:
164: --

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

157: -- IN
158: -- p_api_version_number IN NUMBER Required
159: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
160: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
161: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
162: -- P_strategy_work_item_Rec IN strategy_work_item_Rec_Type Required
163:
164: --
165: -- OUT:

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

174: --
175:
176: PROCEDURE Delete_strategy_work_items(
177: P_Api_Version_Number IN NUMBER,
178: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
179: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
180: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
181: p_WORK_ITEM_ID IN NUMBER,
182: X_Return_Status OUT NOCOPY VARCHAR2,

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

175:
176: PROCEDURE Delete_strategy_work_items(
177: P_Api_Version_Number IN NUMBER,
178: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
179: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
180: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
181: p_WORK_ITEM_ID IN NUMBER,
182: X_Return_Status OUT NOCOPY VARCHAR2,
183: X_Msg_Count OUT NOCOPY NUMBER,

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

176: PROCEDURE Delete_strategy_work_items(
177: P_Api_Version_Number IN NUMBER,
178: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
179: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
180: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
181: p_WORK_ITEM_ID IN NUMBER,
182: X_Return_Status OUT NOCOPY VARCHAR2,
183: X_Msg_Count OUT NOCOPY NUMBER,
184: X_Msg_Data OUT NOCOPY VARCHAR2