eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JTF_LOC_AREAS_PVT_W dependencies on FND_API

Line 12: , p7_a1 DATE := fnd_api.g_miss_date

8: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
9: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
10: , x_loc_area_id OUT NOCOPY /* file.sql.39 change */ NUMBER
11: , p7_a0 NUMBER := 0-1962.0724
12: , p7_a1 DATE := fnd_api.g_miss_date
13: , p7_a2 NUMBER := 0-1962.0724
14: , p7_a3 DATE := fnd_api.g_miss_date
15: , p7_a4 NUMBER := 0-1962.0724
16: , p7_a5 NUMBER := 0-1962.0724

Line 14: , p7_a3 DATE := fnd_api.g_miss_date

10: , x_loc_area_id OUT NOCOPY /* file.sql.39 change */ NUMBER
11: , p7_a0 NUMBER := 0-1962.0724
12: , p7_a1 DATE := fnd_api.g_miss_date
13: , p7_a2 NUMBER := 0-1962.0724
14: , p7_a3 DATE := fnd_api.g_miss_date
15: , p7_a4 NUMBER := 0-1962.0724
16: , p7_a5 NUMBER := 0-1962.0724
17: , p7_a6 NUMBER := 0-1962.0724
18: , p7_a7 NUMBER := 0-1962.0724

Line 21: , p7_a10 DATE := fnd_api.g_miss_date

17: , p7_a6 NUMBER := 0-1962.0724
18: , p7_a7 NUMBER := 0-1962.0724
19: , p7_a8 NUMBER := 0-1962.0724
20: , p7_a9 NUMBER := 0-1962.0724
21: , p7_a10 DATE := fnd_api.g_miss_date
22: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
23: , p7_a12 DATE := fnd_api.g_miss_date
24: , p7_a13 DATE := fnd_api.g_miss_date
25: , p7_a14 VARCHAR2 := fnd_api.g_miss_char

Line 22: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

18: , p7_a7 NUMBER := 0-1962.0724
19: , p7_a8 NUMBER := 0-1962.0724
20: , p7_a9 NUMBER := 0-1962.0724
21: , p7_a10 DATE := fnd_api.g_miss_date
22: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
23: , p7_a12 DATE := fnd_api.g_miss_date
24: , p7_a13 DATE := fnd_api.g_miss_date
25: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
26: , p7_a15 NUMBER := 0-1962.0724

Line 23: , p7_a12 DATE := fnd_api.g_miss_date

19: , p7_a8 NUMBER := 0-1962.0724
20: , p7_a9 NUMBER := 0-1962.0724
21: , p7_a10 DATE := fnd_api.g_miss_date
22: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
23: , p7_a12 DATE := fnd_api.g_miss_date
24: , p7_a13 DATE := fnd_api.g_miss_date
25: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
26: , p7_a15 NUMBER := 0-1962.0724
27: , p7_a16 VARCHAR2 := fnd_api.g_miss_char

Line 24: , p7_a13 DATE := fnd_api.g_miss_date

20: , p7_a9 NUMBER := 0-1962.0724
21: , p7_a10 DATE := fnd_api.g_miss_date
22: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
23: , p7_a12 DATE := fnd_api.g_miss_date
24: , p7_a13 DATE := fnd_api.g_miss_date
25: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
26: , p7_a15 NUMBER := 0-1962.0724
27: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
28: , p7_a17 NUMBER := 0-1962.0724

Line 25: , p7_a14 VARCHAR2 := fnd_api.g_miss_char

21: , p7_a10 DATE := fnd_api.g_miss_date
22: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
23: , p7_a12 DATE := fnd_api.g_miss_date
24: , p7_a13 DATE := fnd_api.g_miss_date
25: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
26: , p7_a15 NUMBER := 0-1962.0724
27: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
28: , p7_a17 NUMBER := 0-1962.0724
29: , p7_a18 VARCHAR2 := fnd_api.g_miss_char

Line 27: , p7_a16 VARCHAR2 := fnd_api.g_miss_char

23: , p7_a12 DATE := fnd_api.g_miss_date
24: , p7_a13 DATE := fnd_api.g_miss_date
25: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
26: , p7_a15 NUMBER := 0-1962.0724
27: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
28: , p7_a17 NUMBER := 0-1962.0724
29: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
30: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
31: );

Line 29: , p7_a18 VARCHAR2 := fnd_api.g_miss_char

