DBA Data[Home] [Help]

APPS.AMS_USER_STATUSES_PVT_W dependencies on FND_API

Line 12: , p7_a1 DATE := fnd_api.g_miss_date

8: , x_msg_count out nocopy NUMBER
9: , x_msg_data out nocopy VARCHAR2
10: , x_user_status_id out nocopy 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_user_status_id out nocopy 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 VARCHAR2 := fnd_api.g_miss_char

Line 18: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

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 VARCHAR2 := fnd_api.g_miss_char
19: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
20: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
21: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
22: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

Line 19: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

15: , p7_a4 NUMBER := 0-1962.0724
16: , p7_a5 NUMBER := 0-1962.0724
17: , p7_a6 NUMBER := 0-1962.0724
18: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
19: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
20: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
21: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
22: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
23: , p7_a12 DATE := fnd_api.g_miss_date

Line 20: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

16: , p7_a5 NUMBER := 0-1962.0724
17: , p7_a6 NUMBER := 0-1962.0724
18: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
19: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
20: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
21: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
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

Line 21: , p7_a10 VARCHAR2 := fnd_api.g_miss_char

17: , p7_a6 NUMBER := 0-1962.0724
18: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
19: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
20: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
21: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
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 VARCHAR2 := fnd_api.g_miss_char
19: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
20: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
21: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
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 VARCHAR2 := fnd_api.g_miss_char

Line 23: , p7_a12 DATE := fnd_api.g_miss_date

19: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
20: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
21: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
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 VARCHAR2 := fnd_api.g_miss_char
27: );

Line 24: , p7_a13 DATE := fnd_api.g_miss_date

20: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
21: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
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 VARCHAR2 := fnd_api.g_miss_char
27: );
28: procedure update_user_status(p_api_version NUMBER

Line 25: , p7_a14 VARCHAR2 := fnd_api.g_miss_char

21: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
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 VARCHAR2 := fnd_api.g_miss_char
27: );
28: procedure update_user_status(p_api_version NUMBER
29: , p_init_msg_list VARCHAR2

Line 26: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

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 VARCHAR2 := fnd_api.g_miss_char
27: );
28: procedure update_user_status(p_api_version NUMBER
29: , p_init_msg_list VARCHAR2
30: , p_commit VARCHAR2

Line 36: , p7_a1 DATE := fnd_api.g_miss_date

32: , x_return_status out nocopy VARCHAR2
33: , x_msg_count out nocopy NUMBER
34: , x_msg_data out nocopy VARCHAR2
35: , p7_a0 NUMBER := 0-1962.0724
36: , p7_a1 DATE := fnd_api.g_miss_date
37: , p7_a2 NUMBER := 0-1962.0724
38: , p7_a3 DATE := fnd_api.g_miss_date
39: , p7_a4 NUMBER := 0-1962.0724
40: , p7_a5 NUMBER := 0-1962.0724

Line 38: , p7_a3 DATE := fnd_api.g_miss_date

34: , x_msg_data out nocopy VARCHAR2
35: , p7_a0 NUMBER := 0-1962.0724
36: , p7_a1 DATE := fnd_api.g_miss_date
37: , p7_a2 NUMBER := 0-1962.0724
38: , p7_a3 DATE := fnd_api.g_miss_date
39: , p7_a4 NUMBER := 0-1962.0724
40: , p7_a5 NUMBER := 0-1962.0724
41: , p7_a6 NUMBER := 0-1962.0724
42: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

Line 42: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

38: , p7_a3 DATE := fnd_api.g_miss_date
39: , p7_a4 NUMBER := 0-1962.0724
40: , p7_a5 NUMBER := 0-1962.0724
41: , p7_a6 NUMBER := 0-1962.0724
42: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
44: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

Line 43: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

39: , p7_a4 NUMBER := 0-1962.0724
40: , p7_a5 NUMBER := 0-1962.0724
41: , p7_a6 NUMBER := 0-1962.0724
42: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
44: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a12 DATE := fnd_api.g_miss_date

Line 44: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

40: , p7_a5 NUMBER := 0-1962.0724
41: , p7_a6 NUMBER := 0-1962.0724
42: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
44: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a12 DATE := fnd_api.g_miss_date
48: , p7_a13 DATE := fnd_api.g_miss_date

Line 45: , p7_a10 VARCHAR2 := fnd_api.g_miss_char

41: , p7_a6 NUMBER := 0-1962.0724
42: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
44: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a12 DATE := fnd_api.g_miss_date
48: , p7_a13 DATE := fnd_api.g_miss_date
49: , p7_a14 VARCHAR2 := fnd_api.g_miss_char

Line 46: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

42: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
43: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
44: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a12 DATE := fnd_api.g_miss_date
48: , p7_a13 DATE := fnd_api.g_miss_date
49: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

Line 47: , p7_a12 DATE := fnd_api.g_miss_date

43: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
44: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a12 DATE := fnd_api.g_miss_date
48: , p7_a13 DATE := fnd_api.g_miss_date
49: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
51: );

