5: INDEX BY BINARY_INTEGER;
6:
7: Procedure Tasks_Rollup_Unlimited(
8: p_api_version IN NUMBER := 1.0
9: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
10: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
11: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
12: ,p_validation_level IN VARCHAR2 := 100
13: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
6:
7: Procedure Tasks_Rollup_Unlimited(
8: p_api_version IN NUMBER := 1.0
9: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
10: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
11: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
12: ,p_validation_level IN VARCHAR2 := 100
13: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
14: ,p_debug_mode IN VARCHAR2 := 'N'
7: Procedure Tasks_Rollup_Unlimited(
8: p_api_version IN NUMBER := 1.0
9: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
10: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
11: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
12: ,p_validation_level IN VARCHAR2 := 100
13: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
14: ,p_debug_mode IN VARCHAR2 := 'N'
15: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
20:
21:
22: Procedure Tasks_Rollup(
23: p_api_version IN NUMBER := 1.0
24: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
25: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
26: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
27: ,p_validation_level IN VARCHAR2 := 100
28: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
21:
22: Procedure Tasks_Rollup(
23: p_api_version IN NUMBER := 1.0
24: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
25: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
26: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
27: ,p_validation_level IN VARCHAR2 := 100
28: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
29: ,p_debug_mode IN VARCHAR2 := 'N'
22: Procedure Tasks_Rollup(
23: p_api_version IN NUMBER := 1.0
24: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
25: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
26: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
27: ,p_validation_level IN VARCHAR2 := 100
28: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
29: ,p_debug_mode IN VARCHAR2 := 'N'
30: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
35:
36:
37: Procedure Task_Status_Rollup(
38: p_api_version IN NUMBER := 1.0
39: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
40: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
41: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
42: ,p_validation_level IN VARCHAR2 := 100
43: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
36:
37: Procedure Task_Status_Rollup(
38: p_api_version IN NUMBER := 1.0
39: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
40: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
41: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
42: ,p_validation_level IN VARCHAR2 := 100
43: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
44: ,p_debug_mode IN VARCHAR2 := 'N'
37: Procedure Task_Status_Rollup(
38: p_api_version IN NUMBER := 1.0
39: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
40: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
41: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
42: ,p_validation_level IN VARCHAR2 := 100
43: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
44: ,p_debug_mode IN VARCHAR2 := 'N'
45: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
51: );
52:
53: Procedure Task_Stat_Pushdown_Rollup(
54: p_api_version IN NUMBER := 1.0
55: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
56: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
57: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
58: ,p_validation_level IN VARCHAR2 := 100
59: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
52:
53: Procedure Task_Stat_Pushdown_Rollup(
54: p_api_version IN NUMBER := 1.0
55: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
56: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
57: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
58: ,p_validation_level IN VARCHAR2 := 100
59: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
60: ,p_debug_mode IN VARCHAR2 := 'N'
53: Procedure Task_Stat_Pushdown_Rollup(
54: p_api_version IN NUMBER := 1.0
55: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
56: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
57: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
58: ,p_validation_level IN VARCHAR2 := 100
59: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
60: ,p_debug_mode IN VARCHAR2 := 'N'
61: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
70: -- Pre-reqs : None
71: -- Return Value : N/A
72: -- Prameters
73: -- p_api_version IN NUMBER := 1.0
74: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
75: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
76: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
77: -- p_validation_level IN VARCHAR2 := 100
78: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
71: -- Return Value : N/A
72: -- Prameters
73: -- p_api_version IN NUMBER := 1.0
74: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
75: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
76: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
77: -- p_validation_level IN VARCHAR2 := 100
78: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
79: -- p_debug_mode IN VARCHAR2 := 'N'
72: -- Prameters
73: -- p_api_version IN NUMBER := 1.0
74: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
75: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
76: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
77: -- p_validation_level IN VARCHAR2 := 100
78: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
79: -- p_debug_mode IN VARCHAR2 := 'N'
80: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
85: --
86: --
87: PROCEDURE Rollup_From_Subproject(
88: p_api_version IN NUMBER := 1.0
89: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
90: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
91: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
92: ,p_validation_level IN VARCHAR2 := 100
93: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
86: --
87: PROCEDURE Rollup_From_Subproject(
88: p_api_version IN NUMBER := 1.0
89: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
90: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
91: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
92: ,p_validation_level IN VARCHAR2 := 100
93: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
94: ,p_debug_mode IN VARCHAR2 := 'N'
87: PROCEDURE Rollup_From_Subproject(
88: p_api_version IN NUMBER := 1.0
89: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
90: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
91: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
92: ,p_validation_level IN VARCHAR2 := 100
93: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
94: ,p_debug_mode IN VARCHAR2 := 'N'
95: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
105: -- Pre-reqs : None
106: -- Return Value : N/A
107: -- Prameters
108: -- p_api_version IN NUMBER := 1.0
109: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
110: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
111: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
112: -- p_validation_level IN VARCHAR2 := 100
113: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
106: -- Return Value : N/A
107: -- Prameters
108: -- p_api_version IN NUMBER := 1.0
109: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
110: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
111: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
112: -- p_validation_level IN VARCHAR2 := 100
113: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
114: -- p_debug_mode IN VARCHAR2 := 'N'
107: -- Prameters
108: -- p_api_version IN NUMBER := 1.0
109: -- p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
110: -- p_commit IN VARCHAR2 := FND_API.G_FALSE
111: -- p_validate_only IN VARCHAR2 := FND_API.G_TRUE
112: -- p_validation_level IN VARCHAR2 := 100
113: -- p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
114: -- p_debug_mode IN VARCHAR2 := 'N'
115: -- p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM
120: --
121: --
122: PROCEDURE Program_Schedule_dates_rollup(
123: p_api_version IN NUMBER := 1.0
124: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
125: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
126: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
127: ,p_validation_level IN VARCHAR2 := 100
128: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
121: --
122: PROCEDURE Program_Schedule_dates_rollup(
123: p_api_version IN NUMBER := 1.0
124: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
125: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
126: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
127: ,p_validation_level IN VARCHAR2 := 100
128: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
129: ,p_debug_mode IN VARCHAR2 := 'N'
122: PROCEDURE Program_Schedule_dates_rollup(
123: p_api_version IN NUMBER := 1.0
124: ,p_init_msg_list IN VARCHAR2 := FND_API.G_TRUE
125: ,p_commit IN VARCHAR2 := FND_API.G_FALSE
126: ,p_validate_only IN VARCHAR2 := FND_API.G_TRUE
127: ,p_validation_level IN VARCHAR2 := 100
128: ,p_calling_module IN VARCHAR2 := 'SELF_SERVICE'
129: ,p_debug_mode IN VARCHAR2 := 'N'
130: ,p_max_msg_count IN NUMBER := PA_INTERFACE_UTILS_PUB.G_PA_MISS_NUM