25: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
26: , p7_a15 NUMBER := 0-1962.0724
27: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
28: , p7_a17 NUMBER := 0-1962.0724
29: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
30: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
31: );
32: procedure update_loc_area(p_api_version NUMBER
33: , p_init_msg_list VARCHAR2

Line 30: , p7_a19 VARCHAR2 := fnd_api.g_miss_char

26: , p7_a15 NUMBER := 0-1962.0724
27: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
28: , p7_a17 NUMBER := 0-1962.0724
29: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
30: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
31: );
32: procedure update_loc_area(p_api_version NUMBER
33: , p_init_msg_list VARCHAR2
34: , p_commit VARCHAR2

Line 41: , p7_a1 DATE := fnd_api.g_miss_date

37: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
38: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
39: , p_remove_flag VARCHAR2
40: , p7_a0 NUMBER := 0-1962.0724
41: , p7_a1 DATE := fnd_api.g_miss_date
42: , p7_a2 NUMBER := 0-1962.0724
43: , p7_a3 DATE := fnd_api.g_miss_date
44: , p7_a4 NUMBER := 0-1962.0724
45: , p7_a5 NUMBER := 0-1962.0724

Line 43: , p7_a3 DATE := fnd_api.g_miss_date

39: , p_remove_flag VARCHAR2
40: , p7_a0 NUMBER := 0-1962.0724
41: , p7_a1 DATE := fnd_api.g_miss_date
42: , p7_a2 NUMBER := 0-1962.0724
43: , p7_a3 DATE := fnd_api.g_miss_date
44: , p7_a4 NUMBER := 0-1962.0724
45: , p7_a5 NUMBER := 0-1962.0724
46: , p7_a6 NUMBER := 0-1962.0724
47: , p7_a7 NUMBER := 0-1962.0724

Line 50: , p7_a10 DATE := fnd_api.g_miss_date

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

Line 51: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

47: , p7_a7 NUMBER := 0-1962.0724
48: , p7_a8 NUMBER := 0-1962.0724
49: , p7_a9 NUMBER := 0-1962.0724
50: , p7_a10 DATE := fnd_api.g_miss_date
51: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
52: , p7_a12 DATE := fnd_api.g_miss_date
53: , p7_a13 DATE := fnd_api.g_miss_date
54: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
55: , p7_a15 NUMBER := 0-1962.0724

Line 52: , p7_a12 DATE := fnd_api.g_miss_date

48: , p7_a8 NUMBER := 0-1962.0724
49: , p7_a9 NUMBER := 0-1962.0724
50: , p7_a10 DATE := fnd_api.g_miss_date
51: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
52: , p7_a12 DATE := fnd_api.g_miss_date
53: , p7_a13 DATE := fnd_api.g_miss_date
54: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
55: , p7_a15 NUMBER := 0-1962.0724
56: , p7_a16 VARCHAR2 := fnd_api.g_miss_char

Line 53: , p7_a13 DATE := fnd_api.g_miss_date

49: , p7_a9 NUMBER := 0-1962.0724
50: , p7_a10 DATE := fnd_api.g_miss_date
51: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
52: , p7_a12 DATE := fnd_api.g_miss_date
53: , p7_a13 DATE := fnd_api.g_miss_date
54: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
55: , p7_a15 NUMBER := 0-1962.0724
56: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
57: , p7_a17 NUMBER := 0-1962.0724

Line 54: , p7_a14 VARCHAR2 := fnd_api.g_miss_char

50: , p7_a10 DATE := fnd_api.g_miss_date
51: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
52: , p7_a12 DATE := fnd_api.g_miss_date
53: , p7_a13 DATE := fnd_api.g_miss_date
54: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
55: , p7_a15 NUMBER := 0-1962.0724
56: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
57: , p7_a17 NUMBER := 0-1962.0724
58: , p7_a18 VARCHAR2 := fnd_api.g_miss_char

Line 56: , p7_a16 VARCHAR2 := fnd_api.g_miss_char

52: , p7_a12 DATE := fnd_api.g_miss_date
53: , p7_a13 DATE := fnd_api.g_miss_date
54: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
55: , p7_a15 NUMBER := 0-1962.0724
56: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
57: , p7_a17 NUMBER := 0-1962.0724
58: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
59: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
60: );

Line 58: , p7_a18 VARCHAR2 := fnd_api.g_miss_char

54: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
55: , p7_a15 NUMBER := 0-1962.0724
56: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
57: , p7_a17 NUMBER := 0-1962.0724
58: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
59: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
60: );
61: procedure validate_loc_area(p_api_version NUMBER
62: , p_init_msg_list VARCHAR2

Line 59: , p7_a19 VARCHAR2 := fnd_api.g_miss_char

55: , p7_a15 NUMBER := 0-1962.0724
56: , p7_a16 VARCHAR2 := fnd_api.g_miss_char
57: , p7_a17 NUMBER := 0-1962.0724
58: , p7_a18 VARCHAR2 := fnd_api.g_miss_char
59: , p7_a19 VARCHAR2 := fnd_api.g_miss_char
60: );
61: procedure validate_loc_area(p_api_version NUMBER
62: , p_init_msg_list VARCHAR2
63: , p_validation_level NUMBER

Line 68: , p6_a1 DATE := fnd_api.g_miss_date

64: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
65: , x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
66: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
67: , p6_a0 NUMBER := 0-1962.0724
68: , p6_a1 DATE := fnd_api.g_miss_date
69: , p6_a2 NUMBER := 0-1962.0724
70: , p6_a3 DATE := fnd_api.g_miss_date
71: , p6_a4 NUMBER := 0-1962.0724
72: , p6_a5 NUMBER := 0-1962.0724

Line 70: , p6_a3 DATE := fnd_api.g_miss_date

66: , x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
67: , p6_a0 NUMBER := 0-1962.0724
68: , p6_a1 DATE := fnd_api.g_miss_date
69: , p6_a2 NUMBER := 0-1962.0724
70: , p6_a3 DATE := fnd_api.g_miss_date
71: , p6_a4 NUMBER := 0-1962.0724
72: , p6_a5 NUMBER := 0-1962.0724
73: , p6_a6 NUMBER := 0-1962.0724
74: , p6_a7 NUMBER := 0-1962.0724

Line 77: , p6_a10 DATE := fnd_api.g_miss_date

73: , p6_a6 NUMBER := 0-1962.0724
74: , p6_a7 NUMBER := 0-1962.0724
75: , p6_a8 NUMBER := 0-1962.0724
76: , p6_a9 NUMBER := 0-1962.0724
77: , p6_a10 DATE := fnd_api.g_miss_date
78: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
79: , p6_a12 DATE := fnd_api.g_miss_date
80: , p6_a13 DATE := fnd_api.g_miss_date
81: , p6_a14 VARCHAR2 := fnd_api.g_miss_char

Line 78: , p6_a11 VARCHAR2 := fnd_api.g_miss_char

74: , p6_a7 NUMBER := 0-1962.0724
75: , p6_a8 NUMBER := 0-1962.0724
76: , p6_a9 NUMBER := 0-1962.0724
77: , p6_a10 DATE := fnd_api.g_miss_date
78: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
79: , p6_a12 DATE := fnd_api.g_miss_date
80: , p6_a13 DATE := fnd_api.g_miss_date
81: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
82: , p6_a15 NUMBER := 0-1962.0724

Line 79: , p6_a12 DATE := fnd_api.g_miss_date

75: , p6_a8 NUMBER := 0-1962.0724
76: , p6_a9 NUMBER := 0-1962.0724
77: , p6_a10 DATE := fnd_api.g_miss_date
78: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
79: , p6_a12 DATE := fnd_api.g_miss_date
80: , p6_a13 DATE := fnd_api.g_miss_date
81: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
82: , p6_a15 NUMBER := 0-1962.0724
83: , p6_a16 VARCHAR2 := fnd_api.g_miss_char

Line 80: , p6_a13 DATE := fnd_api.g_miss_date

76: , p6_a9 NUMBER := 0-1962.0724
77: , p6_a10 DATE := fnd_api.g_miss_date
78: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
79: , p6_a12 DATE := fnd_api.g_miss_date
80: , p6_a13 DATE := fnd_api.g_miss_date
81: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
82: , p6_a15 NUMBER := 0-1962.0724
83: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
84: , p6_a17 NUMBER := 0-1962.0724

Line 81: , p6_a14 VARCHAR2 := fnd_api.g_miss_char

77: , p6_a10 DATE := fnd_api.g_miss_date
78: , p6_a11 VARCHAR2 := fnd_api.g_miss_char
79: , p6_a12 DATE := fnd_api.g_miss_date
80: , p6_a13 DATE := fnd_api.g_miss_date
81: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
82: , p6_a15 NUMBER := 0-1962.0724
83: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
84: , p6_a17 NUMBER := 0-1962.0724
85: , p6_a18 VARCHAR2 := fnd_api.g_miss_char

Line 83: , p6_a16 VARCHAR2 := fnd_api.g_miss_char

79: , p6_a12 DATE := fnd_api.g_miss_date
80: , p6_a13 DATE := fnd_api.g_miss_date
81: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
82: , p6_a15 NUMBER := 0-1962.0724
83: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
84: , p6_a17 NUMBER := 0-1962.0724
85: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
86: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
87: );

