DBA Data[Home] [Help]

APPS.AMS_DM_TARGET_PVT_W dependencies on FND_API

Line 43: , p7_a1 DATE := fnd_api.g_miss_date

39: , x_msg_count out nocopy NUMBER
40: , x_msg_data out nocopy VARCHAR2
41: , x_target_id out nocopy NUMBER
42: , p7_a0 NUMBER := 0-1962.0724
43: , p7_a1 DATE := fnd_api.g_miss_date
44: , p7_a2 NUMBER := 0-1962.0724
45: , p7_a3 DATE := fnd_api.g_miss_date
46: , p7_a4 NUMBER := 0-1962.0724
47: , p7_a5 NUMBER := 0-1962.0724

Line 45: , p7_a3 DATE := fnd_api.g_miss_date

41: , x_target_id out nocopy NUMBER
42: , p7_a0 NUMBER := 0-1962.0724
43: , p7_a1 DATE := fnd_api.g_miss_date
44: , p7_a2 NUMBER := 0-1962.0724
45: , p7_a3 DATE := fnd_api.g_miss_date
46: , p7_a4 NUMBER := 0-1962.0724
47: , p7_a5 NUMBER := 0-1962.0724
48: , p7_a6 NUMBER := 0-1962.0724
49: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

Line 49: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

45: , p7_a3 DATE := fnd_api.g_miss_date
46: , p7_a4 NUMBER := 0-1962.0724
47: , p7_a5 NUMBER := 0-1962.0724
48: , p7_a6 NUMBER := 0-1962.0724
49: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
51: , p7_a9 NUMBER := 0-1962.0724
52: , p7_a10 NUMBER := 0-1962.0724
53: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

Line 50: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

46: , p7_a4 NUMBER := 0-1962.0724
47: , p7_a5 NUMBER := 0-1962.0724
48: , p7_a6 NUMBER := 0-1962.0724
49: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
51: , p7_a9 NUMBER := 0-1962.0724
52: , p7_a10 NUMBER := 0-1962.0724
53: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

Line 53: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

