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

APPS.JTF_TERR_LOOKUP_PUB dependencies on FND_API

Line 64: trans_object_id NUMBER := FND_API.G_MISS_NUM,

60: -- logic control properties
61: use_type VARCHAR2(30), -- refer to body for valid values of this parameter
62: source_id NUMBER,
63: transaction_id NUMBER,
64: trans_object_id NUMBER := FND_API.G_MISS_NUM,
65: trans_detail_object_id NUMBER := FND_API.G_MISS_NUM,
66:
67: -- transaction qualifier values
68: SQUAL_CHAR01 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 65: trans_detail_object_id NUMBER := FND_API.G_MISS_NUM,

61: use_type VARCHAR2(30), -- refer to body for valid values of this parameter
62: source_id NUMBER,
63: transaction_id NUMBER,
64: trans_object_id NUMBER := FND_API.G_MISS_NUM,
65: trans_detail_object_id NUMBER := FND_API.G_MISS_NUM,
66:
67: -- transaction qualifier values
68: SQUAL_CHAR01 VARCHAR2(360) := FND_API.G_MISS_CHAR,
69: SQUAL_CHAR02 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 68: SQUAL_CHAR01 VARCHAR2(360) := FND_API.G_MISS_CHAR,

64: trans_object_id NUMBER := FND_API.G_MISS_NUM,
65: trans_detail_object_id NUMBER := FND_API.G_MISS_NUM,
66:
67: -- transaction qualifier values
68: SQUAL_CHAR01 VARCHAR2(360) := FND_API.G_MISS_CHAR,
69: SQUAL_CHAR02 VARCHAR2(360) := FND_API.G_MISS_CHAR,
70: SQUAL_CHAR03 VARCHAR2(360) := FND_API.G_MISS_CHAR,
71: SQUAL_CHAR04 VARCHAR2(360) := FND_API.G_MISS_CHAR,
72: SQUAL_CHAR05 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 69: SQUAL_CHAR02 VARCHAR2(360) := FND_API.G_MISS_CHAR,

65: trans_detail_object_id NUMBER := FND_API.G_MISS_NUM,
66:
67: -- transaction qualifier values
68: SQUAL_CHAR01 VARCHAR2(360) := FND_API.G_MISS_CHAR,
69: SQUAL_CHAR02 VARCHAR2(360) := FND_API.G_MISS_CHAR,
70: SQUAL_CHAR03 VARCHAR2(360) := FND_API.G_MISS_CHAR,
71: SQUAL_CHAR04 VARCHAR2(360) := FND_API.G_MISS_CHAR,
72: SQUAL_CHAR05 VARCHAR2(360) := FND_API.G_MISS_CHAR,
73: SQUAL_CHAR06 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 70: SQUAL_CHAR03 VARCHAR2(360) := FND_API.G_MISS_CHAR,

66:
67: -- transaction qualifier values
68: SQUAL_CHAR01 VARCHAR2(360) := FND_API.G_MISS_CHAR,
69: SQUAL_CHAR02 VARCHAR2(360) := FND_API.G_MISS_CHAR,
70: SQUAL_CHAR03 VARCHAR2(360) := FND_API.G_MISS_CHAR,
71: SQUAL_CHAR04 VARCHAR2(360) := FND_API.G_MISS_CHAR,
72: SQUAL_CHAR05 VARCHAR2(360) := FND_API.G_MISS_CHAR,
73: SQUAL_CHAR06 VARCHAR2(360) := FND_API.G_MISS_CHAR,
74: SQUAL_CHAR07 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 71: SQUAL_CHAR04 VARCHAR2(360) := FND_API.G_MISS_CHAR,

67: -- transaction qualifier values
68: SQUAL_CHAR01 VARCHAR2(360) := FND_API.G_MISS_CHAR,
69: SQUAL_CHAR02 VARCHAR2(360) := FND_API.G_MISS_CHAR,
70: SQUAL_CHAR03 VARCHAR2(360) := FND_API.G_MISS_CHAR,
71: SQUAL_CHAR04 VARCHAR2(360) := FND_API.G_MISS_CHAR,
72: SQUAL_CHAR05 VARCHAR2(360) := FND_API.G_MISS_CHAR,
73: SQUAL_CHAR06 VARCHAR2(360) := FND_API.G_MISS_CHAR,
74: SQUAL_CHAR07 VARCHAR2(360) := FND_API.G_MISS_CHAR,
75: SQUAL_CHAR08 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 72: SQUAL_CHAR05 VARCHAR2(360) := FND_API.G_MISS_CHAR,

68: SQUAL_CHAR01 VARCHAR2(360) := FND_API.G_MISS_CHAR,
69: SQUAL_CHAR02 VARCHAR2(360) := FND_API.G_MISS_CHAR,
70: SQUAL_CHAR03 VARCHAR2(360) := FND_API.G_MISS_CHAR,
71: SQUAL_CHAR04 VARCHAR2(360) := FND_API.G_MISS_CHAR,
72: SQUAL_CHAR05 VARCHAR2(360) := FND_API.G_MISS_CHAR,
73: SQUAL_CHAR06 VARCHAR2(360) := FND_API.G_MISS_CHAR,
74: SQUAL_CHAR07 VARCHAR2(360) := FND_API.G_MISS_CHAR,
75: SQUAL_CHAR08 VARCHAR2(360) := FND_API.G_MISS_CHAR,
76: SQUAL_CHAR09 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 73: SQUAL_CHAR06 VARCHAR2(360) := FND_API.G_MISS_CHAR,

69: SQUAL_CHAR02 VARCHAR2(360) := FND_API.G_MISS_CHAR,
70: SQUAL_CHAR03 VARCHAR2(360) := FND_API.G_MISS_CHAR,
71: SQUAL_CHAR04 VARCHAR2(360) := FND_API.G_MISS_CHAR,
72: SQUAL_CHAR05 VARCHAR2(360) := FND_API.G_MISS_CHAR,
73: SQUAL_CHAR06 VARCHAR2(360) := FND_API.G_MISS_CHAR,
74: SQUAL_CHAR07 VARCHAR2(360) := FND_API.G_MISS_CHAR,
75: SQUAL_CHAR08 VARCHAR2(360) := FND_API.G_MISS_CHAR,
76: SQUAL_CHAR09 VARCHAR2(360) := FND_API.G_MISS_CHAR,
77: SQUAL_CHAR10 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 74: SQUAL_CHAR07 VARCHAR2(360) := FND_API.G_MISS_CHAR,

70: SQUAL_CHAR03 VARCHAR2(360) := FND_API.G_MISS_CHAR,
71: SQUAL_CHAR04 VARCHAR2(360) := FND_API.G_MISS_CHAR,
72: SQUAL_CHAR05 VARCHAR2(360) := FND_API.G_MISS_CHAR,
73: SQUAL_CHAR06 VARCHAR2(360) := FND_API.G_MISS_CHAR,
74: SQUAL_CHAR07 VARCHAR2(360) := FND_API.G_MISS_CHAR,
75: SQUAL_CHAR08 VARCHAR2(360) := FND_API.G_MISS_CHAR,
76: SQUAL_CHAR09 VARCHAR2(360) := FND_API.G_MISS_CHAR,
77: SQUAL_CHAR10 VARCHAR2(360) := FND_API.G_MISS_CHAR,
78: SQUAL_CHAR11 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 75: SQUAL_CHAR08 VARCHAR2(360) := FND_API.G_MISS_CHAR,

71: SQUAL_CHAR04 VARCHAR2(360) := FND_API.G_MISS_CHAR,
72: SQUAL_CHAR05 VARCHAR2(360) := FND_API.G_MISS_CHAR,
73: SQUAL_CHAR06 VARCHAR2(360) := FND_API.G_MISS_CHAR,
74: SQUAL_CHAR07 VARCHAR2(360) := FND_API.G_MISS_CHAR,
75: SQUAL_CHAR08 VARCHAR2(360) := FND_API.G_MISS_CHAR,
76: SQUAL_CHAR09 VARCHAR2(360) := FND_API.G_MISS_CHAR,
77: SQUAL_CHAR10 VARCHAR2(360) := FND_API.G_MISS_CHAR,
78: SQUAL_CHAR11 VARCHAR2(360) := FND_API.G_MISS_CHAR,
79: SQUAL_CHAR12 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 76: SQUAL_CHAR09 VARCHAR2(360) := FND_API.G_MISS_CHAR,

72: SQUAL_CHAR05 VARCHAR2(360) := FND_API.G_MISS_CHAR,
73: SQUAL_CHAR06 VARCHAR2(360) := FND_API.G_MISS_CHAR,
74: SQUAL_CHAR07 VARCHAR2(360) := FND_API.G_MISS_CHAR,
75: SQUAL_CHAR08 VARCHAR2(360) := FND_API.G_MISS_CHAR,
76: SQUAL_CHAR09 VARCHAR2(360) := FND_API.G_MISS_CHAR,
77: SQUAL_CHAR10 VARCHAR2(360) := FND_API.G_MISS_CHAR,
78: SQUAL_CHAR11 VARCHAR2(360) := FND_API.G_MISS_CHAR,
79: SQUAL_CHAR12 VARCHAR2(360) := FND_API.G_MISS_CHAR,
80: SQUAL_CHAR13 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 77: SQUAL_CHAR10 VARCHAR2(360) := FND_API.G_MISS_CHAR,

73: SQUAL_CHAR06 VARCHAR2(360) := FND_API.G_MISS_CHAR,
74: SQUAL_CHAR07 VARCHAR2(360) := FND_API.G_MISS_CHAR,
75: SQUAL_CHAR08 VARCHAR2(360) := FND_API.G_MISS_CHAR,
76: SQUAL_CHAR09 VARCHAR2(360) := FND_API.G_MISS_CHAR,
77: SQUAL_CHAR10 VARCHAR2(360) := FND_API.G_MISS_CHAR,
78: SQUAL_CHAR11 VARCHAR2(360) := FND_API.G_MISS_CHAR,
79: SQUAL_CHAR12 VARCHAR2(360) := FND_API.G_MISS_CHAR,
80: SQUAL_CHAR13 VARCHAR2(360) := FND_API.G_MISS_CHAR,
81: SQUAL_CHAR14 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 78: SQUAL_CHAR11 VARCHAR2(360) := FND_API.G_MISS_CHAR,

74: SQUAL_CHAR07 VARCHAR2(360) := FND_API.G_MISS_CHAR,
75: SQUAL_CHAR08 VARCHAR2(360) := FND_API.G_MISS_CHAR,
76: SQUAL_CHAR09 VARCHAR2(360) := FND_API.G_MISS_CHAR,
77: SQUAL_CHAR10 VARCHAR2(360) := FND_API.G_MISS_CHAR,
78: SQUAL_CHAR11 VARCHAR2(360) := FND_API.G_MISS_CHAR,
79: SQUAL_CHAR12 VARCHAR2(360) := FND_API.G_MISS_CHAR,
80: SQUAL_CHAR13 VARCHAR2(360) := FND_API.G_MISS_CHAR,
81: SQUAL_CHAR14 VARCHAR2(360) := FND_API.G_MISS_CHAR,
82: SQUAL_CHAR15 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 79: SQUAL_CHAR12 VARCHAR2(360) := FND_API.G_MISS_CHAR,

75: SQUAL_CHAR08 VARCHAR2(360) := FND_API.G_MISS_CHAR,
76: SQUAL_CHAR09 VARCHAR2(360) := FND_API.G_MISS_CHAR,
77: SQUAL_CHAR10 VARCHAR2(360) := FND_API.G_MISS_CHAR,
78: SQUAL_CHAR11 VARCHAR2(360) := FND_API.G_MISS_CHAR,
79: SQUAL_CHAR12 VARCHAR2(360) := FND_API.G_MISS_CHAR,
80: SQUAL_CHAR13 VARCHAR2(360) := FND_API.G_MISS_CHAR,
81: SQUAL_CHAR14 VARCHAR2(360) := FND_API.G_MISS_CHAR,
82: SQUAL_CHAR15 VARCHAR2(360) := FND_API.G_MISS_CHAR,
83: SQUAL_CHAR16 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 80: SQUAL_CHAR13 VARCHAR2(360) := FND_API.G_MISS_CHAR,

76: SQUAL_CHAR09 VARCHAR2(360) := FND_API.G_MISS_CHAR,
77: SQUAL_CHAR10 VARCHAR2(360) := FND_API.G_MISS_CHAR,
78: SQUAL_CHAR11 VARCHAR2(360) := FND_API.G_MISS_CHAR,
79: SQUAL_CHAR12 VARCHAR2(360) := FND_API.G_MISS_CHAR,
80: SQUAL_CHAR13 VARCHAR2(360) := FND_API.G_MISS_CHAR,
81: SQUAL_CHAR14 VARCHAR2(360) := FND_API.G_MISS_CHAR,
82: SQUAL_CHAR15 VARCHAR2(360) := FND_API.G_MISS_CHAR,
83: SQUAL_CHAR16 VARCHAR2(360) := FND_API.G_MISS_CHAR,
84: SQUAL_CHAR17 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 81: SQUAL_CHAR14 VARCHAR2(360) := FND_API.G_MISS_CHAR,

77: SQUAL_CHAR10 VARCHAR2(360) := FND_API.G_MISS_CHAR,
78: SQUAL_CHAR11 VARCHAR2(360) := FND_API.G_MISS_CHAR,
79: SQUAL_CHAR12 VARCHAR2(360) := FND_API.G_MISS_CHAR,
80: SQUAL_CHAR13 VARCHAR2(360) := FND_API.G_MISS_CHAR,
81: SQUAL_CHAR14 VARCHAR2(360) := FND_API.G_MISS_CHAR,
82: SQUAL_CHAR15 VARCHAR2(360) := FND_API.G_MISS_CHAR,
83: SQUAL_CHAR16 VARCHAR2(360) := FND_API.G_MISS_CHAR,
84: SQUAL_CHAR17 VARCHAR2(360) := FND_API.G_MISS_CHAR,
85: SQUAL_CHAR18 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 82: SQUAL_CHAR15 VARCHAR2(360) := FND_API.G_MISS_CHAR,

78: SQUAL_CHAR11 VARCHAR2(360) := FND_API.G_MISS_CHAR,
79: SQUAL_CHAR12 VARCHAR2(360) := FND_API.G_MISS_CHAR,
80: SQUAL_CHAR13 VARCHAR2(360) := FND_API.G_MISS_CHAR,
81: SQUAL_CHAR14 VARCHAR2(360) := FND_API.G_MISS_CHAR,
82: SQUAL_CHAR15 VARCHAR2(360) := FND_API.G_MISS_CHAR,
83: SQUAL_CHAR16 VARCHAR2(360) := FND_API.G_MISS_CHAR,
84: SQUAL_CHAR17 VARCHAR2(360) := FND_API.G_MISS_CHAR,
85: SQUAL_CHAR18 VARCHAR2(360) := FND_API.G_MISS_CHAR,
86: SQUAL_CHAR19 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 83: SQUAL_CHAR16 VARCHAR2(360) := FND_API.G_MISS_CHAR,

79: SQUAL_CHAR12 VARCHAR2(360) := FND_API.G_MISS_CHAR,
80: SQUAL_CHAR13 VARCHAR2(360) := FND_API.G_MISS_CHAR,
81: SQUAL_CHAR14 VARCHAR2(360) := FND_API.G_MISS_CHAR,
82: SQUAL_CHAR15 VARCHAR2(360) := FND_API.G_MISS_CHAR,
83: SQUAL_CHAR16 VARCHAR2(360) := FND_API.G_MISS_CHAR,
84: SQUAL_CHAR17 VARCHAR2(360) := FND_API.G_MISS_CHAR,
85: SQUAL_CHAR18 VARCHAR2(360) := FND_API.G_MISS_CHAR,
86: SQUAL_CHAR19 VARCHAR2(360) := FND_API.G_MISS_CHAR,
87: SQUAL_CHAR20 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 84: SQUAL_CHAR17 VARCHAR2(360) := FND_API.G_MISS_CHAR,

