49: , x_msg_count out nocopy NUMBER
50: , x_msg_data out nocopy VARCHAR2
51: , x_scorecard_id out nocopy NUMBER
52: , p7_a0 NUMBER := 0-1962.0724
53: , p7_a1 DATE := fnd_api.g_miss_date
54: , p7_a2 NUMBER := 0-1962.0724
55: , p7_a3 DATE := fnd_api.g_miss_date
56: , p7_a4 NUMBER := 0-1962.0724
57: , p7_a5 NUMBER := 0-1962.0724
51: , x_scorecard_id out nocopy NUMBER
52: , p7_a0 NUMBER := 0-1962.0724
53: , p7_a1 DATE := fnd_api.g_miss_date
54: , p7_a2 NUMBER := 0-1962.0724
55: , p7_a3 DATE := fnd_api.g_miss_date
56: , p7_a4 NUMBER := 0-1962.0724
57: , p7_a5 NUMBER := 0-1962.0724
58: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
59: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a2 NUMBER := 0-1962.0724
55: , p7_a3 DATE := fnd_api.g_miss_date
56: , p7_a4 NUMBER := 0-1962.0724
57: , p7_a5 NUMBER := 0-1962.0724
58: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
59: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
60: , p7_a8 DATE := fnd_api.g_miss_date
61: , p7_a9 DATE := fnd_api.g_miss_date
62: );
55: , p7_a3 DATE := fnd_api.g_miss_date
56: , p7_a4 NUMBER := 0-1962.0724
57: , p7_a5 NUMBER := 0-1962.0724
58: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
59: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
60: , p7_a8 DATE := fnd_api.g_miss_date
61: , p7_a9 DATE := fnd_api.g_miss_date
62: );
63: procedure update_scorecard(p_api_version NUMBER
56: , p7_a4 NUMBER := 0-1962.0724
57: , p7_a5 NUMBER := 0-1962.0724
58: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
59: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
60: , p7_a8 DATE := fnd_api.g_miss_date
61: , p7_a9 DATE := fnd_api.g_miss_date
62: );
63: procedure update_scorecard(p_api_version NUMBER
64: , p_init_msg_list VARCHAR2
57: , p7_a5 NUMBER := 0-1962.0724
58: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
59: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
60: , p7_a8 DATE := fnd_api.g_miss_date
61: , p7_a9 DATE := fnd_api.g_miss_date
62: );
63: procedure update_scorecard(p_api_version NUMBER
64: , p_init_msg_list VARCHAR2
65: , p_commit VARCHAR2
67: , x_return_status out nocopy VARCHAR2
68: , x_msg_count out nocopy NUMBER
69: , x_msg_data out nocopy VARCHAR2
70: , p7_a0 NUMBER := 0-1962.0724
71: , p7_a1 DATE := fnd_api.g_miss_date
72: , p7_a2 NUMBER := 0-1962.0724
73: , p7_a3 DATE := fnd_api.g_miss_date
74: , p7_a4 NUMBER := 0-1962.0724
75: , p7_a5 NUMBER := 0-1962.0724
69: , x_msg_data out nocopy VARCHAR2
70: , p7_a0 NUMBER := 0-1962.0724
71: , p7_a1 DATE := fnd_api.g_miss_date
72: , p7_a2 NUMBER := 0-1962.0724
73: , p7_a3 DATE := fnd_api.g_miss_date
74: , p7_a4 NUMBER := 0-1962.0724
75: , p7_a5 NUMBER := 0-1962.0724
76: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
77: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
72: , p7_a2 NUMBER := 0-1962.0724
73: , p7_a3 DATE := fnd_api.g_miss_date
74: , p7_a4 NUMBER := 0-1962.0724
75: , p7_a5 NUMBER := 0-1962.0724
76: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
77: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
78: , p7_a8 DATE := fnd_api.g_miss_date
79: , p7_a9 DATE := fnd_api.g_miss_date
80: );
73: , p7_a3 DATE := fnd_api.g_miss_date
74: , p7_a4 NUMBER := 0-1962.0724
75: , p7_a5 NUMBER := 0-1962.0724
76: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
77: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
78: , p7_a8 DATE := fnd_api.g_miss_date
79: , p7_a9 DATE := fnd_api.g_miss_date
80: );
81: procedure create_cardrule_qual(p_api_version NUMBER
74: , p7_a4 NUMBER := 0-1962.0724
75: , p7_a5 NUMBER := 0-1962.0724
76: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
77: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
78: , p7_a8 DATE := fnd_api.g_miss_date
79: , p7_a9 DATE := fnd_api.g_miss_date
80: );
81: procedure create_cardrule_qual(p_api_version NUMBER
82: , p_init_msg_list VARCHAR2
75: , p7_a5 NUMBER := 0-1962.0724
76: , p7_a6 VARCHAR2 := fnd_api.g_miss_char
77: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
78: , p7_a8 DATE := fnd_api.g_miss_date
79: , p7_a9 DATE := fnd_api.g_miss_date
80: );
81: procedure create_cardrule_qual(p_api_version NUMBER
82: , p_init_msg_list VARCHAR2
83: , p_commit VARCHAR2
86: , x_msg_count out nocopy NUMBER
87: , x_msg_data out nocopy VARCHAR2
88: , x_qual_value_id out nocopy NUMBER
89: , p7_a0 NUMBER := 0-1962.0724
90: , p7_a1 DATE := fnd_api.g_miss_date
91: , p7_a2 NUMBER := 0-1962.0724
92: , p7_a3 DATE := fnd_api.g_miss_date
93: , p7_a4 NUMBER := 0-1962.0724
94: , p7_a5 NUMBER := 0-1962.0724
88: , x_qual_value_id out nocopy NUMBER
89: , p7_a0 NUMBER := 0-1962.0724
90: , p7_a1 DATE := fnd_api.g_miss_date
91: , p7_a2 NUMBER := 0-1962.0724
92: , p7_a3 DATE := fnd_api.g_miss_date
93: , p7_a4 NUMBER := 0-1962.0724
94: , p7_a5 NUMBER := 0-1962.0724
95: , p7_a6 NUMBER := 0-1962.0724
96: , p7_a7 NUMBER := 0-1962.0724
97: , p7_a8 NUMBER := 0-1962.0724
98: , p7_a9 NUMBER := 0-1962.0724
99: , p7_a10 NUMBER := 0-1962.0724
100: , p7_a11 NUMBER := 0-1962.0724
101: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
102: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
103: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
104: , p7_a15 DATE := fnd_api.g_miss_date
105: , p7_a16 DATE := fnd_api.g_miss_date
98: , p7_a9 NUMBER := 0-1962.0724
99: , p7_a10 NUMBER := 0-1962.0724
100: , p7_a11 NUMBER := 0-1962.0724
101: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
102: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
103: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
104: , p7_a15 DATE := fnd_api.g_miss_date
105: , p7_a16 DATE := fnd_api.g_miss_date
106: , p7_a17 DATE := fnd_api.g_miss_date
99: , p7_a10 NUMBER := 0-1962.0724
100: , p7_a11 NUMBER := 0-1962.0724
101: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
102: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
103: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
104: , p7_a15 DATE := fnd_api.g_miss_date
105: , p7_a16 DATE := fnd_api.g_miss_date
106: , p7_a17 DATE := fnd_api.g_miss_date
107: , p7_a18 DATE := fnd_api.g_miss_date
100: , p7_a11 NUMBER := 0-1962.0724
101: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
102: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
103: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
104: , p7_a15 DATE := fnd_api.g_miss_date
105: , p7_a16 DATE := fnd_api.g_miss_date
106: , p7_a17 DATE := fnd_api.g_miss_date
107: , p7_a18 DATE := fnd_api.g_miss_date
108: );
101: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
102: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
103: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
104: , p7_a15 DATE := fnd_api.g_miss_date
105: , p7_a16 DATE := fnd_api.g_miss_date
106: , p7_a17 DATE := fnd_api.g_miss_date
107: , p7_a18 DATE := fnd_api.g_miss_date
108: );
109: procedure update_cardrule_qual(p_api_version NUMBER
102: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
103: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
104: , p7_a15 DATE := fnd_api.g_miss_date
105: , p7_a16 DATE := fnd_api.g_miss_date
106: , p7_a17 DATE := fnd_api.g_miss_date
107: , p7_a18 DATE := fnd_api.g_miss_date
108: );
109: procedure update_cardrule_qual(p_api_version NUMBER
110: , p_init_msg_list VARCHAR2
103: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
104: , p7_a15 DATE := fnd_api.g_miss_date
105: , p7_a16 DATE := fnd_api.g_miss_date
106: , p7_a17 DATE := fnd_api.g_miss_date
107: , p7_a18 DATE := fnd_api.g_miss_date
108: );
109: procedure update_cardrule_qual(p_api_version NUMBER
110: , p_init_msg_list VARCHAR2
111: , p_commit VARCHAR2
113: , x_return_status out nocopy VARCHAR2
114: , x_msg_count out nocopy NUMBER
115: , x_msg_data out nocopy VARCHAR2
116: , p7_a0 NUMBER := 0-1962.0724
117: , p7_a1 DATE := fnd_api.g_miss_date
118: , p7_a2 NUMBER := 0-1962.0724
119: , p7_a3 DATE := fnd_api.g_miss_date
120: , p7_a4 NUMBER := 0-1962.0724
121: , p7_a5 NUMBER := 0-1962.0724
115: , x_msg_data out nocopy VARCHAR2
116: , p7_a0 NUMBER := 0-1962.0724
117: , p7_a1 DATE := fnd_api.g_miss_date
118: , p7_a2 NUMBER := 0-1962.0724
119: , p7_a3 DATE := fnd_api.g_miss_date
120: , p7_a4 NUMBER := 0-1962.0724
121: , p7_a5 NUMBER := 0-1962.0724
122: , p7_a6 NUMBER := 0-1962.0724
123: , p7_a7 NUMBER := 0-1962.0724
124: , p7_a8 NUMBER := 0-1962.0724
125: , p7_a9 NUMBER := 0-1962.0724
126: , p7_a10 NUMBER := 0-1962.0724
127: , p7_a11 NUMBER := 0-1962.0724
128: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
129: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
130: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
131: , p7_a15 DATE := fnd_api.g_miss_date
132: , p7_a16 DATE := fnd_api.g_miss_date
125: , p7_a9 NUMBER := 0-1962.0724
126: , p7_a10 NUMBER := 0-1962.0724
127: , p7_a11 NUMBER := 0-1962.0724
128: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
129: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
130: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
131: , p7_a15 DATE := fnd_api.g_miss_date
132: , p7_a16 DATE := fnd_api.g_miss_date
133: , p7_a17 DATE := fnd_api.g_miss_date
126: , p7_a10 NUMBER := 0-1962.0724
127: , p7_a11 NUMBER := 0-1962.0724
128: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
129: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
130: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
131: , p7_a15 DATE := fnd_api.g_miss_date
132: , p7_a16 DATE := fnd_api.g_miss_date
133: , p7_a17 DATE := fnd_api.g_miss_date
134: , p7_a18 DATE := fnd_api.g_miss_date
127: , p7_a11 NUMBER := 0-1962.0724
128: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
129: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
130: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
131: , p7_a15 DATE := fnd_api.g_miss_date
132: , p7_a16 DATE := fnd_api.g_miss_date
133: , p7_a17 DATE := fnd_api.g_miss_date
134: , p7_a18 DATE := fnd_api.g_miss_date
135: );
128: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
129: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
130: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
131: , p7_a15 DATE := fnd_api.g_miss_date
132: , p7_a16 DATE := fnd_api.g_miss_date
133: , p7_a17 DATE := fnd_api.g_miss_date
134: , p7_a18 DATE := fnd_api.g_miss_date
135: );
136: end as_scorecard_rules_pub_w;
129: , p7_a13 VARCHAR2 := fnd_api.g_miss_char
130: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
131: , p7_a15 DATE := fnd_api.g_miss_date
132: , p7_a16 DATE := fnd_api.g_miss_date
133: , p7_a17 DATE := fnd_api.g_miss_date
134: , p7_a18 DATE := fnd_api.g_miss_date
135: );
136: end as_scorecard_rules_pub_w;
130: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
131: , p7_a15 DATE := fnd_api.g_miss_date
132: , p7_a16 DATE := fnd_api.g_miss_date
133: , p7_a17 DATE := fnd_api.g_miss_date
134: , p7_a18 DATE := fnd_api.g_miss_date
135: );
136: end as_scorecard_rules_pub_w;