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.

[Home] [Help]

APPS.WSH_TRIP_STOPS_PUB dependencies on FND_API

Line 19: STOP_ID NUMBER DEFAULT FND_API.G_MISS_NUM,

15: -- PUBLIC VARS
16: --===================
17:
18: TYPE Trip_Stop_Pub_Rec_Type IS RECORD (
19: STOP_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
20: TRIP_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
21: TRIP_NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
22: STOP_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
23: /* When this is called for Update need to populate status code

Line 20: TRIP_ID NUMBER DEFAULT FND_API.G_MISS_NUM,

16: --===================
17:
18: TYPE Trip_Stop_Pub_Rec_Type IS RECORD (
19: STOP_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
20: TRIP_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
21: TRIP_NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
22: STOP_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
23: /* When this is called for Update need to populate status code
24: and stop sequence number */

Line 21: TRIP_NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

17:
18: TYPE Trip_Stop_Pub_Rec_Type IS RECORD (
19: STOP_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
20: TRIP_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
21: TRIP_NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
22: STOP_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
23: /* When this is called for Update need to populate status code
24: and stop sequence number */
25: /* H integration for FTE- anxsharm */

Line 22: STOP_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,

18: TYPE Trip_Stop_Pub_Rec_Type IS RECORD (
19: STOP_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
20: TRIP_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
21: TRIP_NAME VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
22: STOP_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
23: /* When this is called for Update need to populate status code
24: and stop sequence number */
25: /* H integration for FTE- anxsharm */
26: STOP_SEQUENCE_NUMBER NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 26: STOP_SEQUENCE_NUMBER NUMBER DEFAULT FND_API.G_MISS_NUM,

22: STOP_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
23: /* When this is called for Update need to populate status code
24: and stop sequence number */
25: /* H integration for FTE- anxsharm */
26: STOP_SEQUENCE_NUMBER NUMBER DEFAULT FND_API.G_MISS_NUM,
27: --commented status code for H integration
28: -- never give user access to status code update directly
29: -- STATUS_CODE VARCHAR2(2) DEFAULT FND_API.G_MISS_CHAR,
30: /* End of H integration for FTE- anxsharm */

Line 29: -- STATUS_CODE VARCHAR2(2) DEFAULT FND_API.G_MISS_CHAR,

25: /* H integration for FTE- anxsharm */
26: STOP_SEQUENCE_NUMBER NUMBER DEFAULT FND_API.G_MISS_NUM,
27: --commented status code for H integration
28: -- never give user access to status code update directly
29: -- STATUS_CODE VARCHAR2(2) DEFAULT FND_API.G_MISS_CHAR,
30: /* End of H integration for FTE- anxsharm */
31: STOP_LOCATION_CODE wsh_locations.UI_LOCATION_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
32: PLANNED_ARRIVAL_DATE DATE DEFAULT FND_API.G_MISS_DATE,
33: PLANNED_DEPARTURE_DATE DATE DEFAULT FND_API.G_MISS_DATE,

Line 31: STOP_LOCATION_CODE wsh_locations.UI_LOCATION_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,

27: --commented status code for H integration
28: -- never give user access to status code update directly
29: -- STATUS_CODE VARCHAR2(2) DEFAULT FND_API.G_MISS_CHAR,
30: /* End of H integration for FTE- anxsharm */
31: STOP_LOCATION_CODE wsh_locations.UI_LOCATION_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
32: PLANNED_ARRIVAL_DATE DATE DEFAULT FND_API.G_MISS_DATE,
33: PLANNED_DEPARTURE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
34: ACTUAL_ARRIVAL_DATE DATE DEFAULT FND_API.G_MISS_DATE,
35: ACTUAL_DEPARTURE_DATE DATE DEFAULT FND_API.G_MISS_DATE,

Line 32: PLANNED_ARRIVAL_DATE DATE DEFAULT FND_API.G_MISS_DATE,

28: -- never give user access to status code update directly
29: -- STATUS_CODE VARCHAR2(2) DEFAULT FND_API.G_MISS_CHAR,
30: /* End of H integration for FTE- anxsharm */
31: STOP_LOCATION_CODE wsh_locations.UI_LOCATION_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
32: PLANNED_ARRIVAL_DATE DATE DEFAULT FND_API.G_MISS_DATE,
33: PLANNED_DEPARTURE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
34: ACTUAL_ARRIVAL_DATE DATE DEFAULT FND_API.G_MISS_DATE,
35: ACTUAL_DEPARTURE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
36: DEPARTURE_GROSS_WEIGHT NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 33: PLANNED_DEPARTURE_DATE DATE DEFAULT FND_API.G_MISS_DATE,

29: -- STATUS_CODE VARCHAR2(2) DEFAULT FND_API.G_MISS_CHAR,
30: /* End of H integration for FTE- anxsharm */
31: STOP_LOCATION_CODE wsh_locations.UI_LOCATION_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
32: PLANNED_ARRIVAL_DATE DATE DEFAULT FND_API.G_MISS_DATE,
33: PLANNED_DEPARTURE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
34: ACTUAL_ARRIVAL_DATE DATE DEFAULT FND_API.G_MISS_DATE,
35: ACTUAL_DEPARTURE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
36: DEPARTURE_GROSS_WEIGHT NUMBER DEFAULT FND_API.G_MISS_NUM,
37: DEPARTURE_NET_WEIGHT NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 34: ACTUAL_ARRIVAL_DATE DATE DEFAULT FND_API.G_MISS_DATE,

30: /* End of H integration for FTE- anxsharm */
31: STOP_LOCATION_CODE wsh_locations.UI_LOCATION_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
32: PLANNED_ARRIVAL_DATE DATE DEFAULT FND_API.G_MISS_DATE,
33: PLANNED_DEPARTURE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
34: ACTUAL_ARRIVAL_DATE DATE DEFAULT FND_API.G_MISS_DATE,
35: ACTUAL_DEPARTURE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
36: DEPARTURE_GROSS_WEIGHT NUMBER DEFAULT FND_API.G_MISS_NUM,
37: DEPARTURE_NET_WEIGHT NUMBER DEFAULT FND_API.G_MISS_NUM,
38: WEIGHT_UOM_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,

Line 35: ACTUAL_DEPARTURE_DATE DATE DEFAULT FND_API.G_MISS_DATE,

31: STOP_LOCATION_CODE wsh_locations.UI_LOCATION_CODE%TYPE DEFAULT FND_API.G_MISS_CHAR,
32: PLANNED_ARRIVAL_DATE DATE DEFAULT FND_API.G_MISS_DATE,
33: PLANNED_DEPARTURE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
34: ACTUAL_ARRIVAL_DATE DATE DEFAULT FND_API.G_MISS_DATE,
35: ACTUAL_DEPARTURE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
36: DEPARTURE_GROSS_WEIGHT NUMBER DEFAULT FND_API.G_MISS_NUM,
37: DEPARTURE_NET_WEIGHT NUMBER DEFAULT FND_API.G_MISS_NUM,
38: WEIGHT_UOM_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
39: WEIGHT_UOM_DESC VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,

Line 36: DEPARTURE_GROSS_WEIGHT NUMBER DEFAULT FND_API.G_MISS_NUM,

32: PLANNED_ARRIVAL_DATE DATE DEFAULT FND_API.G_MISS_DATE,
33: PLANNED_DEPARTURE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
34: ACTUAL_ARRIVAL_DATE DATE DEFAULT FND_API.G_MISS_DATE,
35: ACTUAL_DEPARTURE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
36: DEPARTURE_GROSS_WEIGHT NUMBER DEFAULT FND_API.G_MISS_NUM,
37: DEPARTURE_NET_WEIGHT NUMBER DEFAULT FND_API.G_MISS_NUM,
38: WEIGHT_UOM_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
39: WEIGHT_UOM_DESC VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
40: DEPARTURE_VOLUME NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 37: DEPARTURE_NET_WEIGHT NUMBER DEFAULT FND_API.G_MISS_NUM,

33: PLANNED_DEPARTURE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
34: ACTUAL_ARRIVAL_DATE DATE DEFAULT FND_API.G_MISS_DATE,
35: ACTUAL_DEPARTURE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
36: DEPARTURE_GROSS_WEIGHT NUMBER DEFAULT FND_API.G_MISS_NUM,
37: DEPARTURE_NET_WEIGHT NUMBER DEFAULT FND_API.G_MISS_NUM,
38: WEIGHT_UOM_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
39: WEIGHT_UOM_DESC VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
40: DEPARTURE_VOLUME NUMBER DEFAULT FND_API.G_MISS_NUM,
41: VOLUME_UOM_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,

Line 38: WEIGHT_UOM_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,

34: ACTUAL_ARRIVAL_DATE DATE DEFAULT FND_API.G_MISS_DATE,
35: ACTUAL_DEPARTURE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
36: DEPARTURE_GROSS_WEIGHT NUMBER DEFAULT FND_API.G_MISS_NUM,
37: DEPARTURE_NET_WEIGHT NUMBER DEFAULT FND_API.G_MISS_NUM,
38: WEIGHT_UOM_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
39: WEIGHT_UOM_DESC VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
40: DEPARTURE_VOLUME NUMBER DEFAULT FND_API.G_MISS_NUM,
41: VOLUME_UOM_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
42: VOLUME_UOM_DESC VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,

Line 39: WEIGHT_UOM_DESC VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,

35: ACTUAL_DEPARTURE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
36: DEPARTURE_GROSS_WEIGHT NUMBER DEFAULT FND_API.G_MISS_NUM,
37: DEPARTURE_NET_WEIGHT NUMBER DEFAULT FND_API.G_MISS_NUM,
38: WEIGHT_UOM_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
39: WEIGHT_UOM_DESC VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
40: DEPARTURE_VOLUME NUMBER DEFAULT FND_API.G_MISS_NUM,
41: VOLUME_UOM_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
42: VOLUME_UOM_DESC VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
43: DEPARTURE_SEAL_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

Line 40: DEPARTURE_VOLUME NUMBER DEFAULT FND_API.G_MISS_NUM,

36: DEPARTURE_GROSS_WEIGHT NUMBER DEFAULT FND_API.G_MISS_NUM,
37: DEPARTURE_NET_WEIGHT NUMBER DEFAULT FND_API.G_MISS_NUM,
38: WEIGHT_UOM_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
39: WEIGHT_UOM_DESC VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
40: DEPARTURE_VOLUME NUMBER DEFAULT FND_API.G_MISS_NUM,
41: VOLUME_UOM_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
42: VOLUME_UOM_DESC VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
43: DEPARTURE_SEAL_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
44: DEPARTURE_FILL_PERCENT NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 41: VOLUME_UOM_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,

37: DEPARTURE_NET_WEIGHT NUMBER DEFAULT FND_API.G_MISS_NUM,
38: WEIGHT_UOM_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
39: WEIGHT_UOM_DESC VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
40: DEPARTURE_VOLUME NUMBER DEFAULT FND_API.G_MISS_NUM,
41: VOLUME_UOM_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
42: VOLUME_UOM_DESC VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
43: DEPARTURE_SEAL_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
44: DEPARTURE_FILL_PERCENT NUMBER DEFAULT FND_API.G_MISS_NUM,
45: TP_ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 42: VOLUME_UOM_DESC VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,

38: WEIGHT_UOM_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
39: WEIGHT_UOM_DESC VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
40: DEPARTURE_VOLUME NUMBER DEFAULT FND_API.G_MISS_NUM,
41: VOLUME_UOM_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
42: VOLUME_UOM_DESC VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
43: DEPARTURE_SEAL_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
44: DEPARTURE_FILL_PERCENT NUMBER DEFAULT FND_API.G_MISS_NUM,
45: TP_ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
46: TP_ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 43: DEPARTURE_SEAL_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,

39: WEIGHT_UOM_DESC VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
40: DEPARTURE_VOLUME NUMBER DEFAULT FND_API.G_MISS_NUM,
41: VOLUME_UOM_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
42: VOLUME_UOM_DESC VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
43: DEPARTURE_SEAL_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
44: DEPARTURE_FILL_PERCENT NUMBER DEFAULT FND_API.G_MISS_NUM,
45: TP_ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
46: TP_ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
47: TP_ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 44: DEPARTURE_FILL_PERCENT NUMBER DEFAULT FND_API.G_MISS_NUM,

40: DEPARTURE_VOLUME NUMBER DEFAULT FND_API.G_MISS_NUM,
41: VOLUME_UOM_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
42: VOLUME_UOM_DESC VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
43: DEPARTURE_SEAL_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
44: DEPARTURE_FILL_PERCENT NUMBER DEFAULT FND_API.G_MISS_NUM,
45: TP_ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
46: TP_ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
47: TP_ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
48: TP_ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 45: TP_ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

41: VOLUME_UOM_CODE VARCHAR2(3) DEFAULT FND_API.G_MISS_CHAR,
42: VOLUME_UOM_DESC VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
43: DEPARTURE_SEAL_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
44: DEPARTURE_FILL_PERCENT NUMBER DEFAULT FND_API.G_MISS_NUM,
45: TP_ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
46: TP_ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
47: TP_ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
48: TP_ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
49: TP_ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 46: TP_ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

42: VOLUME_UOM_DESC VARCHAR2(25) DEFAULT FND_API.G_MISS_CHAR,
43: DEPARTURE_SEAL_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
44: DEPARTURE_FILL_PERCENT NUMBER DEFAULT FND_API.G_MISS_NUM,
45: TP_ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
46: TP_ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
47: TP_ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
48: TP_ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
49: TP_ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
50: TP_ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 47: TP_ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

43: DEPARTURE_SEAL_CODE VARCHAR2(30) DEFAULT FND_API.G_MISS_CHAR,
44: DEPARTURE_FILL_PERCENT NUMBER DEFAULT FND_API.G_MISS_NUM,
45: TP_ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
46: TP_ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
47: TP_ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
48: TP_ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
49: TP_ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
50: TP_ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
51: TP_ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 48: TP_ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

44: DEPARTURE_FILL_PERCENT NUMBER DEFAULT FND_API.G_MISS_NUM,
45: TP_ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
46: TP_ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
47: TP_ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
48: TP_ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
49: TP_ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
50: TP_ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
51: TP_ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
52: TP_ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 49: TP_ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

45: TP_ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
46: TP_ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
47: TP_ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
48: TP_ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
49: TP_ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
50: TP_ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
51: TP_ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
52: TP_ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
53: TP_ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 50: TP_ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

46: TP_ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
47: TP_ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
48: TP_ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
49: TP_ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
50: TP_ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
51: TP_ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
52: TP_ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
53: TP_ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
54: TP_ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 51: TP_ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

47: TP_ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
48: TP_ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
49: TP_ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
50: TP_ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
51: TP_ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
52: TP_ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
53: TP_ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
54: TP_ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
55: TP_ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 52: TP_ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

48: TP_ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
49: TP_ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
50: TP_ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
51: TP_ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
52: TP_ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
53: TP_ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
54: TP_ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
55: TP_ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
56: TP_ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 53: TP_ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

49: TP_ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
50: TP_ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
51: TP_ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
52: TP_ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
53: TP_ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
54: TP_ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
55: TP_ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
56: TP_ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
57: TP_ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 54: TP_ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

50: TP_ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
51: TP_ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
52: TP_ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
53: TP_ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
54: TP_ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
55: TP_ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
56: TP_ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
57: TP_ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
58: TP_ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 55: TP_ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

51: TP_ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
52: TP_ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
53: TP_ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
54: TP_ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
55: TP_ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
56: TP_ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
57: TP_ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
58: TP_ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
59: TP_ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 56: TP_ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

52: TP_ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
53: TP_ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
54: TP_ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
55: TP_ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
56: TP_ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
57: TP_ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
58: TP_ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
59: TP_ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
60: TP_ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 57: TP_ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

53: TP_ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
54: TP_ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
55: TP_ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
56: TP_ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
57: TP_ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
58: TP_ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
59: TP_ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
60: TP_ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
61: ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 58: TP_ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

54: TP_ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
55: TP_ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
56: TP_ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
57: TP_ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
58: TP_ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
59: TP_ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
60: TP_ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
61: ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
62: ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 59: TP_ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

55: TP_ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
56: TP_ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
57: TP_ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
58: TP_ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
59: TP_ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
60: TP_ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
61: ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
62: ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
63: ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 60: TP_ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

56: TP_ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
57: TP_ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
58: TP_ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
59: TP_ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
60: TP_ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
61: ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
62: ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
63: ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
64: ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 61: ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

57: TP_ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
58: TP_ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
59: TP_ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
60: TP_ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
61: ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
62: ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
63: ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
64: ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
65: ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 62: ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

58: TP_ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
59: TP_ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
60: TP_ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
61: ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
62: ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
63: ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
64: ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
65: ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
66: ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 63: ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

59: TP_ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
60: TP_ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
61: ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
62: ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
63: ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
64: ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
65: ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
66: ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
67: ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 64: ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

60: TP_ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
61: ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
62: ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
63: ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
64: ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
65: ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
66: ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
67: ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
68: ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 65: ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

61: ATTRIBUTE_CATEGORY VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
62: ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
63: ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
64: ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
65: ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
66: ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
67: ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
68: ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
69: ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 66: ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

62: ATTRIBUTE1 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
63: ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
64: ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
65: ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
66: ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
67: ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
68: ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
69: ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
70: ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 67: ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

63: ATTRIBUTE2 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
64: ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
65: ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
66: ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
67: ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
68: ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
69: ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
70: ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
71: ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 68: ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

64: ATTRIBUTE3 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
65: ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
66: ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
67: ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
68: ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
69: ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
70: ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
71: ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
72: ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 69: ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

65: ATTRIBUTE4 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
66: ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
67: ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
68: ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
69: ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
70: ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
71: ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
72: ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
73: ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 70: ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

66: ATTRIBUTE5 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
67: ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
68: ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
69: ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
70: ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
71: ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
72: ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
73: ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
74: ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 71: ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

67: ATTRIBUTE6 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
68: ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
69: ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
70: ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
71: ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
72: ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
73: ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
74: ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
75: ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 72: ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

68: ATTRIBUTE7 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
69: ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
70: ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
71: ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
72: ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
73: ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
74: ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
75: ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
76: ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

Line 73: ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

69: ATTRIBUTE8 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
70: ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
71: ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
72: ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
73: ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
74: ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
75: ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
76: ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
77: CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE,

Line 74: ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

70: ATTRIBUTE9 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
71: ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
72: ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
73: ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
74: ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
75: ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
76: ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
77: CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE,
78: CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 75: ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

71: ATTRIBUTE10 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
72: ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
73: ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
74: ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
75: ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
76: ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
77: CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE,
78: CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
79: LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,

Line 76: ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,

72: ATTRIBUTE11 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
73: ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
74: ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
75: ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
76: ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
77: CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE,
78: CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
79: LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
80: LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 77: CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE,

73: ATTRIBUTE12 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
74: ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
75: ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
76: ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
77: CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE,
78: CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
79: LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
80: LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
81: LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 78: CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,

74: ATTRIBUTE13 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
75: ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
76: ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
77: CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE,
78: CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
79: LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
80: LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
81: LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM,
82: PROGRAM_APPLICATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 79: LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,

75: ATTRIBUTE14 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
76: ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
77: CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE,
78: CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
79: LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
80: LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
81: LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM,
82: PROGRAM_APPLICATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
83: PROGRAM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 80: LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,

76: ATTRIBUTE15 VARCHAR2(150) DEFAULT FND_API.G_MISS_CHAR,
77: CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE,
78: CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
79: LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
80: LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
81: LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM,
82: PROGRAM_APPLICATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
83: PROGRAM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
84: PROGRAM_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,

Line 81: LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM,

77: CREATION_DATE DATE DEFAULT FND_API.G_MISS_DATE,
78: CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
79: LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
80: LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
81: LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM,
82: PROGRAM_APPLICATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
83: PROGRAM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
84: PROGRAM_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
85: REQUEST_ID NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 82: PROGRAM_APPLICATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,

78: CREATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
79: LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
80: LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
81: LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM,
82: PROGRAM_APPLICATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
83: PROGRAM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
84: PROGRAM_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
85: REQUEST_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
86: -- csun 10+ internal location change

Line 83: PROGRAM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,

79: LAST_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
80: LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
81: LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM,
82: PROGRAM_APPLICATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
83: PROGRAM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
84: PROGRAM_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
85: REQUEST_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
86: -- csun 10+ internal location change
87: PHYSICAL_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,

Line 84: PROGRAM_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,

80: LAST_UPDATED_BY NUMBER DEFAULT FND_API.G_MISS_NUM,
81: LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM,
82: PROGRAM_APPLICATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
83: PROGRAM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
84: PROGRAM_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
85: REQUEST_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
86: -- csun 10+ internal location change
87: PHYSICAL_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
88: PHYSICAL_STOP_ID NUMBER DEFAULT FND_API.G_MISS_NUM);

Line 85: REQUEST_ID NUMBER DEFAULT FND_API.G_MISS_NUM,

81: LAST_UPDATE_LOGIN NUMBER DEFAULT FND_API.G_MISS_NUM,
82: PROGRAM_APPLICATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
83: PROGRAM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
84: PROGRAM_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
85: REQUEST_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
86: -- csun 10+ internal location change
87: PHYSICAL_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
88: PHYSICAL_STOP_ID NUMBER DEFAULT FND_API.G_MISS_NUM);
89:

Line 87: PHYSICAL_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,

83: PROGRAM_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
84: PROGRAM_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
85: REQUEST_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
86: -- csun 10+ internal location change
87: PHYSICAL_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
88: PHYSICAL_STOP_ID NUMBER DEFAULT FND_API.G_MISS_NUM);
89:
90: --===================
91: -- PROCEDURES