Line 85: , p6_a18 VARCHAR2 := fnd_api.g_miss_char

81: , p6_a14 VARCHAR2 := fnd_api.g_miss_char
82: , p6_a15 NUMBER := 0-1962.0724
83: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
84: , p6_a17 NUMBER := 0-1962.0724
85: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
86: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
87: );
88: procedure check_items(p_validation_mode VARCHAR2
89: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 86: , p6_a19 VARCHAR2 := fnd_api.g_miss_char

82: , p6_a15 NUMBER := 0-1962.0724
83: , p6_a16 VARCHAR2 := fnd_api.g_miss_char
84: , p6_a17 NUMBER := 0-1962.0724
85: , p6_a18 VARCHAR2 := fnd_api.g_miss_char
86: , p6_a19 VARCHAR2 := fnd_api.g_miss_char
87: );
88: procedure check_items(p_validation_mode VARCHAR2
89: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
90: , p2_a0 NUMBER := 0-1962.0724

Line 91: , p2_a1 DATE := fnd_api.g_miss_date

87: );
88: procedure check_items(p_validation_mode VARCHAR2
89: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
90: , p2_a0 NUMBER := 0-1962.0724
91: , p2_a1 DATE := fnd_api.g_miss_date
92: , p2_a2 NUMBER := 0-1962.0724
93: , p2_a3 DATE := fnd_api.g_miss_date
94: , p2_a4 NUMBER := 0-1962.0724
95: , p2_a5 NUMBER := 0-1962.0724

Line 93: , p2_a3 DATE := fnd_api.g_miss_date

89: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
90: , p2_a0 NUMBER := 0-1962.0724
91: , p2_a1 DATE := fnd_api.g_miss_date
92: , p2_a2 NUMBER := 0-1962.0724
93: , p2_a3 DATE := fnd_api.g_miss_date
94: , p2_a4 NUMBER := 0-1962.0724
95: , p2_a5 NUMBER := 0-1962.0724
96: , p2_a6 NUMBER := 0-1962.0724
97: , p2_a7 NUMBER := 0-1962.0724

Line 100: , p2_a10 DATE := fnd_api.g_miss_date

96: , p2_a6 NUMBER := 0-1962.0724
97: , p2_a7 NUMBER := 0-1962.0724
98: , p2_a8 NUMBER := 0-1962.0724
99: , p2_a9 NUMBER := 0-1962.0724
100: , p2_a10 DATE := fnd_api.g_miss_date
101: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
102: , p2_a12 DATE := fnd_api.g_miss_date
103: , p2_a13 DATE := fnd_api.g_miss_date
104: , p2_a14 VARCHAR2 := fnd_api.g_miss_char

Line 101: , p2_a11 VARCHAR2 := fnd_api.g_miss_char

97: , p2_a7 NUMBER := 0-1962.0724
98: , p2_a8 NUMBER := 0-1962.0724
99: , p2_a9 NUMBER := 0-1962.0724
100: , p2_a10 DATE := fnd_api.g_miss_date
101: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
102: , p2_a12 DATE := fnd_api.g_miss_date
103: , p2_a13 DATE := fnd_api.g_miss_date
104: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
105: , p2_a15 NUMBER := 0-1962.0724

Line 102: , p2_a12 DATE := fnd_api.g_miss_date

98: , p2_a8 NUMBER := 0-1962.0724
99: , p2_a9 NUMBER := 0-1962.0724
100: , p2_a10 DATE := fnd_api.g_miss_date
101: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
102: , p2_a12 DATE := fnd_api.g_miss_date
103: , p2_a13 DATE := fnd_api.g_miss_date
104: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
105: , p2_a15 NUMBER := 0-1962.0724
106: , p2_a16 VARCHAR2 := fnd_api.g_miss_char

Line 103: , p2_a13 DATE := fnd_api.g_miss_date

99: , p2_a9 NUMBER := 0-1962.0724
100: , p2_a10 DATE := fnd_api.g_miss_date
101: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
102: , p2_a12 DATE := fnd_api.g_miss_date
103: , p2_a13 DATE := fnd_api.g_miss_date
104: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
105: , p2_a15 NUMBER := 0-1962.0724
106: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
107: , p2_a17 NUMBER := 0-1962.0724

Line 104: , p2_a14 VARCHAR2 := fnd_api.g_miss_char

100: , p2_a10 DATE := fnd_api.g_miss_date
101: , p2_a11 VARCHAR2 := fnd_api.g_miss_char
102: , p2_a12 DATE := fnd_api.g_miss_date
103: , p2_a13 DATE := fnd_api.g_miss_date
104: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
105: , p2_a15 NUMBER := 0-1962.0724
106: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
107: , p2_a17 NUMBER := 0-1962.0724
108: , p2_a18 VARCHAR2 := fnd_api.g_miss_char

Line 106: , p2_a16 VARCHAR2 := fnd_api.g_miss_char

102: , p2_a12 DATE := fnd_api.g_miss_date
103: , p2_a13 DATE := fnd_api.g_miss_date
104: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
105: , p2_a15 NUMBER := 0-1962.0724
106: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
107: , p2_a17 NUMBER := 0-1962.0724
108: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
109: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
110: );