80: SQUAL_CHAR13 VARCHAR2(360) := FND_API.G_MISS_CHAR,
81: SQUAL_CHAR14 VARCHAR2(360) := FND_API.G_MISS_CHAR,
82: SQUAL_CHAR15 VARCHAR2(360) := FND_API.G_MISS_CHAR,
83: SQUAL_CHAR16 VARCHAR2(360) := FND_API.G_MISS_CHAR,
84: SQUAL_CHAR17 VARCHAR2(360) := FND_API.G_MISS_CHAR,
85: SQUAL_CHAR18 VARCHAR2(360) := FND_API.G_MISS_CHAR,
86: SQUAL_CHAR19 VARCHAR2(360) := FND_API.G_MISS_CHAR,
87: SQUAL_CHAR20 VARCHAR2(360) := FND_API.G_MISS_CHAR,
88: SQUAL_CHAR21 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 85: SQUAL_CHAR18 VARCHAR2(360) := FND_API.G_MISS_CHAR,

81: SQUAL_CHAR14 VARCHAR2(360) := FND_API.G_MISS_CHAR,
82: SQUAL_CHAR15 VARCHAR2(360) := FND_API.G_MISS_CHAR,
83: SQUAL_CHAR16 VARCHAR2(360) := FND_API.G_MISS_CHAR,
84: SQUAL_CHAR17 VARCHAR2(360) := FND_API.G_MISS_CHAR,
85: SQUAL_CHAR18 VARCHAR2(360) := FND_API.G_MISS_CHAR,
86: SQUAL_CHAR19 VARCHAR2(360) := FND_API.G_MISS_CHAR,
87: SQUAL_CHAR20 VARCHAR2(360) := FND_API.G_MISS_CHAR,
88: SQUAL_CHAR21 VARCHAR2(360) := FND_API.G_MISS_CHAR,
89: SQUAL_CHAR22 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 86: SQUAL_CHAR19 VARCHAR2(360) := FND_API.G_MISS_CHAR,

82: SQUAL_CHAR15 VARCHAR2(360) := FND_API.G_MISS_CHAR,
83: SQUAL_CHAR16 VARCHAR2(360) := FND_API.G_MISS_CHAR,
84: SQUAL_CHAR17 VARCHAR2(360) := FND_API.G_MISS_CHAR,
85: SQUAL_CHAR18 VARCHAR2(360) := FND_API.G_MISS_CHAR,
86: SQUAL_CHAR19 VARCHAR2(360) := FND_API.G_MISS_CHAR,
87: SQUAL_CHAR20 VARCHAR2(360) := FND_API.G_MISS_CHAR,
88: SQUAL_CHAR21 VARCHAR2(360) := FND_API.G_MISS_CHAR,
89: SQUAL_CHAR22 VARCHAR2(360) := FND_API.G_MISS_CHAR,
90: SQUAL_CHAR23 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 87: SQUAL_CHAR20 VARCHAR2(360) := FND_API.G_MISS_CHAR,

83: SQUAL_CHAR16 VARCHAR2(360) := FND_API.G_MISS_CHAR,
84: SQUAL_CHAR17 VARCHAR2(360) := FND_API.G_MISS_CHAR,
85: SQUAL_CHAR18 VARCHAR2(360) := FND_API.G_MISS_CHAR,
86: SQUAL_CHAR19 VARCHAR2(360) := FND_API.G_MISS_CHAR,
87: SQUAL_CHAR20 VARCHAR2(360) := FND_API.G_MISS_CHAR,
88: SQUAL_CHAR21 VARCHAR2(360) := FND_API.G_MISS_CHAR,
89: SQUAL_CHAR22 VARCHAR2(360) := FND_API.G_MISS_CHAR,
90: SQUAL_CHAR23 VARCHAR2(360) := FND_API.G_MISS_CHAR,
91: SQUAL_CHAR24 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 88: SQUAL_CHAR21 VARCHAR2(360) := FND_API.G_MISS_CHAR,

84: SQUAL_CHAR17 VARCHAR2(360) := FND_API.G_MISS_CHAR,
85: SQUAL_CHAR18 VARCHAR2(360) := FND_API.G_MISS_CHAR,
86: SQUAL_CHAR19 VARCHAR2(360) := FND_API.G_MISS_CHAR,
87: SQUAL_CHAR20 VARCHAR2(360) := FND_API.G_MISS_CHAR,
88: SQUAL_CHAR21 VARCHAR2(360) := FND_API.G_MISS_CHAR,
89: SQUAL_CHAR22 VARCHAR2(360) := FND_API.G_MISS_CHAR,
90: SQUAL_CHAR23 VARCHAR2(360) := FND_API.G_MISS_CHAR,
91: SQUAL_CHAR24 VARCHAR2(360) := FND_API.G_MISS_CHAR,
92: SQUAL_CHAR25 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 89: SQUAL_CHAR22 VARCHAR2(360) := FND_API.G_MISS_CHAR,

85: SQUAL_CHAR18 VARCHAR2(360) := FND_API.G_MISS_CHAR,
86: SQUAL_CHAR19 VARCHAR2(360) := FND_API.G_MISS_CHAR,
87: SQUAL_CHAR20 VARCHAR2(360) := FND_API.G_MISS_CHAR,
88: SQUAL_CHAR21 VARCHAR2(360) := FND_API.G_MISS_CHAR,
89: SQUAL_CHAR22 VARCHAR2(360) := FND_API.G_MISS_CHAR,
90: SQUAL_CHAR23 VARCHAR2(360) := FND_API.G_MISS_CHAR,
91: SQUAL_CHAR24 VARCHAR2(360) := FND_API.G_MISS_CHAR,
92: SQUAL_CHAR25 VARCHAR2(360) := FND_API.G_MISS_CHAR,
93: SQUAL_CHAR26 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 90: SQUAL_CHAR23 VARCHAR2(360) := FND_API.G_MISS_CHAR,

86: SQUAL_CHAR19 VARCHAR2(360) := FND_API.G_MISS_CHAR,
87: SQUAL_CHAR20 VARCHAR2(360) := FND_API.G_MISS_CHAR,
88: SQUAL_CHAR21 VARCHAR2(360) := FND_API.G_MISS_CHAR,
89: SQUAL_CHAR22 VARCHAR2(360) := FND_API.G_MISS_CHAR,
90: SQUAL_CHAR23 VARCHAR2(360) := FND_API.G_MISS_CHAR,
91: SQUAL_CHAR24 VARCHAR2(360) := FND_API.G_MISS_CHAR,
92: SQUAL_CHAR25 VARCHAR2(360) := FND_API.G_MISS_CHAR,
93: SQUAL_CHAR26 VARCHAR2(360) := FND_API.G_MISS_CHAR,
94: SQUAL_CHAR27 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 91: SQUAL_CHAR24 VARCHAR2(360) := FND_API.G_MISS_CHAR,

87: SQUAL_CHAR20 VARCHAR2(360) := FND_API.G_MISS_CHAR,
88: SQUAL_CHAR21 VARCHAR2(360) := FND_API.G_MISS_CHAR,
89: SQUAL_CHAR22 VARCHAR2(360) := FND_API.G_MISS_CHAR,
90: SQUAL_CHAR23 VARCHAR2(360) := FND_API.G_MISS_CHAR,
91: SQUAL_CHAR24 VARCHAR2(360) := FND_API.G_MISS_CHAR,
92: SQUAL_CHAR25 VARCHAR2(360) := FND_API.G_MISS_CHAR,
93: SQUAL_CHAR26 VARCHAR2(360) := FND_API.G_MISS_CHAR,
94: SQUAL_CHAR27 VARCHAR2(360) := FND_API.G_MISS_CHAR,
95: SQUAL_CHAR28 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 92: SQUAL_CHAR25 VARCHAR2(360) := FND_API.G_MISS_CHAR,

88: SQUAL_CHAR21 VARCHAR2(360) := FND_API.G_MISS_CHAR,
89: SQUAL_CHAR22 VARCHAR2(360) := FND_API.G_MISS_CHAR,
90: SQUAL_CHAR23 VARCHAR2(360) := FND_API.G_MISS_CHAR,
91: SQUAL_CHAR24 VARCHAR2(360) := FND_API.G_MISS_CHAR,
92: SQUAL_CHAR25 VARCHAR2(360) := FND_API.G_MISS_CHAR,
93: SQUAL_CHAR26 VARCHAR2(360) := FND_API.G_MISS_CHAR,
94: SQUAL_CHAR27 VARCHAR2(360) := FND_API.G_MISS_CHAR,
95: SQUAL_CHAR28 VARCHAR2(360) := FND_API.G_MISS_CHAR,
96: SQUAL_CHAR29 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 93: SQUAL_CHAR26 VARCHAR2(360) := FND_API.G_MISS_CHAR,

89: SQUAL_CHAR22 VARCHAR2(360) := FND_API.G_MISS_CHAR,
90: SQUAL_CHAR23 VARCHAR2(360) := FND_API.G_MISS_CHAR,
91: SQUAL_CHAR24 VARCHAR2(360) := FND_API.G_MISS_CHAR,
92: SQUAL_CHAR25 VARCHAR2(360) := FND_API.G_MISS_CHAR,
93: SQUAL_CHAR26 VARCHAR2(360) := FND_API.G_MISS_CHAR,
94: SQUAL_CHAR27 VARCHAR2(360) := FND_API.G_MISS_CHAR,
95: SQUAL_CHAR28 VARCHAR2(360) := FND_API.G_MISS_CHAR,
96: SQUAL_CHAR29 VARCHAR2(360) := FND_API.G_MISS_CHAR,
97: SQUAL_CHAR30 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 94: SQUAL_CHAR27 VARCHAR2(360) := FND_API.G_MISS_CHAR,

90: SQUAL_CHAR23 VARCHAR2(360) := FND_API.G_MISS_CHAR,
91: SQUAL_CHAR24 VARCHAR2(360) := FND_API.G_MISS_CHAR,
92: SQUAL_CHAR25 VARCHAR2(360) := FND_API.G_MISS_CHAR,
93: SQUAL_CHAR26 VARCHAR2(360) := FND_API.G_MISS_CHAR,
94: SQUAL_CHAR27 VARCHAR2(360) := FND_API.G_MISS_CHAR,
95: SQUAL_CHAR28 VARCHAR2(360) := FND_API.G_MISS_CHAR,
96: SQUAL_CHAR29 VARCHAR2(360) := FND_API.G_MISS_CHAR,
97: SQUAL_CHAR30 VARCHAR2(360) := FND_API.G_MISS_CHAR,
98: SQUAL_CHAR31 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 95: SQUAL_CHAR28 VARCHAR2(360) := FND_API.G_MISS_CHAR,

91: SQUAL_CHAR24 VARCHAR2(360) := FND_API.G_MISS_CHAR,
92: SQUAL_CHAR25 VARCHAR2(360) := FND_API.G_MISS_CHAR,
93: SQUAL_CHAR26 VARCHAR2(360) := FND_API.G_MISS_CHAR,
94: SQUAL_CHAR27 VARCHAR2(360) := FND_API.G_MISS_CHAR,
95: SQUAL_CHAR28 VARCHAR2(360) := FND_API.G_MISS_CHAR,
96: SQUAL_CHAR29 VARCHAR2(360) := FND_API.G_MISS_CHAR,
97: SQUAL_CHAR30 VARCHAR2(360) := FND_API.G_MISS_CHAR,
98: SQUAL_CHAR31 VARCHAR2(360) := FND_API.G_MISS_CHAR,
99: SQUAL_CHAR32 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 96: SQUAL_CHAR29 VARCHAR2(360) := FND_API.G_MISS_CHAR,

92: SQUAL_CHAR25 VARCHAR2(360) := FND_API.G_MISS_CHAR,
93: SQUAL_CHAR26 VARCHAR2(360) := FND_API.G_MISS_CHAR,
94: SQUAL_CHAR27 VARCHAR2(360) := FND_API.G_MISS_CHAR,
95: SQUAL_CHAR28 VARCHAR2(360) := FND_API.G_MISS_CHAR,
96: SQUAL_CHAR29 VARCHAR2(360) := FND_API.G_MISS_CHAR,
97: SQUAL_CHAR30 VARCHAR2(360) := FND_API.G_MISS_CHAR,
98: SQUAL_CHAR31 VARCHAR2(360) := FND_API.G_MISS_CHAR,
99: SQUAL_CHAR32 VARCHAR2(360) := FND_API.G_MISS_CHAR,
100: SQUAL_CHAR33 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 97: SQUAL_CHAR30 VARCHAR2(360) := FND_API.G_MISS_CHAR,

93: SQUAL_CHAR26 VARCHAR2(360) := FND_API.G_MISS_CHAR,
94: SQUAL_CHAR27 VARCHAR2(360) := FND_API.G_MISS_CHAR,
95: SQUAL_CHAR28 VARCHAR2(360) := FND_API.G_MISS_CHAR,
96: SQUAL_CHAR29 VARCHAR2(360) := FND_API.G_MISS_CHAR,
97: SQUAL_CHAR30 VARCHAR2(360) := FND_API.G_MISS_CHAR,
98: SQUAL_CHAR31 VARCHAR2(360) := FND_API.G_MISS_CHAR,
99: SQUAL_CHAR32 VARCHAR2(360) := FND_API.G_MISS_CHAR,
100: SQUAL_CHAR33 VARCHAR2(360) := FND_API.G_MISS_CHAR,
101: SQUAL_CHAR34 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 98: SQUAL_CHAR31 VARCHAR2(360) := FND_API.G_MISS_CHAR,

94: SQUAL_CHAR27 VARCHAR2(360) := FND_API.G_MISS_CHAR,
95: SQUAL_CHAR28 VARCHAR2(360) := FND_API.G_MISS_CHAR,
96: SQUAL_CHAR29 VARCHAR2(360) := FND_API.G_MISS_CHAR,
97: SQUAL_CHAR30 VARCHAR2(360) := FND_API.G_MISS_CHAR,
98: SQUAL_CHAR31 VARCHAR2(360) := FND_API.G_MISS_CHAR,
99: SQUAL_CHAR32 VARCHAR2(360) := FND_API.G_MISS_CHAR,
100: SQUAL_CHAR33 VARCHAR2(360) := FND_API.G_MISS_CHAR,
101: SQUAL_CHAR34 VARCHAR2(360) := FND_API.G_MISS_CHAR,
102: SQUAL_CHAR35 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 99: SQUAL_CHAR32 VARCHAR2(360) := FND_API.G_MISS_CHAR,

95: SQUAL_CHAR28 VARCHAR2(360) := FND_API.G_MISS_CHAR,
96: SQUAL_CHAR29 VARCHAR2(360) := FND_API.G_MISS_CHAR,
97: SQUAL_CHAR30 VARCHAR2(360) := FND_API.G_MISS_CHAR,
98: SQUAL_CHAR31 VARCHAR2(360) := FND_API.G_MISS_CHAR,
99: SQUAL_CHAR32 VARCHAR2(360) := FND_API.G_MISS_CHAR,
100: SQUAL_CHAR33 VARCHAR2(360) := FND_API.G_MISS_CHAR,
101: SQUAL_CHAR34 VARCHAR2(360) := FND_API.G_MISS_CHAR,
102: SQUAL_CHAR35 VARCHAR2(360) := FND_API.G_MISS_CHAR,
103: SQUAL_CHAR36 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 100: SQUAL_CHAR33 VARCHAR2(360) := FND_API.G_MISS_CHAR,