Line 88: PHYSICAL_STOP_ID NUMBER DEFAULT FND_API.G_MISS_NUM);

84: PROGRAM_UPDATE_DATE DATE DEFAULT FND_API.G_MISS_DATE,
85: REQUEST_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
86: -- csun 10+ internal location change
87: PHYSICAL_LOCATION_ID NUMBER DEFAULT FND_API.G_MISS_NUM,
88: PHYSICAL_STOP_ID NUMBER DEFAULT FND_API.G_MISS_NUM);
89:
90: --===================
91: -- PROCEDURES
92: --===================

Line 98: -- p_init_msg_list FND_API.G_TRUE to reset list

94: --========================================================================
95: -- PROCEDURE : Create_Update_Stop PUBLIC
96: --
97: -- PARAMETERS: p_api_version_number known api versionerror buffer
98: -- p_init_msg_list FND_API.G_TRUE to reset list
99: -- x_return_status return status
100: -- x_msg_count number of messages in the list
101: -- x_msg_data text of messages
102: -- p_stop_info Attributes for the stop entity

Line 147: p_trip_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

143: x_msg_count OUT NOCOPY NUMBER,
144: x_msg_data OUT NOCOPY VARCHAR2,
145: p_action_code IN VARCHAR2,
146: p_stop_info IN OUT NOCOPY Trip_Stop_Pub_Rec_Type,
147: p_trip_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
148: p_trip_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
149: p_stop_location_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
150: p_stop_location_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
151: p_planned_dep_date IN DATE DEFAULT FND_API.G_MISS_DATE,

