DBA Data[Home] [Help]

APPS.AMS_PROD_TEMPLATE_PVT_W dependencies on FND_API

Line 37: , p7_a1 DATE := fnd_api.g_miss_date

33: , x_msg_count OUT NOCOPY NUMBER
34: , x_msg_data OUT NOCOPY VARCHAR2
35: , x_template_id OUT NOCOPY NUMBER
36: , p7_a0 NUMBER := 0-1962.0724
37: , p7_a1 DATE := fnd_api.g_miss_date
38: , p7_a2 NUMBER := 0-1962.0724
39: , p7_a3 DATE := fnd_api.g_miss_date
40: , p7_a4 NUMBER := 0-1962.0724
41: , p7_a5 NUMBER := 0-1962.0724

Line 39: , p7_a3 DATE := fnd_api.g_miss_date

35: , x_template_id OUT NOCOPY NUMBER
36: , p7_a0 NUMBER := 0-1962.0724
37: , p7_a1 DATE := fnd_api.g_miss_date
38: , p7_a2 NUMBER := 0-1962.0724
39: , p7_a3 DATE := fnd_api.g_miss_date
40: , p7_a4 NUMBER := 0-1962.0724
41: , p7_a5 NUMBER := 0-1962.0724
42: , p7_a6 NUMBER := 0-1962.0724
43: , p7_a7 NUMBER := 0-1962.0724

Line 44: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