Line 48: , p7_a13 DATE := fnd_api.g_miss_date

44: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
45: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a12 DATE := fnd_api.g_miss_date
48: , p7_a13 DATE := fnd_api.g_miss_date
49: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
51: );
52: procedure validate_user_status(p_api_version NUMBER

Line 49: , p7_a14 VARCHAR2 := fnd_api.g_miss_char

45: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
46: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a12 DATE := fnd_api.g_miss_date
48: , p7_a13 DATE := fnd_api.g_miss_date
49: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
51: );
52: procedure validate_user_status(p_api_version NUMBER
53: , p_init_msg_list VARCHAR2

Line 50: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

46: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
47: , p7_a12 DATE := fnd_api.g_miss_date
48: , p7_a13 DATE := fnd_api.g_miss_date
49: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
50: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
51: );
52: procedure validate_user_status(p_api_version NUMBER
53: , p_init_msg_list VARCHAR2
54: , p_commit VARCHAR2

Line 60: , p7_a1 DATE := fnd_api.g_miss_date

56: , x_return_status out nocopy VARCHAR2
57: , x_msg_count out nocopy NUMBER
58: , x_msg_data out nocopy VARCHAR2
59: , p7_a0 NUMBER := 0-1962.0724
60: , p7_a1 DATE := fnd_api.g_miss_date
61: , p7_a2 NUMBER := 0-1962.0724
62: , p7_a3 DATE := fnd_api.g_miss_date
63: , p7_a4 NUMBER := 0-1962.0724
64: , p7_a5 NUMBER := 0-1962.0724

Line 62: , p7_a3 DATE := fnd_api.g_miss_date

58: , x_msg_data out nocopy VARCHAR2
59: , p7_a0 NUMBER := 0-1962.0724
60: , p7_a1 DATE := fnd_api.g_miss_date
61: , p7_a2 NUMBER := 0-1962.0724
62: , p7_a3 DATE := fnd_api.g_miss_date
63: , p7_a4 NUMBER := 0-1962.0724
64: , p7_a5 NUMBER := 0-1962.0724
65: , p7_a6 NUMBER := 0-1962.0724
66: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

Line 66: , p7_a7 VARCHAR2 := fnd_api.g_miss_char

62: , p7_a3 DATE := fnd_api.g_miss_date
63: , p7_a4 NUMBER := 0-1962.0724
64: , p7_a5 NUMBER := 0-1962.0724
65: , p7_a6 NUMBER := 0-1962.0724
66: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
67: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
68: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
69: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
70: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

Line 67: , p7_a8 VARCHAR2 := fnd_api.g_miss_char

63: , p7_a4 NUMBER := 0-1962.0724
64: , p7_a5 NUMBER := 0-1962.0724
65: , p7_a6 NUMBER := 0-1962.0724
66: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
67: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
68: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
69: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
70: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
71: , p7_a12 DATE := fnd_api.g_miss_date

Line 68: , p7_a9 VARCHAR2 := fnd_api.g_miss_char

64: , p7_a5 NUMBER := 0-1962.0724
65: , p7_a6 NUMBER := 0-1962.0724
66: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
67: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
68: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
69: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
70: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
71: , p7_a12 DATE := fnd_api.g_miss_date
72: , p7_a13 DATE := fnd_api.g_miss_date

Line 69: , p7_a10 VARCHAR2 := fnd_api.g_miss_char

65: , p7_a6 NUMBER := 0-1962.0724
66: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
67: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
68: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
69: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
70: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
71: , p7_a12 DATE := fnd_api.g_miss_date
72: , p7_a13 DATE := fnd_api.g_miss_date
73: , p7_a14 VARCHAR2 := fnd_api.g_miss_char

Line 70: , p7_a11 VARCHAR2 := fnd_api.g_miss_char

66: , p7_a7 VARCHAR2 := fnd_api.g_miss_char
67: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
68: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
69: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
70: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
71: , p7_a12 DATE := fnd_api.g_miss_date
72: , p7_a13 DATE := fnd_api.g_miss_date
73: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
74: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

Line 71: , p7_a12 DATE := fnd_api.g_miss_date

67: , p7_a8 VARCHAR2 := fnd_api.g_miss_char
68: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
69: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
70: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
71: , p7_a12 DATE := fnd_api.g_miss_date
72: , p7_a13 DATE := fnd_api.g_miss_date
73: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
74: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
75: );