96: SQUAL_CHAR29 VARCHAR2(360) := FND_API.G_MISS_CHAR,
97: SQUAL_CHAR30 VARCHAR2(360) := FND_API.G_MISS_CHAR,
98: SQUAL_CHAR31 VARCHAR2(360) := FND_API.G_MISS_CHAR,
99: SQUAL_CHAR32 VARCHAR2(360) := FND_API.G_MISS_CHAR,
100: SQUAL_CHAR33 VARCHAR2(360) := FND_API.G_MISS_CHAR,
101: SQUAL_CHAR34 VARCHAR2(360) := FND_API.G_MISS_CHAR,
102: SQUAL_CHAR35 VARCHAR2(360) := FND_API.G_MISS_CHAR,
103: SQUAL_CHAR36 VARCHAR2(360) := FND_API.G_MISS_CHAR,
104: SQUAL_CHAR37 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 101: SQUAL_CHAR34 VARCHAR2(360) := FND_API.G_MISS_CHAR,

97: SQUAL_CHAR30 VARCHAR2(360) := FND_API.G_MISS_CHAR,
98: SQUAL_CHAR31 VARCHAR2(360) := FND_API.G_MISS_CHAR,
99: SQUAL_CHAR32 VARCHAR2(360) := FND_API.G_MISS_CHAR,
100: SQUAL_CHAR33 VARCHAR2(360) := FND_API.G_MISS_CHAR,
101: SQUAL_CHAR34 VARCHAR2(360) := FND_API.G_MISS_CHAR,
102: SQUAL_CHAR35 VARCHAR2(360) := FND_API.G_MISS_CHAR,
103: SQUAL_CHAR36 VARCHAR2(360) := FND_API.G_MISS_CHAR,
104: SQUAL_CHAR37 VARCHAR2(360) := FND_API.G_MISS_CHAR,
105: SQUAL_CHAR38 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 102: SQUAL_CHAR35 VARCHAR2(360) := FND_API.G_MISS_CHAR,

98: SQUAL_CHAR31 VARCHAR2(360) := FND_API.G_MISS_CHAR,
99: SQUAL_CHAR32 VARCHAR2(360) := FND_API.G_MISS_CHAR,
100: SQUAL_CHAR33 VARCHAR2(360) := FND_API.G_MISS_CHAR,
101: SQUAL_CHAR34 VARCHAR2(360) := FND_API.G_MISS_CHAR,
102: SQUAL_CHAR35 VARCHAR2(360) := FND_API.G_MISS_CHAR,
103: SQUAL_CHAR36 VARCHAR2(360) := FND_API.G_MISS_CHAR,
104: SQUAL_CHAR37 VARCHAR2(360) := FND_API.G_MISS_CHAR,
105: SQUAL_CHAR38 VARCHAR2(360) := FND_API.G_MISS_CHAR,
106: SQUAL_CHAR39 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 103: SQUAL_CHAR36 VARCHAR2(360) := FND_API.G_MISS_CHAR,

99: SQUAL_CHAR32 VARCHAR2(360) := FND_API.G_MISS_CHAR,
100: SQUAL_CHAR33 VARCHAR2(360) := FND_API.G_MISS_CHAR,
101: SQUAL_CHAR34 VARCHAR2(360) := FND_API.G_MISS_CHAR,
102: SQUAL_CHAR35 VARCHAR2(360) := FND_API.G_MISS_CHAR,
103: SQUAL_CHAR36 VARCHAR2(360) := FND_API.G_MISS_CHAR,
104: SQUAL_CHAR37 VARCHAR2(360) := FND_API.G_MISS_CHAR,
105: SQUAL_CHAR38 VARCHAR2(360) := FND_API.G_MISS_CHAR,
106: SQUAL_CHAR39 VARCHAR2(360) := FND_API.G_MISS_CHAR,
107: SQUAL_CHAR40 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 104: SQUAL_CHAR37 VARCHAR2(360) := FND_API.G_MISS_CHAR,

100: SQUAL_CHAR33 VARCHAR2(360) := FND_API.G_MISS_CHAR,
101: SQUAL_CHAR34 VARCHAR2(360) := FND_API.G_MISS_CHAR,
102: SQUAL_CHAR35 VARCHAR2(360) := FND_API.G_MISS_CHAR,
103: SQUAL_CHAR36 VARCHAR2(360) := FND_API.G_MISS_CHAR,
104: SQUAL_CHAR37 VARCHAR2(360) := FND_API.G_MISS_CHAR,
105: SQUAL_CHAR38 VARCHAR2(360) := FND_API.G_MISS_CHAR,
106: SQUAL_CHAR39 VARCHAR2(360) := FND_API.G_MISS_CHAR,
107: SQUAL_CHAR40 VARCHAR2(360) := FND_API.G_MISS_CHAR,
108: SQUAL_CHAR41 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 105: SQUAL_CHAR38 VARCHAR2(360) := FND_API.G_MISS_CHAR,

101: SQUAL_CHAR34 VARCHAR2(360) := FND_API.G_MISS_CHAR,
102: SQUAL_CHAR35 VARCHAR2(360) := FND_API.G_MISS_CHAR,
103: SQUAL_CHAR36 VARCHAR2(360) := FND_API.G_MISS_CHAR,
104: SQUAL_CHAR37 VARCHAR2(360) := FND_API.G_MISS_CHAR,
105: SQUAL_CHAR38 VARCHAR2(360) := FND_API.G_MISS_CHAR,
106: SQUAL_CHAR39 VARCHAR2(360) := FND_API.G_MISS_CHAR,
107: SQUAL_CHAR40 VARCHAR2(360) := FND_API.G_MISS_CHAR,
108: SQUAL_CHAR41 VARCHAR2(360) := FND_API.G_MISS_CHAR,
109: SQUAL_CHAR42 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 106: SQUAL_CHAR39 VARCHAR2(360) := FND_API.G_MISS_CHAR,

102: SQUAL_CHAR35 VARCHAR2(360) := FND_API.G_MISS_CHAR,
103: SQUAL_CHAR36 VARCHAR2(360) := FND_API.G_MISS_CHAR,
104: SQUAL_CHAR37 VARCHAR2(360) := FND_API.G_MISS_CHAR,
105: SQUAL_CHAR38 VARCHAR2(360) := FND_API.G_MISS_CHAR,
106: SQUAL_CHAR39 VARCHAR2(360) := FND_API.G_MISS_CHAR,
107: SQUAL_CHAR40 VARCHAR2(360) := FND_API.G_MISS_CHAR,
108: SQUAL_CHAR41 VARCHAR2(360) := FND_API.G_MISS_CHAR,
109: SQUAL_CHAR42 VARCHAR2(360) := FND_API.G_MISS_CHAR,
110: SQUAL_CHAR43 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 107: SQUAL_CHAR40 VARCHAR2(360) := FND_API.G_MISS_CHAR,

103: SQUAL_CHAR36 VARCHAR2(360) := FND_API.G_MISS_CHAR,
104: SQUAL_CHAR37 VARCHAR2(360) := FND_API.G_MISS_CHAR,
105: SQUAL_CHAR38 VARCHAR2(360) := FND_API.G_MISS_CHAR,
106: SQUAL_CHAR39 VARCHAR2(360) := FND_API.G_MISS_CHAR,
107: SQUAL_CHAR40 VARCHAR2(360) := FND_API.G_MISS_CHAR,
108: SQUAL_CHAR41 VARCHAR2(360) := FND_API.G_MISS_CHAR,
109: SQUAL_CHAR42 VARCHAR2(360) := FND_API.G_MISS_CHAR,
110: SQUAL_CHAR43 VARCHAR2(360) := FND_API.G_MISS_CHAR,
111: SQUAL_CHAR44 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 108: SQUAL_CHAR41 VARCHAR2(360) := FND_API.G_MISS_CHAR,

104: SQUAL_CHAR37 VARCHAR2(360) := FND_API.G_MISS_CHAR,
105: SQUAL_CHAR38 VARCHAR2(360) := FND_API.G_MISS_CHAR,
106: SQUAL_CHAR39 VARCHAR2(360) := FND_API.G_MISS_CHAR,
107: SQUAL_CHAR40 VARCHAR2(360) := FND_API.G_MISS_CHAR,
108: SQUAL_CHAR41 VARCHAR2(360) := FND_API.G_MISS_CHAR,
109: SQUAL_CHAR42 VARCHAR2(360) := FND_API.G_MISS_CHAR,
110: SQUAL_CHAR43 VARCHAR2(360) := FND_API.G_MISS_CHAR,
111: SQUAL_CHAR44 VARCHAR2(360) := FND_API.G_MISS_CHAR,
112: SQUAL_CHAR45 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 109: SQUAL_CHAR42 VARCHAR2(360) := FND_API.G_MISS_CHAR,

105: SQUAL_CHAR38 VARCHAR2(360) := FND_API.G_MISS_CHAR,
106: SQUAL_CHAR39 VARCHAR2(360) := FND_API.G_MISS_CHAR,
107: SQUAL_CHAR40 VARCHAR2(360) := FND_API.G_MISS_CHAR,
108: SQUAL_CHAR41 VARCHAR2(360) := FND_API.G_MISS_CHAR,
109: SQUAL_CHAR42 VARCHAR2(360) := FND_API.G_MISS_CHAR,
110: SQUAL_CHAR43 VARCHAR2(360) := FND_API.G_MISS_CHAR,
111: SQUAL_CHAR44 VARCHAR2(360) := FND_API.G_MISS_CHAR,
112: SQUAL_CHAR45 VARCHAR2(360) := FND_API.G_MISS_CHAR,
113: SQUAL_CHAR46 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 110: SQUAL_CHAR43 VARCHAR2(360) := FND_API.G_MISS_CHAR,

106: SQUAL_CHAR39 VARCHAR2(360) := FND_API.G_MISS_CHAR,
107: SQUAL_CHAR40 VARCHAR2(360) := FND_API.G_MISS_CHAR,
108: SQUAL_CHAR41 VARCHAR2(360) := FND_API.G_MISS_CHAR,
109: SQUAL_CHAR42 VARCHAR2(360) := FND_API.G_MISS_CHAR,
110: SQUAL_CHAR43 VARCHAR2(360) := FND_API.G_MISS_CHAR,
111: SQUAL_CHAR44 VARCHAR2(360) := FND_API.G_MISS_CHAR,
112: SQUAL_CHAR45 VARCHAR2(360) := FND_API.G_MISS_CHAR,
113: SQUAL_CHAR46 VARCHAR2(360) := FND_API.G_MISS_CHAR,
114: SQUAL_CHAR47 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 111: SQUAL_CHAR44 VARCHAR2(360) := FND_API.G_MISS_CHAR,

107: SQUAL_CHAR40 VARCHAR2(360) := FND_API.G_MISS_CHAR,
108: SQUAL_CHAR41 VARCHAR2(360) := FND_API.G_MISS_CHAR,
109: SQUAL_CHAR42 VARCHAR2(360) := FND_API.G_MISS_CHAR,
110: SQUAL_CHAR43 VARCHAR2(360) := FND_API.G_MISS_CHAR,
111: SQUAL_CHAR44 VARCHAR2(360) := FND_API.G_MISS_CHAR,
112: SQUAL_CHAR45 VARCHAR2(360) := FND_API.G_MISS_CHAR,
113: SQUAL_CHAR46 VARCHAR2(360) := FND_API.G_MISS_CHAR,
114: SQUAL_CHAR47 VARCHAR2(360) := FND_API.G_MISS_CHAR,
115: SQUAL_CHAR48 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 112: SQUAL_CHAR45 VARCHAR2(360) := FND_API.G_MISS_CHAR,

108: SQUAL_CHAR41 VARCHAR2(360) := FND_API.G_MISS_CHAR,
109: SQUAL_CHAR42 VARCHAR2(360) := FND_API.G_MISS_CHAR,
110: SQUAL_CHAR43 VARCHAR2(360) := FND_API.G_MISS_CHAR,
111: SQUAL_CHAR44 VARCHAR2(360) := FND_API.G_MISS_CHAR,
112: SQUAL_CHAR45 VARCHAR2(360) := FND_API.G_MISS_CHAR,
113: SQUAL_CHAR46 VARCHAR2(360) := FND_API.G_MISS_CHAR,
114: SQUAL_CHAR47 VARCHAR2(360) := FND_API.G_MISS_CHAR,
115: SQUAL_CHAR48 VARCHAR2(360) := FND_API.G_MISS_CHAR,
116: SQUAL_CHAR49 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 113: SQUAL_CHAR46 VARCHAR2(360) := FND_API.G_MISS_CHAR,

109: SQUAL_CHAR42 VARCHAR2(360) := FND_API.G_MISS_CHAR,
110: SQUAL_CHAR43 VARCHAR2(360) := FND_API.G_MISS_CHAR,
111: SQUAL_CHAR44 VARCHAR2(360) := FND_API.G_MISS_CHAR,
112: SQUAL_CHAR45 VARCHAR2(360) := FND_API.G_MISS_CHAR,
113: SQUAL_CHAR46 VARCHAR2(360) := FND_API.G_MISS_CHAR,
114: SQUAL_CHAR47 VARCHAR2(360) := FND_API.G_MISS_CHAR,
115: SQUAL_CHAR48 VARCHAR2(360) := FND_API.G_MISS_CHAR,
116: SQUAL_CHAR49 VARCHAR2(360) := FND_API.G_MISS_CHAR,
117: SQUAL_CHAR50 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 114: SQUAL_CHAR47 VARCHAR2(360) := FND_API.G_MISS_CHAR,

110: SQUAL_CHAR43 VARCHAR2(360) := FND_API.G_MISS_CHAR,
111: SQUAL_CHAR44 VARCHAR2(360) := FND_API.G_MISS_CHAR,
112: SQUAL_CHAR45 VARCHAR2(360) := FND_API.G_MISS_CHAR,
113: SQUAL_CHAR46 VARCHAR2(360) := FND_API.G_MISS_CHAR,
114: SQUAL_CHAR47 VARCHAR2(360) := FND_API.G_MISS_CHAR,
115: SQUAL_CHAR48 VARCHAR2(360) := FND_API.G_MISS_CHAR,
116: SQUAL_CHAR49 VARCHAR2(360) := FND_API.G_MISS_CHAR,
117: SQUAL_CHAR50 VARCHAR2(360) := FND_API.G_MISS_CHAR,
118:

Line 115: SQUAL_CHAR48 VARCHAR2(360) := FND_API.G_MISS_CHAR,

111: SQUAL_CHAR44 VARCHAR2(360) := FND_API.G_MISS_CHAR,
112: SQUAL_CHAR45 VARCHAR2(360) := FND_API.G_MISS_CHAR,
113: SQUAL_CHAR46 VARCHAR2(360) := FND_API.G_MISS_CHAR,
114: SQUAL_CHAR47 VARCHAR2(360) := FND_API.G_MISS_CHAR,
115: SQUAL_CHAR48 VARCHAR2(360) := FND_API.G_MISS_CHAR,
116: SQUAL_CHAR49 VARCHAR2(360) := FND_API.G_MISS_CHAR,
117: SQUAL_CHAR50 VARCHAR2(360) := FND_API.G_MISS_CHAR,
118:
119: SQUAL_NUM01 NUMBER := FND_API.G_MISS_NUM,

Line 116: SQUAL_CHAR49 VARCHAR2(360) := FND_API.G_MISS_CHAR,