Line 108: , p2_a18 VARCHAR2 := fnd_api.g_miss_char

104: , p2_a14 VARCHAR2 := fnd_api.g_miss_char
105: , p2_a15 NUMBER := 0-1962.0724
106: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
107: , p2_a17 NUMBER := 0-1962.0724
108: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
109: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
110: );
111: procedure check_loc_area_req_items(p_validation_mode VARCHAR2
112: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 109: , p2_a19 VARCHAR2 := fnd_api.g_miss_char

105: , p2_a15 NUMBER := 0-1962.0724
106: , p2_a16 VARCHAR2 := fnd_api.g_miss_char
107: , p2_a17 NUMBER := 0-1962.0724
108: , p2_a18 VARCHAR2 := fnd_api.g_miss_char
109: , p2_a19 VARCHAR2 := fnd_api.g_miss_char
110: );
111: procedure check_loc_area_req_items(p_validation_mode VARCHAR2
112: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
113: , p1_a0 NUMBER := 0-1962.0724

Line 114: , p1_a1 DATE := fnd_api.g_miss_date

110: );
111: procedure check_loc_area_req_items(p_validation_mode VARCHAR2
112: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
113: , p1_a0 NUMBER := 0-1962.0724
114: , p1_a1 DATE := fnd_api.g_miss_date
115: , p1_a2 NUMBER := 0-1962.0724
116: , p1_a3 DATE := fnd_api.g_miss_date
117: , p1_a4 NUMBER := 0-1962.0724
118: , p1_a5 NUMBER := 0-1962.0724

Line 116: , p1_a3 DATE := fnd_api.g_miss_date

112: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
113: , p1_a0 NUMBER := 0-1962.0724
114: , p1_a1 DATE := fnd_api.g_miss_date
115: , p1_a2 NUMBER := 0-1962.0724
116: , p1_a3 DATE := fnd_api.g_miss_date
117: , p1_a4 NUMBER := 0-1962.0724
118: , p1_a5 NUMBER := 0-1962.0724
119: , p1_a6 NUMBER := 0-1962.0724
120: , p1_a7 NUMBER := 0-1962.0724

Line 123: , p1_a10 DATE := fnd_api.g_miss_date

119: , p1_a6 NUMBER := 0-1962.0724
120: , p1_a7 NUMBER := 0-1962.0724
121: , p1_a8 NUMBER := 0-1962.0724
122: , p1_a9 NUMBER := 0-1962.0724
123: , p1_a10 DATE := fnd_api.g_miss_date
124: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
125: , p1_a12 DATE := fnd_api.g_miss_date
126: , p1_a13 DATE := fnd_api.g_miss_date
127: , p1_a14 VARCHAR2 := fnd_api.g_miss_char

Line 124: , p1_a11 VARCHAR2 := fnd_api.g_miss_char

120: , p1_a7 NUMBER := 0-1962.0724
121: , p1_a8 NUMBER := 0-1962.0724
122: , p1_a9 NUMBER := 0-1962.0724
123: , p1_a10 DATE := fnd_api.g_miss_date
124: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
125: , p1_a12 DATE := fnd_api.g_miss_date
126: , p1_a13 DATE := fnd_api.g_miss_date
127: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
128: , p1_a15 NUMBER := 0-1962.0724

Line 125: , p1_a12 DATE := fnd_api.g_miss_date

121: , p1_a8 NUMBER := 0-1962.0724
122: , p1_a9 NUMBER := 0-1962.0724
123: , p1_a10 DATE := fnd_api.g_miss_date
124: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
125: , p1_a12 DATE := fnd_api.g_miss_date
126: , p1_a13 DATE := fnd_api.g_miss_date
127: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
128: , p1_a15 NUMBER := 0-1962.0724
129: , p1_a16 VARCHAR2 := fnd_api.g_miss_char

Line 126: , p1_a13 DATE := fnd_api.g_miss_date

122: , p1_a9 NUMBER := 0-1962.0724
123: , p1_a10 DATE := fnd_api.g_miss_date
124: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
125: , p1_a12 DATE := fnd_api.g_miss_date
126: , p1_a13 DATE := fnd_api.g_miss_date
127: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
128: , p1_a15 NUMBER := 0-1962.0724
129: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
130: , p1_a17 NUMBER := 0-1962.0724

Line 127: , p1_a14 VARCHAR2 := fnd_api.g_miss_char

123: , p1_a10 DATE := fnd_api.g_miss_date
124: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
125: , p1_a12 DATE := fnd_api.g_miss_date
126: , p1_a13 DATE := fnd_api.g_miss_date
127: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
128: , p1_a15 NUMBER := 0-1962.0724
129: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
130: , p1_a17 NUMBER := 0-1962.0724
131: , p1_a18 VARCHAR2 := fnd_api.g_miss_char

Line 129: , p1_a16 VARCHAR2 := fnd_api.g_miss_char

125: , p1_a12 DATE := fnd_api.g_miss_date
126: , p1_a13 DATE := fnd_api.g_miss_date
127: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
128: , p1_a15 NUMBER := 0-1962.0724
129: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
130: , p1_a17 NUMBER := 0-1962.0724
131: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
132: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
133: );

Line 131: , p1_a18 VARCHAR2 := fnd_api.g_miss_char