Line 72: , p7_a13 DATE := fnd_api.g_miss_date

68: , p7_a9 VARCHAR2 := fnd_api.g_miss_char
69: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
70: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
71: , p7_a12 DATE := fnd_api.g_miss_date
72: , p7_a13 DATE := fnd_api.g_miss_date
73: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
74: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
75: );
76: procedure check_user_status_items(p_validation_mode VARCHAR2

Line 73: , p7_a14 VARCHAR2 := fnd_api.g_miss_char

69: , p7_a10 VARCHAR2 := fnd_api.g_miss_char
70: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
71: , p7_a12 DATE := fnd_api.g_miss_date
72: , p7_a13 DATE := fnd_api.g_miss_date
73: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
74: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
75: );
76: procedure check_user_status_items(p_validation_mode VARCHAR2
77: , x_return_status out nocopy VARCHAR2

Line 74: , p7_a15 VARCHAR2 := fnd_api.g_miss_char

70: , p7_a11 VARCHAR2 := fnd_api.g_miss_char
71: , p7_a12 DATE := fnd_api.g_miss_date
72: , p7_a13 DATE := fnd_api.g_miss_date
73: , p7_a14 VARCHAR2 := fnd_api.g_miss_char
74: , p7_a15 VARCHAR2 := fnd_api.g_miss_char
75: );
76: procedure check_user_status_items(p_validation_mode VARCHAR2
77: , x_return_status out nocopy VARCHAR2
78: , p0_a0 NUMBER := 0-1962.0724

Line 79: , p0_a1 DATE := fnd_api.g_miss_date

75: );
76: procedure check_user_status_items(p_validation_mode VARCHAR2
77: , x_return_status out nocopy VARCHAR2
78: , p0_a0 NUMBER := 0-1962.0724
79: , p0_a1 DATE := fnd_api.g_miss_date
80: , p0_a2 NUMBER := 0-1962.0724
81: , p0_a3 DATE := fnd_api.g_miss_date
82: , p0_a4 NUMBER := 0-1962.0724
83: , p0_a5 NUMBER := 0-1962.0724

Line 81: , p0_a3 DATE := fnd_api.g_miss_date

77: , x_return_status out nocopy VARCHAR2
78: , p0_a0 NUMBER := 0-1962.0724
79: , p0_a1 DATE := fnd_api.g_miss_date
80: , p0_a2 NUMBER := 0-1962.0724
81: , p0_a3 DATE := fnd_api.g_miss_date
82: , p0_a4 NUMBER := 0-1962.0724
83: , p0_a5 NUMBER := 0-1962.0724
84: , p0_a6 NUMBER := 0-1962.0724
85: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

Line 85: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

81: , p0_a3 DATE := fnd_api.g_miss_date
82: , p0_a4 NUMBER := 0-1962.0724
83: , p0_a5 NUMBER := 0-1962.0724
84: , p0_a6 NUMBER := 0-1962.0724
85: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
86: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
87: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
88: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
89: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

Line 86: , p0_a8 VARCHAR2 := fnd_api.g_miss_char

82: , p0_a4 NUMBER := 0-1962.0724
83: , p0_a5 NUMBER := 0-1962.0724
84: , p0_a6 NUMBER := 0-1962.0724
85: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
86: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
87: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
88: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
89: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
90: , p0_a12 DATE := fnd_api.g_miss_date

Line 87: , p0_a9 VARCHAR2 := fnd_api.g_miss_char

83: , p0_a5 NUMBER := 0-1962.0724
84: , p0_a6 NUMBER := 0-1962.0724
85: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
86: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
87: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
88: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
89: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
90: , p0_a12 DATE := fnd_api.g_miss_date
91: , p0_a13 DATE := fnd_api.g_miss_date

Line 88: , p0_a10 VARCHAR2 := fnd_api.g_miss_char

84: , p0_a6 NUMBER := 0-1962.0724
85: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
86: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
87: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
88: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
89: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
90: , p0_a12 DATE := fnd_api.g_miss_date
91: , p0_a13 DATE := fnd_api.g_miss_date
92: , p0_a14 VARCHAR2 := fnd_api.g_miss_char

Line 89: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

85: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
86: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
87: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
88: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
89: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
90: , p0_a12 DATE := fnd_api.g_miss_date
91: , p0_a13 DATE := fnd_api.g_miss_date
92: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
93: , p0_a15 VARCHAR2 := fnd_api.g_miss_char

Line 90: , p0_a12 DATE := fnd_api.g_miss_date

86: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
87: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
88: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
89: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
90: , p0_a12 DATE := fnd_api.g_miss_date
91: , p0_a13 DATE := fnd_api.g_miss_date
92: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
93: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
94: );