40: , p7_a4 NUMBER := 0-1962.0724
41: , p7_a5 NUMBER := 0-1962.0724
42: , p7_a6 NUMBER := 0-1962.0724
43: , p7_a7 NUMBER := 0-1962.0724
44: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
47: );
48: procedure update_prod_template(p_api_version_number NUMBER

Line 45: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

41: , p7_a5 NUMBER := 0-1962.0724
42: , p7_a6 NUMBER := 0-1962.0724
43: , p7_a7 NUMBER := 0-1962.0724
44: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
47: );
48: procedure update_prod_template(p_api_version_number NUMBER
49: , p_init_msg_list VARCHAR2

Line 46: , p7_a10 VARCHAR2 := fnd_api.g_miss_char

42: , p7_a6 NUMBER := 0-1962.0724
43: , p7_a7 NUMBER := 0-1962.0724
44: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
47: );
48: procedure update_prod_template(p_api_version_number NUMBER
49: , p_init_msg_list VARCHAR2
50: , p_commit VARCHAR2

Line 56: , p7_a1 DATE := fnd_api.g_miss_date

52: , x_return_status OUT NOCOPY VARCHAR2
53: , x_msg_count OUT NOCOPY NUMBER
54: , x_msg_data OUT NOCOPY VARCHAR2
55: , p7_a0 NUMBER := 0-1962.0724
56: , p7_a1 DATE := fnd_api.g_miss_date
57: , p7_a2 NUMBER := 0-1962.0724
58: , p7_a3 DATE := fnd_api.g_miss_date
59: , p7_a4 NUMBER := 0-1962.0724
60: , p7_a5 NUMBER := 0-1962.0724

Line 58: , p7_a3 DATE := fnd_api.g_miss_date

54: , x_msg_data OUT NOCOPY VARCHAR2
55: , p7_a0 NUMBER := 0-1962.0724
56: , p7_a1 DATE := fnd_api.g_miss_date
57: , p7_a2 NUMBER := 0-1962.0724
58: , p7_a3 DATE := fnd_api.g_miss_date
59: , p7_a4 NUMBER := 0-1962.0724
60: , p7_a5 NUMBER := 0-1962.0724
61: , p7_a6 NUMBER := 0-1962.0724
62: , p7_a7 NUMBER := 0-1962.0724

Line 63: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

59: , p7_a4 NUMBER := 0-1962.0724
60: , p7_a5 NUMBER := 0-1962.0724
61: , p7_a6 NUMBER := 0-1962.0724
62: , p7_a7 NUMBER := 0-1962.0724
63: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
64: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
65: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
66: );
67: procedure validate_prod_template(p_api_version_number NUMBER

Line 64: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

60: , p7_a5 NUMBER := 0-1962.0724
61: , p7_a6 NUMBER := 0-1962.0724
62: , p7_a7 NUMBER := 0-1962.0724
63: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
64: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
65: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
66: );
67: procedure validate_prod_template(p_api_version_number NUMBER
68: , p_init_msg_list VARCHAR2

Line 65: , p7_a10 VARCHAR2 := fnd_api.g_miss_char

61: , p7_a6 NUMBER := 0-1962.0724
62: , p7_a7 NUMBER := 0-1962.0724
63: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
64: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
65: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
66: );
67: procedure validate_prod_template(p_api_version_number NUMBER
68: , p_init_msg_list VARCHAR2
69: , p_validation_level NUMBER

Line 75: , p3_a1 DATE := fnd_api.g_miss_date

71: , x_return_status OUT NOCOPY VARCHAR2
72: , x_msg_count OUT NOCOPY NUMBER
73: , x_msg_data OUT NOCOPY VARCHAR2
74: , p3_a0 NUMBER := 0-1962.0724
75: , p3_a1 DATE := fnd_api.g_miss_date
76: , p3_a2 NUMBER := 0-1962.0724
77: , p3_a3 DATE := fnd_api.g_miss_date
78: , p3_a4 NUMBER := 0-1962.0724
79: , p3_a5 NUMBER := 0-1962.0724

Line 77: , p3_a3 DATE := fnd_api.g_miss_date

73: , x_msg_data OUT NOCOPY VARCHAR2
74: , p3_a0 NUMBER := 0-1962.0724
75: , p3_a1 DATE := fnd_api.g_miss_date
76: , p3_a2 NUMBER := 0-1962.0724
77: , p3_a3 DATE := fnd_api.g_miss_date
78: , p3_a4 NUMBER := 0-1962.0724
79: , p3_a5 NUMBER := 0-1962.0724
80: , p3_a6 NUMBER := 0-1962.0724
81: , p3_a7 NUMBER := 0-1962.0724

Line 82: , p3_a8 VARCHAR2 := fnd_api.g_miss_char

78: , p3_a4 NUMBER := 0-1962.0724
79: , p3_a5 NUMBER := 0-1962.0724
80: , p3_a6 NUMBER := 0-1962.0724
81: , p3_a7 NUMBER := 0-1962.0724
82: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
83: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
84: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
85: );
86: procedure check_prod_template_items(p_validation_mode VARCHAR2

Line 83: , p3_a9 VARCHAR2 := fnd_api.g_miss_char

79: , p3_a5 NUMBER := 0-1962.0724
80: , p3_a6 NUMBER := 0-1962.0724
81: , p3_a7 NUMBER := 0-1962.0724
82: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
83: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
84: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
85: );
86: procedure check_prod_template_items(p_validation_mode VARCHAR2
87: , x_return_status OUT NOCOPY VARCHAR2

Line 84: , p3_a10 VARCHAR2 := fnd_api.g_miss_char

80: , p3_a6 NUMBER := 0-1962.0724
81: , p3_a7 NUMBER := 0-1962.0724
82: , p3_a8 VARCHAR2 := fnd_api.g_miss_char
83: , p3_a9 VARCHAR2 := fnd_api.g_miss_char
84: , p3_a10 VARCHAR2 := fnd_api.g_miss_char
85: );
86: procedure check_prod_template_items(p_validation_mode VARCHAR2
87: , x_return_status OUT NOCOPY VARCHAR2
88: , p0_a0 NUMBER := 0-1962.0724

Line 89: , p0_a1 DATE := fnd_api.g_miss_date

85: );
86: procedure check_prod_template_items(p_validation_mode VARCHAR2
87: , x_return_status OUT NOCOPY VARCHAR2
88: , p0_a0 NUMBER := 0-1962.0724
89: , p0_a1 DATE := fnd_api.g_miss_date
90: , p0_a2 NUMBER := 0-1962.0724
91: , p0_a3 DATE := fnd_api.g_miss_date
92: , p0_a4 NUMBER := 0-1962.0724
93: , p0_a5 NUMBER := 0-1962.0724

Line 91: , p0_a3 DATE := fnd_api.g_miss_date

87: , x_return_status OUT NOCOPY VARCHAR2
88: , p0_a0 NUMBER := 0-1962.0724
89: , p0_a1 DATE := fnd_api.g_miss_date
90: , p0_a2 NUMBER := 0-1962.0724
91: , p0_a3 DATE := fnd_api.g_miss_date
92: , p0_a4 NUMBER := 0-1962.0724
93: , p0_a5 NUMBER := 0-1962.0724
94: , p0_a6 NUMBER := 0-1962.0724
95: , p0_a7 NUMBER := 0-1962.0724

Line 96: , p0_a8 VARCHAR2 := fnd_api.g_miss_char

92: , p0_a4 NUMBER := 0-1962.0724
93: , p0_a5 NUMBER := 0-1962.0724
94: , p0_a6 NUMBER := 0-1962.0724
95: , p0_a7 NUMBER := 0-1962.0724
96: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
97: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
98: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
99: );
100: procedure validate_prod_template_rec(p_api_version_number NUMBER

Line 97: , p0_a9 VARCHAR2 := fnd_api.g_miss_char

93: , p0_a5 NUMBER := 0-1962.0724
94: , p0_a6 NUMBER := 0-1962.0724
95: , p0_a7 NUMBER := 0-1962.0724
96: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
97: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
98: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
99: );
100: procedure validate_prod_template_rec(p_api_version_number NUMBER
101: , p_init_msg_list VARCHAR2

Line 98: , p0_a10 VARCHAR2 := fnd_api.g_miss_char

94: , p0_a6 NUMBER := 0-1962.0724
95: , p0_a7 NUMBER := 0-1962.0724
96: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
97: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
98: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
99: );
100: procedure validate_prod_template_rec(p_api_version_number NUMBER
101: , p_init_msg_list VARCHAR2
102: , x_return_status OUT NOCOPY VARCHAR2

Line 106: , p5_a1 DATE := fnd_api.g_miss_date

102: , x_return_status OUT NOCOPY VARCHAR2
103: , x_msg_count OUT NOCOPY NUMBER
104: , x_msg_data OUT NOCOPY VARCHAR2
105: , p5_a0 NUMBER := 0-1962.0724
106: , p5_a1 DATE := fnd_api.g_miss_date
107: , p5_a2 NUMBER := 0-1962.0724
108: , p5_a3 DATE := fnd_api.g_miss_date
109: , p5_a4 NUMBER := 0-1962.0724
110: , p5_a5 NUMBER := 0-1962.0724

Line 108: , p5_a3 DATE := fnd_api.g_miss_date

104: , x_msg_data OUT NOCOPY VARCHAR2
105: , p5_a0 NUMBER := 0-1962.0724
106: , p5_a1 DATE := fnd_api.g_miss_date
107: , p5_a2 NUMBER := 0-1962.0724
108: , p5_a3 DATE := fnd_api.g_miss_date
109: , p5_a4 NUMBER := 0-1962.0724
110: , p5_a5 NUMBER := 0-1962.0724
111: , p5_a6 NUMBER := 0-1962.0724
112: , p5_a7 NUMBER := 0-1962.0724

Line 113: , p5_a8 VARCHAR2 := fnd_api.g_miss_char

109: , p5_a4 NUMBER := 0-1962.0724
110: , p5_a5 NUMBER := 0-1962.0724
111: , p5_a6 NUMBER := 0-1962.0724
112: , p5_a7 NUMBER := 0-1962.0724
113: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
114: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
115: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
116: );
117: end ams_prod_template_pvt_w;

Line 114: , p5_a9 VARCHAR2 := fnd_api.g_miss_char

110: , p5_a5 NUMBER := 0-1962.0724
111: , p5_a6 NUMBER := 0-1962.0724
112: , p5_a7 NUMBER := 0-1962.0724
113: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
114: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
115: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
116: );
117: end ams_prod_template_pvt_w;

Line 115: , p5_a10 VARCHAR2 := fnd_api.g_miss_char

111: , p5_a6 NUMBER := 0-1962.0724
112: , p5_a7 NUMBER := 0-1962.0724
113: , p5_a8 VARCHAR2 := fnd_api.g_miss_char
114: , p5_a9 VARCHAR2 := fnd_api.g_miss_char
115: , p5_a10 VARCHAR2 := fnd_api.g_miss_char
116: );
117: end ams_prod_template_pvt_w;