127: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
128: , p1_a15 NUMBER := 0-1962.0724
129: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
130: , p1_a17 NUMBER := 0-1962.0724
131: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
132: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
133: );
134: procedure check_loc_area_uk_items(p_validation_mode VARCHAR2
135: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2

Line 132: , p1_a19 VARCHAR2 := fnd_api.g_miss_char

128: , p1_a15 NUMBER := 0-1962.0724
129: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
130: , p1_a17 NUMBER := 0-1962.0724
131: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
132: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
133: );
134: procedure check_loc_area_uk_items(p_validation_mode VARCHAR2
135: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
136: , p1_a0 NUMBER := 0-1962.0724

Line 137: , p1_a1 DATE := fnd_api.g_miss_date

133: );
134: procedure check_loc_area_uk_items(p_validation_mode VARCHAR2
135: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
136: , p1_a0 NUMBER := 0-1962.0724
137: , p1_a1 DATE := fnd_api.g_miss_date
138: , p1_a2 NUMBER := 0-1962.0724
139: , p1_a3 DATE := fnd_api.g_miss_date
140: , p1_a4 NUMBER := 0-1962.0724
141: , p1_a5 NUMBER := 0-1962.0724

Line 139: , p1_a3 DATE := fnd_api.g_miss_date

135: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
136: , p1_a0 NUMBER := 0-1962.0724
137: , p1_a1 DATE := fnd_api.g_miss_date
138: , p1_a2 NUMBER := 0-1962.0724
139: , p1_a3 DATE := fnd_api.g_miss_date
140: , p1_a4 NUMBER := 0-1962.0724
141: , p1_a5 NUMBER := 0-1962.0724
142: , p1_a6 NUMBER := 0-1962.0724
143: , p1_a7 NUMBER := 0-1962.0724

Line 146: , p1_a10 DATE := fnd_api.g_miss_date

142: , p1_a6 NUMBER := 0-1962.0724
143: , p1_a7 NUMBER := 0-1962.0724
144: , p1_a8 NUMBER := 0-1962.0724
145: , p1_a9 NUMBER := 0-1962.0724
146: , p1_a10 DATE := fnd_api.g_miss_date
147: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
148: , p1_a12 DATE := fnd_api.g_miss_date
149: , p1_a13 DATE := fnd_api.g_miss_date
150: , p1_a14 VARCHAR2 := fnd_api.g_miss_char

Line 147: , p1_a11 VARCHAR2 := fnd_api.g_miss_char

143: , p1_a7 NUMBER := 0-1962.0724
144: , p1_a8 NUMBER := 0-1962.0724
145: , p1_a9 NUMBER := 0-1962.0724
146: , p1_a10 DATE := fnd_api.g_miss_date
147: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
148: , p1_a12 DATE := fnd_api.g_miss_date
149: , p1_a13 DATE := fnd_api.g_miss_date
150: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
151: , p1_a15 NUMBER := 0-1962.0724

Line 148: , p1_a12 DATE := fnd_api.g_miss_date

144: , p1_a8 NUMBER := 0-1962.0724
145: , p1_a9 NUMBER := 0-1962.0724
146: , p1_a10 DATE := fnd_api.g_miss_date
147: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
148: , p1_a12 DATE := fnd_api.g_miss_date
149: , p1_a13 DATE := fnd_api.g_miss_date
150: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
151: , p1_a15 NUMBER := 0-1962.0724
152: , p1_a16 VARCHAR2 := fnd_api.g_miss_char

Line 149: , p1_a13 DATE := fnd_api.g_miss_date

145: , p1_a9 NUMBER := 0-1962.0724
146: , p1_a10 DATE := fnd_api.g_miss_date
147: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
148: , p1_a12 DATE := fnd_api.g_miss_date
149: , p1_a13 DATE := fnd_api.g_miss_date
150: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
151: , p1_a15 NUMBER := 0-1962.0724
152: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
153: , p1_a17 NUMBER := 0-1962.0724

Line 150: , p1_a14 VARCHAR2 := fnd_api.g_miss_char

146: , p1_a10 DATE := fnd_api.g_miss_date
147: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
148: , p1_a12 DATE := fnd_api.g_miss_date
149: , p1_a13 DATE := fnd_api.g_miss_date
150: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
151: , p1_a15 NUMBER := 0-1962.0724
152: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
153: , p1_a17 NUMBER := 0-1962.0724
154: , p1_a18 VARCHAR2 := fnd_api.g_miss_char

Line 152: , p1_a16 VARCHAR2 := fnd_api.g_miss_char

148: , p1_a12 DATE := fnd_api.g_miss_date
149: , p1_a13 DATE := fnd_api.g_miss_date
150: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
151: , p1_a15 NUMBER := 0-1962.0724
152: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
153: , p1_a17 NUMBER := 0-1962.0724
154: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
155: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
156: );

Line 154: , p1_a18 VARCHAR2 := fnd_api.g_miss_char