Line 148: p_trip_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

144: x_msg_data OUT NOCOPY VARCHAR2,
145: p_action_code IN VARCHAR2,
146: p_stop_info IN OUT NOCOPY Trip_Stop_Pub_Rec_Type,
147: p_trip_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
148: p_trip_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
149: p_stop_location_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
150: p_stop_location_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
151: p_planned_dep_date IN DATE DEFAULT FND_API.G_MISS_DATE,
152: x_stop_id OUT NOCOPY NUMBER);

Line 149: p_stop_location_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

145: p_action_code IN VARCHAR2,
146: p_stop_info IN OUT NOCOPY Trip_Stop_Pub_Rec_Type,
147: p_trip_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
148: p_trip_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
149: p_stop_location_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
150: p_stop_location_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
151: p_planned_dep_date IN DATE DEFAULT FND_API.G_MISS_DATE,
152: x_stop_id OUT NOCOPY NUMBER);
153:

Line 150: p_stop_location_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

146: p_stop_info IN OUT NOCOPY Trip_Stop_Pub_Rec_Type,
147: p_trip_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
148: p_trip_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
149: p_stop_location_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
150: p_stop_location_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
151: p_planned_dep_date IN DATE DEFAULT FND_API.G_MISS_DATE,
152: x_stop_id OUT NOCOPY NUMBER);
153:
154:

Line 151: p_planned_dep_date IN DATE DEFAULT FND_API.G_MISS_DATE,

147: p_trip_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
148: p_trip_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
149: p_stop_location_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
150: p_stop_location_code IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
151: p_planned_dep_date IN DATE DEFAULT FND_API.G_MISS_DATE,
152: x_stop_id OUT NOCOPY NUMBER);
153:
154:
155: --========================================================================

Line 159: -- p_init_msg_list FND_API.G_TRUE to reset list

155: --========================================================================
156: -- PROCEDURE : Stop_Action PUBLIC
157: --
158: -- PARAMETERS: p_api_version_number known api version error number
159: -- p_init_msg_list FND_API.G_TRUE to reset list
160: -- p_commit To commit the data or not
161: -- x_return_status return status
162: -- x_msg_count number of messages in the list
163: -- x_msg_data text of messages

Line 211: p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE,

207:
208: PROCEDURE Stop_Action
209: ( p_api_version_number IN NUMBER,
210: p_init_msg_list IN VARCHAR2,
211: p_commit IN VARCHAR2 DEFAULT FND_API.G_TRUE,
212: x_return_status OUT NOCOPY VARCHAR2,
213: x_msg_count OUT NOCOPY NUMBER,
214: x_msg_data OUT NOCOPY VARCHAR2,
215: p_action_code IN VARCHAR2,