Line 91: , p0_a13 DATE := fnd_api.g_miss_date

87: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
88: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
89: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
90: , p0_a12 DATE := fnd_api.g_miss_date
91: , p0_a13 DATE := fnd_api.g_miss_date
92: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
93: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
94: );
95: procedure check_user_status_record(x_return_status out nocopy VARCHAR2

Line 92: , p0_a14 VARCHAR2 := fnd_api.g_miss_char

88: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
89: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
90: , p0_a12 DATE := fnd_api.g_miss_date
91: , p0_a13 DATE := fnd_api.g_miss_date
92: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
93: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
94: );
95: procedure check_user_status_record(x_return_status out nocopy VARCHAR2
96: , p0_a0 NUMBER := 0-1962.0724

Line 93: , p0_a15 VARCHAR2 := fnd_api.g_miss_char

89: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
90: , p0_a12 DATE := fnd_api.g_miss_date
91: , p0_a13 DATE := fnd_api.g_miss_date
92: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
93: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
94: );
95: procedure check_user_status_record(x_return_status out nocopy VARCHAR2
96: , p0_a0 NUMBER := 0-1962.0724
97: , p0_a1 DATE := fnd_api.g_miss_date

Line 97: , p0_a1 DATE := fnd_api.g_miss_date

93: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
94: );
95: procedure check_user_status_record(x_return_status out nocopy VARCHAR2
96: , p0_a0 NUMBER := 0-1962.0724
97: , p0_a1 DATE := fnd_api.g_miss_date
98: , p0_a2 NUMBER := 0-1962.0724
99: , p0_a3 DATE := fnd_api.g_miss_date
100: , p0_a4 NUMBER := 0-1962.0724
101: , p0_a5 NUMBER := 0-1962.0724

Line 99: , p0_a3 DATE := fnd_api.g_miss_date

95: procedure check_user_status_record(x_return_status out nocopy VARCHAR2
96: , p0_a0 NUMBER := 0-1962.0724
97: , p0_a1 DATE := fnd_api.g_miss_date
98: , p0_a2 NUMBER := 0-1962.0724
99: , p0_a3 DATE := fnd_api.g_miss_date
100: , p0_a4 NUMBER := 0-1962.0724
101: , p0_a5 NUMBER := 0-1962.0724
102: , p0_a6 NUMBER := 0-1962.0724
103: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

Line 103: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

99: , p0_a3 DATE := fnd_api.g_miss_date
100: , p0_a4 NUMBER := 0-1962.0724
101: , p0_a5 NUMBER := 0-1962.0724
102: , p0_a6 NUMBER := 0-1962.0724
103: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
104: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
105: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
106: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
107: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

Line 104: , p0_a8 VARCHAR2 := fnd_api.g_miss_char

100: , p0_a4 NUMBER := 0-1962.0724
101: , p0_a5 NUMBER := 0-1962.0724
102: , p0_a6 NUMBER := 0-1962.0724
103: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
104: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
105: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
106: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
107: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
108: , p0_a12 DATE := fnd_api.g_miss_date

Line 105: , p0_a9 VARCHAR2 := fnd_api.g_miss_char

101: , p0_a5 NUMBER := 0-1962.0724
102: , p0_a6 NUMBER := 0-1962.0724
103: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
104: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
105: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
106: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
107: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
108: , p0_a12 DATE := fnd_api.g_miss_date
109: , p0_a13 DATE := fnd_api.g_miss_date

Line 106: , p0_a10 VARCHAR2 := fnd_api.g_miss_char

102: , p0_a6 NUMBER := 0-1962.0724
103: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
104: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
105: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
106: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
107: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
108: , p0_a12 DATE := fnd_api.g_miss_date
109: , p0_a13 DATE := fnd_api.g_miss_date
110: , p0_a14 VARCHAR2 := fnd_api.g_miss_char

Line 107: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

103: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
104: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
105: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
106: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
107: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
108: , p0_a12 DATE := fnd_api.g_miss_date
109: , p0_a13 DATE := fnd_api.g_miss_date
110: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
111: , p0_a15 VARCHAR2 := fnd_api.g_miss_char

Line 108: , p0_a12 DATE := fnd_api.g_miss_date

104: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
105: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
106: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
107: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
108: , p0_a12 DATE := fnd_api.g_miss_date
109: , p0_a13 DATE := fnd_api.g_miss_date
110: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
111: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
112: , p1_a0 NUMBER := 0-1962.0724

Line 109: , p0_a13 DATE := fnd_api.g_miss_date

105: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
106: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
107: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
108: , p0_a12 DATE := fnd_api.g_miss_date
109: , p0_a13 DATE := fnd_api.g_miss_date
110: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
111: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
112: , p1_a0 NUMBER := 0-1962.0724
113: , p1_a1 DATE := fnd_api.g_miss_date

Line 110: , p0_a14 VARCHAR2 := fnd_api.g_miss_char

106: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
107: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
108: , p0_a12 DATE := fnd_api.g_miss_date
109: , p0_a13 DATE := fnd_api.g_miss_date
110: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
111: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
112: , p1_a0 NUMBER := 0-1962.0724
113: , p1_a1 DATE := fnd_api.g_miss_date
114: , p1_a2 NUMBER := 0-1962.0724

Line 111: , p0_a15 VARCHAR2 := fnd_api.g_miss_char

107: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
108: , p0_a12 DATE := fnd_api.g_miss_date
109: , p0_a13 DATE := fnd_api.g_miss_date
110: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
111: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
112: , p1_a0 NUMBER := 0-1962.0724
113: , p1_a1 DATE := fnd_api.g_miss_date
114: , p1_a2 NUMBER := 0-1962.0724
115: , p1_a3 DATE := fnd_api.g_miss_date

Line 113: , p1_a1 DATE := fnd_api.g_miss_date

109: , p0_a13 DATE := fnd_api.g_miss_date
110: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
111: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
112: , p1_a0 NUMBER := 0-1962.0724
113: , p1_a1 DATE := fnd_api.g_miss_date
114: , p1_a2 NUMBER := 0-1962.0724
115: , p1_a3 DATE := fnd_api.g_miss_date
116: , p1_a4 NUMBER := 0-1962.0724
117: , p1_a5 NUMBER := 0-1962.0724

Line 115: , p1_a3 DATE := fnd_api.g_miss_date

111: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
112: , p1_a0 NUMBER := 0-1962.0724
113: , p1_a1 DATE := fnd_api.g_miss_date
114: , p1_a2 NUMBER := 0-1962.0724
115: , p1_a3 DATE := fnd_api.g_miss_date
116: , p1_a4 NUMBER := 0-1962.0724
117: , p1_a5 NUMBER := 0-1962.0724
118: , p1_a6 NUMBER := 0-1962.0724
119: , p1_a7 VARCHAR2 := fnd_api.g_miss_char

Line 119: , p1_a7 VARCHAR2 := fnd_api.g_miss_char

115: , p1_a3 DATE := fnd_api.g_miss_date
116: , p1_a4 NUMBER := 0-1962.0724
117: , p1_a5 NUMBER := 0-1962.0724
118: , p1_a6 NUMBER := 0-1962.0724
119: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
120: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
121: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
122: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
123: , p1_a11 VARCHAR2 := fnd_api.g_miss_char

Line 120: , p1_a8 VARCHAR2 := fnd_api.g_miss_char

116: , p1_a4 NUMBER := 0-1962.0724
117: , p1_a5 NUMBER := 0-1962.0724
118: , p1_a6 NUMBER := 0-1962.0724
119: , p1_a7 VARCHAR2 := fnd_api.g_miss_char
120: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
121: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
122: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
123: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
124: , p1_a12 DATE := fnd_api.g_miss_date

Line 121: , p1_a9 VARCHAR2 := fnd_api.g_miss_char

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

Line 122: , p1_a10 VARCHAR2 := fnd_api.g_miss_char

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

Line 123: , p1_a11 VARCHAR2 := fnd_api.g_miss_char

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

Line 124: , p1_a12 DATE := fnd_api.g_miss_date

120: , p1_a8 VARCHAR2 := fnd_api.g_miss_char
121: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
122: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
123: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
124: , p1_a12 DATE := fnd_api.g_miss_date
125: , p1_a13 DATE := fnd_api.g_miss_date
126: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
127: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
128: );

Line 125: , p1_a13 DATE := fnd_api.g_miss_date

121: , p1_a9 VARCHAR2 := fnd_api.g_miss_char
122: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
123: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
124: , p1_a12 DATE := fnd_api.g_miss_date
125: , p1_a13 DATE := fnd_api.g_miss_date
126: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
127: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
128: );
129: procedure init_user_status_rec(p0_a0 out nocopy NUMBER

Line 126: , p1_a14 VARCHAR2 := fnd_api.g_miss_char

122: , p1_a10 VARCHAR2 := fnd_api.g_miss_char
123: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
124: , p1_a12 DATE := fnd_api.g_miss_date
125: , p1_a13 DATE := fnd_api.g_miss_date
126: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
127: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
128: );
129: procedure init_user_status_rec(p0_a0 out nocopy NUMBER
130: , p0_a1 out nocopy DATE

Line 127: , p1_a15 VARCHAR2 := fnd_api.g_miss_char

123: , p1_a11 VARCHAR2 := fnd_api.g_miss_char
124: , p1_a12 DATE := fnd_api.g_miss_date
125: , p1_a13 DATE := fnd_api.g_miss_date
126: , p1_a14 VARCHAR2 := fnd_api.g_miss_char
127: , p1_a15 VARCHAR2 := fnd_api.g_miss_char
128: );
129: procedure init_user_status_rec(p0_a0 out nocopy NUMBER
130: , p0_a1 out nocopy DATE
131: , p0_a2 out nocopy NUMBER

Line 163: , p0_a1 DATE := fnd_api.g_miss_date

159: , p1_a13 out nocopy DATE
160: , p1_a14 out nocopy VARCHAR2
161: , p1_a15 out nocopy VARCHAR2
162: , p0_a0 NUMBER := 0-1962.0724
163: , p0_a1 DATE := fnd_api.g_miss_date
164: , p0_a2 NUMBER := 0-1962.0724
165: , p0_a3 DATE := fnd_api.g_miss_date
166: , p0_a4 NUMBER := 0-1962.0724
167: , p0_a5 NUMBER := 0-1962.0724

Line 165: , p0_a3 DATE := fnd_api.g_miss_date

161: , p1_a15 out nocopy VARCHAR2
162: , p0_a0 NUMBER := 0-1962.0724
163: , p0_a1 DATE := fnd_api.g_miss_date
164: , p0_a2 NUMBER := 0-1962.0724
165: , p0_a3 DATE := fnd_api.g_miss_date
166: , p0_a4 NUMBER := 0-1962.0724
167: , p0_a5 NUMBER := 0-1962.0724
168: , p0_a6 NUMBER := 0-1962.0724
169: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

Line 169: , p0_a7 VARCHAR2 := fnd_api.g_miss_char

165: , p0_a3 DATE := fnd_api.g_miss_date
166: , p0_a4 NUMBER := 0-1962.0724
167: , p0_a5 NUMBER := 0-1962.0724
168: , p0_a6 NUMBER := 0-1962.0724
169: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
170: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
171: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
172: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
173: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

Line 170: , p0_a8 VARCHAR2 := fnd_api.g_miss_char

166: , p0_a4 NUMBER := 0-1962.0724
167: , p0_a5 NUMBER := 0-1962.0724
168: , p0_a6 NUMBER := 0-1962.0724
169: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
170: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
171: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
172: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
173: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
174: , p0_a12 DATE := fnd_api.g_miss_date

Line 171: , p0_a9 VARCHAR2 := fnd_api.g_miss_char

167: , p0_a5 NUMBER := 0-1962.0724
168: , p0_a6 NUMBER := 0-1962.0724
169: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
170: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
171: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
172: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
173: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
174: , p0_a12 DATE := fnd_api.g_miss_date
175: , p0_a13 DATE := fnd_api.g_miss_date

Line 172: , p0_a10 VARCHAR2 := fnd_api.g_miss_char

168: , p0_a6 NUMBER := 0-1962.0724
169: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
170: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
171: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
172: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
173: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
174: , p0_a12 DATE := fnd_api.g_miss_date
175: , p0_a13 DATE := fnd_api.g_miss_date
176: , p0_a14 VARCHAR2 := fnd_api.g_miss_char

Line 173: , p0_a11 VARCHAR2 := fnd_api.g_miss_char

169: , p0_a7 VARCHAR2 := fnd_api.g_miss_char
170: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
171: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
172: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
173: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
174: , p0_a12 DATE := fnd_api.g_miss_date
175: , p0_a13 DATE := fnd_api.g_miss_date
176: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
177: , p0_a15 VARCHAR2 := fnd_api.g_miss_char

Line 174: , p0_a12 DATE := fnd_api.g_miss_date

170: , p0_a8 VARCHAR2 := fnd_api.g_miss_char
171: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
172: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
173: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
174: , p0_a12 DATE := fnd_api.g_miss_date
175: , p0_a13 DATE := fnd_api.g_miss_date
176: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
177: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
178: );

Line 175: , p0_a13 DATE := fnd_api.g_miss_date

171: , p0_a9 VARCHAR2 := fnd_api.g_miss_char
172: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
173: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
174: , p0_a12 DATE := fnd_api.g_miss_date
175: , p0_a13 DATE := fnd_api.g_miss_date
176: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
177: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
178: );
179: end ams_user_statuses_pvt_w;

Line 176: , p0_a14 VARCHAR2 := fnd_api.g_miss_char

172: , p0_a10 VARCHAR2 := fnd_api.g_miss_char
173: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
174: , p0_a12 DATE := fnd_api.g_miss_date
175: , p0_a13 DATE := fnd_api.g_miss_date
176: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
177: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
178: );
179: end ams_user_statuses_pvt_w;

Line 177: , p0_a15 VARCHAR2 := fnd_api.g_miss_char

173: , p0_a11 VARCHAR2 := fnd_api.g_miss_char
174: , p0_a12 DATE := fnd_api.g_miss_date
175: , p0_a13 DATE := fnd_api.g_miss_date
176: , p0_a14 VARCHAR2 := fnd_api.g_miss_char
177: , p0_a15 VARCHAR2 := fnd_api.g_miss_char
178: );
179: end ams_user_statuses_pvt_w;