112: SQUAL_CHAR45 VARCHAR2(360) := FND_API.G_MISS_CHAR,
113: SQUAL_CHAR46 VARCHAR2(360) := FND_API.G_MISS_CHAR,
114: SQUAL_CHAR47 VARCHAR2(360) := FND_API.G_MISS_CHAR,
115: SQUAL_CHAR48 VARCHAR2(360) := FND_API.G_MISS_CHAR,
116: SQUAL_CHAR49 VARCHAR2(360) := FND_API.G_MISS_CHAR,
117: SQUAL_CHAR50 VARCHAR2(360) := FND_API.G_MISS_CHAR,
118:
119: SQUAL_NUM01 NUMBER := FND_API.G_MISS_NUM,
120: SQUAL_NUM02 NUMBER := FND_API.G_MISS_NUM,

Line 117: SQUAL_CHAR50 VARCHAR2(360) := FND_API.G_MISS_CHAR,

113: SQUAL_CHAR46 VARCHAR2(360) := FND_API.G_MISS_CHAR,
114: SQUAL_CHAR47 VARCHAR2(360) := FND_API.G_MISS_CHAR,
115: SQUAL_CHAR48 VARCHAR2(360) := FND_API.G_MISS_CHAR,
116: SQUAL_CHAR49 VARCHAR2(360) := FND_API.G_MISS_CHAR,
117: SQUAL_CHAR50 VARCHAR2(360) := FND_API.G_MISS_CHAR,
118:
119: SQUAL_NUM01 NUMBER := FND_API.G_MISS_NUM,
120: SQUAL_NUM02 NUMBER := FND_API.G_MISS_NUM,
121: SQUAL_NUM03 NUMBER := FND_API.G_MISS_NUM,

Line 119: SQUAL_NUM01 NUMBER := FND_API.G_MISS_NUM,

115: SQUAL_CHAR48 VARCHAR2(360) := FND_API.G_MISS_CHAR,
116: SQUAL_CHAR49 VARCHAR2(360) := FND_API.G_MISS_CHAR,
117: SQUAL_CHAR50 VARCHAR2(360) := FND_API.G_MISS_CHAR,
118:
119: SQUAL_NUM01 NUMBER := FND_API.G_MISS_NUM,
120: SQUAL_NUM02 NUMBER := FND_API.G_MISS_NUM,
121: SQUAL_NUM03 NUMBER := FND_API.G_MISS_NUM,
122: SQUAL_NUM04 NUMBER := FND_API.G_MISS_NUM,
123: SQUAL_NUM05 NUMBER := FND_API.G_MISS_NUM,

Line 120: SQUAL_NUM02 NUMBER := FND_API.G_MISS_NUM,

116: SQUAL_CHAR49 VARCHAR2(360) := FND_API.G_MISS_CHAR,
117: SQUAL_CHAR50 VARCHAR2(360) := FND_API.G_MISS_CHAR,
118:
119: SQUAL_NUM01 NUMBER := FND_API.G_MISS_NUM,
120: SQUAL_NUM02 NUMBER := FND_API.G_MISS_NUM,
121: SQUAL_NUM03 NUMBER := FND_API.G_MISS_NUM,
122: SQUAL_NUM04 NUMBER := FND_API.G_MISS_NUM,
123: SQUAL_NUM05 NUMBER := FND_API.G_MISS_NUM,
124: SQUAL_NUM06 NUMBER := FND_API.G_MISS_NUM,

Line 121: SQUAL_NUM03 NUMBER := FND_API.G_MISS_NUM,

117: SQUAL_CHAR50 VARCHAR2(360) := FND_API.G_MISS_CHAR,
118:
119: SQUAL_NUM01 NUMBER := FND_API.G_MISS_NUM,
120: SQUAL_NUM02 NUMBER := FND_API.G_MISS_NUM,
121: SQUAL_NUM03 NUMBER := FND_API.G_MISS_NUM,
122: SQUAL_NUM04 NUMBER := FND_API.G_MISS_NUM,
123: SQUAL_NUM05 NUMBER := FND_API.G_MISS_NUM,
124: SQUAL_NUM06 NUMBER := FND_API.G_MISS_NUM,
125: SQUAL_NUM07 NUMBER := FND_API.G_MISS_NUM,

Line 122: SQUAL_NUM04 NUMBER := FND_API.G_MISS_NUM,

118:
119: SQUAL_NUM01 NUMBER := FND_API.G_MISS_NUM,
120: SQUAL_NUM02 NUMBER := FND_API.G_MISS_NUM,
121: SQUAL_NUM03 NUMBER := FND_API.G_MISS_NUM,
122: SQUAL_NUM04 NUMBER := FND_API.G_MISS_NUM,
123: SQUAL_NUM05 NUMBER := FND_API.G_MISS_NUM,
124: SQUAL_NUM06 NUMBER := FND_API.G_MISS_NUM,
125: SQUAL_NUM07 NUMBER := FND_API.G_MISS_NUM,
126: SQUAL_NUM08 NUMBER := FND_API.G_MISS_NUM,

Line 123: SQUAL_NUM05 NUMBER := FND_API.G_MISS_NUM,

119: SQUAL_NUM01 NUMBER := FND_API.G_MISS_NUM,
120: SQUAL_NUM02 NUMBER := FND_API.G_MISS_NUM,
121: SQUAL_NUM03 NUMBER := FND_API.G_MISS_NUM,
122: SQUAL_NUM04 NUMBER := FND_API.G_MISS_NUM,
123: SQUAL_NUM05 NUMBER := FND_API.G_MISS_NUM,
124: SQUAL_NUM06 NUMBER := FND_API.G_MISS_NUM,
125: SQUAL_NUM07 NUMBER := FND_API.G_MISS_NUM,
126: SQUAL_NUM08 NUMBER := FND_API.G_MISS_NUM,
127: SQUAL_NUM09 NUMBER := FND_API.G_MISS_NUM,

Line 124: SQUAL_NUM06 NUMBER := FND_API.G_MISS_NUM,

120: SQUAL_NUM02 NUMBER := FND_API.G_MISS_NUM,
121: SQUAL_NUM03 NUMBER := FND_API.G_MISS_NUM,
122: SQUAL_NUM04 NUMBER := FND_API.G_MISS_NUM,
123: SQUAL_NUM05 NUMBER := FND_API.G_MISS_NUM,
124: SQUAL_NUM06 NUMBER := FND_API.G_MISS_NUM,
125: SQUAL_NUM07 NUMBER := FND_API.G_MISS_NUM,
126: SQUAL_NUM08 NUMBER := FND_API.G_MISS_NUM,
127: SQUAL_NUM09 NUMBER := FND_API.G_MISS_NUM,
128: SQUAL_NUM10 NUMBER := FND_API.G_MISS_NUM,

Line 125: SQUAL_NUM07 NUMBER := FND_API.G_MISS_NUM,

121: SQUAL_NUM03 NUMBER := FND_API.G_MISS_NUM,
122: SQUAL_NUM04 NUMBER := FND_API.G_MISS_NUM,
123: SQUAL_NUM05 NUMBER := FND_API.G_MISS_NUM,
124: SQUAL_NUM06 NUMBER := FND_API.G_MISS_NUM,
125: SQUAL_NUM07 NUMBER := FND_API.G_MISS_NUM,
126: SQUAL_NUM08 NUMBER := FND_API.G_MISS_NUM,
127: SQUAL_NUM09 NUMBER := FND_API.G_MISS_NUM,
128: SQUAL_NUM10 NUMBER := FND_API.G_MISS_NUM,
129: SQUAL_NUM11 NUMBER := FND_API.G_MISS_NUM,

Line 126: SQUAL_NUM08 NUMBER := FND_API.G_MISS_NUM,

122: SQUAL_NUM04 NUMBER := FND_API.G_MISS_NUM,
123: SQUAL_NUM05 NUMBER := FND_API.G_MISS_NUM,
124: SQUAL_NUM06 NUMBER := FND_API.G_MISS_NUM,
125: SQUAL_NUM07 NUMBER := FND_API.G_MISS_NUM,
126: SQUAL_NUM08 NUMBER := FND_API.G_MISS_NUM,
127: SQUAL_NUM09 NUMBER := FND_API.G_MISS_NUM,
128: SQUAL_NUM10 NUMBER := FND_API.G_MISS_NUM,
129: SQUAL_NUM11 NUMBER := FND_API.G_MISS_NUM,
130: SQUAL_NUM12 NUMBER := FND_API.G_MISS_NUM,

Line 127: SQUAL_NUM09 NUMBER := FND_API.G_MISS_NUM,

123: SQUAL_NUM05 NUMBER := FND_API.G_MISS_NUM,
124: SQUAL_NUM06 NUMBER := FND_API.G_MISS_NUM,
125: SQUAL_NUM07 NUMBER := FND_API.G_MISS_NUM,
126: SQUAL_NUM08 NUMBER := FND_API.G_MISS_NUM,
127: SQUAL_NUM09 NUMBER := FND_API.G_MISS_NUM,
128: SQUAL_NUM10 NUMBER := FND_API.G_MISS_NUM,
129: SQUAL_NUM11 NUMBER := FND_API.G_MISS_NUM,
130: SQUAL_NUM12 NUMBER := FND_API.G_MISS_NUM,
131: SQUAL_NUM13 NUMBER := FND_API.G_MISS_NUM,

Line 128: SQUAL_NUM10 NUMBER := FND_API.G_MISS_NUM,

124: SQUAL_NUM06 NUMBER := FND_API.G_MISS_NUM,
125: SQUAL_NUM07 NUMBER := FND_API.G_MISS_NUM,
126: SQUAL_NUM08 NUMBER := FND_API.G_MISS_NUM,
127: SQUAL_NUM09 NUMBER := FND_API.G_MISS_NUM,
128: SQUAL_NUM10 NUMBER := FND_API.G_MISS_NUM,
129: SQUAL_NUM11 NUMBER := FND_API.G_MISS_NUM,
130: SQUAL_NUM12 NUMBER := FND_API.G_MISS_NUM,
131: SQUAL_NUM13 NUMBER := FND_API.G_MISS_NUM,
132: SQUAL_NUM14 NUMBER := FND_API.G_MISS_NUM,

Line 129: SQUAL_NUM11 NUMBER := FND_API.G_MISS_NUM,

125: SQUAL_NUM07 NUMBER := FND_API.G_MISS_NUM,
126: SQUAL_NUM08 NUMBER := FND_API.G_MISS_NUM,
127: SQUAL_NUM09 NUMBER := FND_API.G_MISS_NUM,
128: SQUAL_NUM10 NUMBER := FND_API.G_MISS_NUM,
129: SQUAL_NUM11 NUMBER := FND_API.G_MISS_NUM,
130: SQUAL_NUM12 NUMBER := FND_API.G_MISS_NUM,
131: SQUAL_NUM13 NUMBER := FND_API.G_MISS_NUM,
132: SQUAL_NUM14 NUMBER := FND_API.G_MISS_NUM,
133: SQUAL_NUM15 NUMBER := FND_API.G_MISS_NUM,

Line 130: SQUAL_NUM12 NUMBER := FND_API.G_MISS_NUM,

126: SQUAL_NUM08 NUMBER := FND_API.G_MISS_NUM,
127: SQUAL_NUM09 NUMBER := FND_API.G_MISS_NUM,
128: SQUAL_NUM10 NUMBER := FND_API.G_MISS_NUM,
129: SQUAL_NUM11 NUMBER := FND_API.G_MISS_NUM,
130: SQUAL_NUM12 NUMBER := FND_API.G_MISS_NUM,
131: SQUAL_NUM13 NUMBER := FND_API.G_MISS_NUM,
132: SQUAL_NUM14 NUMBER := FND_API.G_MISS_NUM,
133: SQUAL_NUM15 NUMBER := FND_API.G_MISS_NUM,
134: SQUAL_NUM16 NUMBER := FND_API.G_MISS_NUM,

Line 131: SQUAL_NUM13 NUMBER := FND_API.G_MISS_NUM,

127: SQUAL_NUM09 NUMBER := FND_API.G_MISS_NUM,
128: SQUAL_NUM10 NUMBER := FND_API.G_MISS_NUM,
129: SQUAL_NUM11 NUMBER := FND_API.G_MISS_NUM,
130: SQUAL_NUM12 NUMBER := FND_API.G_MISS_NUM,
131: SQUAL_NUM13 NUMBER := FND_API.G_MISS_NUM,
132: SQUAL_NUM14 NUMBER := FND_API.G_MISS_NUM,
133: SQUAL_NUM15 NUMBER := FND_API.G_MISS_NUM,
134: SQUAL_NUM16 NUMBER := FND_API.G_MISS_NUM,
135: SQUAL_NUM17 NUMBER := FND_API.G_MISS_NUM,

Line 132: SQUAL_NUM14 NUMBER := FND_API.G_MISS_NUM,

128: SQUAL_NUM10 NUMBER := FND_API.G_MISS_NUM,
129: SQUAL_NUM11 NUMBER := FND_API.G_MISS_NUM,
130: SQUAL_NUM12 NUMBER := FND_API.G_MISS_NUM,
131: SQUAL_NUM13 NUMBER := FND_API.G_MISS_NUM,
132: SQUAL_NUM14 NUMBER := FND_API.G_MISS_NUM,
133: SQUAL_NUM15 NUMBER := FND_API.G_MISS_NUM,
134: SQUAL_NUM16 NUMBER := FND_API.G_MISS_NUM,
135: SQUAL_NUM17 NUMBER := FND_API.G_MISS_NUM,
136: SQUAL_NUM18 NUMBER := FND_API.G_MISS_NUM,

Line 133: SQUAL_NUM15 NUMBER := FND_API.G_MISS_NUM,

129: SQUAL_NUM11 NUMBER := FND_API.G_MISS_NUM,
130: SQUAL_NUM12 NUMBER := FND_API.G_MISS_NUM,
131: SQUAL_NUM13 NUMBER := FND_API.G_MISS_NUM,
132: SQUAL_NUM14 NUMBER := FND_API.G_MISS_NUM,
133: SQUAL_NUM15 NUMBER := FND_API.G_MISS_NUM,
134: SQUAL_NUM16 NUMBER := FND_API.G_MISS_NUM,
135: SQUAL_NUM17 NUMBER := FND_API.G_MISS_NUM,
136: SQUAL_NUM18 NUMBER := FND_API.G_MISS_NUM,
137: SQUAL_NUM19 NUMBER := FND_API.G_MISS_NUM,

Line 134: SQUAL_NUM16 NUMBER := FND_API.G_MISS_NUM,

130: SQUAL_NUM12 NUMBER := FND_API.G_MISS_NUM,
131: SQUAL_NUM13 NUMBER := FND_API.G_MISS_NUM,
132: SQUAL_NUM14 NUMBER := FND_API.G_MISS_NUM,
133: SQUAL_NUM15 NUMBER := FND_API.G_MISS_NUM,
134: SQUAL_NUM16 NUMBER := FND_API.G_MISS_NUM,
135: SQUAL_NUM17 NUMBER := FND_API.G_MISS_NUM,
136: SQUAL_NUM18 NUMBER := FND_API.G_MISS_NUM,
137: SQUAL_NUM19 NUMBER := FND_API.G_MISS_NUM,
138: SQUAL_NUM20 NUMBER := FND_API.G_MISS_NUM,

Line 135: SQUAL_NUM17 NUMBER := FND_API.G_MISS_NUM,

131: SQUAL_NUM13 NUMBER := FND_API.G_MISS_NUM,
132: SQUAL_NUM14 NUMBER := FND_API.G_MISS_NUM,
133: SQUAL_NUM15 NUMBER := FND_API.G_MISS_NUM,
134: SQUAL_NUM16 NUMBER := FND_API.G_MISS_NUM,
135: SQUAL_NUM17 NUMBER := FND_API.G_MISS_NUM,
136: SQUAL_NUM18 NUMBER := FND_API.G_MISS_NUM,
137: SQUAL_NUM19 NUMBER := FND_API.G_MISS_NUM,
138: SQUAL_NUM20 NUMBER := FND_API.G_MISS_NUM,
139: SQUAL_NUM21 NUMBER := FND_API.G_MISS_NUM,

