DBA Data[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: -- x_return_status return status
161: -- x_msg_count number of messages in the list
162: -- x_msg_data text of messages
163: -- p_action_code Stop action code. Valid action codes are