49: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
51: , p7_a9 NUMBER := 0-1962.0724
52: , p7_a10 NUMBER := 0-1962.0724
53: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
55: , p7_a13 NUMBER := 0-1962.0724
56: );
57: procedure update_dmtarget(p_api_version_number NUMBER

Line 54: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

50: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
51: , p7_a9 NUMBER := 0-1962.0724
52: , p7_a10 NUMBER := 0-1962.0724
53: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
54: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
55: , p7_a13 NUMBER := 0-1962.0724
56: );
57: procedure update_dmtarget(p_api_version_number NUMBER
58: , p_init_msg_list VARCHAR2

Line 66: , p7_a1 DATE := fnd_api.g_miss_date

62: , x_msg_count out nocopy NUMBER
63: , x_msg_data out nocopy VARCHAR2
64: , x_object_version_number out nocopy NUMBER
65: , p7_a0 NUMBER := 0-1962.0724
66: , p7_a1 DATE := fnd_api.g_miss_date
67: , p7_a2 NUMBER := 0-1962.0724
68: , p7_a3 DATE := fnd_api.g_miss_date
69: , p7_a4 NUMBER := 0-1962.0724
70: , p7_a5 NUMBER := 0-1962.0724

Line 68: , p7_a3 DATE := fnd_api.g_miss_date

64: , x_object_version_number out nocopy NUMBER
65: , p7_a0 NUMBER := 0-1962.0724
66: , p7_a1 DATE := fnd_api.g_miss_date
67: , p7_a2 NUMBER := 0-1962.0724
68: , p7_a3 DATE := fnd_api.g_miss_date
69: , p7_a4 NUMBER := 0-1962.0724
70: , p7_a5 NUMBER := 0-1962.0724
71: , p7_a6 NUMBER := 0-1962.0724
72: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

Line 72: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

68: , p7_a3 DATE := fnd_api.g_miss_date
69: , p7_a4 NUMBER := 0-1962.0724
70: , p7_a5 NUMBER := 0-1962.0724
71: , p7_a6 NUMBER := 0-1962.0724
72: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
73: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
74: , p7_a9 NUMBER := 0-1962.0724
75: , p7_a10 NUMBER := 0-1962.0724
76: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

Line 73: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

69: , p7_a4 NUMBER := 0-1962.0724
70: , p7_a5 NUMBER := 0-1962.0724
71: , p7_a6 NUMBER := 0-1962.0724
72: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
73: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
74: , p7_a9 NUMBER := 0-1962.0724
75: , p7_a10 NUMBER := 0-1962.0724
76: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
77: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

Line 76: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

72: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
73: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
74: , p7_a9 NUMBER := 0-1962.0724
75: , p7_a10 NUMBER := 0-1962.0724
76: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
77: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
78: , p7_a13 NUMBER := 0-1962.0724
79: );
80: procedure validate_dmtarget(p_api_version_number NUMBER

Line 77: , p7_a12 VARCHAR2 := fnd_api.g_miss_char

73: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
74: , p7_a9 NUMBER := 0-1962.0724
75: , p7_a10 NUMBER := 0-1962.0724
76: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
77: , p7_a12 VARCHAR2 := fnd_api.g_miss_char
78: , p7_a13 NUMBER := 0-1962.0724
79: );
80: procedure validate_dmtarget(p_api_version_number NUMBER
81: , p_init_msg_list VARCHAR2

Line 88: , p3_a1 DATE := fnd_api.g_miss_date

84: , x_return_status out nocopy VARCHAR2
85: , x_msg_count out nocopy NUMBER
86: , x_msg_data out nocopy VARCHAR2
87: , p3_a0 NUMBER := 0-1962.0724
88: , p3_a1 DATE := fnd_api.g_miss_date
89: , p3_a2 NUMBER := 0-1962.0724
90: , p3_a3 DATE := fnd_api.g_miss_date
91: , p3_a4 NUMBER := 0-1962.0724
92: , p3_a5 NUMBER := 0-1962.0724

Line 90: , p3_a3 DATE := fnd_api.g_miss_date

86: , x_msg_data out nocopy VARCHAR2
87: , p3_a0 NUMBER := 0-1962.0724
88: , p3_a1 DATE := fnd_api.g_miss_date
89: , p3_a2 NUMBER := 0-1962.0724
90: , p3_a3 DATE := fnd_api.g_miss_date
91: , p3_a4 NUMBER := 0-1962.0724
92: , p3_a5 NUMBER := 0-1962.0724
93: , p3_a6 NUMBER := 0-1962.0724
94: , p3_a7 VARCHAR2 := fnd_api.g_miss_char

Line 94: , p3_a7 VARCHAR2 := fnd_api.g_miss_char

90: , p3_a3 DATE := fnd_api.g_miss_date
91: , p3_a4 NUMBER := 0-1962.0724
92: , p3_a5 NUMBER := 0-1962.0724
93: , p3_a6 NUMBER := 0-1962.0724
94: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
95: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
96: , p3_a9 NUMBER := 0-1962.0724
97: , p3_a10 NUMBER := 0-1962.0724
98: , p3_a11 VARCHAR2 := fnd_api.g_miss_char

Line 95: , p3_a8 VARCHAR2 := fnd_api.g_miss_char

91: , p3_a4 NUMBER := 0-1962.0724
92: , p3_a5 NUMBER := 0-1962.0724
93: , p3_a6 NUMBER := 0-1962.0724
94: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
95: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
96: , p3_a9 NUMBER := 0-1962.0724
97: , p3_a10 NUMBER := 0-1962.0724
98: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
99: , p3_a12 VARCHAR2 := fnd_api.g_miss_char

Line 98: , p3_a11 VARCHAR2 := fnd_api.g_miss_char

94: , p3_a7 VARCHAR2 := fnd_api.g_miss_char
95: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
96: , p3_a9 NUMBER := 0-1962.0724
97: , p3_a10 NUMBER := 0-1962.0724
98: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
99: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
100: , p3_a13 NUMBER := 0-1962.0724
101: );
102: procedure check_dm_target_items(p_validation_mode VARCHAR2

Line 99: , p3_a12 VARCHAR2 := fnd_api.g_miss_char

95: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
96: , p3_a9 NUMBER := 0-1962.0724
97: , p3_a10 NUMBER := 0-1962.0724
98: , p3_a11 VARCHAR2 := fnd_api.g_miss_char
99: , p3_a12 VARCHAR2 := fnd_api.g_miss_char
100: , p3_a13 NUMBER := 0-1962.0724
101: );
102: procedure check_dm_target_items(p_validation_mode VARCHAR2
103: , x_return_status out nocopy VARCHAR2

Line 105: , p0_a1 DATE := fnd_api.g_miss_date

101: );
102: procedure check_dm_target_items(p_validation_mode VARCHAR2
103: , x_return_status out nocopy VARCHAR2
104: , p0_a0 NUMBER := 0-1962.0724
105: , p0_a1 DATE := fnd_api.g_miss_date
106: , p0_a2 NUMBER := 0-1962.0724
107: , p0_a3 DATE := fnd_api.g_miss_date
108: , p0_a4 NUMBER := 0-1962.0724
109: , p0_a5 NUMBER := 0-1962.0724

Line 107: , p0_a3 DATE := fnd_api.g_miss_date

103: , x_return_status out nocopy VARCHAR2
104: , p0_a0 NUMBER := 0-1962.0724
105: , p0_a1 DATE := fnd_api.g_miss_date
106: , p0_a2 NUMBER := 0-1962.0724
107: , p0_a3 DATE := fnd_api.g_miss_date
108: , p0_a4 NUMBER := 0-1962.0724
109: , p0_a5 NUMBER := 0-1962.0724
110: , p0_a6 NUMBER := 0-1962.0724
111: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

Line 111: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

107: , p0_a3 DATE := fnd_api.g_miss_date
108: , p0_a4 NUMBER := 0-1962.0724
109: , p0_a5 NUMBER := 0-1962.0724
110: , p0_a6 NUMBER := 0-1962.0724
111: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
112: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
113: , p0_a9 NUMBER := 0-1962.0724
114: , p0_a10 NUMBER := 0-1962.0724
115: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

Line 112: , p0_a8 VARCHAR2 := fnd_api.g_miss_char

108: , p0_a4 NUMBER := 0-1962.0724
109: , p0_a5 NUMBER := 0-1962.0724
110: , p0_a6 NUMBER := 0-1962.0724
111: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
112: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
113: , p0_a9 NUMBER := 0-1962.0724
114: , p0_a10 NUMBER := 0-1962.0724
115: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
116: , p0_a12 VARCHAR2 := fnd_api.g_miss_char

Line 115: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

111: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
112: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
113: , p0_a9 NUMBER := 0-1962.0724
114: , p0_a10 NUMBER := 0-1962.0724
115: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
116: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
117: , p0_a13 NUMBER := 0-1962.0724
118: );
119: procedure validate_dm_target_rec(p_api_version_number NUMBER

Line 116: , p0_a12 VARCHAR2 := fnd_api.g_miss_char

112: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
113: , p0_a9 NUMBER := 0-1962.0724
114: , p0_a10 NUMBER := 0-1962.0724
115: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
116: , p0_a12 VARCHAR2 := fnd_api.g_miss_char
117: , p0_a13 NUMBER := 0-1962.0724
118: );
119: procedure validate_dm_target_rec(p_api_version_number NUMBER
120: , p_init_msg_list VARCHAR2

Line 125: , p5_a1 DATE := fnd_api.g_miss_date

121: , x_return_status out nocopy VARCHAR2
122: , x_msg_count out nocopy NUMBER
123: , x_msg_data out nocopy VARCHAR2
124: , p5_a0 NUMBER := 0-1962.0724
125: , p5_a1 DATE := fnd_api.g_miss_date
126: , p5_a2 NUMBER := 0-1962.0724
127: , p5_a3 DATE := fnd_api.g_miss_date
128: , p5_a4 NUMBER := 0-1962.0724
129: , p5_a5 NUMBER := 0-1962.0724

Line 127: , p5_a3 DATE := fnd_api.g_miss_date

123: , x_msg_data out nocopy VARCHAR2
124: , p5_a0 NUMBER := 0-1962.0724
125: , p5_a1 DATE := fnd_api.g_miss_date
126: , p5_a2 NUMBER := 0-1962.0724
127: , p5_a3 DATE := fnd_api.g_miss_date
128: , p5_a4 NUMBER := 0-1962.0724
129: , p5_a5 NUMBER := 0-1962.0724
130: , p5_a6 NUMBER := 0-1962.0724
131: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

Line 131: , p5_a7 VARCHAR2 := fnd_api.g_miss_char

127: , p5_a3 DATE := fnd_api.g_miss_date
128: , p5_a4 NUMBER := 0-1962.0724
129: , p5_a5 NUMBER := 0-1962.0724
130: , p5_a6 NUMBER := 0-1962.0724
131: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
132: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
133: , p5_a9 NUMBER := 0-1962.0724
134: , p5_a10 NUMBER := 0-1962.0724
135: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

Line 132: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

128: , p5_a4 NUMBER := 0-1962.0724
129: , p5_a5 NUMBER := 0-1962.0724
130: , p5_a6 NUMBER := 0-1962.0724
131: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
132: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
133: , p5_a9 NUMBER := 0-1962.0724
134: , p5_a10 NUMBER := 0-1962.0724
135: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
136: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

Line 135: , p5_a11 VARCHAR2 := fnd_api.g_miss_char

131: , p5_a7 VARCHAR2 := fnd_api.g_miss_char
132: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
133: , p5_a9 NUMBER := 0-1962.0724
134: , p5_a10 NUMBER := 0-1962.0724
135: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
136: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
137: , p5_a13 NUMBER := 0-1962.0724
138: );
139: end ams_dm_target_pvt_w;

Line 136: , p5_a12 VARCHAR2 := fnd_api.g_miss_char

132: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
133: , p5_a9 NUMBER := 0-1962.0724
134: , p5_a10 NUMBER := 0-1962.0724
135: , p5_a11 VARCHAR2 := fnd_api.g_miss_char
136: , p5_a12 VARCHAR2 := fnd_api.g_miss_char
137: , p5_a13 NUMBER := 0-1962.0724
138: );
139: end ams_dm_target_pvt_w;