Line 136: SQUAL_NUM18 NUMBER := FND_API.G_MISS_NUM,

132: SQUAL_NUM14 NUMBER := FND_API.G_MISS_NUM,
133: SQUAL_NUM15 NUMBER := FND_API.G_MISS_NUM,
134: SQUAL_NUM16 NUMBER := FND_API.G_MISS_NUM,
135: SQUAL_NUM17 NUMBER := FND_API.G_MISS_NUM,
136: SQUAL_NUM18 NUMBER := FND_API.G_MISS_NUM,
137: SQUAL_NUM19 NUMBER := FND_API.G_MISS_NUM,
138: SQUAL_NUM20 NUMBER := FND_API.G_MISS_NUM,
139: SQUAL_NUM21 NUMBER := FND_API.G_MISS_NUM,
140: SQUAL_NUM22 NUMBER := FND_API.G_MISS_NUM,

Line 137: SQUAL_NUM19 NUMBER := FND_API.G_MISS_NUM,

133: SQUAL_NUM15 NUMBER := FND_API.G_MISS_NUM,
134: SQUAL_NUM16 NUMBER := FND_API.G_MISS_NUM,
135: SQUAL_NUM17 NUMBER := FND_API.G_MISS_NUM,
136: SQUAL_NUM18 NUMBER := FND_API.G_MISS_NUM,
137: SQUAL_NUM19 NUMBER := FND_API.G_MISS_NUM,
138: SQUAL_NUM20 NUMBER := FND_API.G_MISS_NUM,
139: SQUAL_NUM21 NUMBER := FND_API.G_MISS_NUM,
140: SQUAL_NUM22 NUMBER := FND_API.G_MISS_NUM,
141: SQUAL_NUM23 NUMBER := FND_API.G_MISS_NUM,

Line 138: SQUAL_NUM20 NUMBER := FND_API.G_MISS_NUM,

134: SQUAL_NUM16 NUMBER := FND_API.G_MISS_NUM,
135: SQUAL_NUM17 NUMBER := FND_API.G_MISS_NUM,
136: SQUAL_NUM18 NUMBER := FND_API.G_MISS_NUM,
137: SQUAL_NUM19 NUMBER := FND_API.G_MISS_NUM,
138: SQUAL_NUM20 NUMBER := FND_API.G_MISS_NUM,
139: SQUAL_NUM21 NUMBER := FND_API.G_MISS_NUM,
140: SQUAL_NUM22 NUMBER := FND_API.G_MISS_NUM,
141: SQUAL_NUM23 NUMBER := FND_API.G_MISS_NUM,
142: SQUAL_NUM24 NUMBER := FND_API.G_MISS_NUM,

Line 139: SQUAL_NUM21 NUMBER := FND_API.G_MISS_NUM,

135: SQUAL_NUM17 NUMBER := FND_API.G_MISS_NUM,
136: SQUAL_NUM18 NUMBER := FND_API.G_MISS_NUM,
137: SQUAL_NUM19 NUMBER := FND_API.G_MISS_NUM,
138: SQUAL_NUM20 NUMBER := FND_API.G_MISS_NUM,
139: SQUAL_NUM21 NUMBER := FND_API.G_MISS_NUM,
140: SQUAL_NUM22 NUMBER := FND_API.G_MISS_NUM,
141: SQUAL_NUM23 NUMBER := FND_API.G_MISS_NUM,
142: SQUAL_NUM24 NUMBER := FND_API.G_MISS_NUM,
143: SQUAL_NUM25 NUMBER := FND_API.G_MISS_NUM,

Line 140: SQUAL_NUM22 NUMBER := FND_API.G_MISS_NUM,

136: SQUAL_NUM18 NUMBER := FND_API.G_MISS_NUM,
137: SQUAL_NUM19 NUMBER := FND_API.G_MISS_NUM,
138: SQUAL_NUM20 NUMBER := FND_API.G_MISS_NUM,
139: SQUAL_NUM21 NUMBER := FND_API.G_MISS_NUM,
140: SQUAL_NUM22 NUMBER := FND_API.G_MISS_NUM,
141: SQUAL_NUM23 NUMBER := FND_API.G_MISS_NUM,
142: SQUAL_NUM24 NUMBER := FND_API.G_MISS_NUM,
143: SQUAL_NUM25 NUMBER := FND_API.G_MISS_NUM,
144: SQUAL_NUM26 NUMBER := FND_API.G_MISS_NUM,

Line 141: SQUAL_NUM23 NUMBER := FND_API.G_MISS_NUM,

137: SQUAL_NUM19 NUMBER := FND_API.G_MISS_NUM,
138: SQUAL_NUM20 NUMBER := FND_API.G_MISS_NUM,
139: SQUAL_NUM21 NUMBER := FND_API.G_MISS_NUM,
140: SQUAL_NUM22 NUMBER := FND_API.G_MISS_NUM,
141: SQUAL_NUM23 NUMBER := FND_API.G_MISS_NUM,
142: SQUAL_NUM24 NUMBER := FND_API.G_MISS_NUM,
143: SQUAL_NUM25 NUMBER := FND_API.G_MISS_NUM,
144: SQUAL_NUM26 NUMBER := FND_API.G_MISS_NUM,
145: SQUAL_NUM27 NUMBER := FND_API.G_MISS_NUM,

Line 142: SQUAL_NUM24 NUMBER := FND_API.G_MISS_NUM,

138: SQUAL_NUM20 NUMBER := FND_API.G_MISS_NUM,
139: SQUAL_NUM21 NUMBER := FND_API.G_MISS_NUM,
140: SQUAL_NUM22 NUMBER := FND_API.G_MISS_NUM,
141: SQUAL_NUM23 NUMBER := FND_API.G_MISS_NUM,
142: SQUAL_NUM24 NUMBER := FND_API.G_MISS_NUM,
143: SQUAL_NUM25 NUMBER := FND_API.G_MISS_NUM,
144: SQUAL_NUM26 NUMBER := FND_API.G_MISS_NUM,
145: SQUAL_NUM27 NUMBER := FND_API.G_MISS_NUM,
146: SQUAL_NUM28 NUMBER := FND_API.G_MISS_NUM,

Line 143: SQUAL_NUM25 NUMBER := FND_API.G_MISS_NUM,

139: SQUAL_NUM21 NUMBER := FND_API.G_MISS_NUM,
140: SQUAL_NUM22 NUMBER := FND_API.G_MISS_NUM,
141: SQUAL_NUM23 NUMBER := FND_API.G_MISS_NUM,
142: SQUAL_NUM24 NUMBER := FND_API.G_MISS_NUM,
143: SQUAL_NUM25 NUMBER := FND_API.G_MISS_NUM,
144: SQUAL_NUM26 NUMBER := FND_API.G_MISS_NUM,
145: SQUAL_NUM27 NUMBER := FND_API.G_MISS_NUM,
146: SQUAL_NUM28 NUMBER := FND_API.G_MISS_NUM,
147: SQUAL_NUM29 NUMBER := FND_API.G_MISS_NUM,

Line 144: SQUAL_NUM26 NUMBER := FND_API.G_MISS_NUM,

140: SQUAL_NUM22 NUMBER := FND_API.G_MISS_NUM,
141: SQUAL_NUM23 NUMBER := FND_API.G_MISS_NUM,
142: SQUAL_NUM24 NUMBER := FND_API.G_MISS_NUM,
143: SQUAL_NUM25 NUMBER := FND_API.G_MISS_NUM,
144: SQUAL_NUM26 NUMBER := FND_API.G_MISS_NUM,
145: SQUAL_NUM27 NUMBER := FND_API.G_MISS_NUM,
146: SQUAL_NUM28 NUMBER := FND_API.G_MISS_NUM,
147: SQUAL_NUM29 NUMBER := FND_API.G_MISS_NUM,
148: SQUAL_NUM30 NUMBER := FND_API.G_MISS_NUM,

Line 145: SQUAL_NUM27 NUMBER := FND_API.G_MISS_NUM,

141: SQUAL_NUM23 NUMBER := FND_API.G_MISS_NUM,
142: SQUAL_NUM24 NUMBER := FND_API.G_MISS_NUM,
143: SQUAL_NUM25 NUMBER := FND_API.G_MISS_NUM,
144: SQUAL_NUM26 NUMBER := FND_API.G_MISS_NUM,
145: SQUAL_NUM27 NUMBER := FND_API.G_MISS_NUM,
146: SQUAL_NUM28 NUMBER := FND_API.G_MISS_NUM,
147: SQUAL_NUM29 NUMBER := FND_API.G_MISS_NUM,
148: SQUAL_NUM30 NUMBER := FND_API.G_MISS_NUM,
149: SQUAL_NUM31 NUMBER := FND_API.G_MISS_NUM,

Line 146: SQUAL_NUM28 NUMBER := FND_API.G_MISS_NUM,

142: SQUAL_NUM24 NUMBER := FND_API.G_MISS_NUM,
143: SQUAL_NUM25 NUMBER := FND_API.G_MISS_NUM,
144: SQUAL_NUM26 NUMBER := FND_API.G_MISS_NUM,
145: SQUAL_NUM27 NUMBER := FND_API.G_MISS_NUM,
146: SQUAL_NUM28 NUMBER := FND_API.G_MISS_NUM,
147: SQUAL_NUM29 NUMBER := FND_API.G_MISS_NUM,
148: SQUAL_NUM30 NUMBER := FND_API.G_MISS_NUM,
149: SQUAL_NUM31 NUMBER := FND_API.G_MISS_NUM,
150: SQUAL_NUM32 NUMBER := FND_API.G_MISS_NUM,

Line 147: SQUAL_NUM29 NUMBER := FND_API.G_MISS_NUM,

143: SQUAL_NUM25 NUMBER := FND_API.G_MISS_NUM,
144: SQUAL_NUM26 NUMBER := FND_API.G_MISS_NUM,
145: SQUAL_NUM27 NUMBER := FND_API.G_MISS_NUM,
146: SQUAL_NUM28 NUMBER := FND_API.G_MISS_NUM,
147: SQUAL_NUM29 NUMBER := FND_API.G_MISS_NUM,
148: SQUAL_NUM30 NUMBER := FND_API.G_MISS_NUM,
149: SQUAL_NUM31 NUMBER := FND_API.G_MISS_NUM,
150: SQUAL_NUM32 NUMBER := FND_API.G_MISS_NUM,
151: SQUAL_NUM33 NUMBER := FND_API.G_MISS_NUM,

Line 148: SQUAL_NUM30 NUMBER := FND_API.G_MISS_NUM,

144: SQUAL_NUM26 NUMBER := FND_API.G_MISS_NUM,
145: SQUAL_NUM27 NUMBER := FND_API.G_MISS_NUM,
146: SQUAL_NUM28 NUMBER := FND_API.G_MISS_NUM,
147: SQUAL_NUM29 NUMBER := FND_API.G_MISS_NUM,
148: SQUAL_NUM30 NUMBER := FND_API.G_MISS_NUM,
149: SQUAL_NUM31 NUMBER := FND_API.G_MISS_NUM,
150: SQUAL_NUM32 NUMBER := FND_API.G_MISS_NUM,
151: SQUAL_NUM33 NUMBER := FND_API.G_MISS_NUM,
152: SQUAL_NUM34 NUMBER := FND_API.G_MISS_NUM,

Line 149: SQUAL_NUM31 NUMBER := FND_API.G_MISS_NUM,

145: SQUAL_NUM27 NUMBER := FND_API.G_MISS_NUM,
146: SQUAL_NUM28 NUMBER := FND_API.G_MISS_NUM,
147: SQUAL_NUM29 NUMBER := FND_API.G_MISS_NUM,
148: SQUAL_NUM30 NUMBER := FND_API.G_MISS_NUM,
149: SQUAL_NUM31 NUMBER := FND_API.G_MISS_NUM,
150: SQUAL_NUM32 NUMBER := FND_API.G_MISS_NUM,
151: SQUAL_NUM33 NUMBER := FND_API.G_MISS_NUM,
152: SQUAL_NUM34 NUMBER := FND_API.G_MISS_NUM,
153: SQUAL_NUM35 NUMBER := FND_API.G_MISS_NUM,

Line 150: SQUAL_NUM32 NUMBER := FND_API.G_MISS_NUM,

146: SQUAL_NUM28 NUMBER := FND_API.G_MISS_NUM,
147: SQUAL_NUM29 NUMBER := FND_API.G_MISS_NUM,
148: SQUAL_NUM30 NUMBER := FND_API.G_MISS_NUM,
149: SQUAL_NUM31 NUMBER := FND_API.G_MISS_NUM,
150: SQUAL_NUM32 NUMBER := FND_API.G_MISS_NUM,
151: SQUAL_NUM33 NUMBER := FND_API.G_MISS_NUM,
152: SQUAL_NUM34 NUMBER := FND_API.G_MISS_NUM,
153: SQUAL_NUM35 NUMBER := FND_API.G_MISS_NUM,
154: SQUAL_NUM36 NUMBER := FND_API.G_MISS_NUM,

Line 151: SQUAL_NUM33 NUMBER := FND_API.G_MISS_NUM,

147: SQUAL_NUM29 NUMBER := FND_API.G_MISS_NUM,
148: SQUAL_NUM30 NUMBER := FND_API.G_MISS_NUM,
149: SQUAL_NUM31 NUMBER := FND_API.G_MISS_NUM,
150: SQUAL_NUM32 NUMBER := FND_API.G_MISS_NUM,
151: SQUAL_NUM33 NUMBER := FND_API.G_MISS_NUM,
152: SQUAL_NUM34 NUMBER := FND_API.G_MISS_NUM,
153: SQUAL_NUM35 NUMBER := FND_API.G_MISS_NUM,
154: SQUAL_NUM36 NUMBER := FND_API.G_MISS_NUM,
155: SQUAL_NUM37 NUMBER := FND_API.G_MISS_NUM,

Line 152: SQUAL_NUM34 NUMBER := FND_API.G_MISS_NUM,

148: SQUAL_NUM30 NUMBER := FND_API.G_MISS_NUM,
149: SQUAL_NUM31 NUMBER := FND_API.G_MISS_NUM,
150: SQUAL_NUM32 NUMBER := FND_API.G_MISS_NUM,
151: SQUAL_NUM33 NUMBER := FND_API.G_MISS_NUM,
152: SQUAL_NUM34 NUMBER := FND_API.G_MISS_NUM,
153: SQUAL_NUM35 NUMBER := FND_API.G_MISS_NUM,
154: SQUAL_NUM36 NUMBER := FND_API.G_MISS_NUM,
155: SQUAL_NUM37 NUMBER := FND_API.G_MISS_NUM,
156: SQUAL_NUM38 NUMBER := FND_API.G_MISS_NUM,

Line 153: SQUAL_NUM35 NUMBER := FND_API.G_MISS_NUM,

149: SQUAL_NUM31 NUMBER := FND_API.G_MISS_NUM,
150: SQUAL_NUM32 NUMBER := FND_API.G_MISS_NUM,
151: SQUAL_NUM33 NUMBER := FND_API.G_MISS_NUM,
152: SQUAL_NUM34 NUMBER := FND_API.G_MISS_NUM,
153: SQUAL_NUM35 NUMBER := FND_API.G_MISS_NUM,
154: SQUAL_NUM36 NUMBER := FND_API.G_MISS_NUM,
155: SQUAL_NUM37 NUMBER := FND_API.G_MISS_NUM,
156: SQUAL_NUM38 NUMBER := FND_API.G_MISS_NUM,
157: SQUAL_NUM39 NUMBER := FND_API.G_MISS_NUM,