150: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
151: , p1_a15 NUMBER := 0-1962.0724
152: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
153: , p1_a17 NUMBER := 0-1962.0724
154: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
155: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
156: );
157: procedure check_loc_area_fk_items(x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
158: , p0_a0 NUMBER := 0-1962.0724

Line 155: , p1_a19 VARCHAR2 := fnd_api.g_miss_char

151: , p1_a15 NUMBER := 0-1962.0724
152: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
153: , p1_a17 NUMBER := 0-1962.0724
154: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
155: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
156: );
157: procedure check_loc_area_fk_items(x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
158: , p0_a0 NUMBER := 0-1962.0724
159: , p0_a1 DATE := fnd_api.g_miss_date

Line 159: , p0_a1 DATE := fnd_api.g_miss_date

155: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
156: );
157: procedure check_loc_area_fk_items(x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
158: , p0_a0 NUMBER := 0-1962.0724
159: , p0_a1 DATE := fnd_api.g_miss_date
160: , p0_a2 NUMBER := 0-1962.0724
161: , p0_a3 DATE := fnd_api.g_miss_date
162: , p0_a4 NUMBER := 0-1962.0724
163: , p0_a5 NUMBER := 0-1962.0724

Line 161: , p0_a3 DATE := fnd_api.g_miss_date

157: procedure check_loc_area_fk_items(x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
158: , p0_a0 NUMBER := 0-1962.0724
159: , p0_a1 DATE := fnd_api.g_miss_date
160: , p0_a2 NUMBER := 0-1962.0724
161: , p0_a3 DATE := fnd_api.g_miss_date
162: , p0_a4 NUMBER := 0-1962.0724
163: , p0_a5 NUMBER := 0-1962.0724
164: , p0_a6 NUMBER := 0-1962.0724
165: , p0_a7 NUMBER := 0-1962.0724

Line 168: , p0_a10 DATE := fnd_api.g_miss_date

164: , p0_a6 NUMBER := 0-1962.0724
165: , p0_a7 NUMBER := 0-1962.0724
166: , p0_a8 NUMBER := 0-1962.0724
167: , p0_a9 NUMBER := 0-1962.0724
168: , p0_a10 DATE := fnd_api.g_miss_date
169: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
170: , p0_a12 DATE := fnd_api.g_miss_date
171: , p0_a13 DATE := fnd_api.g_miss_date
172: , p0_a14 VARCHAR2 := fnd_api.g_miss_char

Line 169: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

165: , p0_a7 NUMBER := 0-1962.0724
166: , p0_a8 NUMBER := 0-1962.0724
167: , p0_a9 NUMBER := 0-1962.0724
168: , p0_a10 DATE := fnd_api.g_miss_date
169: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
170: , p0_a12 DATE := fnd_api.g_miss_date
171: , p0_a13 DATE := fnd_api.g_miss_date
172: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
173: , p0_a15 NUMBER := 0-1962.0724

Line 170: , p0_a12 DATE := fnd_api.g_miss_date

166: , p0_a8 NUMBER := 0-1962.0724
167: , p0_a9 NUMBER := 0-1962.0724
168: , p0_a10 DATE := fnd_api.g_miss_date
169: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
170: , p0_a12 DATE := fnd_api.g_miss_date
171: , p0_a13 DATE := fnd_api.g_miss_date
172: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
173: , p0_a15 NUMBER := 0-1962.0724
174: , p0_a16 VARCHAR2 := fnd_api.g_miss_char

Line 171: , p0_a13 DATE := fnd_api.g_miss_date

167: , p0_a9 NUMBER := 0-1962.0724
168: , p0_a10 DATE := fnd_api.g_miss_date
169: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
170: , p0_a12 DATE := fnd_api.g_miss_date
171: , p0_a13 DATE := fnd_api.g_miss_date
172: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
173: , p0_a15 NUMBER := 0-1962.0724
174: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
175: , p0_a17 NUMBER := 0-1962.0724

Line 172: , p0_a14 VARCHAR2 := fnd_api.g_miss_char

168: , p0_a10 DATE := fnd_api.g_miss_date
169: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
170: , p0_a12 DATE := fnd_api.g_miss_date
171: , p0_a13 DATE := fnd_api.g_miss_date
172: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
173: , p0_a15 NUMBER := 0-1962.0724
174: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
175: , p0_a17 NUMBER := 0-1962.0724
176: , p0_a18 VARCHAR2 := fnd_api.g_miss_char

Line 174: , p0_a16 VARCHAR2 := fnd_api.g_miss_char

170: , p0_a12 DATE := fnd_api.g_miss_date
171: , p0_a13 DATE := fnd_api.g_miss_date
172: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
173: , p0_a15 NUMBER := 0-1962.0724
174: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
175: , p0_a17 NUMBER := 0-1962.0724
176: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
177: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
178: );

Line 176: , p0_a18 VARCHAR2 := fnd_api.g_miss_char

172: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
173: , p0_a15 NUMBER := 0-1962.0724
174: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
175: , p0_a17 NUMBER := 0-1962.0724
176: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
177: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
178: );
179: procedure check_record(x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
180: , p0_a0 NUMBER := 0-1962.0724

Line 177: , p0_a19 VARCHAR2 := fnd_api.g_miss_char

173: , p0_a15 NUMBER := 0-1962.0724
174: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
175: , p0_a17 NUMBER := 0-1962.0724
176: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
177: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
178: );
179: procedure check_record(x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
180: , p0_a0 NUMBER := 0-1962.0724
181: , p0_a1 DATE := fnd_api.g_miss_date

Line 181: , p0_a1 DATE := fnd_api.g_miss_date

177: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
178: );
179: procedure check_record(x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
180: , p0_a0 NUMBER := 0-1962.0724
181: , p0_a1 DATE := fnd_api.g_miss_date
182: , p0_a2 NUMBER := 0-1962.0724
183: , p0_a3 DATE := fnd_api.g_miss_date
184: , p0_a4 NUMBER := 0-1962.0724
185: , p0_a5 NUMBER := 0-1962.0724

Line 183: , p0_a3 DATE := fnd_api.g_miss_date

179: procedure check_record(x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
180: , p0_a0 NUMBER := 0-1962.0724
181: , p0_a1 DATE := fnd_api.g_miss_date
182: , p0_a2 NUMBER := 0-1962.0724
183: , p0_a3 DATE := fnd_api.g_miss_date
184: , p0_a4 NUMBER := 0-1962.0724
185: , p0_a5 NUMBER := 0-1962.0724
186: , p0_a6 NUMBER := 0-1962.0724
187: , p0_a7 NUMBER := 0-1962.0724

Line 190: , p0_a10 DATE := fnd_api.g_miss_date

186: , p0_a6 NUMBER := 0-1962.0724
187: , p0_a7 NUMBER := 0-1962.0724
188: , p0_a8 NUMBER := 0-1962.0724
189: , p0_a9 NUMBER := 0-1962.0724
190: , p0_a10 DATE := fnd_api.g_miss_date
191: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
192: , p0_a12 DATE := fnd_api.g_miss_date
193: , p0_a13 DATE := fnd_api.g_miss_date
194: , p0_a14 VARCHAR2 := fnd_api.g_miss_char

Line 191: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

187: , p0_a7 NUMBER := 0-1962.0724
188: , p0_a8 NUMBER := 0-1962.0724
189: , p0_a9 NUMBER := 0-1962.0724
190: , p0_a10 DATE := fnd_api.g_miss_date
191: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
192: , p0_a12 DATE := fnd_api.g_miss_date
193: , p0_a13 DATE := fnd_api.g_miss_date
194: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
195: , p0_a15 NUMBER := 0-1962.0724

Line 192: , p0_a12 DATE := fnd_api.g_miss_date

188: , p0_a8 NUMBER := 0-1962.0724
189: , p0_a9 NUMBER := 0-1962.0724
190: , p0_a10 DATE := fnd_api.g_miss_date
191: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
192: , p0_a12 DATE := fnd_api.g_miss_date
193: , p0_a13 DATE := fnd_api.g_miss_date
194: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
195: , p0_a15 NUMBER := 0-1962.0724
196: , p0_a16 VARCHAR2 := fnd_api.g_miss_char

Line 193: , p0_a13 DATE := fnd_api.g_miss_date

189: , p0_a9 NUMBER := 0-1962.0724
190: , p0_a10 DATE := fnd_api.g_miss_date
191: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
192: , p0_a12 DATE := fnd_api.g_miss_date
193: , p0_a13 DATE := fnd_api.g_miss_date
194: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
195: , p0_a15 NUMBER := 0-1962.0724
196: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
197: , p0_a17 NUMBER := 0-1962.0724

Line 194: , p0_a14 VARCHAR2 := fnd_api.g_miss_char

190: , p0_a10 DATE := fnd_api.g_miss_date
191: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
192: , p0_a12 DATE := fnd_api.g_miss_date
193: , p0_a13 DATE := fnd_api.g_miss_date
194: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
195: , p0_a15 NUMBER := 0-1962.0724
196: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
197: , p0_a17 NUMBER := 0-1962.0724
198: , p0_a18 VARCHAR2 := fnd_api.g_miss_char

Line 196: , p0_a16 VARCHAR2 := fnd_api.g_miss_char

192: , p0_a12 DATE := fnd_api.g_miss_date
193: , p0_a13 DATE := fnd_api.g_miss_date
194: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
195: , p0_a15 NUMBER := 0-1962.0724
196: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
197: , p0_a17 NUMBER := 0-1962.0724
198: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
199: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
200: , p1_a0 NUMBER := 0-1962.0724

Line 198: , p0_a18 VARCHAR2 := fnd_api.g_miss_char

194: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
195: , p0_a15 NUMBER := 0-1962.0724
196: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
197: , p0_a17 NUMBER := 0-1962.0724
198: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
199: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
200: , p1_a0 NUMBER := 0-1962.0724
201: , p1_a1 DATE := fnd_api.g_miss_date
202: , p1_a2 NUMBER := 0-1962.0724

Line 199: , p0_a19 VARCHAR2 := fnd_api.g_miss_char

195: , p0_a15 NUMBER := 0-1962.0724
196: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
197: , p0_a17 NUMBER := 0-1962.0724
198: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
199: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
200: , p1_a0 NUMBER := 0-1962.0724
201: , p1_a1 DATE := fnd_api.g_miss_date
202: , p1_a2 NUMBER := 0-1962.0724
203: , p1_a3 DATE := fnd_api.g_miss_date

Line 201: , p1_a1 DATE := fnd_api.g_miss_date

197: , p0_a17 NUMBER := 0-1962.0724
198: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
199: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
200: , p1_a0 NUMBER := 0-1962.0724
201: , p1_a1 DATE := fnd_api.g_miss_date
202: , p1_a2 NUMBER := 0-1962.0724
203: , p1_a3 DATE := fnd_api.g_miss_date
204: , p1_a4 NUMBER := 0-1962.0724
205: , p1_a5 NUMBER := 0-1962.0724

Line 203: , p1_a3 DATE := fnd_api.g_miss_date

199: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
200: , p1_a0 NUMBER := 0-1962.0724
201: , p1_a1 DATE := fnd_api.g_miss_date
202: , p1_a2 NUMBER := 0-1962.0724
203: , p1_a3 DATE := fnd_api.g_miss_date
204: , p1_a4 NUMBER := 0-1962.0724
205: , p1_a5 NUMBER := 0-1962.0724
206: , p1_a6 NUMBER := 0-1962.0724
207: , p1_a7 NUMBER := 0-1962.0724

Line 210: , p1_a10 DATE := fnd_api.g_miss_date

206: , p1_a6 NUMBER := 0-1962.0724
207: , p1_a7 NUMBER := 0-1962.0724
208: , p1_a8 NUMBER := 0-1962.0724
209: , p1_a9 NUMBER := 0-1962.0724
210: , p1_a10 DATE := fnd_api.g_miss_date
211: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
212: , p1_a12 DATE := fnd_api.g_miss_date
213: , p1_a13 DATE := fnd_api.g_miss_date
214: , p1_a14 VARCHAR2 := fnd_api.g_miss_char

Line 211: , p1_a11 VARCHAR2 := fnd_api.g_miss_char

207: , p1_a7 NUMBER := 0-1962.0724
208: , p1_a8 NUMBER := 0-1962.0724
209: , p1_a9 NUMBER := 0-1962.0724
210: , p1_a10 DATE := fnd_api.g_miss_date
211: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
212: , p1_a12 DATE := fnd_api.g_miss_date
213: , p1_a13 DATE := fnd_api.g_miss_date
214: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
215: , p1_a15 NUMBER := 0-1962.0724

Line 212: , p1_a12 DATE := fnd_api.g_miss_date

208: , p1_a8 NUMBER := 0-1962.0724
209: , p1_a9 NUMBER := 0-1962.0724
210: , p1_a10 DATE := fnd_api.g_miss_date
211: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
212: , p1_a12 DATE := fnd_api.g_miss_date
213: , p1_a13 DATE := fnd_api.g_miss_date
214: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
215: , p1_a15 NUMBER := 0-1962.0724
216: , p1_a16 VARCHAR2 := fnd_api.g_miss_char

Line 213: , p1_a13 DATE := fnd_api.g_miss_date

209: , p1_a9 NUMBER := 0-1962.0724
210: , p1_a10 DATE := fnd_api.g_miss_date
211: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
212: , p1_a12 DATE := fnd_api.g_miss_date
213: , p1_a13 DATE := fnd_api.g_miss_date
214: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
215: , p1_a15 NUMBER := 0-1962.0724
216: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
217: , p1_a17 NUMBER := 0-1962.0724

Line 214: , p1_a14 VARCHAR2 := fnd_api.g_miss_char

210: , p1_a10 DATE := fnd_api.g_miss_date
211: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
212: , p1_a12 DATE := fnd_api.g_miss_date
213: , p1_a13 DATE := fnd_api.g_miss_date
214: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
215: , p1_a15 NUMBER := 0-1962.0724
216: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
217: , p1_a17 NUMBER := 0-1962.0724
218: , p1_a18 VARCHAR2 := fnd_api.g_miss_char

Line 216: , p1_a16 VARCHAR2 := fnd_api.g_miss_char

212: , p1_a12 DATE := fnd_api.g_miss_date
213: , p1_a13 DATE := fnd_api.g_miss_date
214: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
215: , p1_a15 NUMBER := 0-1962.0724
216: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
217: , p1_a17 NUMBER := 0-1962.0724
218: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
219: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
220: );

Line 218: , p1_a18 VARCHAR2 := fnd_api.g_miss_char

214: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
215: , p1_a15 NUMBER := 0-1962.0724
216: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
217: , p1_a17 NUMBER := 0-1962.0724
218: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
219: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
220: );
221: procedure complete_loc_area_rec(p1_a0 OUT NOCOPY /* file.sql.39 change */ NUMBER
222: , p1_a1 OUT NOCOPY /* file.sql.39 change */ DATE

Line 219: , p1_a19 VARCHAR2 := fnd_api.g_miss_char

215: , p1_a15 NUMBER := 0-1962.0724
216: , p1_a16 VARCHAR2 := fnd_api.g_miss_char
217: , p1_a17 NUMBER := 0-1962.0724
218: , p1_a18 VARCHAR2 := fnd_api.g_miss_char
219: , p1_a19 VARCHAR2 := fnd_api.g_miss_char
220: );
221: procedure complete_loc_area_rec(p1_a0 OUT NOCOPY /* file.sql.39 change */ NUMBER
222: , p1_a1 OUT NOCOPY /* file.sql.39 change */ DATE
223: , p1_a2 OUT NOCOPY /* file.sql.39 change */ NUMBER

Line 242: , p0_a1 DATE := fnd_api.g_miss_date

238: , p1_a17 OUT NOCOPY /* file.sql.39 change */ NUMBER
239: , p1_a18 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
240: , p1_a19 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
241: , p0_a0 NUMBER := 0-1962.0724
242: , p0_a1 DATE := fnd_api.g_miss_date
243: , p0_a2 NUMBER := 0-1962.0724
244: , p0_a3 DATE := fnd_api.g_miss_date
245: , p0_a4 NUMBER := 0-1962.0724
246: , p0_a5 NUMBER := 0-1962.0724

Line 244: , p0_a3 DATE := fnd_api.g_miss_date

240: , p1_a19 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
241: , p0_a0 NUMBER := 0-1962.0724
242: , p0_a1 DATE := fnd_api.g_miss_date
243: , p0_a2 NUMBER := 0-1962.0724
244: , p0_a3 DATE := fnd_api.g_miss_date
245: , p0_a4 NUMBER := 0-1962.0724
246: , p0_a5 NUMBER := 0-1962.0724
247: , p0_a6 NUMBER := 0-1962.0724
248: , p0_a7 NUMBER := 0-1962.0724

Line 251: , p0_a10 DATE := fnd_api.g_miss_date

247: , p0_a6 NUMBER := 0-1962.0724
248: , p0_a7 NUMBER := 0-1962.0724
249: , p0_a8 NUMBER := 0-1962.0724
250: , p0_a9 NUMBER := 0-1962.0724
251: , p0_a10 DATE := fnd_api.g_miss_date
252: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
253: , p0_a12 DATE := fnd_api.g_miss_date
254: , p0_a13 DATE := fnd_api.g_miss_date
255: , p0_a14 VARCHAR2 := fnd_api.g_miss_char

Line 252: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

248: , p0_a7 NUMBER := 0-1962.0724
249: , p0_a8 NUMBER := 0-1962.0724
250: , p0_a9 NUMBER := 0-1962.0724
251: , p0_a10 DATE := fnd_api.g_miss_date
252: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
253: , p0_a12 DATE := fnd_api.g_miss_date
254: , p0_a13 DATE := fnd_api.g_miss_date
255: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
256: , p0_a15 NUMBER := 0-1962.0724

Line 253: , p0_a12 DATE := fnd_api.g_miss_date

249: , p0_a8 NUMBER := 0-1962.0724
250: , p0_a9 NUMBER := 0-1962.0724
251: , p0_a10 DATE := fnd_api.g_miss_date
252: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
253: , p0_a12 DATE := fnd_api.g_miss_date
254: , p0_a13 DATE := fnd_api.g_miss_date
255: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
256: , p0_a15 NUMBER := 0-1962.0724
257: , p0_a16 VARCHAR2 := fnd_api.g_miss_char

Line 254: , p0_a13 DATE := fnd_api.g_miss_date

250: , p0_a9 NUMBER := 0-1962.0724
251: , p0_a10 DATE := fnd_api.g_miss_date
252: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
253: , p0_a12 DATE := fnd_api.g_miss_date
254: , p0_a13 DATE := fnd_api.g_miss_date
255: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
256: , p0_a15 NUMBER := 0-1962.0724
257: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
258: , p0_a17 NUMBER := 0-1962.0724

Line 255: , p0_a14 VARCHAR2 := fnd_api.g_miss_char

251: , p0_a10 DATE := fnd_api.g_miss_date
252: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
253: , p0_a12 DATE := fnd_api.g_miss_date
254: , p0_a13 DATE := fnd_api.g_miss_date
255: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
256: , p0_a15 NUMBER := 0-1962.0724
257: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
258: , p0_a17 NUMBER := 0-1962.0724
259: , p0_a18 VARCHAR2 := fnd_api.g_miss_char

Line 257: , p0_a16 VARCHAR2 := fnd_api.g_miss_char

253: , p0_a12 DATE := fnd_api.g_miss_date
254: , p0_a13 DATE := fnd_api.g_miss_date
255: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
256: , p0_a15 NUMBER := 0-1962.0724
257: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
258: , p0_a17 NUMBER := 0-1962.0724
259: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
260: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
261: );

Line 259: , p0_a18 VARCHAR2 := fnd_api.g_miss_char

255: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
256: , p0_a15 NUMBER := 0-1962.0724
257: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
258: , p0_a17 NUMBER := 0-1962.0724
259: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
260: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
261: );
262: procedure init_rec(p0_a0 OUT NOCOPY /* file.sql.39 change */ NUMBER
263: , p0_a1 OUT NOCOPY /* file.sql.39 change */ DATE

Line 260: , p0_a19 VARCHAR2 := fnd_api.g_miss_char

256: , p0_a15 NUMBER := 0-1962.0724
257: , p0_a16 VARCHAR2 := fnd_api.g_miss_char
258: , p0_a17 NUMBER := 0-1962.0724
259: , p0_a18 VARCHAR2 := fnd_api.g_miss_char
260: , p0_a19 VARCHAR2 := fnd_api.g_miss_char
261: );
262: procedure init_rec(p0_a0 OUT NOCOPY /* file.sql.39 change */ NUMBER
263: , p0_a1 OUT NOCOPY /* file.sql.39 change */ DATE
264: , p0_a2 OUT NOCOPY /* file.sql.39 change */ NUMBER