Line 154: SQUAL_NUM36 NUMBER := FND_API.G_MISS_NUM,

150: SQUAL_NUM32 NUMBER := FND_API.G_MISS_NUM,
151: SQUAL_NUM33 NUMBER := FND_API.G_MISS_NUM,
152: SQUAL_NUM34 NUMBER := FND_API.G_MISS_NUM,
153: SQUAL_NUM35 NUMBER := FND_API.G_MISS_NUM,
154: SQUAL_NUM36 NUMBER := FND_API.G_MISS_NUM,
155: SQUAL_NUM37 NUMBER := FND_API.G_MISS_NUM,
156: SQUAL_NUM38 NUMBER := FND_API.G_MISS_NUM,
157: SQUAL_NUM39 NUMBER := FND_API.G_MISS_NUM,
158: SQUAL_NUM40 NUMBER := FND_API.G_MISS_NUM,

Line 155: SQUAL_NUM37 NUMBER := FND_API.G_MISS_NUM,

151: SQUAL_NUM33 NUMBER := FND_API.G_MISS_NUM,
152: SQUAL_NUM34 NUMBER := FND_API.G_MISS_NUM,
153: SQUAL_NUM35 NUMBER := FND_API.G_MISS_NUM,
154: SQUAL_NUM36 NUMBER := FND_API.G_MISS_NUM,
155: SQUAL_NUM37 NUMBER := FND_API.G_MISS_NUM,
156: SQUAL_NUM38 NUMBER := FND_API.G_MISS_NUM,
157: SQUAL_NUM39 NUMBER := FND_API.G_MISS_NUM,
158: SQUAL_NUM40 NUMBER := FND_API.G_MISS_NUM,
159: SQUAL_NUM41 NUMBER := FND_API.G_MISS_NUM,

Line 156: SQUAL_NUM38 NUMBER := FND_API.G_MISS_NUM,

152: SQUAL_NUM34 NUMBER := FND_API.G_MISS_NUM,
153: SQUAL_NUM35 NUMBER := FND_API.G_MISS_NUM,
154: SQUAL_NUM36 NUMBER := FND_API.G_MISS_NUM,
155: SQUAL_NUM37 NUMBER := FND_API.G_MISS_NUM,
156: SQUAL_NUM38 NUMBER := FND_API.G_MISS_NUM,
157: SQUAL_NUM39 NUMBER := FND_API.G_MISS_NUM,
158: SQUAL_NUM40 NUMBER := FND_API.G_MISS_NUM,
159: SQUAL_NUM41 NUMBER := FND_API.G_MISS_NUM,
160: SQUAL_NUM42 NUMBER := FND_API.G_MISS_NUM,

Line 157: SQUAL_NUM39 NUMBER := FND_API.G_MISS_NUM,

153: SQUAL_NUM35 NUMBER := FND_API.G_MISS_NUM,
154: SQUAL_NUM36 NUMBER := FND_API.G_MISS_NUM,
155: SQUAL_NUM37 NUMBER := FND_API.G_MISS_NUM,
156: SQUAL_NUM38 NUMBER := FND_API.G_MISS_NUM,
157: SQUAL_NUM39 NUMBER := FND_API.G_MISS_NUM,
158: SQUAL_NUM40 NUMBER := FND_API.G_MISS_NUM,
159: SQUAL_NUM41 NUMBER := FND_API.G_MISS_NUM,
160: SQUAL_NUM42 NUMBER := FND_API.G_MISS_NUM,
161: SQUAL_NUM43 NUMBER := FND_API.G_MISS_NUM,

Line 158: SQUAL_NUM40 NUMBER := FND_API.G_MISS_NUM,

154: SQUAL_NUM36 NUMBER := FND_API.G_MISS_NUM,
155: SQUAL_NUM37 NUMBER := FND_API.G_MISS_NUM,
156: SQUAL_NUM38 NUMBER := FND_API.G_MISS_NUM,
157: SQUAL_NUM39 NUMBER := FND_API.G_MISS_NUM,
158: SQUAL_NUM40 NUMBER := FND_API.G_MISS_NUM,
159: SQUAL_NUM41 NUMBER := FND_API.G_MISS_NUM,
160: SQUAL_NUM42 NUMBER := FND_API.G_MISS_NUM,
161: SQUAL_NUM43 NUMBER := FND_API.G_MISS_NUM,
162: SQUAL_NUM44 NUMBER := FND_API.G_MISS_NUM,

Line 159: SQUAL_NUM41 NUMBER := FND_API.G_MISS_NUM,

155: SQUAL_NUM37 NUMBER := FND_API.G_MISS_NUM,
156: SQUAL_NUM38 NUMBER := FND_API.G_MISS_NUM,
157: SQUAL_NUM39 NUMBER := FND_API.G_MISS_NUM,
158: SQUAL_NUM40 NUMBER := FND_API.G_MISS_NUM,
159: SQUAL_NUM41 NUMBER := FND_API.G_MISS_NUM,
160: SQUAL_NUM42 NUMBER := FND_API.G_MISS_NUM,
161: SQUAL_NUM43 NUMBER := FND_API.G_MISS_NUM,
162: SQUAL_NUM44 NUMBER := FND_API.G_MISS_NUM,
163: SQUAL_NUM45 NUMBER := FND_API.G_MISS_NUM,

Line 160: SQUAL_NUM42 NUMBER := FND_API.G_MISS_NUM,

156: SQUAL_NUM38 NUMBER := FND_API.G_MISS_NUM,
157: SQUAL_NUM39 NUMBER := FND_API.G_MISS_NUM,
158: SQUAL_NUM40 NUMBER := FND_API.G_MISS_NUM,
159: SQUAL_NUM41 NUMBER := FND_API.G_MISS_NUM,
160: SQUAL_NUM42 NUMBER := FND_API.G_MISS_NUM,
161: SQUAL_NUM43 NUMBER := FND_API.G_MISS_NUM,
162: SQUAL_NUM44 NUMBER := FND_API.G_MISS_NUM,
163: SQUAL_NUM45 NUMBER := FND_API.G_MISS_NUM,
164: SQUAL_NUM46 NUMBER := FND_API.G_MISS_NUM,

Line 161: SQUAL_NUM43 NUMBER := FND_API.G_MISS_NUM,

157: SQUAL_NUM39 NUMBER := FND_API.G_MISS_NUM,
158: SQUAL_NUM40 NUMBER := FND_API.G_MISS_NUM,
159: SQUAL_NUM41 NUMBER := FND_API.G_MISS_NUM,
160: SQUAL_NUM42 NUMBER := FND_API.G_MISS_NUM,
161: SQUAL_NUM43 NUMBER := FND_API.G_MISS_NUM,
162: SQUAL_NUM44 NUMBER := FND_API.G_MISS_NUM,
163: SQUAL_NUM45 NUMBER := FND_API.G_MISS_NUM,
164: SQUAL_NUM46 NUMBER := FND_API.G_MISS_NUM,
165: SQUAL_NUM47 NUMBER := FND_API.G_MISS_NUM,

Line 162: SQUAL_NUM44 NUMBER := FND_API.G_MISS_NUM,

158: SQUAL_NUM40 NUMBER := FND_API.G_MISS_NUM,
159: SQUAL_NUM41 NUMBER := FND_API.G_MISS_NUM,
160: SQUAL_NUM42 NUMBER := FND_API.G_MISS_NUM,
161: SQUAL_NUM43 NUMBER := FND_API.G_MISS_NUM,
162: SQUAL_NUM44 NUMBER := FND_API.G_MISS_NUM,
163: SQUAL_NUM45 NUMBER := FND_API.G_MISS_NUM,
164: SQUAL_NUM46 NUMBER := FND_API.G_MISS_NUM,
165: SQUAL_NUM47 NUMBER := FND_API.G_MISS_NUM,
166: SQUAL_NUM48 NUMBER := FND_API.G_MISS_NUM,

Line 163: SQUAL_NUM45 NUMBER := FND_API.G_MISS_NUM,

159: SQUAL_NUM41 NUMBER := FND_API.G_MISS_NUM,
160: SQUAL_NUM42 NUMBER := FND_API.G_MISS_NUM,
161: SQUAL_NUM43 NUMBER := FND_API.G_MISS_NUM,
162: SQUAL_NUM44 NUMBER := FND_API.G_MISS_NUM,
163: SQUAL_NUM45 NUMBER := FND_API.G_MISS_NUM,
164: SQUAL_NUM46 NUMBER := FND_API.G_MISS_NUM,
165: SQUAL_NUM47 NUMBER := FND_API.G_MISS_NUM,
166: SQUAL_NUM48 NUMBER := FND_API.G_MISS_NUM,
167: SQUAL_NUM49 NUMBER := FND_API.G_MISS_NUM,

Line 164: SQUAL_NUM46 NUMBER := FND_API.G_MISS_NUM,

160: SQUAL_NUM42 NUMBER := FND_API.G_MISS_NUM,
161: SQUAL_NUM43 NUMBER := FND_API.G_MISS_NUM,
162: SQUAL_NUM44 NUMBER := FND_API.G_MISS_NUM,
163: SQUAL_NUM45 NUMBER := FND_API.G_MISS_NUM,
164: SQUAL_NUM46 NUMBER := FND_API.G_MISS_NUM,
165: SQUAL_NUM47 NUMBER := FND_API.G_MISS_NUM,
166: SQUAL_NUM48 NUMBER := FND_API.G_MISS_NUM,
167: SQUAL_NUM49 NUMBER := FND_API.G_MISS_NUM,
168: SQUAL_NUM50 NUMBER := FND_API.G_MISS_NUM

Line 165: SQUAL_NUM47 NUMBER := FND_API.G_MISS_NUM,

161: SQUAL_NUM43 NUMBER := FND_API.G_MISS_NUM,
162: SQUAL_NUM44 NUMBER := FND_API.G_MISS_NUM,
163: SQUAL_NUM45 NUMBER := FND_API.G_MISS_NUM,
164: SQUAL_NUM46 NUMBER := FND_API.G_MISS_NUM,
165: SQUAL_NUM47 NUMBER := FND_API.G_MISS_NUM,
166: SQUAL_NUM48 NUMBER := FND_API.G_MISS_NUM,
167: SQUAL_NUM49 NUMBER := FND_API.G_MISS_NUM,
168: SQUAL_NUM50 NUMBER := FND_API.G_MISS_NUM
169: );

Line 166: SQUAL_NUM48 NUMBER := FND_API.G_MISS_NUM,

162: SQUAL_NUM44 NUMBER := FND_API.G_MISS_NUM,
163: SQUAL_NUM45 NUMBER := FND_API.G_MISS_NUM,
164: SQUAL_NUM46 NUMBER := FND_API.G_MISS_NUM,
165: SQUAL_NUM47 NUMBER := FND_API.G_MISS_NUM,
166: SQUAL_NUM48 NUMBER := FND_API.G_MISS_NUM,
167: SQUAL_NUM49 NUMBER := FND_API.G_MISS_NUM,
168: SQUAL_NUM50 NUMBER := FND_API.G_MISS_NUM
169: );
170:

Line 167: SQUAL_NUM49 NUMBER := FND_API.G_MISS_NUM,

163: SQUAL_NUM45 NUMBER := FND_API.G_MISS_NUM,
164: SQUAL_NUM46 NUMBER := FND_API.G_MISS_NUM,
165: SQUAL_NUM47 NUMBER := FND_API.G_MISS_NUM,
166: SQUAL_NUM48 NUMBER := FND_API.G_MISS_NUM,
167: SQUAL_NUM49 NUMBER := FND_API.G_MISS_NUM,
168: SQUAL_NUM50 NUMBER := FND_API.G_MISS_NUM
169: );
170:
171: G_MISS_TRANS_REC trans_rec_type;

Line 168: SQUAL_NUM50 NUMBER := FND_API.G_MISS_NUM

164: SQUAL_NUM46 NUMBER := FND_API.G_MISS_NUM,
165: SQUAL_NUM47 NUMBER := FND_API.G_MISS_NUM,
166: SQUAL_NUM48 NUMBER := FND_API.G_MISS_NUM,
167: SQUAL_NUM49 NUMBER := FND_API.G_MISS_NUM,
168: SQUAL_NUM50 NUMBER := FND_API.G_MISS_NUM
169: );
170:
171: G_MISS_TRANS_REC trans_rec_type;
172:

Line 210: (resource_id NUMBER := FND_API.G_MISS_NUM,

206:
207:
208: -- This record_type stores the winning resource and their properties for the territory lookup
209: TYPE win_rsc_rec_type IS record
210: (resource_id NUMBER := FND_API.G_MISS_NUM,
211: terr_id NUMBER := FND_API.G_MISS_NUM,
212: resource_name varchar2(150) := FND_API.G_MISS_CHAR,
213: resource_phone varchar2(150) := FND_API.G_MISS_CHAR,
214: resource_job_title varchar2(150) := FND_API.G_MISS_CHAR,

Line 211: terr_id NUMBER := FND_API.G_MISS_NUM,

207:
208: -- This record_type stores the winning resource and their properties for the territory lookup
209: TYPE win_rsc_rec_type IS record
210: (resource_id NUMBER := FND_API.G_MISS_NUM,
211: terr_id NUMBER := FND_API.G_MISS_NUM,
212: resource_name varchar2(150) := FND_API.G_MISS_CHAR,
213: resource_phone varchar2(150) := FND_API.G_MISS_CHAR,
214: resource_job_title varchar2(150) := FND_API.G_MISS_CHAR,
215: resource_email varchar2(150) := FND_API.G_MISS_CHAR,

Line 212: resource_name varchar2(150) := FND_API.G_MISS_CHAR,

208: -- This record_type stores the winning resource and their properties for the territory lookup
209: TYPE win_rsc_rec_type IS record
210: (resource_id NUMBER := FND_API.G_MISS_NUM,
211: terr_id NUMBER := FND_API.G_MISS_NUM,
212: resource_name varchar2(150) := FND_API.G_MISS_CHAR,
213: resource_phone varchar2(150) := FND_API.G_MISS_CHAR,
214: resource_job_title varchar2(150) := FND_API.G_MISS_CHAR,
215: resource_email varchar2(150) := FND_API.G_MISS_CHAR,
216: resource_mgr_name varchar2(150) := FND_API.G_MISS_CHAR,

Line 213: resource_phone varchar2(150) := FND_API.G_MISS_CHAR,

209: TYPE win_rsc_rec_type IS record
210: (resource_id NUMBER := FND_API.G_MISS_NUM,
211: terr_id NUMBER := FND_API.G_MISS_NUM,
212: resource_name varchar2(150) := FND_API.G_MISS_CHAR,
213: resource_phone varchar2(150) := FND_API.G_MISS_CHAR,
214: resource_job_title varchar2(150) := FND_API.G_MISS_CHAR,
215: resource_email varchar2(150) := FND_API.G_MISS_CHAR,
216: resource_mgr_name varchar2(150) := FND_API.G_MISS_CHAR,
217: resource_mgr_phone varchar2(150) := FND_API.G_MISS_CHAR,

Line 214: resource_job_title varchar2(150) := FND_API.G_MISS_CHAR,

210: (resource_id NUMBER := FND_API.G_MISS_NUM,
211: terr_id NUMBER := FND_API.G_MISS_NUM,
212: resource_name varchar2(150) := FND_API.G_MISS_CHAR,
213: resource_phone varchar2(150) := FND_API.G_MISS_CHAR,
214: resource_job_title varchar2(150) := FND_API.G_MISS_CHAR,
215: resource_email varchar2(150) := FND_API.G_MISS_CHAR,
216: resource_mgr_name varchar2(150) := FND_API.G_MISS_CHAR,
217: resource_mgr_phone varchar2(150) := FND_API.G_MISS_CHAR,
218: resource_mgr_email varchar2(150) := FND_API.G_MISS_CHAR,

Line 215: resource_email varchar2(150) := FND_API.G_MISS_CHAR,

211: terr_id NUMBER := FND_API.G_MISS_NUM,
212: resource_name varchar2(150) := FND_API.G_MISS_CHAR,
213: resource_phone varchar2(150) := FND_API.G_MISS_CHAR,
214: resource_job_title varchar2(150) := FND_API.G_MISS_CHAR,
215: resource_email varchar2(150) := FND_API.G_MISS_CHAR,
216: resource_mgr_name varchar2(150) := FND_API.G_MISS_CHAR,
217: resource_mgr_phone varchar2(150) := FND_API.G_MISS_CHAR,
218: resource_mgr_email varchar2(150) := FND_API.G_MISS_CHAR,
219: resource_property1 varchar2(150) := FND_API.G_MISS_CHAR,

Line 216: resource_mgr_name varchar2(150) := FND_API.G_MISS_CHAR,

212: resource_name varchar2(150) := FND_API.G_MISS_CHAR,
213: resource_phone varchar2(150) := FND_API.G_MISS_CHAR,
214: resource_job_title varchar2(150) := FND_API.G_MISS_CHAR,
215: resource_email varchar2(150) := FND_API.G_MISS_CHAR,
216: resource_mgr_name varchar2(150) := FND_API.G_MISS_CHAR,
217: resource_mgr_phone varchar2(150) := FND_API.G_MISS_CHAR,
218: resource_mgr_email varchar2(150) := FND_API.G_MISS_CHAR,
219: resource_property1 varchar2(150) := FND_API.G_MISS_CHAR,
220: resource_property2 varchar2(150) := FND_API.G_MISS_CHAR,

Line 217: resource_mgr_phone varchar2(150) := FND_API.G_MISS_CHAR,

213: resource_phone varchar2(150) := FND_API.G_MISS_CHAR,
214: resource_job_title varchar2(150) := FND_API.G_MISS_CHAR,
215: resource_email varchar2(150) := FND_API.G_MISS_CHAR,
216: resource_mgr_name varchar2(150) := FND_API.G_MISS_CHAR,
217: resource_mgr_phone varchar2(150) := FND_API.G_MISS_CHAR,
218: resource_mgr_email varchar2(150) := FND_API.G_MISS_CHAR,
219: resource_property1 varchar2(150) := FND_API.G_MISS_CHAR,
220: resource_property2 varchar2(150) := FND_API.G_MISS_CHAR,
221: resource_property3 varchar2(150) := FND_API.G_MISS_CHAR,

Line 218: resource_mgr_email varchar2(150) := FND_API.G_MISS_CHAR,

214: resource_job_title varchar2(150) := FND_API.G_MISS_CHAR,
215: resource_email varchar2(150) := FND_API.G_MISS_CHAR,
216: resource_mgr_name varchar2(150) := FND_API.G_MISS_CHAR,
217: resource_mgr_phone varchar2(150) := FND_API.G_MISS_CHAR,
218: resource_mgr_email varchar2(150) := FND_API.G_MISS_CHAR,
219: resource_property1 varchar2(150) := FND_API.G_MISS_CHAR,
220: resource_property2 varchar2(150) := FND_API.G_MISS_CHAR,
221: resource_property3 varchar2(150) := FND_API.G_MISS_CHAR,
222: resource_property4 varchar2(150) := FND_API.G_MISS_CHAR

Line 219: resource_property1 varchar2(150) := FND_API.G_MISS_CHAR,

215: resource_email varchar2(150) := FND_API.G_MISS_CHAR,
216: resource_mgr_name varchar2(150) := FND_API.G_MISS_CHAR,
217: resource_mgr_phone varchar2(150) := FND_API.G_MISS_CHAR,
218: resource_mgr_email varchar2(150) := FND_API.G_MISS_CHAR,
219: resource_property1 varchar2(150) := FND_API.G_MISS_CHAR,
220: resource_property2 varchar2(150) := FND_API.G_MISS_CHAR,
221: resource_property3 varchar2(150) := FND_API.G_MISS_CHAR,
222: resource_property4 varchar2(150) := FND_API.G_MISS_CHAR
223: );

Line 220: resource_property2 varchar2(150) := FND_API.G_MISS_CHAR,

216: resource_mgr_name varchar2(150) := FND_API.G_MISS_CHAR,
217: resource_mgr_phone varchar2(150) := FND_API.G_MISS_CHAR,
218: resource_mgr_email varchar2(150) := FND_API.G_MISS_CHAR,
219: resource_property1 varchar2(150) := FND_API.G_MISS_CHAR,
220: resource_property2 varchar2(150) := FND_API.G_MISS_CHAR,
221: resource_property3 varchar2(150) := FND_API.G_MISS_CHAR,
222: resource_property4 varchar2(150) := FND_API.G_MISS_CHAR
223: );
224:

Line 221: resource_property3 varchar2(150) := FND_API.G_MISS_CHAR,

217: resource_mgr_phone varchar2(150) := FND_API.G_MISS_CHAR,
218: resource_mgr_email varchar2(150) := FND_API.G_MISS_CHAR,
219: resource_property1 varchar2(150) := FND_API.G_MISS_CHAR,
220: resource_property2 varchar2(150) := FND_API.G_MISS_CHAR,
221: resource_property3 varchar2(150) := FND_API.G_MISS_CHAR,
222: resource_property4 varchar2(150) := FND_API.G_MISS_CHAR
223: );
224:
225: TYPE win_rsc_tbl_type IS table of win_rsc_rec_type

Line 222: resource_property4 varchar2(150) := FND_API.G_MISS_CHAR

218: resource_mgr_email varchar2(150) := FND_API.G_MISS_CHAR,
219: resource_property1 varchar2(150) := FND_API.G_MISS_CHAR,
220: resource_property2 varchar2(150) := FND_API.G_MISS_CHAR,
221: resource_property3 varchar2(150) := FND_API.G_MISS_CHAR,
222: resource_property4 varchar2(150) := FND_API.G_MISS_CHAR
223: );
224:
225: TYPE win_rsc_tbl_type IS table of win_rsc_rec_type
226: INDEX BY binary_integer;

Line 238: trans_object_id NUMBER := FND_API.G_MISS_NUM,

234:
235: use_type VARCHAR2(30), -- refer to body for valid values of this parameter
236: source_id NUMBER,
237: transaction_id NUMBER,
238: trans_object_id NUMBER := FND_API.G_MISS_NUM,
239: trans_detail_object_id NUMBER := FND_API.G_MISS_NUM,
240:
241: -- territory definition properties
242: terr_id NUMBER := FND_API.G_MISS_NUM,

Line 239: trans_detail_object_id NUMBER := FND_API.G_MISS_NUM,

235: use_type VARCHAR2(30), -- refer to body for valid values of this parameter
236: source_id NUMBER,
237: transaction_id NUMBER,
238: trans_object_id NUMBER := FND_API.G_MISS_NUM,
239: trans_detail_object_id NUMBER := FND_API.G_MISS_NUM,
240:
241: -- territory definition properties
242: terr_id NUMBER := FND_API.G_MISS_NUM,
243: terr_rsc_id NUMBER := FND_API.G_MISS_NUM,

Line 242: terr_id NUMBER := FND_API.G_MISS_NUM,

238: trans_object_id NUMBER := FND_API.G_MISS_NUM,
239: trans_detail_object_id NUMBER := FND_API.G_MISS_NUM,
240:
241: -- territory definition properties
242: terr_id NUMBER := FND_API.G_MISS_NUM,
243: terr_rsc_id NUMBER := FND_API.G_MISS_NUM,
244: terr_name NUMBER := FND_API.G_MISS_NUM,
245: top_level_terr_id NUMBER := FND_API.G_MISS_NUM,
246: absolute_rank NUMBER := FND_API.G_MISS_NUM,

Line 243: terr_rsc_id NUMBER := FND_API.G_MISS_NUM,

239: trans_detail_object_id NUMBER := FND_API.G_MISS_NUM,
240:
241: -- territory definition properties
242: terr_id NUMBER := FND_API.G_MISS_NUM,
243: terr_rsc_id NUMBER := FND_API.G_MISS_NUM,
244: terr_name NUMBER := FND_API.G_MISS_NUM,
245: top_level_terr_id NUMBER := FND_API.G_MISS_NUM,
246: absolute_rank NUMBER := FND_API.G_MISS_NUM,
247:

Line 244: terr_name NUMBER := FND_API.G_MISS_NUM,

240:
241: -- territory definition properties
242: terr_id NUMBER := FND_API.G_MISS_NUM,
243: terr_rsc_id NUMBER := FND_API.G_MISS_NUM,
244: terr_name NUMBER := FND_API.G_MISS_NUM,
245: top_level_terr_id NUMBER := FND_API.G_MISS_NUM,
246: absolute_rank NUMBER := FND_API.G_MISS_NUM,
247:
248: -- resource definition properties

Line 245: top_level_terr_id NUMBER := FND_API.G_MISS_NUM,

241: -- territory definition properties
242: terr_id NUMBER := FND_API.G_MISS_NUM,
243: terr_rsc_id NUMBER := FND_API.G_MISS_NUM,
244: terr_name NUMBER := FND_API.G_MISS_NUM,
245: top_level_terr_id NUMBER := FND_API.G_MISS_NUM,
246: absolute_rank NUMBER := FND_API.G_MISS_NUM,
247:
248: -- resource definition properties
249: resource_id NUMBER := FND_API.G_MISS_NUM,

Line 246: absolute_rank NUMBER := FND_API.G_MISS_NUM,

242: terr_id NUMBER := FND_API.G_MISS_NUM,
243: terr_rsc_id NUMBER := FND_API.G_MISS_NUM,
244: terr_name NUMBER := FND_API.G_MISS_NUM,
245: top_level_terr_id NUMBER := FND_API.G_MISS_NUM,
246: absolute_rank NUMBER := FND_API.G_MISS_NUM,
247:
248: -- resource definition properties
249: resource_id NUMBER := FND_API.G_MISS_NUM,
250: resource_type VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 249: resource_id NUMBER := FND_API.G_MISS_NUM,

245: top_level_terr_id NUMBER := FND_API.G_MISS_NUM,
246: absolute_rank NUMBER := FND_API.G_MISS_NUM,
247:
248: -- resource definition properties
249: resource_id NUMBER := FND_API.G_MISS_NUM,
250: resource_type VARCHAR2(360) := FND_API.G_MISS_CHAR,
251: group_id NUMBER := FND_API.G_MISS_NUM,
252: role VARCHAR2(360) := FND_API.G_MISS_CHAR,
253: full_access_flag VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 250: resource_type VARCHAR2(360) := FND_API.G_MISS_CHAR,

246: absolute_rank NUMBER := FND_API.G_MISS_NUM,
247:
248: -- resource definition properties
249: resource_id NUMBER := FND_API.G_MISS_NUM,
250: resource_type VARCHAR2(360) := FND_API.G_MISS_CHAR,
251: group_id NUMBER := FND_API.G_MISS_NUM,
252: role VARCHAR2(360) := FND_API.G_MISS_CHAR,
253: full_access_flag VARCHAR2(360) := FND_API.G_MISS_CHAR,
254: primary_contact_flag VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 251: group_id NUMBER := FND_API.G_MISS_NUM,

247:
248: -- resource definition properties
249: resource_id NUMBER := FND_API.G_MISS_NUM,
250: resource_type VARCHAR2(360) := FND_API.G_MISS_CHAR,
251: group_id NUMBER := FND_API.G_MISS_NUM,
252: role VARCHAR2(360) := FND_API.G_MISS_CHAR,
253: full_access_flag VARCHAR2(360) := FND_API.G_MISS_CHAR,
254: primary_contact_flag VARCHAR2(360) := FND_API.G_MISS_CHAR,
255: resource_name VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 252: role VARCHAR2(360) := FND_API.G_MISS_CHAR,

248: -- resource definition properties
249: resource_id NUMBER := FND_API.G_MISS_NUM,
250: resource_type VARCHAR2(360) := FND_API.G_MISS_CHAR,
251: group_id NUMBER := FND_API.G_MISS_NUM,
252: role VARCHAR2(360) := FND_API.G_MISS_CHAR,
253: full_access_flag VARCHAR2(360) := FND_API.G_MISS_CHAR,
254: primary_contact_flag VARCHAR2(360) := FND_API.G_MISS_CHAR,
255: resource_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
256: resource_job_title VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 253: full_access_flag VARCHAR2(360) := FND_API.G_MISS_CHAR,

249: resource_id NUMBER := FND_API.G_MISS_NUM,
250: resource_type VARCHAR2(360) := FND_API.G_MISS_CHAR,
251: group_id NUMBER := FND_API.G_MISS_NUM,
252: role VARCHAR2(360) := FND_API.G_MISS_CHAR,
253: full_access_flag VARCHAR2(360) := FND_API.G_MISS_CHAR,
254: primary_contact_flag VARCHAR2(360) := FND_API.G_MISS_CHAR,
255: resource_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
256: resource_job_title VARCHAR2(360) := FND_API.G_MISS_CHAR,
257: resource_phone VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 254: primary_contact_flag VARCHAR2(360) := FND_API.G_MISS_CHAR,

250: resource_type VARCHAR2(360) := FND_API.G_MISS_CHAR,
251: group_id NUMBER := FND_API.G_MISS_NUM,
252: role VARCHAR2(360) := FND_API.G_MISS_CHAR,
253: full_access_flag VARCHAR2(360) := FND_API.G_MISS_CHAR,
254: primary_contact_flag VARCHAR2(360) := FND_API.G_MISS_CHAR,
255: resource_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
256: resource_job_title VARCHAR2(360) := FND_API.G_MISS_CHAR,
257: resource_phone VARCHAR2(360) := FND_API.G_MISS_CHAR,
258: resource_email VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 255: resource_name VARCHAR2(360) := FND_API.G_MISS_CHAR,

251: group_id NUMBER := FND_API.G_MISS_NUM,
252: role VARCHAR2(360) := FND_API.G_MISS_CHAR,
253: full_access_flag VARCHAR2(360) := FND_API.G_MISS_CHAR,
254: primary_contact_flag VARCHAR2(360) := FND_API.G_MISS_CHAR,
255: resource_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
256: resource_job_title VARCHAR2(360) := FND_API.G_MISS_CHAR,
257: resource_phone VARCHAR2(360) := FND_API.G_MISS_CHAR,
258: resource_email VARCHAR2(360) := FND_API.G_MISS_CHAR,
259: resource_mgr_name VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 256: resource_job_title VARCHAR2(360) := FND_API.G_MISS_CHAR,

252: role VARCHAR2(360) := FND_API.G_MISS_CHAR,
253: full_access_flag VARCHAR2(360) := FND_API.G_MISS_CHAR,
254: primary_contact_flag VARCHAR2(360) := FND_API.G_MISS_CHAR,
255: resource_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
256: resource_job_title VARCHAR2(360) := FND_API.G_MISS_CHAR,
257: resource_phone VARCHAR2(360) := FND_API.G_MISS_CHAR,
258: resource_email VARCHAR2(360) := FND_API.G_MISS_CHAR,
259: resource_mgr_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
260: resource_mgr_phone VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 257: resource_phone VARCHAR2(360) := FND_API.G_MISS_CHAR,

253: full_access_flag VARCHAR2(360) := FND_API.G_MISS_CHAR,
254: primary_contact_flag VARCHAR2(360) := FND_API.G_MISS_CHAR,
255: resource_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
256: resource_job_title VARCHAR2(360) := FND_API.G_MISS_CHAR,
257: resource_phone VARCHAR2(360) := FND_API.G_MISS_CHAR,
258: resource_email VARCHAR2(360) := FND_API.G_MISS_CHAR,
259: resource_mgr_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
260: resource_mgr_phone VARCHAR2(360) := FND_API.G_MISS_CHAR,
261: resource_mgr_email VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 258: resource_email VARCHAR2(360) := FND_API.G_MISS_CHAR,

254: primary_contact_flag VARCHAR2(360) := FND_API.G_MISS_CHAR,
255: resource_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
256: resource_job_title VARCHAR2(360) := FND_API.G_MISS_CHAR,
257: resource_phone VARCHAR2(360) := FND_API.G_MISS_CHAR,
258: resource_email VARCHAR2(360) := FND_API.G_MISS_CHAR,
259: resource_mgr_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
260: resource_mgr_phone VARCHAR2(360) := FND_API.G_MISS_CHAR,
261: resource_mgr_email VARCHAR2(360) := FND_API.G_MISS_CHAR,
262: property1 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 259: resource_mgr_name VARCHAR2(360) := FND_API.G_MISS_CHAR,

255: resource_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
256: resource_job_title VARCHAR2(360) := FND_API.G_MISS_CHAR,
257: resource_phone VARCHAR2(360) := FND_API.G_MISS_CHAR,
258: resource_email VARCHAR2(360) := FND_API.G_MISS_CHAR,
259: resource_mgr_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
260: resource_mgr_phone VARCHAR2(360) := FND_API.G_MISS_CHAR,
261: resource_mgr_email VARCHAR2(360) := FND_API.G_MISS_CHAR,
262: property1 VARCHAR2(360) := FND_API.G_MISS_CHAR,
263: property2 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 260: resource_mgr_phone VARCHAR2(360) := FND_API.G_MISS_CHAR,

256: resource_job_title VARCHAR2(360) := FND_API.G_MISS_CHAR,
257: resource_phone VARCHAR2(360) := FND_API.G_MISS_CHAR,
258: resource_email VARCHAR2(360) := FND_API.G_MISS_CHAR,
259: resource_mgr_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
260: resource_mgr_phone VARCHAR2(360) := FND_API.G_MISS_CHAR,
261: resource_mgr_email VARCHAR2(360) := FND_API.G_MISS_CHAR,
262: property1 VARCHAR2(360) := FND_API.G_MISS_CHAR,
263: property2 VARCHAR2(360) := FND_API.G_MISS_CHAR,
264: property3 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 261: resource_mgr_email VARCHAR2(360) := FND_API.G_MISS_CHAR,

257: resource_phone VARCHAR2(360) := FND_API.G_MISS_CHAR,
258: resource_email VARCHAR2(360) := FND_API.G_MISS_CHAR,
259: resource_mgr_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
260: resource_mgr_phone VARCHAR2(360) := FND_API.G_MISS_CHAR,
261: resource_mgr_email VARCHAR2(360) := FND_API.G_MISS_CHAR,
262: property1 VARCHAR2(360) := FND_API.G_MISS_CHAR,
263: property2 VARCHAR2(360) := FND_API.G_MISS_CHAR,
264: property3 VARCHAR2(360) := FND_API.G_MISS_CHAR,
265: property4 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 262: property1 VARCHAR2(360) := FND_API.G_MISS_CHAR,

258: resource_email VARCHAR2(360) := FND_API.G_MISS_CHAR,
259: resource_mgr_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
260: resource_mgr_phone VARCHAR2(360) := FND_API.G_MISS_CHAR,
261: resource_mgr_email VARCHAR2(360) := FND_API.G_MISS_CHAR,
262: property1 VARCHAR2(360) := FND_API.G_MISS_CHAR,
263: property2 VARCHAR2(360) := FND_API.G_MISS_CHAR,
264: property3 VARCHAR2(360) := FND_API.G_MISS_CHAR,
265: property4 VARCHAR2(360) := FND_API.G_MISS_CHAR,
266: property5 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 263: property2 VARCHAR2(360) := FND_API.G_MISS_CHAR,

259: resource_mgr_name VARCHAR2(360) := FND_API.G_MISS_CHAR,
260: resource_mgr_phone VARCHAR2(360) := FND_API.G_MISS_CHAR,
261: resource_mgr_email VARCHAR2(360) := FND_API.G_MISS_CHAR,
262: property1 VARCHAR2(360) := FND_API.G_MISS_CHAR,
263: property2 VARCHAR2(360) := FND_API.G_MISS_CHAR,
264: property3 VARCHAR2(360) := FND_API.G_MISS_CHAR,
265: property4 VARCHAR2(360) := FND_API.G_MISS_CHAR,
266: property5 VARCHAR2(360) := FND_API.G_MISS_CHAR,
267: property6 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 264: property3 VARCHAR2(360) := FND_API.G_MISS_CHAR,

260: resource_mgr_phone VARCHAR2(360) := FND_API.G_MISS_CHAR,
261: resource_mgr_email VARCHAR2(360) := FND_API.G_MISS_CHAR,
262: property1 VARCHAR2(360) := FND_API.G_MISS_CHAR,
263: property2 VARCHAR2(360) := FND_API.G_MISS_CHAR,
264: property3 VARCHAR2(360) := FND_API.G_MISS_CHAR,
265: property4 VARCHAR2(360) := FND_API.G_MISS_CHAR,
266: property5 VARCHAR2(360) := FND_API.G_MISS_CHAR,
267: property6 VARCHAR2(360) := FND_API.G_MISS_CHAR,
268: property7 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 265: property4 VARCHAR2(360) := FND_API.G_MISS_CHAR,

261: resource_mgr_email VARCHAR2(360) := FND_API.G_MISS_CHAR,
262: property1 VARCHAR2(360) := FND_API.G_MISS_CHAR,
263: property2 VARCHAR2(360) := FND_API.G_MISS_CHAR,
264: property3 VARCHAR2(360) := FND_API.G_MISS_CHAR,
265: property4 VARCHAR2(360) := FND_API.G_MISS_CHAR,
266: property5 VARCHAR2(360) := FND_API.G_MISS_CHAR,
267: property6 VARCHAR2(360) := FND_API.G_MISS_CHAR,
268: property7 VARCHAR2(360) := FND_API.G_MISS_CHAR,
269: property8 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 266: property5 VARCHAR2(360) := FND_API.G_MISS_CHAR,

262: property1 VARCHAR2(360) := FND_API.G_MISS_CHAR,
263: property2 VARCHAR2(360) := FND_API.G_MISS_CHAR,
264: property3 VARCHAR2(360) := FND_API.G_MISS_CHAR,
265: property4 VARCHAR2(360) := FND_API.G_MISS_CHAR,
266: property5 VARCHAR2(360) := FND_API.G_MISS_CHAR,
267: property6 VARCHAR2(360) := FND_API.G_MISS_CHAR,
268: property7 VARCHAR2(360) := FND_API.G_MISS_CHAR,
269: property8 VARCHAR2(360) := FND_API.G_MISS_CHAR,
270: property9 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 267: property6 VARCHAR2(360) := FND_API.G_MISS_CHAR,

263: property2 VARCHAR2(360) := FND_API.G_MISS_CHAR,
264: property3 VARCHAR2(360) := FND_API.G_MISS_CHAR,
265: property4 VARCHAR2(360) := FND_API.G_MISS_CHAR,
266: property5 VARCHAR2(360) := FND_API.G_MISS_CHAR,
267: property6 VARCHAR2(360) := FND_API.G_MISS_CHAR,
268: property7 VARCHAR2(360) := FND_API.G_MISS_CHAR,
269: property8 VARCHAR2(360) := FND_API.G_MISS_CHAR,
270: property9 VARCHAR2(360) := FND_API.G_MISS_CHAR,
271: property10 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 268: property7 VARCHAR2(360) := FND_API.G_MISS_CHAR,

264: property3 VARCHAR2(360) := FND_API.G_MISS_CHAR,
265: property4 VARCHAR2(360) := FND_API.G_MISS_CHAR,
266: property5 VARCHAR2(360) := FND_API.G_MISS_CHAR,
267: property6 VARCHAR2(360) := FND_API.G_MISS_CHAR,
268: property7 VARCHAR2(360) := FND_API.G_MISS_CHAR,
269: property8 VARCHAR2(360) := FND_API.G_MISS_CHAR,
270: property9 VARCHAR2(360) := FND_API.G_MISS_CHAR,
271: property10 VARCHAR2(360) := FND_API.G_MISS_CHAR,
272: property11 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 269: property8 VARCHAR2(360) := FND_API.G_MISS_CHAR,

265: property4 VARCHAR2(360) := FND_API.G_MISS_CHAR,
266: property5 VARCHAR2(360) := FND_API.G_MISS_CHAR,
267: property6 VARCHAR2(360) := FND_API.G_MISS_CHAR,
268: property7 VARCHAR2(360) := FND_API.G_MISS_CHAR,
269: property8 VARCHAR2(360) := FND_API.G_MISS_CHAR,
270: property9 VARCHAR2(360) := FND_API.G_MISS_CHAR,
271: property10 VARCHAR2(360) := FND_API.G_MISS_CHAR,
272: property11 VARCHAR2(360) := FND_API.G_MISS_CHAR,
273: property12 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 270: property9 VARCHAR2(360) := FND_API.G_MISS_CHAR,

266: property5 VARCHAR2(360) := FND_API.G_MISS_CHAR,
267: property6 VARCHAR2(360) := FND_API.G_MISS_CHAR,
268: property7 VARCHAR2(360) := FND_API.G_MISS_CHAR,
269: property8 VARCHAR2(360) := FND_API.G_MISS_CHAR,
270: property9 VARCHAR2(360) := FND_API.G_MISS_CHAR,
271: property10 VARCHAR2(360) := FND_API.G_MISS_CHAR,
272: property11 VARCHAR2(360) := FND_API.G_MISS_CHAR,
273: property12 VARCHAR2(360) := FND_API.G_MISS_CHAR,
274: property13 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 271: property10 VARCHAR2(360) := FND_API.G_MISS_CHAR,

267: property6 VARCHAR2(360) := FND_API.G_MISS_CHAR,
268: property7 VARCHAR2(360) := FND_API.G_MISS_CHAR,
269: property8 VARCHAR2(360) := FND_API.G_MISS_CHAR,
270: property9 VARCHAR2(360) := FND_API.G_MISS_CHAR,
271: property10 VARCHAR2(360) := FND_API.G_MISS_CHAR,
272: property11 VARCHAR2(360) := FND_API.G_MISS_CHAR,
273: property12 VARCHAR2(360) := FND_API.G_MISS_CHAR,
274: property13 VARCHAR2(360) := FND_API.G_MISS_CHAR,
275: property14 VARCHAR2(360) := FND_API.G_MISS_CHAR,

Line 272: property11 VARCHAR2(360) := FND_API.G_MISS_CHAR,

268: property7 VARCHAR2(360) := FND_API.G_MISS_CHAR,
269: property8 VARCHAR2(360) := FND_API.G_MISS_CHAR,
270: property9 VARCHAR2(360) := FND_API.G_MISS_CHAR,
271: property10 VARCHAR2(360) := FND_API.G_MISS_CHAR,
272: property11 VARCHAR2(360) := FND_API.G_MISS_CHAR,
273: property12 VARCHAR2(360) := FND_API.G_MISS_CHAR,
274: property13 VARCHAR2(360) := FND_API.G_MISS_CHAR,
275: property14 VARCHAR2(360) := FND_API.G_MISS_CHAR,
276: property15 VARCHAR2(360) := FND_API.G_MISS_CHAR

Line 273: property12 VARCHAR2(360) := FND_API.G_MISS_CHAR,

269: property8 VARCHAR2(360) := FND_API.G_MISS_CHAR,
270: property9 VARCHAR2(360) := FND_API.G_MISS_CHAR,
271: property10 VARCHAR2(360) := FND_API.G_MISS_CHAR,
272: property11 VARCHAR2(360) := FND_API.G_MISS_CHAR,
273: property12 VARCHAR2(360) := FND_API.G_MISS_CHAR,
274: property13 VARCHAR2(360) := FND_API.G_MISS_CHAR,
275: property14 VARCHAR2(360) := FND_API.G_MISS_CHAR,
276: property15 VARCHAR2(360) := FND_API.G_MISS_CHAR
277:

Line 274: property13 VARCHAR2(360) := FND_API.G_MISS_CHAR,

270: property9 VARCHAR2(360) := FND_API.G_MISS_CHAR,
271: property10 VARCHAR2(360) := FND_API.G_MISS_CHAR,
272: property11 VARCHAR2(360) := FND_API.G_MISS_CHAR,
273: property12 VARCHAR2(360) := FND_API.G_MISS_CHAR,
274: property13 VARCHAR2(360) := FND_API.G_MISS_CHAR,
275: property14 VARCHAR2(360) := FND_API.G_MISS_CHAR,
276: property15 VARCHAR2(360) := FND_API.G_MISS_CHAR
277:
278:

Line 275: property14 VARCHAR2(360) := FND_API.G_MISS_CHAR,

271: property10 VARCHAR2(360) := FND_API.G_MISS_CHAR,
272: property11 VARCHAR2(360) := FND_API.G_MISS_CHAR,
273: property12 VARCHAR2(360) := FND_API.G_MISS_CHAR,
274: property13 VARCHAR2(360) := FND_API.G_MISS_CHAR,
275: property14 VARCHAR2(360) := FND_API.G_MISS_CHAR,
276: property15 VARCHAR2(360) := FND_API.G_MISS_CHAR
277:
278:
279: ); -- end bulk_terr_winners_rec_type

Line 276: property15 VARCHAR2(360) := FND_API.G_MISS_CHAR

272: property11 VARCHAR2(360) := FND_API.G_MISS_CHAR,
273: property12 VARCHAR2(360) := FND_API.G_MISS_CHAR,
274: property13 VARCHAR2(360) := FND_API.G_MISS_CHAR,
275: property14 VARCHAR2(360) := FND_API.G_MISS_CHAR,
276: property15 VARCHAR2(360) := FND_API.G_MISS_CHAR
277:
278:
279: ); -- end bulk_terr_winners_rec_type
280:

Line 333: -- p_init_msg_list IN varchar2 optional --default = fnd_api.g_false

329: -- parameters :
330: --
331: -- IN:
332: -- p_api_version_number IN number required
333: -- p_init_msg_list IN varchar2 optional --default = fnd_api.g_false
334: -- p_commit IN varchar2 optional --default = fnd_api.g_false
335: -- p_Org_Id IN number required
336: -- p_TerrAccount_Rec IN JTF_Account_rec_type
337: -- p_Resource_Type IN varchar2

Line 334: -- p_commit IN varchar2 optional --default = fnd_api.g_false

330: --
331: -- IN:
332: -- p_api_version_number IN number required
333: -- p_init_msg_list IN varchar2 optional --default = fnd_api.g_false
334: -- p_commit IN varchar2 optional --default = fnd_api.g_false
335: -- p_Org_Id IN number required
336: -- p_TerrAccount_Rec IN JTF_Account_rec_type
337: -- p_Resource_Type IN varchar2
338: -- p_Role IN varchar2,

Line 360: p_init_msg_list IN varchar2 := fnd_api.g_false,

356: --
357: -- end of comments
358: procedure Get_Winners
359: ( p_api_version_number IN number,
360: p_init_msg_list IN varchar2 := fnd_api.g_false,
361: p_trans_rec IN trans_rec_type,
362: p_source_id IN number,
363: p_trans_id IN number,
364: p_Resource_Type IN varchar2,