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.CS_SERVICEREQUEST_PVT dependencies on FND_API

Line 83: ( type_id NUMBER := FND_API.G_MISS_NUM,

79: ------------------------------------------------------------------------
80: -- Set up record types to be used for the Validate_ServiceRequest_Record Procedure
81: ------------------------------------------------------------------------
82: TYPE Request_Validation_Rec_Type IS RECORD
83: ( type_id NUMBER := FND_API.G_MISS_NUM,
84: status_id NUMBER := FND_API.G_MISS_NUM,
85: severity_id NUMBER := FND_API.G_MISS_NUM,
86: urgency_id NUMBER := FND_API.G_MISS_NUM,
87: resource_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 84: status_id NUMBER := FND_API.G_MISS_NUM,

80: -- Set up record types to be used for the Validate_ServiceRequest_Record Procedure
81: ------------------------------------------------------------------------
82: TYPE Request_Validation_Rec_Type IS RECORD
83: ( type_id NUMBER := FND_API.G_MISS_NUM,
84: status_id NUMBER := FND_API.G_MISS_NUM,
85: severity_id NUMBER := FND_API.G_MISS_NUM,
86: urgency_id NUMBER := FND_API.G_MISS_NUM,
87: resource_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
88: owner_id NUMBER := FND_API.G_MISS_NUM,

Line 85: severity_id NUMBER := FND_API.G_MISS_NUM,

81: ------------------------------------------------------------------------
82: TYPE Request_Validation_Rec_Type IS RECORD
83: ( type_id NUMBER := FND_API.G_MISS_NUM,
84: status_id NUMBER := FND_API.G_MISS_NUM,
85: severity_id NUMBER := FND_API.G_MISS_NUM,
86: urgency_id NUMBER := FND_API.G_MISS_NUM,
87: resource_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
88: owner_id NUMBER := FND_API.G_MISS_NUM,
89: publish_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

Line 86: urgency_id NUMBER := FND_API.G_MISS_NUM,

82: TYPE Request_Validation_Rec_Type IS RECORD
83: ( type_id NUMBER := FND_API.G_MISS_NUM,
84: status_id NUMBER := FND_API.G_MISS_NUM,
85: severity_id NUMBER := FND_API.G_MISS_NUM,
86: urgency_id NUMBER := FND_API.G_MISS_NUM,
87: resource_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
88: owner_id NUMBER := FND_API.G_MISS_NUM,
89: publish_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
90: customer_id NUMBER := FND_API.G_MISS_NUM,

Line 87: resource_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

83: ( type_id NUMBER := FND_API.G_MISS_NUM,
84: status_id NUMBER := FND_API.G_MISS_NUM,
85: severity_id NUMBER := FND_API.G_MISS_NUM,
86: urgency_id NUMBER := FND_API.G_MISS_NUM,
87: resource_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
88: owner_id NUMBER := FND_API.G_MISS_NUM,
89: publish_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
90: customer_id NUMBER := FND_API.G_MISS_NUM,
91: employee_id NUMBER := FND_API.G_MISS_NUM,

Line 88: owner_id NUMBER := FND_API.G_MISS_NUM,

84: status_id NUMBER := FND_API.G_MISS_NUM,
85: severity_id NUMBER := FND_API.G_MISS_NUM,
86: urgency_id NUMBER := FND_API.G_MISS_NUM,
87: resource_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
88: owner_id NUMBER := FND_API.G_MISS_NUM,
89: publish_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
90: customer_id NUMBER := FND_API.G_MISS_NUM,
91: employee_id NUMBER := FND_API.G_MISS_NUM,
92: contact_id NUMBER := FND_API.G_MISS_NUM,

Line 89: publish_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,

85: severity_id NUMBER := FND_API.G_MISS_NUM,
86: urgency_id NUMBER := FND_API.G_MISS_NUM,
87: resource_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
88: owner_id NUMBER := FND_API.G_MISS_NUM,
89: publish_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
90: customer_id NUMBER := FND_API.G_MISS_NUM,
91: employee_id NUMBER := FND_API.G_MISS_NUM,
92: contact_id NUMBER := FND_API.G_MISS_NUM,
93: represented_by_id NUMBER := FND_API.G_MISS_NUM,

Line 90: customer_id NUMBER := FND_API.G_MISS_NUM,

86: urgency_id NUMBER := FND_API.G_MISS_NUM,
87: resource_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
88: owner_id NUMBER := FND_API.G_MISS_NUM,
89: publish_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
90: customer_id NUMBER := FND_API.G_MISS_NUM,
91: employee_id NUMBER := FND_API.G_MISS_NUM,
92: contact_id NUMBER := FND_API.G_MISS_NUM,
93: represented_by_id NUMBER := FND_API.G_MISS_NUM,
94: customer_product_id NUMBER := FND_API.G_MISS_NUM,

Line 91: employee_id NUMBER := FND_API.G_MISS_NUM,

87: resource_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
88: owner_id NUMBER := FND_API.G_MISS_NUM,
89: publish_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
90: customer_id NUMBER := FND_API.G_MISS_NUM,
91: employee_id NUMBER := FND_API.G_MISS_NUM,
92: contact_id NUMBER := FND_API.G_MISS_NUM,
93: represented_by_id NUMBER := FND_API.G_MISS_NUM,
94: customer_product_id NUMBER := FND_API.G_MISS_NUM,
95: inventory_item_id NUMBER := FND_API.G_MISS_NUM,

Line 92: contact_id NUMBER := FND_API.G_MISS_NUM,

88: owner_id NUMBER := FND_API.G_MISS_NUM,
89: publish_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
90: customer_id NUMBER := FND_API.G_MISS_NUM,
91: employee_id NUMBER := FND_API.G_MISS_NUM,
92: contact_id NUMBER := FND_API.G_MISS_NUM,
93: represented_by_id NUMBER := FND_API.G_MISS_NUM,
94: customer_product_id NUMBER := FND_API.G_MISS_NUM,
95: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
96: inventory_org_id NUMBER := FND_API.G_MISS_NUM,

Line 93: represented_by_id NUMBER := FND_API.G_MISS_NUM,

89: publish_flag VARCHAR2(1) := FND_API.G_MISS_CHAR,
90: customer_id NUMBER := FND_API.G_MISS_NUM,
91: employee_id NUMBER := FND_API.G_MISS_NUM,
92: contact_id NUMBER := FND_API.G_MISS_NUM,
93: represented_by_id NUMBER := FND_API.G_MISS_NUM,
94: customer_product_id NUMBER := FND_API.G_MISS_NUM,
95: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
96: inventory_org_id NUMBER := FND_API.G_MISS_NUM,
97: problem_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 94: customer_product_id NUMBER := FND_API.G_MISS_NUM,

90: customer_id NUMBER := FND_API.G_MISS_NUM,
91: employee_id NUMBER := FND_API.G_MISS_NUM,
92: contact_id NUMBER := FND_API.G_MISS_NUM,
93: represented_by_id NUMBER := FND_API.G_MISS_NUM,
94: customer_product_id NUMBER := FND_API.G_MISS_NUM,
95: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
96: inventory_org_id NUMBER := FND_API.G_MISS_NUM,
97: problem_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
98: exp_resolution_date DATE := FND_API.G_MISS_DATE,

Line 95: inventory_item_id NUMBER := FND_API.G_MISS_NUM,

91: employee_id NUMBER := FND_API.G_MISS_NUM,
92: contact_id NUMBER := FND_API.G_MISS_NUM,
93: represented_by_id NUMBER := FND_API.G_MISS_NUM,
94: customer_product_id NUMBER := FND_API.G_MISS_NUM,
95: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
96: inventory_org_id NUMBER := FND_API.G_MISS_NUM,
97: problem_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
98: exp_resolution_date DATE := FND_API.G_MISS_DATE,
99: rma_header_id NUMBER := FND_API.G_MISS_NUM,

Line 96: inventory_org_id NUMBER := FND_API.G_MISS_NUM,

92: contact_id NUMBER := FND_API.G_MISS_NUM,
93: represented_by_id NUMBER := FND_API.G_MISS_NUM,
94: customer_product_id NUMBER := FND_API.G_MISS_NUM,
95: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
96: inventory_org_id NUMBER := FND_API.G_MISS_NUM,
97: problem_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
98: exp_resolution_date DATE := FND_API.G_MISS_DATE,
99: rma_header_id NUMBER := FND_API.G_MISS_NUM,
100: bill_to_site_use_id NUMBER := FND_API.G_MISS_NUM,

Line 97: problem_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

93: represented_by_id NUMBER := FND_API.G_MISS_NUM,
94: customer_product_id NUMBER := FND_API.G_MISS_NUM,
95: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
96: inventory_org_id NUMBER := FND_API.G_MISS_NUM,
97: problem_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
98: exp_resolution_date DATE := FND_API.G_MISS_DATE,
99: rma_header_id NUMBER := FND_API.G_MISS_NUM,
100: bill_to_site_use_id NUMBER := FND_API.G_MISS_NUM,
101: bill_to_contact_id NUMBER := FND_API.G_MISS_NUM,

Line 98: exp_resolution_date DATE := FND_API.G_MISS_DATE,

94: customer_product_id NUMBER := FND_API.G_MISS_NUM,
95: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
96: inventory_org_id NUMBER := FND_API.G_MISS_NUM,
97: problem_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
98: exp_resolution_date DATE := FND_API.G_MISS_DATE,
99: rma_header_id NUMBER := FND_API.G_MISS_NUM,
100: bill_to_site_use_id NUMBER := FND_API.G_MISS_NUM,
101: bill_to_contact_id NUMBER := FND_API.G_MISS_NUM,
102: ship_to_site_use_id NUMBER := FND_API.G_MISS_NUM,

Line 99: rma_header_id NUMBER := FND_API.G_MISS_NUM,

95: inventory_item_id NUMBER := FND_API.G_MISS_NUM,
96: inventory_org_id NUMBER := FND_API.G_MISS_NUM,
97: problem_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
98: exp_resolution_date DATE := FND_API.G_MISS_DATE,
99: rma_header_id NUMBER := FND_API.G_MISS_NUM,
100: bill_to_site_use_id NUMBER := FND_API.G_MISS_NUM,
101: bill_to_contact_id NUMBER := FND_API.G_MISS_NUM,
102: ship_to_site_use_id NUMBER := FND_API.G_MISS_NUM,
103: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,

Line 100: bill_to_site_use_id NUMBER := FND_API.G_MISS_NUM,

96: inventory_org_id NUMBER := FND_API.G_MISS_NUM,
97: problem_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
98: exp_resolution_date DATE := FND_API.G_MISS_DATE,
99: rma_header_id NUMBER := FND_API.G_MISS_NUM,
100: bill_to_site_use_id NUMBER := FND_API.G_MISS_NUM,
101: bill_to_contact_id NUMBER := FND_API.G_MISS_NUM,
102: ship_to_site_use_id NUMBER := FND_API.G_MISS_NUM,
103: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,
104: -- Nullified value as thic column will no longer be used and install_site

Line 101: bill_to_contact_id NUMBER := FND_API.G_MISS_NUM,

97: problem_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
98: exp_resolution_date DATE := FND_API.G_MISS_DATE,
99: rma_header_id NUMBER := FND_API.G_MISS_NUM,
100: bill_to_site_use_id NUMBER := FND_API.G_MISS_NUM,
101: bill_to_contact_id NUMBER := FND_API.G_MISS_NUM,
102: ship_to_site_use_id NUMBER := FND_API.G_MISS_NUM,
103: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,
104: -- Nullified value as thic column will no longer be used and install_site
105: -- id column will be used instead by shijain dec4th 2002

Line 102: ship_to_site_use_id NUMBER := FND_API.G_MISS_NUM,

98: exp_resolution_date DATE := FND_API.G_MISS_DATE,
99: rma_header_id NUMBER := FND_API.G_MISS_NUM,
100: bill_to_site_use_id NUMBER := FND_API.G_MISS_NUM,
101: bill_to_contact_id NUMBER := FND_API.G_MISS_NUM,
102: ship_to_site_use_id NUMBER := FND_API.G_MISS_NUM,
103: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,
104: -- Nullified value as thic column will no longer be used and install_site
105: -- id column will be used instead by shijain dec4th 2002
106: install_site_use_id NUMBER := FND_API.G_MISS_NUM,

Line 103: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,

99: rma_header_id NUMBER := FND_API.G_MISS_NUM,
100: bill_to_site_use_id NUMBER := FND_API.G_MISS_NUM,
101: bill_to_contact_id NUMBER := FND_API.G_MISS_NUM,
102: ship_to_site_use_id NUMBER := FND_API.G_MISS_NUM,
103: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,
104: -- Nullified value as thic column will no longer be used and install_site
105: -- id column will be used instead by shijain dec4th 2002
106: install_site_use_id NUMBER := FND_API.G_MISS_NUM,
107: resolution_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 106: install_site_use_id NUMBER := FND_API.G_MISS_NUM,

102: ship_to_site_use_id NUMBER := FND_API.G_MISS_NUM,
103: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,
104: -- Nullified value as thic column will no longer be used and install_site
105: -- id column will be used instead by shijain dec4th 2002
106: install_site_use_id NUMBER := FND_API.G_MISS_NUM,
107: resolution_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
108: act_resolution_date DATE := FND_API.G_MISS_DATE,
109: current_contact_time_diff NUMBER := FND_API.G_MISS_NUM,
110: rep_by_time_difference NUMBER := FND_API.G_MISS_NUM,

Line 107: resolution_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

103: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,
104: -- Nullified value as thic column will no longer be used and install_site
105: -- id column will be used instead by shijain dec4th 2002
106: install_site_use_id NUMBER := FND_API.G_MISS_NUM,
107: resolution_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
108: act_resolution_date DATE := FND_API.G_MISS_DATE,
109: current_contact_time_diff NUMBER := FND_API.G_MISS_NUM,
110: rep_by_time_difference NUMBER := FND_API.G_MISS_NUM,
111: validate_type VARCHAR2(1) := FND_API.G_FALSE,

Line 108: act_resolution_date DATE := FND_API.G_MISS_DATE,

104: -- Nullified value as thic column will no longer be used and install_site
105: -- id column will be used instead by shijain dec4th 2002
106: install_site_use_id NUMBER := FND_API.G_MISS_NUM,
107: resolution_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
108: act_resolution_date DATE := FND_API.G_MISS_DATE,
109: current_contact_time_diff NUMBER := FND_API.G_MISS_NUM,
110: rep_by_time_difference NUMBER := FND_API.G_MISS_NUM,
111: validate_type VARCHAR2(1) := FND_API.G_FALSE,
112: validate_status VARCHAR2(1) := FND_API.G_FALSE,

Line 109: current_contact_time_diff NUMBER := FND_API.G_MISS_NUM,

105: -- id column will be used instead by shijain dec4th 2002
106: install_site_use_id NUMBER := FND_API.G_MISS_NUM,
107: resolution_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
108: act_resolution_date DATE := FND_API.G_MISS_DATE,
109: current_contact_time_diff NUMBER := FND_API.G_MISS_NUM,
110: rep_by_time_difference NUMBER := FND_API.G_MISS_NUM,
111: validate_type VARCHAR2(1) := FND_API.G_FALSE,
112: validate_status VARCHAR2(1) := FND_API.G_FALSE,
113: validate_customer VARCHAR2(1) := FND_API.G_FALSE,

Line 110: rep_by_time_difference NUMBER := FND_API.G_MISS_NUM,

106: install_site_use_id NUMBER := FND_API.G_MISS_NUM,
107: resolution_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
108: act_resolution_date DATE := FND_API.G_MISS_DATE,
109: current_contact_time_diff NUMBER := FND_API.G_MISS_NUM,
110: rep_by_time_difference NUMBER := FND_API.G_MISS_NUM,
111: validate_type VARCHAR2(1) := FND_API.G_FALSE,
112: validate_status VARCHAR2(1) := FND_API.G_FALSE,
113: validate_customer VARCHAR2(1) := FND_API.G_FALSE,
114: validate_employee VARCHAR2(1) := FND_API.G_FALSE,

Line 111: validate_type VARCHAR2(1) := FND_API.G_FALSE,

107: resolution_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
108: act_resolution_date DATE := FND_API.G_MISS_DATE,
109: current_contact_time_diff NUMBER := FND_API.G_MISS_NUM,
110: rep_by_time_difference NUMBER := FND_API.G_MISS_NUM,
111: validate_type VARCHAR2(1) := FND_API.G_FALSE,
112: validate_status VARCHAR2(1) := FND_API.G_FALSE,
113: validate_customer VARCHAR2(1) := FND_API.G_FALSE,
114: validate_employee VARCHAR2(1) := FND_API.G_FALSE,
115: validate_bill_to_site VARCHAR2(1) := FND_API.G_FALSE,

Line 112: validate_status VARCHAR2(1) := FND_API.G_FALSE,

108: act_resolution_date DATE := FND_API.G_MISS_DATE,
109: current_contact_time_diff NUMBER := FND_API.G_MISS_NUM,
110: rep_by_time_difference NUMBER := FND_API.G_MISS_NUM,
111: validate_type VARCHAR2(1) := FND_API.G_FALSE,
112: validate_status VARCHAR2(1) := FND_API.G_FALSE,
113: validate_customer VARCHAR2(1) := FND_API.G_FALSE,
114: validate_employee VARCHAR2(1) := FND_API.G_FALSE,
115: validate_bill_to_site VARCHAR2(1) := FND_API.G_FALSE,
116: validate_ship_to_site VARCHAR2(1) := FND_API.G_FALSE,

Line 113: validate_customer VARCHAR2(1) := FND_API.G_FALSE,

109: current_contact_time_diff NUMBER := FND_API.G_MISS_NUM,
110: rep_by_time_difference NUMBER := FND_API.G_MISS_NUM,
111: validate_type VARCHAR2(1) := FND_API.G_FALSE,
112: validate_status VARCHAR2(1) := FND_API.G_FALSE,
113: validate_customer VARCHAR2(1) := FND_API.G_FALSE,
114: validate_employee VARCHAR2(1) := FND_API.G_FALSE,
115: validate_bill_to_site VARCHAR2(1) := FND_API.G_FALSE,
116: validate_ship_to_site VARCHAR2(1) := FND_API.G_FALSE,
117: validate_install_site VARCHAR2(1) := FND_API.G_FALSE,

Line 114: validate_employee VARCHAR2(1) := FND_API.G_FALSE,

110: rep_by_time_difference NUMBER := FND_API.G_MISS_NUM,
111: validate_type VARCHAR2(1) := FND_API.G_FALSE,
112: validate_status VARCHAR2(1) := FND_API.G_FALSE,
113: validate_customer VARCHAR2(1) := FND_API.G_FALSE,
114: validate_employee VARCHAR2(1) := FND_API.G_FALSE,
115: validate_bill_to_site VARCHAR2(1) := FND_API.G_FALSE,
116: validate_ship_to_site VARCHAR2(1) := FND_API.G_FALSE,
117: validate_install_site VARCHAR2(1) := FND_API.G_FALSE,
118: contract_service_id NUMBER := FND_API.G_MISS_NUM,

Line 115: validate_bill_to_site VARCHAR2(1) := FND_API.G_FALSE,

111: validate_type VARCHAR2(1) := FND_API.G_FALSE,
112: validate_status VARCHAR2(1) := FND_API.G_FALSE,
113: validate_customer VARCHAR2(1) := FND_API.G_FALSE,
114: validate_employee VARCHAR2(1) := FND_API.G_FALSE,
115: validate_bill_to_site VARCHAR2(1) := FND_API.G_FALSE,
116: validate_ship_to_site VARCHAR2(1) := FND_API.G_FALSE,
117: validate_install_site VARCHAR2(1) := FND_API.G_FALSE,
118: contract_service_id NUMBER := FND_API.G_MISS_NUM,
119: --04/16/01

Line 116: validate_ship_to_site VARCHAR2(1) := FND_API.G_FALSE,

112: validate_status VARCHAR2(1) := FND_API.G_FALSE,
113: validate_customer VARCHAR2(1) := FND_API.G_FALSE,
114: validate_employee VARCHAR2(1) := FND_API.G_FALSE,
115: validate_bill_to_site VARCHAR2(1) := FND_API.G_FALSE,
116: validate_ship_to_site VARCHAR2(1) := FND_API.G_FALSE,
117: validate_install_site VARCHAR2(1) := FND_API.G_FALSE,
118: contract_service_id NUMBER := FND_API.G_MISS_NUM,
119: --04/16/01
120: contract_id NUMBER := FND_API.G_MISS_NUM,

Line 117: validate_install_site VARCHAR2(1) := FND_API.G_FALSE,

113: validate_customer VARCHAR2(1) := FND_API.G_FALSE,
114: validate_employee VARCHAR2(1) := FND_API.G_FALSE,
115: validate_bill_to_site VARCHAR2(1) := FND_API.G_FALSE,
116: validate_ship_to_site VARCHAR2(1) := FND_API.G_FALSE,
117: validate_install_site VARCHAR2(1) := FND_API.G_FALSE,
118: contract_service_id NUMBER := FND_API.G_MISS_NUM,
119: --04/16/01
120: contract_id NUMBER := FND_API.G_MISS_NUM,
121: project_number VARCHAR2(120):= FND_API.G_MISS_CHAR,

Line 118: contract_service_id NUMBER := FND_API.G_MISS_NUM,

114: validate_employee VARCHAR2(1) := FND_API.G_FALSE,
115: validate_bill_to_site VARCHAR2(1) := FND_API.G_FALSE,
116: validate_ship_to_site VARCHAR2(1) := FND_API.G_FALSE,
117: validate_install_site VARCHAR2(1) := FND_API.G_FALSE,
118: contract_service_id NUMBER := FND_API.G_MISS_NUM,
119: --04/16/01
120: contract_id NUMBER := FND_API.G_MISS_NUM,
121: project_number VARCHAR2(120):= FND_API.G_MISS_CHAR,
122: --04/16/01

Line 120: contract_id NUMBER := FND_API.G_MISS_NUM,

116: validate_ship_to_site VARCHAR2(1) := FND_API.G_FALSE,
117: validate_install_site VARCHAR2(1) := FND_API.G_FALSE,
118: contract_service_id NUMBER := FND_API.G_MISS_NUM,
119: --04/16/01
120: contract_id NUMBER := FND_API.G_MISS_NUM,
121: project_number VARCHAR2(120):= FND_API.G_MISS_CHAR,
122: --04/16/01
123: account_id NUMBER := FND_API.G_MISS_NUM,
124: site_id NUMBER := FND_API.G_MISS_NUM,

Line 121: project_number VARCHAR2(120):= FND_API.G_MISS_CHAR,

117: validate_install_site VARCHAR2(1) := FND_API.G_FALSE,
118: contract_service_id NUMBER := FND_API.G_MISS_NUM,
119: --04/16/01
120: contract_id NUMBER := FND_API.G_MISS_NUM,
121: project_number VARCHAR2(120):= FND_API.G_MISS_CHAR,
122: --04/16/01
123: account_id NUMBER := FND_API.G_MISS_NUM,
124: site_id NUMBER := FND_API.G_MISS_NUM,
125: territory_id NUMBER := FND_API.G_MISS_NUM,

Line 123: account_id NUMBER := FND_API.G_MISS_NUM,

119: --04/16/01
120: contract_id NUMBER := FND_API.G_MISS_NUM,
121: project_number VARCHAR2(120):= FND_API.G_MISS_CHAR,
122: --04/16/01
123: account_id NUMBER := FND_API.G_MISS_NUM,
124: site_id NUMBER := FND_API.G_MISS_NUM,
125: territory_id NUMBER := FND_API.G_MISS_NUM,
126: platform_id NUMBER := FND_API.G_MISS_NUM,
127: platform_version VARCHAR2(250) := FND_API.G_MISS_CHAR,

Line 124: site_id NUMBER := FND_API.G_MISS_NUM,

120: contract_id NUMBER := FND_API.G_MISS_NUM,
121: project_number VARCHAR2(120):= FND_API.G_MISS_CHAR,
122: --04/16/01
123: account_id NUMBER := FND_API.G_MISS_NUM,
124: site_id NUMBER := FND_API.G_MISS_NUM,
125: territory_id NUMBER := FND_API.G_MISS_NUM,
126: platform_id NUMBER := FND_API.G_MISS_NUM,
127: platform_version VARCHAR2(250) := FND_API.G_MISS_CHAR,
128: db_version VARCHAR2(250) := FND_API.G_MISS_CHAR,

Line 125: territory_id NUMBER := FND_API.G_MISS_NUM,

121: project_number VARCHAR2(120):= FND_API.G_MISS_CHAR,
122: --04/16/01
123: account_id NUMBER := FND_API.G_MISS_NUM,
124: site_id NUMBER := FND_API.G_MISS_NUM,
125: territory_id NUMBER := FND_API.G_MISS_NUM,
126: platform_id NUMBER := FND_API.G_MISS_NUM,
127: platform_version VARCHAR2(250) := FND_API.G_MISS_CHAR,
128: db_version VARCHAR2(250) := FND_API.G_MISS_CHAR,
129: platform_version_id NUMBER := FND_API.G_MISS_NUM,

Line 126: platform_id NUMBER := FND_API.G_MISS_NUM,

122: --04/16/01
123: account_id NUMBER := FND_API.G_MISS_NUM,
124: site_id NUMBER := FND_API.G_MISS_NUM,
125: territory_id NUMBER := FND_API.G_MISS_NUM,
126: platform_id NUMBER := FND_API.G_MISS_NUM,
127: platform_version VARCHAR2(250) := FND_API.G_MISS_CHAR,
128: db_version VARCHAR2(250) := FND_API.G_MISS_CHAR,
129: platform_version_id NUMBER := FND_API.G_MISS_NUM,
130: cp_component_id NUMBER := FND_API.G_MISS_NUM,

Line 127: platform_version VARCHAR2(250) := FND_API.G_MISS_CHAR,

123: account_id NUMBER := FND_API.G_MISS_NUM,
124: site_id NUMBER := FND_API.G_MISS_NUM,
125: territory_id NUMBER := FND_API.G_MISS_NUM,
126: platform_id NUMBER := FND_API.G_MISS_NUM,
127: platform_version VARCHAR2(250) := FND_API.G_MISS_CHAR,
128: db_version VARCHAR2(250) := FND_API.G_MISS_CHAR,
129: platform_version_id NUMBER := FND_API.G_MISS_NUM,
130: cp_component_id NUMBER := FND_API.G_MISS_NUM,
131: cp_component_version_id NUMBER := FND_API.G_MISS_NUM,

Line 128: db_version VARCHAR2(250) := FND_API.G_MISS_CHAR,

124: site_id NUMBER := FND_API.G_MISS_NUM,
125: territory_id NUMBER := FND_API.G_MISS_NUM,
126: platform_id NUMBER := FND_API.G_MISS_NUM,
127: platform_version VARCHAR2(250) := FND_API.G_MISS_CHAR,
128: db_version VARCHAR2(250) := FND_API.G_MISS_CHAR,
129: platform_version_id NUMBER := FND_API.G_MISS_NUM,
130: cp_component_id NUMBER := FND_API.G_MISS_NUM,
131: cp_component_version_id NUMBER := FND_API.G_MISS_NUM,
132: cp_subcomponent_id NUMBER := FND_API.G_MISS_NUM,

Line 129: platform_version_id NUMBER := FND_API.G_MISS_NUM,

125: territory_id NUMBER := FND_API.G_MISS_NUM,
126: platform_id NUMBER := FND_API.G_MISS_NUM,
127: platform_version VARCHAR2(250) := FND_API.G_MISS_CHAR,
128: db_version VARCHAR2(250) := FND_API.G_MISS_CHAR,
129: platform_version_id NUMBER := FND_API.G_MISS_NUM,
130: cp_component_id NUMBER := FND_API.G_MISS_NUM,
131: cp_component_version_id NUMBER := FND_API.G_MISS_NUM,
132: cp_subcomponent_id NUMBER := FND_API.G_MISS_NUM,
133: cp_subcomponent_version_id NUMBER := FND_API.G_MISS_NUM,

Line 130: cp_component_id NUMBER := FND_API.G_MISS_NUM,

126: platform_id NUMBER := FND_API.G_MISS_NUM,
127: platform_version VARCHAR2(250) := FND_API.G_MISS_CHAR,
128: db_version VARCHAR2(250) := FND_API.G_MISS_CHAR,
129: platform_version_id NUMBER := FND_API.G_MISS_NUM,
130: cp_component_id NUMBER := FND_API.G_MISS_NUM,
131: cp_component_version_id NUMBER := FND_API.G_MISS_NUM,
132: cp_subcomponent_id NUMBER := FND_API.G_MISS_NUM,
133: cp_subcomponent_version_id NUMBER := FND_API.G_MISS_NUM,
134: cp_revision_id NUMBER := FND_API.G_MISS_NUM,

Line 131: cp_component_version_id NUMBER := FND_API.G_MISS_NUM,

127: platform_version VARCHAR2(250) := FND_API.G_MISS_CHAR,
128: db_version VARCHAR2(250) := FND_API.G_MISS_CHAR,
129: platform_version_id NUMBER := FND_API.G_MISS_NUM,
130: cp_component_id NUMBER := FND_API.G_MISS_NUM,
131: cp_component_version_id NUMBER := FND_API.G_MISS_NUM,
132: cp_subcomponent_id NUMBER := FND_API.G_MISS_NUM,
133: cp_subcomponent_version_id NUMBER := FND_API.G_MISS_NUM,
134: cp_revision_id NUMBER := FND_API.G_MISS_NUM,
135: language_id NUMBER := FND_API.G_MISS_NUM,

Line 132: cp_subcomponent_id NUMBER := FND_API.G_MISS_NUM,

128: db_version VARCHAR2(250) := FND_API.G_MISS_CHAR,
129: platform_version_id NUMBER := FND_API.G_MISS_NUM,
130: cp_component_id NUMBER := FND_API.G_MISS_NUM,
131: cp_component_version_id NUMBER := FND_API.G_MISS_NUM,
132: cp_subcomponent_id NUMBER := FND_API.G_MISS_NUM,
133: cp_subcomponent_version_id NUMBER := FND_API.G_MISS_NUM,
134: cp_revision_id NUMBER := FND_API.G_MISS_NUM,
135: language_id NUMBER := FND_API.G_MISS_NUM,
136: inv_item_revision VARCHAR2(240):= FND_API.G_MISS_CHAR,

Line 133: cp_subcomponent_version_id NUMBER := FND_API.G_MISS_NUM,

129: platform_version_id NUMBER := FND_API.G_MISS_NUM,
130: cp_component_id NUMBER := FND_API.G_MISS_NUM,
131: cp_component_version_id NUMBER := FND_API.G_MISS_NUM,
132: cp_subcomponent_id NUMBER := FND_API.G_MISS_NUM,
133: cp_subcomponent_version_id NUMBER := FND_API.G_MISS_NUM,
134: cp_revision_id NUMBER := FND_API.G_MISS_NUM,
135: language_id NUMBER := FND_API.G_MISS_NUM,
136: inv_item_revision VARCHAR2(240):= FND_API.G_MISS_CHAR,
137: inv_component_id NUMBER:= FND_API.G_MISS_NUM,

Line 134: cp_revision_id NUMBER := FND_API.G_MISS_NUM,

130: cp_component_id NUMBER := FND_API.G_MISS_NUM,
131: cp_component_version_id NUMBER := FND_API.G_MISS_NUM,
132: cp_subcomponent_id NUMBER := FND_API.G_MISS_NUM,
133: cp_subcomponent_version_id NUMBER := FND_API.G_MISS_NUM,
134: cp_revision_id NUMBER := FND_API.G_MISS_NUM,
135: language_id NUMBER := FND_API.G_MISS_NUM,
136: inv_item_revision VARCHAR2(240):= FND_API.G_MISS_CHAR,
137: inv_component_id NUMBER:= FND_API.G_MISS_NUM,
138: inv_component_version VARCHAR2(90):= FND_API.G_MISS_CHAR,

Line 135: language_id NUMBER := FND_API.G_MISS_NUM,

131: cp_component_version_id NUMBER := FND_API.G_MISS_NUM,
132: cp_subcomponent_id NUMBER := FND_API.G_MISS_NUM,
133: cp_subcomponent_version_id NUMBER := FND_API.G_MISS_NUM,
134: cp_revision_id NUMBER := FND_API.G_MISS_NUM,
135: language_id NUMBER := FND_API.G_MISS_NUM,
136: inv_item_revision VARCHAR2(240):= FND_API.G_MISS_CHAR,
137: inv_component_id NUMBER:= FND_API.G_MISS_NUM,
138: inv_component_version VARCHAR2(90):= FND_API.G_MISS_CHAR,
139: inv_subcomponent_id NUMBER:= FND_API.G_MISS_NUM,

Line 136: inv_item_revision VARCHAR2(240):= FND_API.G_MISS_CHAR,

132: cp_subcomponent_id NUMBER := FND_API.G_MISS_NUM,
133: cp_subcomponent_version_id NUMBER := FND_API.G_MISS_NUM,
134: cp_revision_id NUMBER := FND_API.G_MISS_NUM,
135: language_id NUMBER := FND_API.G_MISS_NUM,
136: inv_item_revision VARCHAR2(240):= FND_API.G_MISS_CHAR,
137: inv_component_id NUMBER:= FND_API.G_MISS_NUM,
138: inv_component_version VARCHAR2(90):= FND_API.G_MISS_CHAR,
139: inv_subcomponent_id NUMBER:= FND_API.G_MISS_NUM,
140: inv_subcomponent_version VARCHAR2(90):= FND_API.G_MISS_CHAR,

Line 137: inv_component_id NUMBER:= FND_API.G_MISS_NUM,

133: cp_subcomponent_version_id NUMBER := FND_API.G_MISS_NUM,
134: cp_revision_id NUMBER := FND_API.G_MISS_NUM,
135: language_id NUMBER := FND_API.G_MISS_NUM,
136: inv_item_revision VARCHAR2(240):= FND_API.G_MISS_CHAR,
137: inv_component_id NUMBER:= FND_API.G_MISS_NUM,
138: inv_component_version VARCHAR2(90):= FND_API.G_MISS_CHAR,
139: inv_subcomponent_id NUMBER:= FND_API.G_MISS_NUM,
140: inv_subcomponent_version VARCHAR2(90):= FND_API.G_MISS_CHAR,
141: caller_type VARCHAR2(30):= FND_API.G_MISS_CHAR,

Line 138: inv_component_version VARCHAR2(90):= FND_API.G_MISS_CHAR,

134: cp_revision_id NUMBER := FND_API.G_MISS_NUM,
135: language_id NUMBER := FND_API.G_MISS_NUM,
136: inv_item_revision VARCHAR2(240):= FND_API.G_MISS_CHAR,
137: inv_component_id NUMBER:= FND_API.G_MISS_NUM,
138: inv_component_version VARCHAR2(90):= FND_API.G_MISS_CHAR,
139: inv_subcomponent_id NUMBER:= FND_API.G_MISS_NUM,
140: inv_subcomponent_version VARCHAR2(90):= FND_API.G_MISS_CHAR,
141: caller_type VARCHAR2(30):= FND_API.G_MISS_CHAR,
142: primary_contact_id NUMBER:= FND_API.G_MISS_NUM,

Line 139: inv_subcomponent_id NUMBER:= FND_API.G_MISS_NUM,

135: language_id NUMBER := FND_API.G_MISS_NUM,
136: inv_item_revision VARCHAR2(240):= FND_API.G_MISS_CHAR,
137: inv_component_id NUMBER:= FND_API.G_MISS_NUM,
138: inv_component_version VARCHAR2(90):= FND_API.G_MISS_CHAR,
139: inv_subcomponent_id NUMBER:= FND_API.G_MISS_NUM,
140: inv_subcomponent_version VARCHAR2(90):= FND_API.G_MISS_CHAR,
141: caller_type VARCHAR2(30):= FND_API.G_MISS_CHAR,
142: primary_contact_id NUMBER:= FND_API.G_MISS_NUM,
143: validate_updated_status VARCHAR2(1) := FND_API.G_FALSE,

Line 140: inv_subcomponent_version VARCHAR2(90):= FND_API.G_MISS_CHAR,

136: inv_item_revision VARCHAR2(240):= FND_API.G_MISS_CHAR,
137: inv_component_id NUMBER:= FND_API.G_MISS_NUM,
138: inv_component_version VARCHAR2(90):= FND_API.G_MISS_CHAR,
139: inv_subcomponent_id NUMBER:= FND_API.G_MISS_NUM,
140: inv_subcomponent_version VARCHAR2(90):= FND_API.G_MISS_CHAR,
141: caller_type VARCHAR2(30):= FND_API.G_MISS_CHAR,
142: primary_contact_id NUMBER:= FND_API.G_MISS_NUM,
143: validate_updated_status VARCHAR2(1) := FND_API.G_FALSE,
144: updated_status_id NUMBER := FND_API.G_MISS_NUM,

Line 141: caller_type VARCHAR2(30):= FND_API.G_MISS_CHAR,

137: inv_component_id NUMBER:= FND_API.G_MISS_NUM,
138: inv_component_version VARCHAR2(90):= FND_API.G_MISS_CHAR,
139: inv_subcomponent_id NUMBER:= FND_API.G_MISS_NUM,
140: inv_subcomponent_version VARCHAR2(90):= FND_API.G_MISS_CHAR,
141: caller_type VARCHAR2(30):= FND_API.G_MISS_CHAR,
142: primary_contact_id NUMBER:= FND_API.G_MISS_NUM,
143: validate_updated_status VARCHAR2(1) := FND_API.G_FALSE,
144: updated_status_id NUMBER := FND_API.G_MISS_NUM,
145: status_id_change VARCHAR2(1) := FND_API.G_FALSE,

Line 142: primary_contact_id NUMBER:= FND_API.G_MISS_NUM,

138: inv_component_version VARCHAR2(90):= FND_API.G_MISS_CHAR,
139: inv_subcomponent_id NUMBER:= FND_API.G_MISS_NUM,
140: inv_subcomponent_version VARCHAR2(90):= FND_API.G_MISS_CHAR,
141: caller_type VARCHAR2(30):= FND_API.G_MISS_CHAR,
142: primary_contact_id NUMBER:= FND_API.G_MISS_NUM,
143: validate_updated_status VARCHAR2(1) := FND_API.G_FALSE,
144: updated_status_id NUMBER := FND_API.G_MISS_NUM,
145: status_id_change VARCHAR2(1) := FND_API.G_FALSE,
146: current_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 143: validate_updated_status VARCHAR2(1) := FND_API.G_FALSE,

139: inv_subcomponent_id NUMBER:= FND_API.G_MISS_NUM,
140: inv_subcomponent_version VARCHAR2(90):= FND_API.G_MISS_CHAR,
141: caller_type VARCHAR2(30):= FND_API.G_MISS_CHAR,
142: primary_contact_id NUMBER:= FND_API.G_MISS_NUM,
143: validate_updated_status VARCHAR2(1) := FND_API.G_FALSE,
144: updated_status_id NUMBER := FND_API.G_MISS_NUM,
145: status_id_change VARCHAR2(1) := FND_API.G_FALSE,
146: current_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
147: -----jngeorge-----enhancements-----11.5.6 ------07/20/01

Line 144: updated_status_id NUMBER := FND_API.G_MISS_NUM,

140: inv_subcomponent_version VARCHAR2(90):= FND_API.G_MISS_CHAR,
141: caller_type VARCHAR2(30):= FND_API.G_MISS_CHAR,
142: primary_contact_id NUMBER:= FND_API.G_MISS_NUM,
143: validate_updated_status VARCHAR2(1) := FND_API.G_FALSE,
144: updated_status_id NUMBER := FND_API.G_MISS_NUM,
145: status_id_change VARCHAR2(1) := FND_API.G_FALSE,
146: current_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
147: -----jngeorge-----enhancements-----11.5.6 ------07/20/01
148: tier VARCHAR2(250) :=FND_API.G_MISS_CHAR,

Line 145: status_id_change VARCHAR2(1) := FND_API.G_FALSE,

141: caller_type VARCHAR2(30):= FND_API.G_MISS_CHAR,
142: primary_contact_id NUMBER:= FND_API.G_MISS_NUM,
143: validate_updated_status VARCHAR2(1) := FND_API.G_FALSE,
144: updated_status_id NUMBER := FND_API.G_MISS_NUM,
145: status_id_change VARCHAR2(1) := FND_API.G_FALSE,
146: current_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
147: -----jngeorge-----enhancements-----11.5.6 ------07/20/01
148: tier VARCHAR2(250) :=FND_API.G_MISS_CHAR,
149: tier_version VARCHAR2(250) := FND_API.G_MISS_CHAR,

Line 146: current_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,

142: primary_contact_id NUMBER:= FND_API.G_MISS_NUM,
143: validate_updated_status VARCHAR2(1) := FND_API.G_FALSE,
144: updated_status_id NUMBER := FND_API.G_MISS_NUM,
145: status_id_change VARCHAR2(1) := FND_API.G_FALSE,
146: current_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
147: -----jngeorge-----enhancements-----11.5.6 ------07/20/01
148: tier VARCHAR2(250) :=FND_API.G_MISS_CHAR,
149: tier_version VARCHAR2(250) := FND_API.G_MISS_CHAR,
150: operating_system VARCHAR2(250) := FND_API.G_MISS_CHAR,

Line 148: tier VARCHAR2(250) :=FND_API.G_MISS_CHAR,

144: updated_status_id NUMBER := FND_API.G_MISS_NUM,
145: status_id_change VARCHAR2(1) := FND_API.G_FALSE,
146: current_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
147: -----jngeorge-----enhancements-----11.5.6 ------07/20/01
148: tier VARCHAR2(250) :=FND_API.G_MISS_CHAR,
149: tier_version VARCHAR2(250) := FND_API.G_MISS_CHAR,
150: operating_system VARCHAR2(250) := FND_API.G_MISS_CHAR,
151: operating_system_version VARCHAR2(250) := FND_API.G_MISS_CHAR,
152: database VARCHAR2(250) :=FND_API.G_MISS_CHAR,

Line 149: tier_version VARCHAR2(250) := FND_API.G_MISS_CHAR,

145: status_id_change VARCHAR2(1) := FND_API.G_FALSE,
146: current_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
147: -----jngeorge-----enhancements-----11.5.6 ------07/20/01
148: tier VARCHAR2(250) :=FND_API.G_MISS_CHAR,
149: tier_version VARCHAR2(250) := FND_API.G_MISS_CHAR,
150: operating_system VARCHAR2(250) := FND_API.G_MISS_CHAR,
151: operating_system_version VARCHAR2(250) := FND_API.G_MISS_CHAR,
152: database VARCHAR2(250) :=FND_API.G_MISS_CHAR,
153: cust_pref_lang_id NUMBER := FND_API.G_MISS_NUM,

Line 150: operating_system VARCHAR2(250) := FND_API.G_MISS_CHAR,

146: current_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
147: -----jngeorge-----enhancements-----11.5.6 ------07/20/01
148: tier VARCHAR2(250) :=FND_API.G_MISS_CHAR,
149: tier_version VARCHAR2(250) := FND_API.G_MISS_CHAR,
150: operating_system VARCHAR2(250) := FND_API.G_MISS_CHAR,
151: operating_system_version VARCHAR2(250) := FND_API.G_MISS_CHAR,
152: database VARCHAR2(250) :=FND_API.G_MISS_CHAR,
153: cust_pref_lang_id NUMBER := FND_API.G_MISS_NUM,
154: category_id NUMBER := FND_API.G_MISS_NUM,

Line 151: operating_system_version VARCHAR2(250) := FND_API.G_MISS_CHAR,

147: -----jngeorge-----enhancements-----11.5.6 ------07/20/01
148: tier VARCHAR2(250) :=FND_API.G_MISS_CHAR,
149: tier_version VARCHAR2(250) := FND_API.G_MISS_CHAR,
150: operating_system VARCHAR2(250) := FND_API.G_MISS_CHAR,
151: operating_system_version VARCHAR2(250) := FND_API.G_MISS_CHAR,
152: database VARCHAR2(250) :=FND_API.G_MISS_CHAR,
153: cust_pref_lang_id NUMBER := FND_API.G_MISS_NUM,
154: category_id NUMBER := FND_API.G_MISS_NUM,
155: owner_group_id NUMBER := FND_API.G_MISS_NUM,

Line 152: database VARCHAR2(250) :=FND_API.G_MISS_CHAR,

148: tier VARCHAR2(250) :=FND_API.G_MISS_CHAR,
149: tier_version VARCHAR2(250) := FND_API.G_MISS_CHAR,
150: operating_system VARCHAR2(250) := FND_API.G_MISS_CHAR,
151: operating_system_version VARCHAR2(250) := FND_API.G_MISS_CHAR,
152: database VARCHAR2(250) :=FND_API.G_MISS_CHAR,
153: cust_pref_lang_id NUMBER := FND_API.G_MISS_NUM,
154: category_id NUMBER := FND_API.G_MISS_NUM,
155: owner_group_id NUMBER := FND_API.G_MISS_NUM,
156: group_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 153: cust_pref_lang_id NUMBER := FND_API.G_MISS_NUM,

149: tier_version VARCHAR2(250) := FND_API.G_MISS_CHAR,
150: operating_system VARCHAR2(250) := FND_API.G_MISS_CHAR,
151: operating_system_version VARCHAR2(250) := FND_API.G_MISS_CHAR,
152: database VARCHAR2(250) :=FND_API.G_MISS_CHAR,
153: cust_pref_lang_id NUMBER := FND_API.G_MISS_NUM,
154: category_id NUMBER := FND_API.G_MISS_NUM,
155: owner_group_id NUMBER := FND_API.G_MISS_NUM,
156: group_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
157: group_territory_id NUMBER := FND_API.G_MISS_NUM,

Line 154: category_id NUMBER := FND_API.G_MISS_NUM,

150: operating_system VARCHAR2(250) := FND_API.G_MISS_CHAR,
151: operating_system_version VARCHAR2(250) := FND_API.G_MISS_CHAR,
152: database VARCHAR2(250) :=FND_API.G_MISS_CHAR,
153: cust_pref_lang_id NUMBER := FND_API.G_MISS_NUM,
154: category_id NUMBER := FND_API.G_MISS_NUM,
155: owner_group_id NUMBER := FND_API.G_MISS_NUM,
156: group_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
157: group_territory_id NUMBER := FND_API.G_MISS_NUM,
158: inv_platform_org_id NUMBER := FND_API.G_MISS_NUM,

Line 155: owner_group_id NUMBER := FND_API.G_MISS_NUM,

151: operating_system_version VARCHAR2(250) := FND_API.G_MISS_CHAR,
152: database VARCHAR2(250) :=FND_API.G_MISS_CHAR,
153: cust_pref_lang_id NUMBER := FND_API.G_MISS_NUM,
154: category_id NUMBER := FND_API.G_MISS_NUM,
155: owner_group_id NUMBER := FND_API.G_MISS_NUM,
156: group_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
157: group_territory_id NUMBER := FND_API.G_MISS_NUM,
158: inv_platform_org_id NUMBER := FND_API.G_MISS_NUM,
159: product_revision VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 156: group_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

152: database VARCHAR2(250) :=FND_API.G_MISS_CHAR,
153: cust_pref_lang_id NUMBER := FND_API.G_MISS_NUM,
154: category_id NUMBER := FND_API.G_MISS_NUM,
155: owner_group_id NUMBER := FND_API.G_MISS_NUM,
156: group_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
157: group_territory_id NUMBER := FND_API.G_MISS_NUM,
158: inv_platform_org_id NUMBER := FND_API.G_MISS_NUM,
159: product_revision VARCHAR2(240) := FND_API.G_MISS_CHAR,
160: component_version VARCHAR2(3) := FND_API.G_MISS_CHAR,

Line 157: group_territory_id NUMBER := FND_API.G_MISS_NUM,

153: cust_pref_lang_id NUMBER := FND_API.G_MISS_NUM,
154: category_id NUMBER := FND_API.G_MISS_NUM,
155: owner_group_id NUMBER := FND_API.G_MISS_NUM,
156: group_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
157: group_territory_id NUMBER := FND_API.G_MISS_NUM,
158: inv_platform_org_id NUMBER := FND_API.G_MISS_NUM,
159: product_revision VARCHAR2(240) := FND_API.G_MISS_CHAR,
160: component_version VARCHAR2(3) := FND_API.G_MISS_CHAR,
161: subcomponent_version VARCHAR2(3) := FND_API.G_MISS_CHAR,

Line 158: inv_platform_org_id NUMBER := FND_API.G_MISS_NUM,

154: category_id NUMBER := FND_API.G_MISS_NUM,
155: owner_group_id NUMBER := FND_API.G_MISS_NUM,
156: group_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
157: group_territory_id NUMBER := FND_API.G_MISS_NUM,
158: inv_platform_org_id NUMBER := FND_API.G_MISS_NUM,
159: product_revision VARCHAR2(240) := FND_API.G_MISS_CHAR,
160: component_version VARCHAR2(3) := FND_API.G_MISS_CHAR,
161: subcomponent_version VARCHAR2(3) := FND_API.G_MISS_CHAR,
162: comm_pref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 159: product_revision VARCHAR2(240) := FND_API.G_MISS_CHAR,

155: owner_group_id NUMBER := FND_API.G_MISS_NUM,
156: group_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
157: group_territory_id NUMBER := FND_API.G_MISS_NUM,
158: inv_platform_org_id NUMBER := FND_API.G_MISS_NUM,
159: product_revision VARCHAR2(240) := FND_API.G_MISS_CHAR,
160: component_version VARCHAR2(3) := FND_API.G_MISS_CHAR,
161: subcomponent_version VARCHAR2(3) := FND_API.G_MISS_CHAR,
162: comm_pref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
163: cust_pref_lang_code VARCHAR2(4) := FND_API.G_MISS_CHAR,

Line 160: component_version VARCHAR2(3) := FND_API.G_MISS_CHAR,

156: group_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
157: group_territory_id NUMBER := FND_API.G_MISS_NUM,
158: inv_platform_org_id NUMBER := FND_API.G_MISS_NUM,
159: product_revision VARCHAR2(240) := FND_API.G_MISS_CHAR,
160: component_version VARCHAR2(3) := FND_API.G_MISS_CHAR,
161: subcomponent_version VARCHAR2(3) := FND_API.G_MISS_CHAR,
162: comm_pref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
163: cust_pref_lang_code VARCHAR2(4) := FND_API.G_MISS_CHAR,
164: category_set_id NUMBER := FND_API.G_MISS_NUM,

Line 161: subcomponent_version VARCHAR2(3) := FND_API.G_MISS_CHAR,

157: group_territory_id NUMBER := FND_API.G_MISS_NUM,
158: inv_platform_org_id NUMBER := FND_API.G_MISS_NUM,
159: product_revision VARCHAR2(240) := FND_API.G_MISS_CHAR,
160: component_version VARCHAR2(3) := FND_API.G_MISS_CHAR,
161: subcomponent_version VARCHAR2(3) := FND_API.G_MISS_CHAR,
162: comm_pref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
163: cust_pref_lang_code VARCHAR2(4) := FND_API.G_MISS_CHAR,
164: category_set_id NUMBER := FND_API.G_MISS_NUM,
165: external_reference VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 162: comm_pref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

158: inv_platform_org_id NUMBER := FND_API.G_MISS_NUM,
159: product_revision VARCHAR2(240) := FND_API.G_MISS_CHAR,
160: component_version VARCHAR2(3) := FND_API.G_MISS_CHAR,
161: subcomponent_version VARCHAR2(3) := FND_API.G_MISS_CHAR,
162: comm_pref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
163: cust_pref_lang_code VARCHAR2(4) := FND_API.G_MISS_CHAR,
164: category_set_id NUMBER := FND_API.G_MISS_NUM,
165: external_reference VARCHAR2(30) := FND_API.G_MISS_CHAR,
166: system_id NUMBER := FND_API.G_MISS_NUM,

Line 163: cust_pref_lang_code VARCHAR2(4) := FND_API.G_MISS_CHAR,

159: product_revision VARCHAR2(240) := FND_API.G_MISS_CHAR,
160: component_version VARCHAR2(3) := FND_API.G_MISS_CHAR,
161: subcomponent_version VARCHAR2(3) := FND_API.G_MISS_CHAR,
162: comm_pref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
163: cust_pref_lang_code VARCHAR2(4) := FND_API.G_MISS_CHAR,
164: category_set_id NUMBER := FND_API.G_MISS_NUM,
165: external_reference VARCHAR2(30) := FND_API.G_MISS_CHAR,
166: system_id NUMBER := FND_API.G_MISS_NUM,
167: ---- Added for Enh# 1830701

Line 164: category_set_id NUMBER := FND_API.G_MISS_NUM,

160: component_version VARCHAR2(3) := FND_API.G_MISS_CHAR,
161: subcomponent_version VARCHAR2(3) := FND_API.G_MISS_CHAR,
162: comm_pref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
163: cust_pref_lang_code VARCHAR2(4) := FND_API.G_MISS_CHAR,
164: category_set_id NUMBER := FND_API.G_MISS_NUM,
165: external_reference VARCHAR2(30) := FND_API.G_MISS_CHAR,
166: system_id NUMBER := FND_API.G_MISS_NUM,
167: ---- Added for Enh# 1830701
168: request_date DATE := FND_API.G_MISS_DATE,

Line 165: external_reference VARCHAR2(30) := FND_API.G_MISS_CHAR,

161: subcomponent_version VARCHAR2(3) := FND_API.G_MISS_CHAR,
162: comm_pref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
163: cust_pref_lang_code VARCHAR2(4) := FND_API.G_MISS_CHAR,
164: category_set_id NUMBER := FND_API.G_MISS_NUM,
165: external_reference VARCHAR2(30) := FND_API.G_MISS_CHAR,
166: system_id NUMBER := FND_API.G_MISS_NUM,
167: ---- Added for Enh# 1830701
168: request_date DATE := FND_API.G_MISS_DATE,
169: incident_occurred_date DATE := FND_API.G_MISS_DATE,

Line 166: system_id NUMBER := FND_API.G_MISS_NUM,

162: comm_pref_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
163: cust_pref_lang_code VARCHAR2(4) := FND_API.G_MISS_CHAR,
164: category_set_id NUMBER := FND_API.G_MISS_NUM,
165: external_reference VARCHAR2(30) := FND_API.G_MISS_CHAR,
166: system_id NUMBER := FND_API.G_MISS_NUM,
167: ---- Added for Enh# 1830701
168: request_date DATE := FND_API.G_MISS_DATE,
169: incident_occurred_date DATE := FND_API.G_MISS_DATE,
170: incident_resolved_date DATE := FND_API.G_MISS_DATE,

Line 168: request_date DATE := FND_API.G_MISS_DATE,

164: category_set_id NUMBER := FND_API.G_MISS_NUM,
165: external_reference VARCHAR2(30) := FND_API.G_MISS_CHAR,
166: system_id NUMBER := FND_API.G_MISS_NUM,
167: ---- Added for Enh# 1830701
168: request_date DATE := FND_API.G_MISS_DATE,
169: incident_occurred_date DATE := FND_API.G_MISS_DATE,
170: incident_resolved_date DATE := FND_API.G_MISS_DATE,
171: inc_responded_by_date DATE := FND_API.G_MISS_DATE,
172: ---- Added for Enh# 222054

Line 169: incident_occurred_date DATE := FND_API.G_MISS_DATE,

165: external_reference VARCHAR2(30) := FND_API.G_MISS_CHAR,
166: system_id NUMBER := FND_API.G_MISS_NUM,
167: ---- Added for Enh# 1830701
168: request_date DATE := FND_API.G_MISS_DATE,
169: incident_occurred_date DATE := FND_API.G_MISS_DATE,
170: incident_resolved_date DATE := FND_API.G_MISS_DATE,
171: inc_responded_by_date DATE := FND_API.G_MISS_DATE,
172: ---- Added for Enh# 222054
173: incident_location_id NUMBER := FND_API.G_MISS_NUM,

Line 170: incident_resolved_date DATE := FND_API.G_MISS_DATE,

166: system_id NUMBER := FND_API.G_MISS_NUM,
167: ---- Added for Enh# 1830701
168: request_date DATE := FND_API.G_MISS_DATE,
169: incident_occurred_date DATE := FND_API.G_MISS_DATE,
170: incident_resolved_date DATE := FND_API.G_MISS_DATE,
171: inc_responded_by_date DATE := FND_API.G_MISS_DATE,
172: ---- Added for Enh# 222054
173: incident_location_id NUMBER := FND_API.G_MISS_NUM,
174: incident_country VARCHAR2(60) := FND_API.G_MISS_CHAR,

Line 171: inc_responded_by_date DATE := FND_API.G_MISS_DATE,

167: ---- Added for Enh# 1830701
168: request_date DATE := FND_API.G_MISS_DATE,
169: incident_occurred_date DATE := FND_API.G_MISS_DATE,
170: incident_resolved_date DATE := FND_API.G_MISS_DATE,
171: inc_responded_by_date DATE := FND_API.G_MISS_DATE,
172: ---- Added for Enh# 222054
173: incident_location_id NUMBER := FND_API.G_MISS_NUM,
174: incident_country VARCHAR2(60) := FND_API.G_MISS_CHAR,
175: --- Added for ER# 2433831

Line 173: incident_location_id NUMBER := FND_API.G_MISS_NUM,

169: incident_occurred_date DATE := FND_API.G_MISS_DATE,
170: incident_resolved_date DATE := FND_API.G_MISS_DATE,
171: inc_responded_by_date DATE := FND_API.G_MISS_DATE,
172: ---- Added for Enh# 222054
173: incident_location_id NUMBER := FND_API.G_MISS_NUM,
174: incident_country VARCHAR2(60) := FND_API.G_MISS_CHAR,
175: --- Added for ER# 2433831
176: bill_to_account_id NUMBER := FND_API.G_MISS_NUM ,
177: ship_to_account_id NUMBER := FND_API.G_MISS_NUM ,

Line 174: incident_country VARCHAR2(60) := FND_API.G_MISS_CHAR,

170: incident_resolved_date DATE := FND_API.G_MISS_DATE,
171: inc_responded_by_date DATE := FND_API.G_MISS_DATE,
172: ---- Added for Enh# 222054
173: incident_location_id NUMBER := FND_API.G_MISS_NUM,
174: incident_country VARCHAR2(60) := FND_API.G_MISS_CHAR,
175: --- Added for ER# 2433831
176: bill_to_account_id NUMBER := FND_API.G_MISS_NUM ,
177: ship_to_account_id NUMBER := FND_API.G_MISS_NUM ,
178: --- Added for ER# 2463321

Line 176: bill_to_account_id NUMBER := FND_API.G_MISS_NUM ,

172: ---- Added for Enh# 222054
173: incident_location_id NUMBER := FND_API.G_MISS_NUM,
174: incident_country VARCHAR2(60) := FND_API.G_MISS_CHAR,
175: --- Added for ER# 2433831
176: bill_to_account_id NUMBER := FND_API.G_MISS_NUM ,
177: ship_to_account_id NUMBER := FND_API.G_MISS_NUM ,
178: --- Added for ER# 2463321
179: customer_phone_id NUMBER := FND_API.G_MISS_NUM ,
180: customer_email_id NUMBER := FND_API.G_MISS_NUM ,

Line 177: ship_to_account_id NUMBER := FND_API.G_MISS_NUM ,

173: incident_location_id NUMBER := FND_API.G_MISS_NUM,
174: incident_country VARCHAR2(60) := FND_API.G_MISS_CHAR,
175: --- Added for ER# 2433831
176: bill_to_account_id NUMBER := FND_API.G_MISS_NUM ,
177: ship_to_account_id NUMBER := FND_API.G_MISS_NUM ,
178: --- Added for ER# 2463321
179: customer_phone_id NUMBER := FND_API.G_MISS_NUM ,
180: customer_email_id NUMBER := FND_API.G_MISS_NUM ,
181: bill_to_party_id NUMBER := FND_API.G_MISS_NUM ,

Line 179: customer_phone_id NUMBER := FND_API.G_MISS_NUM ,

175: --- Added for ER# 2433831
176: bill_to_account_id NUMBER := FND_API.G_MISS_NUM ,
177: ship_to_account_id NUMBER := FND_API.G_MISS_NUM ,
178: --- Added for ER# 2463321
179: customer_phone_id NUMBER := FND_API.G_MISS_NUM ,
180: customer_email_id NUMBER := FND_API.G_MISS_NUM ,
181: bill_to_party_id NUMBER := FND_API.G_MISS_NUM ,
182: ship_to_party_id NUMBER := FND_API.G_MISS_NUM ,
183: bill_to_site_id NUMBER := FND_API.G_MISS_NUM ,

Line 180: customer_email_id NUMBER := FND_API.G_MISS_NUM ,

176: bill_to_account_id NUMBER := FND_API.G_MISS_NUM ,
177: ship_to_account_id NUMBER := FND_API.G_MISS_NUM ,
178: --- Added for ER# 2463321
179: customer_phone_id NUMBER := FND_API.G_MISS_NUM ,
180: customer_email_id NUMBER := FND_API.G_MISS_NUM ,
181: bill_to_party_id NUMBER := FND_API.G_MISS_NUM ,
182: ship_to_party_id NUMBER := FND_API.G_MISS_NUM ,
183: bill_to_site_id NUMBER := FND_API.G_MISS_NUM ,
184: ship_to_site_id NUMBER := FND_API.G_MISS_NUM ,

Line 181: bill_to_party_id NUMBER := FND_API.G_MISS_NUM ,

177: ship_to_account_id NUMBER := FND_API.G_MISS_NUM ,
178: --- Added for ER# 2463321
179: customer_phone_id NUMBER := FND_API.G_MISS_NUM ,
180: customer_email_id NUMBER := FND_API.G_MISS_NUM ,
181: bill_to_party_id NUMBER := FND_API.G_MISS_NUM ,
182: ship_to_party_id NUMBER := FND_API.G_MISS_NUM ,
183: bill_to_site_id NUMBER := FND_API.G_MISS_NUM ,
184: ship_to_site_id NUMBER := FND_API.G_MISS_NUM ,
185:

Line 182: ship_to_party_id NUMBER := FND_API.G_MISS_NUM ,

178: --- Added for ER# 2463321
179: customer_phone_id NUMBER := FND_API.G_MISS_NUM ,
180: customer_email_id NUMBER := FND_API.G_MISS_NUM ,
181: bill_to_party_id NUMBER := FND_API.G_MISS_NUM ,
182: ship_to_party_id NUMBER := FND_API.G_MISS_NUM ,
183: bill_to_site_id NUMBER := FND_API.G_MISS_NUM ,
184: ship_to_site_id NUMBER := FND_API.G_MISS_NUM ,
185:
186: -- Added address related columns by shijain 4th dec 2002

Line 183: bill_to_site_id NUMBER := FND_API.G_MISS_NUM ,

179: customer_phone_id NUMBER := FND_API.G_MISS_NUM ,
180: customer_email_id NUMBER := FND_API.G_MISS_NUM ,
181: bill_to_party_id NUMBER := FND_API.G_MISS_NUM ,
182: ship_to_party_id NUMBER := FND_API.G_MISS_NUM ,
183: bill_to_site_id NUMBER := FND_API.G_MISS_NUM ,
184: ship_to_site_id NUMBER := FND_API.G_MISS_NUM ,
185:
186: -- Added address related columns by shijain 4th dec 2002
187: incident_point_of_interest Varchar2(240):=FND_API.G_MISS_CHAR ,

Line 184: ship_to_site_id NUMBER := FND_API.G_MISS_NUM ,

180: customer_email_id NUMBER := FND_API.G_MISS_NUM ,
181: bill_to_party_id NUMBER := FND_API.G_MISS_NUM ,
182: ship_to_party_id NUMBER := FND_API.G_MISS_NUM ,
183: bill_to_site_id NUMBER := FND_API.G_MISS_NUM ,
184: ship_to_site_id NUMBER := FND_API.G_MISS_NUM ,
185:
186: -- Added address related columns by shijain 4th dec 2002
187: incident_point_of_interest Varchar2(240):=FND_API.G_MISS_CHAR ,
188: incident_cross_street Varchar2(240):=FND_API.G_MISS_CHAR ,

Line 187: incident_point_of_interest Varchar2(240):=FND_API.G_MISS_CHAR ,

183: bill_to_site_id NUMBER := FND_API.G_MISS_NUM ,
184: ship_to_site_id NUMBER := FND_API.G_MISS_NUM ,
185:
186: -- Added address related columns by shijain 4th dec 2002
187: incident_point_of_interest Varchar2(240):=FND_API.G_MISS_CHAR ,
188: incident_cross_street Varchar2(240):=FND_API.G_MISS_CHAR ,
189: incident_direction_qualifier Varchar2(30):=FND_API.G_MISS_CHAR,
190: incident_distance_qualifier Varchar2(240):=FND_API.G_MISS_CHAR ,
191: incident_distance_qual_uom Varchar2(30):=FND_API.G_MISS_CHAR,

Line 188: incident_cross_street Varchar2(240):=FND_API.G_MISS_CHAR ,

184: ship_to_site_id NUMBER := FND_API.G_MISS_NUM ,
185:
186: -- Added address related columns by shijain 4th dec 2002
187: incident_point_of_interest Varchar2(240):=FND_API.G_MISS_CHAR ,
188: incident_cross_street Varchar2(240):=FND_API.G_MISS_CHAR ,
189: incident_direction_qualifier Varchar2(30):=FND_API.G_MISS_CHAR,
190: incident_distance_qualifier Varchar2(240):=FND_API.G_MISS_CHAR ,
191: incident_distance_qual_uom Varchar2(30):=FND_API.G_MISS_CHAR,
192: incident_address2 Varchar2(240):=FND_API.G_MISS_CHAR ,

Line 189: incident_direction_qualifier Varchar2(30):=FND_API.G_MISS_CHAR,

185:
186: -- Added address related columns by shijain 4th dec 2002
187: incident_point_of_interest Varchar2(240):=FND_API.G_MISS_CHAR ,
188: incident_cross_street Varchar2(240):=FND_API.G_MISS_CHAR ,
189: incident_direction_qualifier Varchar2(30):=FND_API.G_MISS_CHAR,
190: incident_distance_qualifier Varchar2(240):=FND_API.G_MISS_CHAR ,
191: incident_distance_qual_uom Varchar2(30):=FND_API.G_MISS_CHAR,
192: incident_address2 Varchar2(240):=FND_API.G_MISS_CHAR ,
193: incident_address3 Varchar2(240):=FND_API.G_MISS_CHAR,

Line 190: incident_distance_qualifier Varchar2(240):=FND_API.G_MISS_CHAR ,

186: -- Added address related columns by shijain 4th dec 2002
187: incident_point_of_interest Varchar2(240):=FND_API.G_MISS_CHAR ,
188: incident_cross_street Varchar2(240):=FND_API.G_MISS_CHAR ,
189: incident_direction_qualifier Varchar2(30):=FND_API.G_MISS_CHAR,
190: incident_distance_qualifier Varchar2(240):=FND_API.G_MISS_CHAR ,
191: incident_distance_qual_uom Varchar2(30):=FND_API.G_MISS_CHAR,
192: incident_address2 Varchar2(240):=FND_API.G_MISS_CHAR ,
193: incident_address3 Varchar2(240):=FND_API.G_MISS_CHAR,
194: incident_address4 Varchar2(240):=FND_API.G_MISS_CHAR ,

Line 191: incident_distance_qual_uom Varchar2(30):=FND_API.G_MISS_CHAR,

187: incident_point_of_interest Varchar2(240):=FND_API.G_MISS_CHAR ,
188: incident_cross_street Varchar2(240):=FND_API.G_MISS_CHAR ,
189: incident_direction_qualifier Varchar2(30):=FND_API.G_MISS_CHAR,
190: incident_distance_qualifier Varchar2(240):=FND_API.G_MISS_CHAR ,
191: incident_distance_qual_uom Varchar2(30):=FND_API.G_MISS_CHAR,
192: incident_address2 Varchar2(240):=FND_API.G_MISS_CHAR ,
193: incident_address3 Varchar2(240):=FND_API.G_MISS_CHAR,
194: incident_address4 Varchar2(240):=FND_API.G_MISS_CHAR ,
195: incident_address_style Varchar2(30):=FND_API.G_MISS_CHAR,

Line 192: incident_address2 Varchar2(240):=FND_API.G_MISS_CHAR ,

188: incident_cross_street Varchar2(240):=FND_API.G_MISS_CHAR ,
189: incident_direction_qualifier Varchar2(30):=FND_API.G_MISS_CHAR,
190: incident_distance_qualifier Varchar2(240):=FND_API.G_MISS_CHAR ,
191: incident_distance_qual_uom Varchar2(30):=FND_API.G_MISS_CHAR,
192: incident_address2 Varchar2(240):=FND_API.G_MISS_CHAR ,
193: incident_address3 Varchar2(240):=FND_API.G_MISS_CHAR,
194: incident_address4 Varchar2(240):=FND_API.G_MISS_CHAR ,
195: incident_address_style Varchar2(30):=FND_API.G_MISS_CHAR,
196: incident_addr_lines_phonetic Varchar2(560):=FND_API.G_MISS_CHAR ,

Line 193: incident_address3 Varchar2(240):=FND_API.G_MISS_CHAR,

189: incident_direction_qualifier Varchar2(30):=FND_API.G_MISS_CHAR,
190: incident_distance_qualifier Varchar2(240):=FND_API.G_MISS_CHAR ,
191: incident_distance_qual_uom Varchar2(30):=FND_API.G_MISS_CHAR,
192: incident_address2 Varchar2(240):=FND_API.G_MISS_CHAR ,
193: incident_address3 Varchar2(240):=FND_API.G_MISS_CHAR,
194: incident_address4 Varchar2(240):=FND_API.G_MISS_CHAR ,
195: incident_address_style Varchar2(30):=FND_API.G_MISS_CHAR,
196: incident_addr_lines_phonetic Varchar2(560):=FND_API.G_MISS_CHAR ,
197: incident_po_box_number Varchar2(50):=FND_API.G_MISS_CHAR ,

Line 194: incident_address4 Varchar2(240):=FND_API.G_MISS_CHAR ,

190: incident_distance_qualifier Varchar2(240):=FND_API.G_MISS_CHAR ,
191: incident_distance_qual_uom Varchar2(30):=FND_API.G_MISS_CHAR,
192: incident_address2 Varchar2(240):=FND_API.G_MISS_CHAR ,
193: incident_address3 Varchar2(240):=FND_API.G_MISS_CHAR,
194: incident_address4 Varchar2(240):=FND_API.G_MISS_CHAR ,
195: incident_address_style Varchar2(30):=FND_API.G_MISS_CHAR,
196: incident_addr_lines_phonetic Varchar2(560):=FND_API.G_MISS_CHAR ,
197: incident_po_box_number Varchar2(50):=FND_API.G_MISS_CHAR ,
198: incident_house_number Varchar2(50):=FND_API.G_MISS_CHAR,

Line 195: incident_address_style Varchar2(30):=FND_API.G_MISS_CHAR,

191: incident_distance_qual_uom Varchar2(30):=FND_API.G_MISS_CHAR,
192: incident_address2 Varchar2(240):=FND_API.G_MISS_CHAR ,
193: incident_address3 Varchar2(240):=FND_API.G_MISS_CHAR,
194: incident_address4 Varchar2(240):=FND_API.G_MISS_CHAR ,
195: incident_address_style Varchar2(30):=FND_API.G_MISS_CHAR,
196: incident_addr_lines_phonetic Varchar2(560):=FND_API.G_MISS_CHAR ,
197: incident_po_box_number Varchar2(50):=FND_API.G_MISS_CHAR ,
198: incident_house_number Varchar2(50):=FND_API.G_MISS_CHAR,
199: incident_street_suffix Varchar2(50):=FND_API.G_MISS_CHAR ,

Line 196: incident_addr_lines_phonetic Varchar2(560):=FND_API.G_MISS_CHAR ,

192: incident_address2 Varchar2(240):=FND_API.G_MISS_CHAR ,
193: incident_address3 Varchar2(240):=FND_API.G_MISS_CHAR,
194: incident_address4 Varchar2(240):=FND_API.G_MISS_CHAR ,
195: incident_address_style Varchar2(30):=FND_API.G_MISS_CHAR,
196: incident_addr_lines_phonetic Varchar2(560):=FND_API.G_MISS_CHAR ,
197: incident_po_box_number Varchar2(50):=FND_API.G_MISS_CHAR ,
198: incident_house_number Varchar2(50):=FND_API.G_MISS_CHAR,
199: incident_street_suffix Varchar2(50):=FND_API.G_MISS_CHAR ,
200: incident_street Varchar2(150):=FND_API.G_MISS_CHAR,

Line 197: incident_po_box_number Varchar2(50):=FND_API.G_MISS_CHAR ,

193: incident_address3 Varchar2(240):=FND_API.G_MISS_CHAR,
194: incident_address4 Varchar2(240):=FND_API.G_MISS_CHAR ,
195: incident_address_style Varchar2(30):=FND_API.G_MISS_CHAR,
196: incident_addr_lines_phonetic Varchar2(560):=FND_API.G_MISS_CHAR ,
197: incident_po_box_number Varchar2(50):=FND_API.G_MISS_CHAR ,
198: incident_house_number Varchar2(50):=FND_API.G_MISS_CHAR,
199: incident_street_suffix Varchar2(50):=FND_API.G_MISS_CHAR ,
200: incident_street Varchar2(150):=FND_API.G_MISS_CHAR,
201: incident_street_number Varchar2(50):=FND_API.G_MISS_CHAR ,

Line 198: incident_house_number Varchar2(50):=FND_API.G_MISS_CHAR,

194: incident_address4 Varchar2(240):=FND_API.G_MISS_CHAR ,
195: incident_address_style Varchar2(30):=FND_API.G_MISS_CHAR,
196: incident_addr_lines_phonetic Varchar2(560):=FND_API.G_MISS_CHAR ,
197: incident_po_box_number Varchar2(50):=FND_API.G_MISS_CHAR ,
198: incident_house_number Varchar2(50):=FND_API.G_MISS_CHAR,
199: incident_street_suffix Varchar2(50):=FND_API.G_MISS_CHAR ,
200: incident_street Varchar2(150):=FND_API.G_MISS_CHAR,
201: incident_street_number Varchar2(50):=FND_API.G_MISS_CHAR ,
202: incident_floor Varchar2(50):=FND_API.G_MISS_CHAR ,

Line 199: incident_street_suffix Varchar2(50):=FND_API.G_MISS_CHAR ,

195: incident_address_style Varchar2(30):=FND_API.G_MISS_CHAR,
196: incident_addr_lines_phonetic Varchar2(560):=FND_API.G_MISS_CHAR ,
197: incident_po_box_number Varchar2(50):=FND_API.G_MISS_CHAR ,
198: incident_house_number Varchar2(50):=FND_API.G_MISS_CHAR,
199: incident_street_suffix Varchar2(50):=FND_API.G_MISS_CHAR ,
200: incident_street Varchar2(150):=FND_API.G_MISS_CHAR,
201: incident_street_number Varchar2(50):=FND_API.G_MISS_CHAR ,
202: incident_floor Varchar2(50):=FND_API.G_MISS_CHAR ,
203: incident_suite Varchar2(50):=FND_API.G_MISS_CHAR ,

Line 200: incident_street Varchar2(150):=FND_API.G_MISS_CHAR,

196: incident_addr_lines_phonetic Varchar2(560):=FND_API.G_MISS_CHAR ,
197: incident_po_box_number Varchar2(50):=FND_API.G_MISS_CHAR ,
198: incident_house_number Varchar2(50):=FND_API.G_MISS_CHAR,
199: incident_street_suffix Varchar2(50):=FND_API.G_MISS_CHAR ,
200: incident_street Varchar2(150):=FND_API.G_MISS_CHAR,
201: incident_street_number Varchar2(50):=FND_API.G_MISS_CHAR ,
202: incident_floor Varchar2(50):=FND_API.G_MISS_CHAR ,
203: incident_suite Varchar2(50):=FND_API.G_MISS_CHAR ,
204: incident_postal_plus4_code Varchar2(30):=FND_API.G_MISS_CHAR ,

Line 201: incident_street_number Varchar2(50):=FND_API.G_MISS_CHAR ,

197: incident_po_box_number Varchar2(50):=FND_API.G_MISS_CHAR ,
198: incident_house_number Varchar2(50):=FND_API.G_MISS_CHAR,
199: incident_street_suffix Varchar2(50):=FND_API.G_MISS_CHAR ,
200: incident_street Varchar2(150):=FND_API.G_MISS_CHAR,
201: incident_street_number Varchar2(50):=FND_API.G_MISS_CHAR ,
202: incident_floor Varchar2(50):=FND_API.G_MISS_CHAR ,
203: incident_suite Varchar2(50):=FND_API.G_MISS_CHAR ,
204: incident_postal_plus4_code Varchar2(30):=FND_API.G_MISS_CHAR ,
205: incident_position Varchar2(50):=FND_API.G_MISS_CHAR ,

Line 202: incident_floor Varchar2(50):=FND_API.G_MISS_CHAR ,

198: incident_house_number Varchar2(50):=FND_API.G_MISS_CHAR,
199: incident_street_suffix Varchar2(50):=FND_API.G_MISS_CHAR ,
200: incident_street Varchar2(150):=FND_API.G_MISS_CHAR,
201: incident_street_number Varchar2(50):=FND_API.G_MISS_CHAR ,
202: incident_floor Varchar2(50):=FND_API.G_MISS_CHAR ,
203: incident_suite Varchar2(50):=FND_API.G_MISS_CHAR ,
204: incident_postal_plus4_code Varchar2(30):=FND_API.G_MISS_CHAR ,
205: incident_position Varchar2(50):=FND_API.G_MISS_CHAR ,
206: incident_location_directions Varchar2(640):=FND_API.G_MISS_CHAR,

Line 203: incident_suite Varchar2(50):=FND_API.G_MISS_CHAR ,

199: incident_street_suffix Varchar2(50):=FND_API.G_MISS_CHAR ,
200: incident_street Varchar2(150):=FND_API.G_MISS_CHAR,
201: incident_street_number Varchar2(50):=FND_API.G_MISS_CHAR ,
202: incident_floor Varchar2(50):=FND_API.G_MISS_CHAR ,
203: incident_suite Varchar2(50):=FND_API.G_MISS_CHAR ,
204: incident_postal_plus4_code Varchar2(30):=FND_API.G_MISS_CHAR ,
205: incident_position Varchar2(50):=FND_API.G_MISS_CHAR ,
206: incident_location_directions Varchar2(640):=FND_API.G_MISS_CHAR,
207: incident_location_description Varchar2(2000):=FND_API.G_MISS_CHAR ,

Line 204: incident_postal_plus4_code Varchar2(30):=FND_API.G_MISS_CHAR ,

200: incident_street Varchar2(150):=FND_API.G_MISS_CHAR,
201: incident_street_number Varchar2(50):=FND_API.G_MISS_CHAR ,
202: incident_floor Varchar2(50):=FND_API.G_MISS_CHAR ,
203: incident_suite Varchar2(50):=FND_API.G_MISS_CHAR ,
204: incident_postal_plus4_code Varchar2(30):=FND_API.G_MISS_CHAR ,
205: incident_position Varchar2(50):=FND_API.G_MISS_CHAR ,
206: incident_location_directions Varchar2(640):=FND_API.G_MISS_CHAR,
207: incident_location_description Varchar2(2000):=FND_API.G_MISS_CHAR ,
208: install_site_id NUMBER := FND_API.G_MISS_NUM ,

Line 205: incident_position Varchar2(50):=FND_API.G_MISS_CHAR ,

201: incident_street_number Varchar2(50):=FND_API.G_MISS_CHAR ,
202: incident_floor Varchar2(50):=FND_API.G_MISS_CHAR ,
203: incident_suite Varchar2(50):=FND_API.G_MISS_CHAR ,
204: incident_postal_plus4_code Varchar2(30):=FND_API.G_MISS_CHAR ,
205: incident_position Varchar2(50):=FND_API.G_MISS_CHAR ,
206: incident_location_directions Varchar2(640):=FND_API.G_MISS_CHAR,
207: incident_location_description Varchar2(2000):=FND_API.G_MISS_CHAR ,
208: install_site_id NUMBER := FND_API.G_MISS_NUM ,
209: group_owner Varchar2(60):=FND_API.G_MISS_CHAR,

Line 206: incident_location_directions Varchar2(640):=FND_API.G_MISS_CHAR,

202: incident_floor Varchar2(50):=FND_API.G_MISS_CHAR ,
203: incident_suite Varchar2(50):=FND_API.G_MISS_CHAR ,
204: incident_postal_plus4_code Varchar2(30):=FND_API.G_MISS_CHAR ,
205: incident_position Varchar2(50):=FND_API.G_MISS_CHAR ,
206: incident_location_directions Varchar2(640):=FND_API.G_MISS_CHAR,
207: incident_location_description Varchar2(2000):=FND_API.G_MISS_CHAR ,
208: install_site_id NUMBER := FND_API.G_MISS_NUM ,
209: group_owner Varchar2(60):=FND_API.G_MISS_CHAR,
210: owner Varchar2(360):=FND_API.G_MISS_CHAR,

Line 207: incident_location_description Varchar2(2000):=FND_API.G_MISS_CHAR ,

203: incident_suite Varchar2(50):=FND_API.G_MISS_CHAR ,
204: incident_postal_plus4_code Varchar2(30):=FND_API.G_MISS_CHAR ,
205: incident_position Varchar2(50):=FND_API.G_MISS_CHAR ,
206: incident_location_directions Varchar2(640):=FND_API.G_MISS_CHAR,
207: incident_location_description Varchar2(2000):=FND_API.G_MISS_CHAR ,
208: install_site_id NUMBER := FND_API.G_MISS_NUM ,
209: group_owner Varchar2(60):=FND_API.G_MISS_CHAR,
210: owner Varchar2(360):=FND_API.G_MISS_CHAR,
211: --------------------anmukher--------------------08/01/03

Line 208: install_site_id NUMBER := FND_API.G_MISS_NUM ,

204: incident_postal_plus4_code Varchar2(30):=FND_API.G_MISS_CHAR ,
205: incident_position Varchar2(50):=FND_API.G_MISS_CHAR ,
206: incident_location_directions Varchar2(640):=FND_API.G_MISS_CHAR,
207: incident_location_description Varchar2(2000):=FND_API.G_MISS_CHAR ,
208: install_site_id NUMBER := FND_API.G_MISS_NUM ,
209: group_owner Varchar2(60):=FND_API.G_MISS_CHAR,
210: owner Varchar2(360):=FND_API.G_MISS_CHAR,
211: --------------------anmukher--------------------08/01/03
212: -- Added for CMRO-EAM project of Release 11.5.10

Line 209: group_owner Varchar2(60):=FND_API.G_MISS_CHAR,

205: incident_position Varchar2(50):=FND_API.G_MISS_CHAR ,
206: incident_location_directions Varchar2(640):=FND_API.G_MISS_CHAR,
207: incident_location_description Varchar2(2000):=FND_API.G_MISS_CHAR ,
208: install_site_id NUMBER := FND_API.G_MISS_NUM ,
209: group_owner Varchar2(60):=FND_API.G_MISS_CHAR,
210: owner Varchar2(360):=FND_API.G_MISS_CHAR,
211: --------------------anmukher--------------------08/01/03
212: -- Added for CMRO-EAM project of Release 11.5.10
213: item_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 210: owner Varchar2(360):=FND_API.G_MISS_CHAR,

206: incident_location_directions Varchar2(640):=FND_API.G_MISS_CHAR,
207: incident_location_description Varchar2(2000):=FND_API.G_MISS_CHAR ,
208: install_site_id NUMBER := FND_API.G_MISS_NUM ,
209: group_owner Varchar2(60):=FND_API.G_MISS_CHAR,
210: owner Varchar2(360):=FND_API.G_MISS_CHAR,
211: --------------------anmukher--------------------08/01/03
212: -- Added for CMRO-EAM project of Release 11.5.10
213: item_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
214: owning_dept_id NUMBER := FND_API.G_MISS_NUM,

Line 213: item_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,

209: group_owner Varchar2(60):=FND_API.G_MISS_CHAR,
210: owner Varchar2(360):=FND_API.G_MISS_CHAR,
211: --------------------anmukher--------------------08/01/03
212: -- Added for CMRO-EAM project of Release 11.5.10
213: item_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
214: owning_dept_id NUMBER := FND_API.G_MISS_NUM,
215: ---------------------anmukher--------------------08/18/03
216: incident_location_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
217: --Added for bug 3635269

Line 214: owning_dept_id NUMBER := FND_API.G_MISS_NUM,

210: owner Varchar2(360):=FND_API.G_MISS_CHAR,
211: --------------------anmukher--------------------08/01/03
212: -- Added for CMRO-EAM project of Release 11.5.10
213: item_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
214: owning_dept_id NUMBER := FND_API.G_MISS_NUM,
215: ---------------------anmukher--------------------08/18/03
216: incident_location_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
217: --Added for bug 3635269
218: sr_creation_channel VARCHAR2(50) := FND_API.G_MISS_CHAR,

Line 216: incident_location_type VARCHAR2(30) := FND_API.G_MISS_CHAR,

212: -- Added for CMRO-EAM project of Release 11.5.10
213: item_serial_number VARCHAR2(30) := FND_API.G_MISS_CHAR,
214: owning_dept_id NUMBER := FND_API.G_MISS_NUM,
215: ---------------------anmukher--------------------08/18/03
216: incident_location_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
217: --Added for bug 3635269
218: sr_creation_channel VARCHAR2(50) := FND_API.G_MISS_CHAR,
219: maint_organization_id NUMBER := FND_API.G_MISS_NUM,
220: old_type_id NUMBER,

Line 218: sr_creation_channel VARCHAR2(50) := FND_API.G_MISS_CHAR,

214: owning_dept_id NUMBER := FND_API.G_MISS_NUM,
215: ---------------------anmukher--------------------08/18/03
216: incident_location_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
217: --Added for bug 3635269
218: sr_creation_channel VARCHAR2(50) := FND_API.G_MISS_CHAR,
219: maint_organization_id NUMBER := FND_API.G_MISS_NUM,
220: old_type_id NUMBER,
221: -- Credit Card 9358401
222: instrument_payment_use_id Number := FND_API.G_MISS_NUM,

Line 219: maint_organization_id NUMBER := FND_API.G_MISS_NUM,

215: ---------------------anmukher--------------------08/18/03
216: incident_location_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
217: --Added for bug 3635269
218: sr_creation_channel VARCHAR2(50) := FND_API.G_MISS_CHAR,
219: maint_organization_id NUMBER := FND_API.G_MISS_NUM,
220: old_type_id NUMBER,
221: -- Credit Card 9358401
222: instrument_payment_use_id Number := FND_API.G_MISS_NUM,
223: --12.2 + project siahmed added for integration with Oracle Projects

Line 222: instrument_payment_use_id Number := FND_API.G_MISS_NUM,

218: sr_creation_channel VARCHAR2(50) := FND_API.G_MISS_CHAR,
219: maint_organization_id NUMBER := FND_API.G_MISS_NUM,
220: old_type_id NUMBER,
221: -- Credit Card 9358401
222: instrument_payment_use_id Number := FND_API.G_MISS_NUM,
223: --12.2 + project siahmed added for integration with Oracle Projects
224: project_id Number := FND_API.G_MISS_NUM,
225: project_task_id Number := FND_API.G_MISS_NUM,
226: expenditure_org_id Number := FND_API.G_MISS_NUM,

Line 224: project_id Number := FND_API.G_MISS_NUM,

220: old_type_id NUMBER,
221: -- Credit Card 9358401
222: instrument_payment_use_id Number := FND_API.G_MISS_NUM,
223: --12.2 + project siahmed added for integration with Oracle Projects
224: project_id Number := FND_API.G_MISS_NUM,
225: project_task_id Number := FND_API.G_MISS_NUM,
226: expenditure_org_id Number := FND_API.G_MISS_NUM,
227: --14004721 . Additional SLA dates
228: sla_date_1 DATE := FND_API.G_MISS_DATE,

Line 225: project_task_id Number := FND_API.G_MISS_NUM,

221: -- Credit Card 9358401
222: instrument_payment_use_id Number := FND_API.G_MISS_NUM,
223: --12.2 + project siahmed added for integration with Oracle Projects
224: project_id Number := FND_API.G_MISS_NUM,
225: project_task_id Number := FND_API.G_MISS_NUM,
226: expenditure_org_id Number := FND_API.G_MISS_NUM,
227: --14004721 . Additional SLA dates
228: sla_date_1 DATE := FND_API.G_MISS_DATE,
229: sla_date_2 DATE := FND_API.G_MISS_DATE,

Line 226: expenditure_org_id Number := FND_API.G_MISS_NUM,

222: instrument_payment_use_id Number := FND_API.G_MISS_NUM,
223: --12.2 + project siahmed added for integration with Oracle Projects
224: project_id Number := FND_API.G_MISS_NUM,
225: project_task_id Number := FND_API.G_MISS_NUM,
226: expenditure_org_id Number := FND_API.G_MISS_NUM,
227: --14004721 . Additional SLA dates
228: sla_date_1 DATE := FND_API.G_MISS_DATE,
229: sla_date_2 DATE := FND_API.G_MISS_DATE,
230: sla_date_3 DATE := FND_API.G_MISS_DATE,

Line 228: sla_date_1 DATE := FND_API.G_MISS_DATE,

224: project_id Number := FND_API.G_MISS_NUM,
225: project_task_id Number := FND_API.G_MISS_NUM,
226: expenditure_org_id Number := FND_API.G_MISS_NUM,
227: --14004721 . Additional SLA dates
228: sla_date_1 DATE := FND_API.G_MISS_DATE,
229: sla_date_2 DATE := FND_API.G_MISS_DATE,
230: sla_date_3 DATE := FND_API.G_MISS_DATE,
231: sla_date_4 DATE := FND_API.G_MISS_DATE,
232: sla_date_5 DATE := FND_API.G_MISS_DATE,

Line 229: sla_date_2 DATE := FND_API.G_MISS_DATE,

225: project_task_id Number := FND_API.G_MISS_NUM,
226: expenditure_org_id Number := FND_API.G_MISS_NUM,
227: --14004721 . Additional SLA dates
228: sla_date_1 DATE := FND_API.G_MISS_DATE,
229: sla_date_2 DATE := FND_API.G_MISS_DATE,
230: sla_date_3 DATE := FND_API.G_MISS_DATE,
231: sla_date_4 DATE := FND_API.G_MISS_DATE,
232: sla_date_5 DATE := FND_API.G_MISS_DATE,
233: sla_date_6 DATE := FND_API.G_MISS_DATE,

Line 230: sla_date_3 DATE := FND_API.G_MISS_DATE,

226: expenditure_org_id Number := FND_API.G_MISS_NUM,
227: --14004721 . Additional SLA dates
228: sla_date_1 DATE := FND_API.G_MISS_DATE,
229: sla_date_2 DATE := FND_API.G_MISS_DATE,
230: sla_date_3 DATE := FND_API.G_MISS_DATE,
231: sla_date_4 DATE := FND_API.G_MISS_DATE,
232: sla_date_5 DATE := FND_API.G_MISS_DATE,
233: sla_date_6 DATE := FND_API.G_MISS_DATE,
234: sla_duration_1 NUMBER := FND_API.G_MISS_NUM,

Line 231: sla_date_4 DATE := FND_API.G_MISS_DATE,

227: --14004721 . Additional SLA dates
228: sla_date_1 DATE := FND_API.G_MISS_DATE,
229: sla_date_2 DATE := FND_API.G_MISS_DATE,
230: sla_date_3 DATE := FND_API.G_MISS_DATE,
231: sla_date_4 DATE := FND_API.G_MISS_DATE,
232: sla_date_5 DATE := FND_API.G_MISS_DATE,
233: sla_date_6 DATE := FND_API.G_MISS_DATE,
234: sla_duration_1 NUMBER := FND_API.G_MISS_NUM,
235: sla_duration_2 NUMBER := FND_API.G_MISS_NUM,

Line 232: sla_date_5 DATE := FND_API.G_MISS_DATE,

228: sla_date_1 DATE := FND_API.G_MISS_DATE,
229: sla_date_2 DATE := FND_API.G_MISS_DATE,
230: sla_date_3 DATE := FND_API.G_MISS_DATE,
231: sla_date_4 DATE := FND_API.G_MISS_DATE,
232: sla_date_5 DATE := FND_API.G_MISS_DATE,
233: sla_date_6 DATE := FND_API.G_MISS_DATE,
234: sla_duration_1 NUMBER := FND_API.G_MISS_NUM,
235: sla_duration_2 NUMBER := FND_API.G_MISS_NUM,
236: --15995804. Add price_list_header_id

Line 233: sla_date_6 DATE := FND_API.G_MISS_DATE,

229: sla_date_2 DATE := FND_API.G_MISS_DATE,
230: sla_date_3 DATE := FND_API.G_MISS_DATE,
231: sla_date_4 DATE := FND_API.G_MISS_DATE,
232: sla_date_5 DATE := FND_API.G_MISS_DATE,
233: sla_date_6 DATE := FND_API.G_MISS_DATE,
234: sla_duration_1 NUMBER := FND_API.G_MISS_NUM,
235: sla_duration_2 NUMBER := FND_API.G_MISS_NUM,
236: --15995804. Add price_list_header_id
237: price_list_header_id NUMBER := FND_API.G_MISS_NUM

Line 234: sla_duration_1 NUMBER := FND_API.G_MISS_NUM,

230: sla_date_3 DATE := FND_API.G_MISS_DATE,
231: sla_date_4 DATE := FND_API.G_MISS_DATE,
232: sla_date_5 DATE := FND_API.G_MISS_DATE,
233: sla_date_6 DATE := FND_API.G_MISS_DATE,
234: sla_duration_1 NUMBER := FND_API.G_MISS_NUM,
235: sla_duration_2 NUMBER := FND_API.G_MISS_NUM,
236: --15995804. Add price_list_header_id
237: price_list_header_id NUMBER := FND_API.G_MISS_NUM
238: );

Line 235: sla_duration_2 NUMBER := FND_API.G_MISS_NUM,

231: sla_date_4 DATE := FND_API.G_MISS_DATE,
232: sla_date_5 DATE := FND_API.G_MISS_DATE,
233: sla_date_6 DATE := FND_API.G_MISS_DATE,
234: sla_duration_1 NUMBER := FND_API.G_MISS_NUM,
235: sla_duration_2 NUMBER := FND_API.G_MISS_NUM,
236: --15995804. Add price_list_header_id
237: price_list_header_id NUMBER := FND_API.G_MISS_NUM
238: );
239: --------------------------------------------------------------------------

Line 237: price_list_header_id NUMBER := FND_API.G_MISS_NUM

233: sla_date_6 DATE := FND_API.G_MISS_DATE,
234: sla_duration_1 NUMBER := FND_API.G_MISS_NUM,
235: sla_duration_2 NUMBER := FND_API.G_MISS_NUM,
236: --15995804. Add price_list_header_id
237: price_list_header_id NUMBER := FND_API.G_MISS_NUM
238: );
239: --------------------------------------------------------------------------
240: -- Start of comments
241: -- Record Type : Request_Validation_Rec_Type

Line 392: -- FND_API.G_RET_STS_SUCCESS => all non-missing fields are valid

388: -- p_inventory_item_id OUT NUMBER
389: -- Returned iff customer_product_id is passed
390: -- Identifies an item for a customer product
391: -- p_return_status OUT VARCHAR2(1)
392: -- FND_API.G_RET_STS_SUCCESS => all non-missing fields are valid
393: -- FND_API.G_RET_STS_ERROR => one or more non-missing fields
394: -- are invalid
395: -- Notes :
396: -- Please take into considerations the following dependencies when

Line 393: -- FND_API.G_RET_STS_ERROR => one or more non-missing fields

389: -- Returned iff customer_product_id is passed
390: -- Identifies an item for a customer product
391: -- p_return_status OUT VARCHAR2(1)
392: -- FND_API.G_RET_STS_SUCCESS => all non-missing fields are valid
393: -- FND_API.G_RET_STS_ERROR => one or more non-missing fields
394: -- are invalid
395: -- Notes :
396: -- Please take into considerations the following dependencies when
397: -- passing in parameters and record fields. For example, the status of

Line 431: change_status VARCHAR2(1) := FND_API.G_FALSE,

427: -- Set up record types to be used for the audit record API
428: -----------------------------------------------------------
429: /*************** Comment out these 3 audit recs and use New Audit Rec **
430: TYPE audit_flags_rec_type IS RECORD (
431: change_status VARCHAR2(1) := FND_API.G_FALSE,
432: change_owner VARCHAR2(1) := FND_API.G_FALSE,
433: change_group VARCHAR2(1) := FND_API.G_FALSE,
434: change_group_type VARCHAR2(1) := FND_API.G_FALSE,
435: change_assigned_time VARCHAR2(1) := FND_API.G_FALSE,

Line 432: change_owner VARCHAR2(1) := FND_API.G_FALSE,

428: -----------------------------------------------------------
429: /*************** Comment out these 3 audit recs and use New Audit Rec **
430: TYPE audit_flags_rec_type IS RECORD (
431: change_status VARCHAR2(1) := FND_API.G_FALSE,
432: change_owner VARCHAR2(1) := FND_API.G_FALSE,
433: change_group VARCHAR2(1) := FND_API.G_FALSE,
434: change_group_type VARCHAR2(1) := FND_API.G_FALSE,
435: change_assigned_time VARCHAR2(1) := FND_API.G_FALSE,
436: change_platform_org_id VARCHAR2(1) := FND_API.G_FALSE,

Line 433: change_group VARCHAR2(1) := FND_API.G_FALSE,

429: /*************** Comment out these 3 audit recs and use New Audit Rec **
430: TYPE audit_flags_rec_type IS RECORD (
431: change_status VARCHAR2(1) := FND_API.G_FALSE,
432: change_owner VARCHAR2(1) := FND_API.G_FALSE,
433: change_group VARCHAR2(1) := FND_API.G_FALSE,
434: change_group_type VARCHAR2(1) := FND_API.G_FALSE,
435: change_assigned_time VARCHAR2(1) := FND_API.G_FALSE,
436: change_platform_org_id VARCHAR2(1) := FND_API.G_FALSE,
437: change_type VARCHAR2(1) := FND_API.G_FALSE,

Line 434: change_group_type VARCHAR2(1) := FND_API.G_FALSE,

430: TYPE audit_flags_rec_type IS RECORD (
431: change_status VARCHAR2(1) := FND_API.G_FALSE,
432: change_owner VARCHAR2(1) := FND_API.G_FALSE,
433: change_group VARCHAR2(1) := FND_API.G_FALSE,
434: change_group_type VARCHAR2(1) := FND_API.G_FALSE,
435: change_assigned_time VARCHAR2(1) := FND_API.G_FALSE,
436: change_platform_org_id VARCHAR2(1) := FND_API.G_FALSE,
437: change_type VARCHAR2(1) := FND_API.G_FALSE,
438: change_urgency VARCHAR2(1) := FND_API.G_FALSE,

Line 435: change_assigned_time VARCHAR2(1) := FND_API.G_FALSE,

431: change_status VARCHAR2(1) := FND_API.G_FALSE,
432: change_owner VARCHAR2(1) := FND_API.G_FALSE,
433: change_group VARCHAR2(1) := FND_API.G_FALSE,
434: change_group_type VARCHAR2(1) := FND_API.G_FALSE,
435: change_assigned_time VARCHAR2(1) := FND_API.G_FALSE,
436: change_platform_org_id VARCHAR2(1) := FND_API.G_FALSE,
437: change_type VARCHAR2(1) := FND_API.G_FALSE,
438: change_urgency VARCHAR2(1) := FND_API.G_FALSE,
439: change_severity VARCHAR2(1) := FND_API.G_FALSE,

Line 436: change_platform_org_id VARCHAR2(1) := FND_API.G_FALSE,

432: change_owner VARCHAR2(1) := FND_API.G_FALSE,
433: change_group VARCHAR2(1) := FND_API.G_FALSE,
434: change_group_type VARCHAR2(1) := FND_API.G_FALSE,
435: change_assigned_time VARCHAR2(1) := FND_API.G_FALSE,
436: change_platform_org_id VARCHAR2(1) := FND_API.G_FALSE,
437: change_type VARCHAR2(1) := FND_API.G_FALSE,
438: change_urgency VARCHAR2(1) := FND_API.G_FALSE,
439: change_severity VARCHAR2(1) := FND_API.G_FALSE,
440: change_exp_res_date VARCHAR2(1) := FND_API.G_FALSE,

Line 437: change_type VARCHAR2(1) := FND_API.G_FALSE,

433: change_group VARCHAR2(1) := FND_API.G_FALSE,
434: change_group_type VARCHAR2(1) := FND_API.G_FALSE,
435: change_assigned_time VARCHAR2(1) := FND_API.G_FALSE,
436: change_platform_org_id VARCHAR2(1) := FND_API.G_FALSE,
437: change_type VARCHAR2(1) := FND_API.G_FALSE,
438: change_urgency VARCHAR2(1) := FND_API.G_FALSE,
439: change_severity VARCHAR2(1) := FND_API.G_FALSE,
440: change_exp_res_date VARCHAR2(1) := FND_API.G_FALSE,
441: new_action VARCHAR2(1) := FND_API.G_FALSE,

Line 438: change_urgency VARCHAR2(1) := FND_API.G_FALSE,

434: change_group_type VARCHAR2(1) := FND_API.G_FALSE,
435: change_assigned_time VARCHAR2(1) := FND_API.G_FALSE,
436: change_platform_org_id VARCHAR2(1) := FND_API.G_FALSE,
437: change_type VARCHAR2(1) := FND_API.G_FALSE,
438: change_urgency VARCHAR2(1) := FND_API.G_FALSE,
439: change_severity VARCHAR2(1) := FND_API.G_FALSE,
440: change_exp_res_date VARCHAR2(1) := FND_API.G_FALSE,
441: new_action VARCHAR2(1) := FND_API.G_FALSE,
442: new_workflow VARCHAR2(1) := FND_API.G_FALSE,

Line 439: change_severity VARCHAR2(1) := FND_API.G_FALSE,

435: change_assigned_time VARCHAR2(1) := FND_API.G_FALSE,
436: change_platform_org_id VARCHAR2(1) := FND_API.G_FALSE,
437: change_type VARCHAR2(1) := FND_API.G_FALSE,
438: change_urgency VARCHAR2(1) := FND_API.G_FALSE,
439: change_severity VARCHAR2(1) := FND_API.G_FALSE,
440: change_exp_res_date VARCHAR2(1) := FND_API.G_FALSE,
441: new_action VARCHAR2(1) := FND_API.G_FALSE,
442: new_workflow VARCHAR2(1) := FND_API.G_FALSE,
443: change_obligation_date VARCHAR2(1) := FND_API.G_FALSE,

Line 440: change_exp_res_date VARCHAR2(1) := FND_API.G_FALSE,

436: change_platform_org_id VARCHAR2(1) := FND_API.G_FALSE,
437: change_type VARCHAR2(1) := FND_API.G_FALSE,
438: change_urgency VARCHAR2(1) := FND_API.G_FALSE,
439: change_severity VARCHAR2(1) := FND_API.G_FALSE,
440: change_exp_res_date VARCHAR2(1) := FND_API.G_FALSE,
441: new_action VARCHAR2(1) := FND_API.G_FALSE,
442: new_workflow VARCHAR2(1) := FND_API.G_FALSE,
443: change_obligation_date VARCHAR2(1) := FND_API.G_FALSE,
444: change_site_id VARCHAR2(1) := FND_API.G_FALSE,

Line 441: new_action VARCHAR2(1) := FND_API.G_FALSE,

437: change_type VARCHAR2(1) := FND_API.G_FALSE,
438: change_urgency VARCHAR2(1) := FND_API.G_FALSE,
439: change_severity VARCHAR2(1) := FND_API.G_FALSE,
440: change_exp_res_date VARCHAR2(1) := FND_API.G_FALSE,
441: new_action VARCHAR2(1) := FND_API.G_FALSE,
442: new_workflow VARCHAR2(1) := FND_API.G_FALSE,
443: change_obligation_date VARCHAR2(1) := FND_API.G_FALSE,
444: change_site_id VARCHAR2(1) := FND_API.G_FALSE,
445: change_contact_id VARCHAR2(1) := FND_API.G_FALSE,

Line 442: new_workflow VARCHAR2(1) := FND_API.G_FALSE,

438: change_urgency VARCHAR2(1) := FND_API.G_FALSE,
439: change_severity VARCHAR2(1) := FND_API.G_FALSE,
440: change_exp_res_date VARCHAR2(1) := FND_API.G_FALSE,
441: new_action VARCHAR2(1) := FND_API.G_FALSE,
442: new_workflow VARCHAR2(1) := FND_API.G_FALSE,
443: change_obligation_date VARCHAR2(1) := FND_API.G_FALSE,
444: change_site_id VARCHAR2(1) := FND_API.G_FALSE,
445: change_contact_id VARCHAR2(1) := FND_API.G_FALSE,
446: change_bill_to_contact_id VARCHAR2(1) := FND_API.G_FALSE,

Line 443: change_obligation_date VARCHAR2(1) := FND_API.G_FALSE,

439: change_severity VARCHAR2(1) := FND_API.G_FALSE,
440: change_exp_res_date VARCHAR2(1) := FND_API.G_FALSE,
441: new_action VARCHAR2(1) := FND_API.G_FALSE,
442: new_workflow VARCHAR2(1) := FND_API.G_FALSE,
443: change_obligation_date VARCHAR2(1) := FND_API.G_FALSE,
444: change_site_id VARCHAR2(1) := FND_API.G_FALSE,
445: change_contact_id VARCHAR2(1) := FND_API.G_FALSE,
446: change_bill_to_contact_id VARCHAR2(1) := FND_API.G_FALSE,
447: change_ship_to_contact_id VARCHAR2(1) := FND_API.G_FALSE,

Line 444: change_site_id VARCHAR2(1) := FND_API.G_FALSE,

440: change_exp_res_date VARCHAR2(1) := FND_API.G_FALSE,
441: new_action VARCHAR2(1) := FND_API.G_FALSE,
442: new_workflow VARCHAR2(1) := FND_API.G_FALSE,
443: change_obligation_date VARCHAR2(1) := FND_API.G_FALSE,
444: change_site_id VARCHAR2(1) := FND_API.G_FALSE,
445: change_contact_id VARCHAR2(1) := FND_API.G_FALSE,
446: change_bill_to_contact_id VARCHAR2(1) := FND_API.G_FALSE,
447: change_ship_to_contact_id VARCHAR2(1) := FND_API.G_FALSE,
448: change_incident_date VARCHAR2(1) := FND_API.G_FALSE,

Line 445: change_contact_id VARCHAR2(1) := FND_API.G_FALSE,

441: new_action VARCHAR2(1) := FND_API.G_FALSE,
442: new_workflow VARCHAR2(1) := FND_API.G_FALSE,
443: change_obligation_date VARCHAR2(1) := FND_API.G_FALSE,
444: change_site_id VARCHAR2(1) := FND_API.G_FALSE,
445: change_contact_id VARCHAR2(1) := FND_API.G_FALSE,
446: change_bill_to_contact_id VARCHAR2(1) := FND_API.G_FALSE,
447: change_ship_to_contact_id VARCHAR2(1) := FND_API.G_FALSE,
448: change_incident_date VARCHAR2(1) := FND_API.G_FALSE,
449: change_close_date VARCHAR2(1) := FND_API.G_FALSE,

Line 446: change_bill_to_contact_id VARCHAR2(1) := FND_API.G_FALSE,

442: new_workflow VARCHAR2(1) := FND_API.G_FALSE,
443: change_obligation_date VARCHAR2(1) := FND_API.G_FALSE,
444: change_site_id VARCHAR2(1) := FND_API.G_FALSE,
445: change_contact_id VARCHAR2(1) := FND_API.G_FALSE,
446: change_bill_to_contact_id VARCHAR2(1) := FND_API.G_FALSE,
447: change_ship_to_contact_id VARCHAR2(1) := FND_API.G_FALSE,
448: change_incident_date VARCHAR2(1) := FND_API.G_FALSE,
449: change_close_date VARCHAR2(1) := FND_API.G_FALSE,
450: change_customer_product_id VARCHAR2(1) := FND_API.G_FALSE,

Line 447: change_ship_to_contact_id VARCHAR2(1) := FND_API.G_FALSE,

443: change_obligation_date VARCHAR2(1) := FND_API.G_FALSE,
444: change_site_id VARCHAR2(1) := FND_API.G_FALSE,
445: change_contact_id VARCHAR2(1) := FND_API.G_FALSE,
446: change_bill_to_contact_id VARCHAR2(1) := FND_API.G_FALSE,
447: change_ship_to_contact_id VARCHAR2(1) := FND_API.G_FALSE,
448: change_incident_date VARCHAR2(1) := FND_API.G_FALSE,
449: change_close_date VARCHAR2(1) := FND_API.G_FALSE,
450: change_customer_product_id VARCHAR2(1) := FND_API.G_FALSE,
451: change_platform_id VARCHAR2(1) := FND_API.G_FALSE,

Line 448: change_incident_date VARCHAR2(1) := FND_API.G_FALSE,

444: change_site_id VARCHAR2(1) := FND_API.G_FALSE,
445: change_contact_id VARCHAR2(1) := FND_API.G_FALSE,
446: change_bill_to_contact_id VARCHAR2(1) := FND_API.G_FALSE,
447: change_ship_to_contact_id VARCHAR2(1) := FND_API.G_FALSE,
448: change_incident_date VARCHAR2(1) := FND_API.G_FALSE,
449: change_close_date VARCHAR2(1) := FND_API.G_FALSE,
450: change_customer_product_id VARCHAR2(1) := FND_API.G_FALSE,
451: change_platform_id VARCHAR2(1) := FND_API.G_FALSE,
452: change_plat_ver_id VARCHAR2(1) := FND_API.G_FALSE,

Line 449: change_close_date VARCHAR2(1) := FND_API.G_FALSE,

445: change_contact_id VARCHAR2(1) := FND_API.G_FALSE,
446: change_bill_to_contact_id VARCHAR2(1) := FND_API.G_FALSE,
447: change_ship_to_contact_id VARCHAR2(1) := FND_API.G_FALSE,
448: change_incident_date VARCHAR2(1) := FND_API.G_FALSE,
449: change_close_date VARCHAR2(1) := FND_API.G_FALSE,
450: change_customer_product_id VARCHAR2(1) := FND_API.G_FALSE,
451: change_platform_id VARCHAR2(1) := FND_API.G_FALSE,
452: change_plat_ver_id VARCHAR2(1) := FND_API.G_FALSE,
453: change_cp_comp_id VARCHAR2(1) := FND_API.G_FALSE,

Line 450: change_customer_product_id VARCHAR2(1) := FND_API.G_FALSE,

446: change_bill_to_contact_id VARCHAR2(1) := FND_API.G_FALSE,
447: change_ship_to_contact_id VARCHAR2(1) := FND_API.G_FALSE,
448: change_incident_date VARCHAR2(1) := FND_API.G_FALSE,
449: change_close_date VARCHAR2(1) := FND_API.G_FALSE,
450: change_customer_product_id VARCHAR2(1) := FND_API.G_FALSE,
451: change_platform_id VARCHAR2(1) := FND_API.G_FALSE,
452: change_plat_ver_id VARCHAR2(1) := FND_API.G_FALSE,
453: change_cp_comp_id VARCHAR2(1) := FND_API.G_FALSE,
454: change_cp_pro_rev VARCHAR2(1) := FND_API.G_FALSE,

Line 451: change_platform_id VARCHAR2(1) := FND_API.G_FALSE,

447: change_ship_to_contact_id VARCHAR2(1) := FND_API.G_FALSE,
448: change_incident_date VARCHAR2(1) := FND_API.G_FALSE,
449: change_close_date VARCHAR2(1) := FND_API.G_FALSE,
450: change_customer_product_id VARCHAR2(1) := FND_API.G_FALSE,
451: change_platform_id VARCHAR2(1) := FND_API.G_FALSE,
452: change_plat_ver_id VARCHAR2(1) := FND_API.G_FALSE,
453: change_cp_comp_id VARCHAR2(1) := FND_API.G_FALSE,
454: change_cp_pro_rev VARCHAR2(1) := FND_API.G_FALSE,
455: change_cp_comp_ver_id VARCHAR2(1) := FND_API.G_FALSE,

Line 452: change_plat_ver_id VARCHAR2(1) := FND_API.G_FALSE,

448: change_incident_date VARCHAR2(1) := FND_API.G_FALSE,
449: change_close_date VARCHAR2(1) := FND_API.G_FALSE,
450: change_customer_product_id VARCHAR2(1) := FND_API.G_FALSE,
451: change_platform_id VARCHAR2(1) := FND_API.G_FALSE,
452: change_plat_ver_id VARCHAR2(1) := FND_API.G_FALSE,
453: change_cp_comp_id VARCHAR2(1) := FND_API.G_FALSE,
454: change_cp_pro_rev VARCHAR2(1) := FND_API.G_FALSE,
455: change_cp_comp_ver_id VARCHAR2(1) := FND_API.G_FALSE,
456: change_cp_comp_ver VARCHAR2(1) := FND_API.G_FALSE,

Line 453: change_cp_comp_id VARCHAR2(1) := FND_API.G_FALSE,

449: change_close_date VARCHAR2(1) := FND_API.G_FALSE,
450: change_customer_product_id VARCHAR2(1) := FND_API.G_FALSE,
451: change_platform_id VARCHAR2(1) := FND_API.G_FALSE,
452: change_plat_ver_id VARCHAR2(1) := FND_API.G_FALSE,
453: change_cp_comp_id VARCHAR2(1) := FND_API.G_FALSE,
454: change_cp_pro_rev VARCHAR2(1) := FND_API.G_FALSE,
455: change_cp_comp_ver_id VARCHAR2(1) := FND_API.G_FALSE,
456: change_cp_comp_ver VARCHAR2(1) := FND_API.G_FALSE,
457: change_cp_subcomp_id VARCHAR2(1) := FND_API.G_FALSE,

Line 454: change_cp_pro_rev VARCHAR2(1) := FND_API.G_FALSE,

450: change_customer_product_id VARCHAR2(1) := FND_API.G_FALSE,
451: change_platform_id VARCHAR2(1) := FND_API.G_FALSE,
452: change_plat_ver_id VARCHAR2(1) := FND_API.G_FALSE,
453: change_cp_comp_id VARCHAR2(1) := FND_API.G_FALSE,
454: change_cp_pro_rev VARCHAR2(1) := FND_API.G_FALSE,
455: change_cp_comp_ver_id VARCHAR2(1) := FND_API.G_FALSE,
456: change_cp_comp_ver VARCHAR2(1) := FND_API.G_FALSE,
457: change_cp_subcomp_id VARCHAR2(1) := FND_API.G_FALSE,
458: change_cp_subcomp_ver VARCHAR2(1) := FND_API.G_FALSE,

Line 455: change_cp_comp_ver_id VARCHAR2(1) := FND_API.G_FALSE,

451: change_platform_id VARCHAR2(1) := FND_API.G_FALSE,
452: change_plat_ver_id VARCHAR2(1) := FND_API.G_FALSE,
453: change_cp_comp_id VARCHAR2(1) := FND_API.G_FALSE,
454: change_cp_pro_rev VARCHAR2(1) := FND_API.G_FALSE,
455: change_cp_comp_ver_id VARCHAR2(1) := FND_API.G_FALSE,
456: change_cp_comp_ver VARCHAR2(1) := FND_API.G_FALSE,
457: change_cp_subcomp_id VARCHAR2(1) := FND_API.G_FALSE,
458: change_cp_subcomp_ver VARCHAR2(1) := FND_API.G_FALSE,
459: change_cp_subcomp_ver_id VARCHAR2(1) := FND_API.G_FALSE,

Line 456: change_cp_comp_ver VARCHAR2(1) := FND_API.G_FALSE,

452: change_plat_ver_id VARCHAR2(1) := FND_API.G_FALSE,
453: change_cp_comp_id VARCHAR2(1) := FND_API.G_FALSE,
454: change_cp_pro_rev VARCHAR2(1) := FND_API.G_FALSE,
455: change_cp_comp_ver_id VARCHAR2(1) := FND_API.G_FALSE,
456: change_cp_comp_ver VARCHAR2(1) := FND_API.G_FALSE,
457: change_cp_subcomp_id VARCHAR2(1) := FND_API.G_FALSE,
458: change_cp_subcomp_ver VARCHAR2(1) := FND_API.G_FALSE,
459: change_cp_subcomp_ver_id VARCHAR2(1) := FND_API.G_FALSE,
460: change_language_id VARCHAR2(1) := FND_API.G_FALSE,

Line 457: change_cp_subcomp_id VARCHAR2(1) := FND_API.G_FALSE,

453: change_cp_comp_id VARCHAR2(1) := FND_API.G_FALSE,
454: change_cp_pro_rev VARCHAR2(1) := FND_API.G_FALSE,
455: change_cp_comp_ver_id VARCHAR2(1) := FND_API.G_FALSE,
456: change_cp_comp_ver VARCHAR2(1) := FND_API.G_FALSE,
457: change_cp_subcomp_id VARCHAR2(1) := FND_API.G_FALSE,
458: change_cp_subcomp_ver VARCHAR2(1) := FND_API.G_FALSE,
459: change_cp_subcomp_ver_id VARCHAR2(1) := FND_API.G_FALSE,
460: change_language_id VARCHAR2(1) := FND_API.G_FALSE,
461: change_cp_rev_id VARCHAR2(1) := FND_API.G_FALSE,

Line 458: change_cp_subcomp_ver VARCHAR2(1) := FND_API.G_FALSE,

454: change_cp_pro_rev VARCHAR2(1) := FND_API.G_FALSE,
455: change_cp_comp_ver_id VARCHAR2(1) := FND_API.G_FALSE,
456: change_cp_comp_ver VARCHAR2(1) := FND_API.G_FALSE,
457: change_cp_subcomp_id VARCHAR2(1) := FND_API.G_FALSE,
458: change_cp_subcomp_ver VARCHAR2(1) := FND_API.G_FALSE,
459: change_cp_subcomp_ver_id VARCHAR2(1) := FND_API.G_FALSE,
460: change_language_id VARCHAR2(1) := FND_API.G_FALSE,
461: change_cp_rev_id VARCHAR2(1) := FND_API.G_FALSE,
462: change_inv_item_rev VARCHAR2(1) := FND_API.G_FALSE,

Line 459: change_cp_subcomp_ver_id VARCHAR2(1) := FND_API.G_FALSE,

455: change_cp_comp_ver_id VARCHAR2(1) := FND_API.G_FALSE,
456: change_cp_comp_ver VARCHAR2(1) := FND_API.G_FALSE,
457: change_cp_subcomp_id VARCHAR2(1) := FND_API.G_FALSE,
458: change_cp_subcomp_ver VARCHAR2(1) := FND_API.G_FALSE,
459: change_cp_subcomp_ver_id VARCHAR2(1) := FND_API.G_FALSE,
460: change_language_id VARCHAR2(1) := FND_API.G_FALSE,
461: change_cp_rev_id VARCHAR2(1) := FND_API.G_FALSE,
462: change_inv_item_rev VARCHAR2(1) := FND_API.G_FALSE,
463: change_inv_comp_id VARCHAR2(1) := FND_API.G_FALSE,

Line 460: change_language_id VARCHAR2(1) := FND_API.G_FALSE,

456: change_cp_comp_ver VARCHAR2(1) := FND_API.G_FALSE,
457: change_cp_subcomp_id VARCHAR2(1) := FND_API.G_FALSE,
458: change_cp_subcomp_ver VARCHAR2(1) := FND_API.G_FALSE,
459: change_cp_subcomp_ver_id VARCHAR2(1) := FND_API.G_FALSE,
460: change_language_id VARCHAR2(1) := FND_API.G_FALSE,
461: change_cp_rev_id VARCHAR2(1) := FND_API.G_FALSE,
462: change_inv_item_rev VARCHAR2(1) := FND_API.G_FALSE,
463: change_inv_comp_id VARCHAR2(1) := FND_API.G_FALSE,
464: change_inv_comp_ver VARCHAR2(1) := FND_API.G_FALSE,

Line 461: change_cp_rev_id VARCHAR2(1) := FND_API.G_FALSE,

457: change_cp_subcomp_id VARCHAR2(1) := FND_API.G_FALSE,
458: change_cp_subcomp_ver VARCHAR2(1) := FND_API.G_FALSE,
459: change_cp_subcomp_ver_id VARCHAR2(1) := FND_API.G_FALSE,
460: change_language_id VARCHAR2(1) := FND_API.G_FALSE,
461: change_cp_rev_id VARCHAR2(1) := FND_API.G_FALSE,
462: change_inv_item_rev VARCHAR2(1) := FND_API.G_FALSE,
463: change_inv_comp_id VARCHAR2(1) := FND_API.G_FALSE,
464: change_inv_comp_ver VARCHAR2(1) := FND_API.G_FALSE,
465: change_inv_subcomp_id VARCHAR2(1) := FND_API.G_FALSE,

Line 462: change_inv_item_rev VARCHAR2(1) := FND_API.G_FALSE,

458: change_cp_subcomp_ver VARCHAR2(1) := FND_API.G_FALSE,
459: change_cp_subcomp_ver_id VARCHAR2(1) := FND_API.G_FALSE,
460: change_language_id VARCHAR2(1) := FND_API.G_FALSE,
461: change_cp_rev_id VARCHAR2(1) := FND_API.G_FALSE,
462: change_inv_item_rev VARCHAR2(1) := FND_API.G_FALSE,
463: change_inv_comp_id VARCHAR2(1) := FND_API.G_FALSE,
464: change_inv_comp_ver VARCHAR2(1) := FND_API.G_FALSE,
465: change_inv_subcomp_id VARCHAR2(1) := FND_API.G_FALSE,
466: change_inv_subcomp_ver VARCHAR2(1) := FND_API.G_FALSE,

Line 463: change_inv_comp_id VARCHAR2(1) := FND_API.G_FALSE,

459: change_cp_subcomp_ver_id VARCHAR2(1) := FND_API.G_FALSE,
460: change_language_id VARCHAR2(1) := FND_API.G_FALSE,
461: change_cp_rev_id VARCHAR2(1) := FND_API.G_FALSE,
462: change_inv_item_rev VARCHAR2(1) := FND_API.G_FALSE,
463: change_inv_comp_id VARCHAR2(1) := FND_API.G_FALSE,
464: change_inv_comp_ver VARCHAR2(1) := FND_API.G_FALSE,
465: change_inv_subcomp_id VARCHAR2(1) := FND_API.G_FALSE,
466: change_inv_subcomp_ver VARCHAR2(1) := FND_API.G_FALSE,
467: change_territory_id VARCHAR2(1) := FND_API.G_FALSE,

Line 464: change_inv_comp_ver VARCHAR2(1) := FND_API.G_FALSE,

460: change_language_id VARCHAR2(1) := FND_API.G_FALSE,
461: change_cp_rev_id VARCHAR2(1) := FND_API.G_FALSE,
462: change_inv_item_rev VARCHAR2(1) := FND_API.G_FALSE,
463: change_inv_comp_id VARCHAR2(1) := FND_API.G_FALSE,
464: change_inv_comp_ver VARCHAR2(1) := FND_API.G_FALSE,
465: change_inv_subcomp_id VARCHAR2(1) := FND_API.G_FALSE,
466: change_inv_subcomp_ver VARCHAR2(1) := FND_API.G_FALSE,
467: change_territory_id VARCHAR2(1) := FND_API.G_FALSE,
468: change_resource_type VARCHAR2(1) := FND_API.G_FALSE

Line 465: change_inv_subcomp_id VARCHAR2(1) := FND_API.G_FALSE,

461: change_cp_rev_id VARCHAR2(1) := FND_API.G_FALSE,
462: change_inv_item_rev VARCHAR2(1) := FND_API.G_FALSE,
463: change_inv_comp_id VARCHAR2(1) := FND_API.G_FALSE,
464: change_inv_comp_ver VARCHAR2(1) := FND_API.G_FALSE,
465: change_inv_subcomp_id VARCHAR2(1) := FND_API.G_FALSE,
466: change_inv_subcomp_ver VARCHAR2(1) := FND_API.G_FALSE,
467: change_territory_id VARCHAR2(1) := FND_API.G_FALSE,
468: change_resource_type VARCHAR2(1) := FND_API.G_FALSE
469: );

Line 466: change_inv_subcomp_ver VARCHAR2(1) := FND_API.G_FALSE,

462: change_inv_item_rev VARCHAR2(1) := FND_API.G_FALSE,
463: change_inv_comp_id VARCHAR2(1) := FND_API.G_FALSE,
464: change_inv_comp_ver VARCHAR2(1) := FND_API.G_FALSE,
465: change_inv_subcomp_id VARCHAR2(1) := FND_API.G_FALSE,
466: change_inv_subcomp_ver VARCHAR2(1) := FND_API.G_FALSE,
467: change_territory_id VARCHAR2(1) := FND_API.G_FALSE,
468: change_resource_type VARCHAR2(1) := FND_API.G_FALSE
469: );
470:

Line 467: change_territory_id VARCHAR2(1) := FND_API.G_FALSE,

463: change_inv_comp_id VARCHAR2(1) := FND_API.G_FALSE,
464: change_inv_comp_ver VARCHAR2(1) := FND_API.G_FALSE,
465: change_inv_subcomp_id VARCHAR2(1) := FND_API.G_FALSE,
466: change_inv_subcomp_ver VARCHAR2(1) := FND_API.G_FALSE,
467: change_territory_id VARCHAR2(1) := FND_API.G_FALSE,
468: change_resource_type VARCHAR2(1) := FND_API.G_FALSE
469: );
470:
471: TYPE audit_vals_rec_type IS RECORD (

Line 468: change_resource_type VARCHAR2(1) := FND_API.G_FALSE

464: change_inv_comp_ver VARCHAR2(1) := FND_API.G_FALSE,
465: change_inv_subcomp_id VARCHAR2(1) := FND_API.G_FALSE,
466: change_inv_subcomp_ver VARCHAR2(1) := FND_API.G_FALSE,
467: change_territory_id VARCHAR2(1) := FND_API.G_FALSE,
468: change_resource_type VARCHAR2(1) := FND_API.G_FALSE
469: );
470:
471: TYPE audit_vals_rec_type IS RECORD (
472: status_id NUMBER := FND_API.G_MISS_NUM,

Line 472: status_id NUMBER := FND_API.G_MISS_NUM,

468: change_resource_type VARCHAR2(1) := FND_API.G_FALSE
469: );
470:
471: TYPE audit_vals_rec_type IS RECORD (
472: status_id NUMBER := FND_API.G_MISS_NUM,
473: owner_id NUMBER := FND_API.G_MISS_NUM,
474: group_id NUMBER := FND_API.G_MISS_NUM,
475: group_type VARCHAR2(30) :=FND_API.G_MISS_CHAR,
476: owner_assigned_time DATE := FND_API.G_MISS_DATE,

Line 473: owner_id NUMBER := FND_API.G_MISS_NUM,

469: );
470:
471: TYPE audit_vals_rec_type IS RECORD (
472: status_id NUMBER := FND_API.G_MISS_NUM,
473: owner_id NUMBER := FND_API.G_MISS_NUM,
474: group_id NUMBER := FND_API.G_MISS_NUM,
475: group_type VARCHAR2(30) :=FND_API.G_MISS_CHAR,
476: owner_assigned_time DATE := FND_API.G_MISS_DATE,
477: inv_platform_org_id NUMBER := FND_API.G_MISS_NUM,

Line 474: group_id NUMBER := FND_API.G_MISS_NUM,

470:
471: TYPE audit_vals_rec_type IS RECORD (
472: status_id NUMBER := FND_API.G_MISS_NUM,
473: owner_id NUMBER := FND_API.G_MISS_NUM,
474: group_id NUMBER := FND_API.G_MISS_NUM,
475: group_type VARCHAR2(30) :=FND_API.G_MISS_CHAR,
476: owner_assigned_time DATE := FND_API.G_MISS_DATE,
477: inv_platform_org_id NUMBER := FND_API.G_MISS_NUM,
478: type_id NUMBER := FND_API.G_MISS_NUM,

Line 475: group_type VARCHAR2(30) :=FND_API.G_MISS_CHAR,

471: TYPE audit_vals_rec_type IS RECORD (
472: status_id NUMBER := FND_API.G_MISS_NUM,
473: owner_id NUMBER := FND_API.G_MISS_NUM,
474: group_id NUMBER := FND_API.G_MISS_NUM,
475: group_type VARCHAR2(30) :=FND_API.G_MISS_CHAR,
476: owner_assigned_time DATE := FND_API.G_MISS_DATE,
477: inv_platform_org_id NUMBER := FND_API.G_MISS_NUM,
478: type_id NUMBER := FND_API.G_MISS_NUM,
479: urgency_id NUMBER := FND_API.G_MISS_NUM,

Line 476: owner_assigned_time DATE := FND_API.G_MISS_DATE,

472: status_id NUMBER := FND_API.G_MISS_NUM,
473: owner_id NUMBER := FND_API.G_MISS_NUM,
474: group_id NUMBER := FND_API.G_MISS_NUM,
475: group_type VARCHAR2(30) :=FND_API.G_MISS_CHAR,
476: owner_assigned_time DATE := FND_API.G_MISS_DATE,
477: inv_platform_org_id NUMBER := FND_API.G_MISS_NUM,
478: type_id NUMBER := FND_API.G_MISS_NUM,
479: urgency_id NUMBER := FND_API.G_MISS_NUM,
480: severity_id NUMBER := FND_API.G_MISS_NUM,

Line 477: inv_platform_org_id NUMBER := FND_API.G_MISS_NUM,

473: owner_id NUMBER := FND_API.G_MISS_NUM,
474: group_id NUMBER := FND_API.G_MISS_NUM,
475: group_type VARCHAR2(30) :=FND_API.G_MISS_CHAR,
476: owner_assigned_time DATE := FND_API.G_MISS_DATE,
477: inv_platform_org_id NUMBER := FND_API.G_MISS_NUM,
478: type_id NUMBER := FND_API.G_MISS_NUM,
479: urgency_id NUMBER := FND_API.G_MISS_NUM,
480: severity_id NUMBER := FND_API.G_MISS_NUM,
481: exp_res_date DATE := FND_API.G_MISS_DATE,

Line 478: type_id NUMBER := FND_API.G_MISS_NUM,

474: group_id NUMBER := FND_API.G_MISS_NUM,
475: group_type VARCHAR2(30) :=FND_API.G_MISS_CHAR,
476: owner_assigned_time DATE := FND_API.G_MISS_DATE,
477: inv_platform_org_id NUMBER := FND_API.G_MISS_NUM,
478: type_id NUMBER := FND_API.G_MISS_NUM,
479: urgency_id NUMBER := FND_API.G_MISS_NUM,
480: severity_id NUMBER := FND_API.G_MISS_NUM,
481: exp_res_date DATE := FND_API.G_MISS_DATE,
482: obligation_date DATE := FND_API.G_MISS_DATE,

Line 479: urgency_id NUMBER := FND_API.G_MISS_NUM,

475: group_type VARCHAR2(30) :=FND_API.G_MISS_CHAR,
476: owner_assigned_time DATE := FND_API.G_MISS_DATE,
477: inv_platform_org_id NUMBER := FND_API.G_MISS_NUM,
478: type_id NUMBER := FND_API.G_MISS_NUM,
479: urgency_id NUMBER := FND_API.G_MISS_NUM,
480: severity_id NUMBER := FND_API.G_MISS_NUM,
481: exp_res_date DATE := FND_API.G_MISS_DATE,
482: obligation_date DATE := FND_API.G_MISS_DATE,
483: site_id NUMBER := FND_API.G_MISS_NUM,

Line 480: severity_id NUMBER := FND_API.G_MISS_NUM,

476: owner_assigned_time DATE := FND_API.G_MISS_DATE,
477: inv_platform_org_id NUMBER := FND_API.G_MISS_NUM,
478: type_id NUMBER := FND_API.G_MISS_NUM,
479: urgency_id NUMBER := FND_API.G_MISS_NUM,
480: severity_id NUMBER := FND_API.G_MISS_NUM,
481: exp_res_date DATE := FND_API.G_MISS_DATE,
482: obligation_date DATE := FND_API.G_MISS_DATE,
483: site_id NUMBER := FND_API.G_MISS_NUM,
484: contact_id NUMBER := FND_API.G_MISS_NUM,

Line 481: exp_res_date DATE := FND_API.G_MISS_DATE,

477: inv_platform_org_id NUMBER := FND_API.G_MISS_NUM,
478: type_id NUMBER := FND_API.G_MISS_NUM,
479: urgency_id NUMBER := FND_API.G_MISS_NUM,
480: severity_id NUMBER := FND_API.G_MISS_NUM,
481: exp_res_date DATE := FND_API.G_MISS_DATE,
482: obligation_date DATE := FND_API.G_MISS_DATE,
483: site_id NUMBER := FND_API.G_MISS_NUM,
484: contact_id NUMBER := FND_API.G_MISS_NUM,
485: bill_to_contact_id NUMBER := FND_API.G_MISS_NUM,

Line 482: obligation_date DATE := FND_API.G_MISS_DATE,

478: type_id NUMBER := FND_API.G_MISS_NUM,
479: urgency_id NUMBER := FND_API.G_MISS_NUM,
480: severity_id NUMBER := FND_API.G_MISS_NUM,
481: exp_res_date DATE := FND_API.G_MISS_DATE,
482: obligation_date DATE := FND_API.G_MISS_DATE,
483: site_id NUMBER := FND_API.G_MISS_NUM,
484: contact_id NUMBER := FND_API.G_MISS_NUM,
485: bill_to_contact_id NUMBER := FND_API.G_MISS_NUM,
486: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,

Line 483: site_id NUMBER := FND_API.G_MISS_NUM,

479: urgency_id NUMBER := FND_API.G_MISS_NUM,
480: severity_id NUMBER := FND_API.G_MISS_NUM,
481: exp_res_date DATE := FND_API.G_MISS_DATE,
482: obligation_date DATE := FND_API.G_MISS_DATE,
483: site_id NUMBER := FND_API.G_MISS_NUM,
484: contact_id NUMBER := FND_API.G_MISS_NUM,
485: bill_to_contact_id NUMBER := FND_API.G_MISS_NUM,
486: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,
487: incident_date DATE := FND_API.G_MISS_DATE,

Line 484: contact_id NUMBER := FND_API.G_MISS_NUM,

480: severity_id NUMBER := FND_API.G_MISS_NUM,
481: exp_res_date DATE := FND_API.G_MISS_DATE,
482: obligation_date DATE := FND_API.G_MISS_DATE,
483: site_id NUMBER := FND_API.G_MISS_NUM,
484: contact_id NUMBER := FND_API.G_MISS_NUM,
485: bill_to_contact_id NUMBER := FND_API.G_MISS_NUM,
486: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,
487: incident_date DATE := FND_API.G_MISS_DATE,
488: close_date DATE := FND_API.G_MISS_DATE,

Line 485: bill_to_contact_id NUMBER := FND_API.G_MISS_NUM,

481: exp_res_date DATE := FND_API.G_MISS_DATE,
482: obligation_date DATE := FND_API.G_MISS_DATE,
483: site_id NUMBER := FND_API.G_MISS_NUM,
484: contact_id NUMBER := FND_API.G_MISS_NUM,
485: bill_to_contact_id NUMBER := FND_API.G_MISS_NUM,
486: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,
487: incident_date DATE := FND_API.G_MISS_DATE,
488: close_date DATE := FND_API.G_MISS_DATE,
489: customer_product_id NUMBER := FND_API.G_MISS_NUM,

Line 486: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,

482: obligation_date DATE := FND_API.G_MISS_DATE,
483: site_id NUMBER := FND_API.G_MISS_NUM,
484: contact_id NUMBER := FND_API.G_MISS_NUM,
485: bill_to_contact_id NUMBER := FND_API.G_MISS_NUM,
486: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,
487: incident_date DATE := FND_API.G_MISS_DATE,
488: close_date DATE := FND_API.G_MISS_DATE,
489: customer_product_id NUMBER := FND_API.G_MISS_NUM,
490: platform_id NUMBER := FND_API.G_MISS_NUM,

Line 487: incident_date DATE := FND_API.G_MISS_DATE,

483: site_id NUMBER := FND_API.G_MISS_NUM,
484: contact_id NUMBER := FND_API.G_MISS_NUM,
485: bill_to_contact_id NUMBER := FND_API.G_MISS_NUM,
486: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,
487: incident_date DATE := FND_API.G_MISS_DATE,
488: close_date DATE := FND_API.G_MISS_DATE,
489: customer_product_id NUMBER := FND_API.G_MISS_NUM,
490: platform_id NUMBER := FND_API.G_MISS_NUM,
491: platform_version_id NUMBER := FND_API.G_MISS_NUM,

Line 488: close_date DATE := FND_API.G_MISS_DATE,

484: contact_id NUMBER := FND_API.G_MISS_NUM,
485: bill_to_contact_id NUMBER := FND_API.G_MISS_NUM,
486: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,
487: incident_date DATE := FND_API.G_MISS_DATE,
488: close_date DATE := FND_API.G_MISS_DATE,
489: customer_product_id NUMBER := FND_API.G_MISS_NUM,
490: platform_id NUMBER := FND_API.G_MISS_NUM,
491: platform_version_id NUMBER := FND_API.G_MISS_NUM,
492: cp_component_id NUMBER := FND_API.G_MISS_NUM,

Line 489: customer_product_id NUMBER := FND_API.G_MISS_NUM,

485: bill_to_contact_id NUMBER := FND_API.G_MISS_NUM,
486: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,
487: incident_date DATE := FND_API.G_MISS_DATE,
488: close_date DATE := FND_API.G_MISS_DATE,
489: customer_product_id NUMBER := FND_API.G_MISS_NUM,
490: platform_id NUMBER := FND_API.G_MISS_NUM,
491: platform_version_id NUMBER := FND_API.G_MISS_NUM,
492: cp_component_id NUMBER := FND_API.G_MISS_NUM,
493: product_revision VARCHAR2(240):= FND_API.G_MISS_CHAR,

Line 490: platform_id NUMBER := FND_API.G_MISS_NUM,

486: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,
487: incident_date DATE := FND_API.G_MISS_DATE,
488: close_date DATE := FND_API.G_MISS_DATE,
489: customer_product_id NUMBER := FND_API.G_MISS_NUM,
490: platform_id NUMBER := FND_API.G_MISS_NUM,
491: platform_version_id NUMBER := FND_API.G_MISS_NUM,
492: cp_component_id NUMBER := FND_API.G_MISS_NUM,
493: product_revision VARCHAR2(240):= FND_API.G_MISS_CHAR,
494: cp_component_version_id NUMBER := FND_API.G_MISS_NUM,

Line 491: platform_version_id NUMBER := FND_API.G_MISS_NUM,

487: incident_date DATE := FND_API.G_MISS_DATE,
488: close_date DATE := FND_API.G_MISS_DATE,
489: customer_product_id NUMBER := FND_API.G_MISS_NUM,
490: platform_id NUMBER := FND_API.G_MISS_NUM,
491: platform_version_id NUMBER := FND_API.G_MISS_NUM,
492: cp_component_id NUMBER := FND_API.G_MISS_NUM,
493: product_revision VARCHAR2(240):= FND_API.G_MISS_CHAR,
494: cp_component_version_id NUMBER := FND_API.G_MISS_NUM,
495: component_version VARCHAR2(3):= FND_API.G_MISS_CHAR,

Line 492: cp_component_id NUMBER := FND_API.G_MISS_NUM,

488: close_date DATE := FND_API.G_MISS_DATE,
489: customer_product_id NUMBER := FND_API.G_MISS_NUM,
490: platform_id NUMBER := FND_API.G_MISS_NUM,
491: platform_version_id NUMBER := FND_API.G_MISS_NUM,
492: cp_component_id NUMBER := FND_API.G_MISS_NUM,
493: product_revision VARCHAR2(240):= FND_API.G_MISS_CHAR,
494: cp_component_version_id NUMBER := FND_API.G_MISS_NUM,
495: component_version VARCHAR2(3):= FND_API.G_MISS_CHAR,
496: cp_subcomponent_id NUMBER := FND_API.G_MISS_NUM,

Line 493: product_revision VARCHAR2(240):= FND_API.G_MISS_CHAR,

489: customer_product_id NUMBER := FND_API.G_MISS_NUM,
490: platform_id NUMBER := FND_API.G_MISS_NUM,
491: platform_version_id NUMBER := FND_API.G_MISS_NUM,
492: cp_component_id NUMBER := FND_API.G_MISS_NUM,
493: product_revision VARCHAR2(240):= FND_API.G_MISS_CHAR,
494: cp_component_version_id NUMBER := FND_API.G_MISS_NUM,
495: component_version VARCHAR2(3):= FND_API.G_MISS_CHAR,
496: cp_subcomponent_id NUMBER := FND_API.G_MISS_NUM,
497: cp_subcomponent_version_id NUMBER := FND_API.G_MISS_NUM,

Line 494: cp_component_version_id NUMBER := FND_API.G_MISS_NUM,

490: platform_id NUMBER := FND_API.G_MISS_NUM,
491: platform_version_id NUMBER := FND_API.G_MISS_NUM,
492: cp_component_id NUMBER := FND_API.G_MISS_NUM,
493: product_revision VARCHAR2(240):= FND_API.G_MISS_CHAR,
494: cp_component_version_id NUMBER := FND_API.G_MISS_NUM,
495: component_version VARCHAR2(3):= FND_API.G_MISS_CHAR,
496: cp_subcomponent_id NUMBER := FND_API.G_MISS_NUM,
497: cp_subcomponent_version_id NUMBER := FND_API.G_MISS_NUM,
498: subcomponent_version VARCHAR2(3):= FND_API.G_MISS_CHAR,

Line 495: component_version VARCHAR2(3):= FND_API.G_MISS_CHAR,

491: platform_version_id NUMBER := FND_API.G_MISS_NUM,
492: cp_component_id NUMBER := FND_API.G_MISS_NUM,
493: product_revision VARCHAR2(240):= FND_API.G_MISS_CHAR,
494: cp_component_version_id NUMBER := FND_API.G_MISS_NUM,
495: component_version VARCHAR2(3):= FND_API.G_MISS_CHAR,
496: cp_subcomponent_id NUMBER := FND_API.G_MISS_NUM,
497: cp_subcomponent_version_id NUMBER := FND_API.G_MISS_NUM,
498: subcomponent_version VARCHAR2(3):= FND_API.G_MISS_CHAR,
499: language_id NUMBER := FND_API.G_MISS_NUM,

Line 496: cp_subcomponent_id NUMBER := FND_API.G_MISS_NUM,

492: cp_component_id NUMBER := FND_API.G_MISS_NUM,
493: product_revision VARCHAR2(240):= FND_API.G_MISS_CHAR,
494: cp_component_version_id NUMBER := FND_API.G_MISS_NUM,
495: component_version VARCHAR2(3):= FND_API.G_MISS_CHAR,
496: cp_subcomponent_id NUMBER := FND_API.G_MISS_NUM,
497: cp_subcomponent_version_id NUMBER := FND_API.G_MISS_NUM,
498: subcomponent_version VARCHAR2(3):= FND_API.G_MISS_CHAR,
499: language_id NUMBER := FND_API.G_MISS_NUM,
500: cp_revision_id NUMBER := FND_API.G_MISS_NUM,

Line 497: cp_subcomponent_version_id NUMBER := FND_API.G_MISS_NUM,

493: product_revision VARCHAR2(240):= FND_API.G_MISS_CHAR,
494: cp_component_version_id NUMBER := FND_API.G_MISS_NUM,
495: component_version VARCHAR2(3):= FND_API.G_MISS_CHAR,
496: cp_subcomponent_id NUMBER := FND_API.G_MISS_NUM,
497: cp_subcomponent_version_id NUMBER := FND_API.G_MISS_NUM,
498: subcomponent_version VARCHAR2(3):= FND_API.G_MISS_CHAR,
499: language_id NUMBER := FND_API.G_MISS_NUM,
500: cp_revision_id NUMBER := FND_API.G_MISS_NUM,
501: inv_item_revision VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 498: subcomponent_version VARCHAR2(3):= FND_API.G_MISS_CHAR,

494: cp_component_version_id NUMBER := FND_API.G_MISS_NUM,
495: component_version VARCHAR2(3):= FND_API.G_MISS_CHAR,
496: cp_subcomponent_id NUMBER := FND_API.G_MISS_NUM,
497: cp_subcomponent_version_id NUMBER := FND_API.G_MISS_NUM,
498: subcomponent_version VARCHAR2(3):= FND_API.G_MISS_CHAR,
499: language_id NUMBER := FND_API.G_MISS_NUM,
500: cp_revision_id NUMBER := FND_API.G_MISS_NUM,
501: inv_item_revision VARCHAR2(240) := FND_API.G_MISS_CHAR,
502: inv_component_id NUMBER := FND_API.G_MISS_NUM,

Line 499: language_id NUMBER := FND_API.G_MISS_NUM,

495: component_version VARCHAR2(3):= FND_API.G_MISS_CHAR,
496: cp_subcomponent_id NUMBER := FND_API.G_MISS_NUM,
497: cp_subcomponent_version_id NUMBER := FND_API.G_MISS_NUM,
498: subcomponent_version VARCHAR2(3):= FND_API.G_MISS_CHAR,
499: language_id NUMBER := FND_API.G_MISS_NUM,
500: cp_revision_id NUMBER := FND_API.G_MISS_NUM,
501: inv_item_revision VARCHAR2(240) := FND_API.G_MISS_CHAR,
502: inv_component_id NUMBER := FND_API.G_MISS_NUM,
503: inv_component_version VARCHAR2(90) := FND_API.G_MISS_CHAR,

Line 500: cp_revision_id NUMBER := FND_API.G_MISS_NUM,

496: cp_subcomponent_id NUMBER := FND_API.G_MISS_NUM,
497: cp_subcomponent_version_id NUMBER := FND_API.G_MISS_NUM,
498: subcomponent_version VARCHAR2(3):= FND_API.G_MISS_CHAR,
499: language_id NUMBER := FND_API.G_MISS_NUM,
500: cp_revision_id NUMBER := FND_API.G_MISS_NUM,
501: inv_item_revision VARCHAR2(240) := FND_API.G_MISS_CHAR,
502: inv_component_id NUMBER := FND_API.G_MISS_NUM,
503: inv_component_version VARCHAR2(90) := FND_API.G_MISS_CHAR,
504: inv_subcomponent_id NUMBER := FND_API.G_MISS_NUM,

Line 501: inv_item_revision VARCHAR2(240) := FND_API.G_MISS_CHAR,

497: cp_subcomponent_version_id NUMBER := FND_API.G_MISS_NUM,
498: subcomponent_version VARCHAR2(3):= FND_API.G_MISS_CHAR,
499: language_id NUMBER := FND_API.G_MISS_NUM,
500: cp_revision_id NUMBER := FND_API.G_MISS_NUM,
501: inv_item_revision VARCHAR2(240) := FND_API.G_MISS_CHAR,
502: inv_component_id NUMBER := FND_API.G_MISS_NUM,
503: inv_component_version VARCHAR2(90) := FND_API.G_MISS_CHAR,
504: inv_subcomponent_id NUMBER := FND_API.G_MISS_NUM,
505: inv_subcomponent_version VARCHAR2(90) := FND_API.G_MISS_CHAR,

Line 502: inv_component_id NUMBER := FND_API.G_MISS_NUM,

498: subcomponent_version VARCHAR2(3):= FND_API.G_MISS_CHAR,
499: language_id NUMBER := FND_API.G_MISS_NUM,
500: cp_revision_id NUMBER := FND_API.G_MISS_NUM,
501: inv_item_revision VARCHAR2(240) := FND_API.G_MISS_CHAR,
502: inv_component_id NUMBER := FND_API.G_MISS_NUM,
503: inv_component_version VARCHAR2(90) := FND_API.G_MISS_CHAR,
504: inv_subcomponent_id NUMBER := FND_API.G_MISS_NUM,
505: inv_subcomponent_version VARCHAR2(90) := FND_API.G_MISS_CHAR,
506: territory_id NUMBER := FND_API.G_MISS_NUM,

Line 503: inv_component_version VARCHAR2(90) := FND_API.G_MISS_CHAR,

499: language_id NUMBER := FND_API.G_MISS_NUM,
500: cp_revision_id NUMBER := FND_API.G_MISS_NUM,
501: inv_item_revision VARCHAR2(240) := FND_API.G_MISS_CHAR,
502: inv_component_id NUMBER := FND_API.G_MISS_NUM,
503: inv_component_version VARCHAR2(90) := FND_API.G_MISS_CHAR,
504: inv_subcomponent_id NUMBER := FND_API.G_MISS_NUM,
505: inv_subcomponent_version VARCHAR2(90) := FND_API.G_MISS_CHAR,
506: territory_id NUMBER := FND_API.G_MISS_NUM,
507: resource_type VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 504: inv_subcomponent_id NUMBER := FND_API.G_MISS_NUM,

500: cp_revision_id NUMBER := FND_API.G_MISS_NUM,
501: inv_item_revision VARCHAR2(240) := FND_API.G_MISS_CHAR,
502: inv_component_id NUMBER := FND_API.G_MISS_NUM,
503: inv_component_version VARCHAR2(90) := FND_API.G_MISS_CHAR,
504: inv_subcomponent_id NUMBER := FND_API.G_MISS_NUM,
505: inv_subcomponent_version VARCHAR2(90) := FND_API.G_MISS_CHAR,
506: territory_id NUMBER := FND_API.G_MISS_NUM,
507: resource_type VARCHAR2(30) := FND_API.G_MISS_CHAR
508: );

Line 505: inv_subcomponent_version VARCHAR2(90) := FND_API.G_MISS_CHAR,

501: inv_item_revision VARCHAR2(240) := FND_API.G_MISS_CHAR,
502: inv_component_id NUMBER := FND_API.G_MISS_NUM,
503: inv_component_version VARCHAR2(90) := FND_API.G_MISS_CHAR,
504: inv_subcomponent_id NUMBER := FND_API.G_MISS_NUM,
505: inv_subcomponent_version VARCHAR2(90) := FND_API.G_MISS_CHAR,
506: territory_id NUMBER := FND_API.G_MISS_NUM,
507: resource_type VARCHAR2(30) := FND_API.G_MISS_CHAR
508: );
509: G_MISS_AUDIT_VALS_REC audit_vals_rec_type;

Line 506: territory_id NUMBER := FND_API.G_MISS_NUM,

502: inv_component_id NUMBER := FND_API.G_MISS_NUM,
503: inv_component_version VARCHAR2(90) := FND_API.G_MISS_CHAR,
504: inv_subcomponent_id NUMBER := FND_API.G_MISS_NUM,
505: inv_subcomponent_version VARCHAR2(90) := FND_API.G_MISS_CHAR,
506: territory_id NUMBER := FND_API.G_MISS_NUM,
507: resource_type VARCHAR2(30) := FND_API.G_MISS_CHAR
508: );
509: G_MISS_AUDIT_VALS_REC audit_vals_rec_type;
510: ********** End of Comments - Use the Ne Audit Record ***/

Line 507: resource_type VARCHAR2(30) := FND_API.G_MISS_CHAR

503: inv_component_version VARCHAR2(90) := FND_API.G_MISS_CHAR,
504: inv_subcomponent_id NUMBER := FND_API.G_MISS_NUM,
505: inv_subcomponent_version VARCHAR2(90) := FND_API.G_MISS_CHAR,
506: territory_id NUMBER := FND_API.G_MISS_NUM,
507: resource_type VARCHAR2(30) := FND_API.G_MISS_CHAR
508: );
509: G_MISS_AUDIT_VALS_REC audit_vals_rec_type;
510: ********** End of Comments - Use the Ne Audit Record ***/
511:

Line 966: NOTE_ID NUMBER := FND_API.G_MISS_NUM,

962: -- A table within a record type is not possible. That's why I defined
963: -- three context fields in the following record type.
964: --
965: TYPE notes_rec IS RECORD (
966: NOTE_ID NUMBER := FND_API.G_MISS_NUM,
967: NOTE VARCHAR2(2000) := FND_API.G_MISS_CHAR,
968: NOTE_DETAIL VARCHAR2(32767) := FND_API.G_MISS_CHAR,
969: NOTE_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
970: NOTE_STATUS VARCHAR2(240) := FND_API.G_MISS_CHAR,

Line 967: NOTE VARCHAR2(2000) := FND_API.G_MISS_CHAR,

963: -- three context fields in the following record type.
964: --
965: TYPE notes_rec IS RECORD (
966: NOTE_ID NUMBER := FND_API.G_MISS_NUM,
967: NOTE VARCHAR2(2000) := FND_API.G_MISS_CHAR,
968: NOTE_DETAIL VARCHAR2(32767) := FND_API.G_MISS_CHAR,
969: NOTE_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
970: NOTE_STATUS VARCHAR2(240) := FND_API.G_MISS_CHAR,
971: ENTERED_BY NUMBER := FND_API.G_MISS_NUM,

Line 968: NOTE_DETAIL VARCHAR2(32767) := FND_API.G_MISS_CHAR,

964: --
965: TYPE notes_rec IS RECORD (
966: NOTE_ID NUMBER := FND_API.G_MISS_NUM,
967: NOTE VARCHAR2(2000) := FND_API.G_MISS_CHAR,
968: NOTE_DETAIL VARCHAR2(32767) := FND_API.G_MISS_CHAR,
969: NOTE_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
970: NOTE_STATUS VARCHAR2(240) := FND_API.G_MISS_CHAR,
971: ENTERED_BY NUMBER := FND_API.G_MISS_NUM,
972: ENTERED_DATE DATE := FND_API.G_MISS_DATE,

Line 969: NOTE_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,

965: TYPE notes_rec IS RECORD (
966: NOTE_ID NUMBER := FND_API.G_MISS_NUM,
967: NOTE VARCHAR2(2000) := FND_API.G_MISS_CHAR,
968: NOTE_DETAIL VARCHAR2(32767) := FND_API.G_MISS_CHAR,
969: NOTE_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
970: NOTE_STATUS VARCHAR2(240) := FND_API.G_MISS_CHAR,
971: ENTERED_BY NUMBER := FND_API.G_MISS_NUM,
972: ENTERED_DATE DATE := FND_API.G_MISS_DATE,
973: SOURCE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,

Line 970: NOTE_STATUS VARCHAR2(240) := FND_API.G_MISS_CHAR,

966: NOTE_ID NUMBER := FND_API.G_MISS_NUM,
967: NOTE VARCHAR2(2000) := FND_API.G_MISS_CHAR,
968: NOTE_DETAIL VARCHAR2(32767) := FND_API.G_MISS_CHAR,
969: NOTE_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
970: NOTE_STATUS VARCHAR2(240) := FND_API.G_MISS_CHAR,
971: ENTERED_BY NUMBER := FND_API.G_MISS_NUM,
972: ENTERED_DATE DATE := FND_API.G_MISS_DATE,
973: SOURCE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
974: SOURCE_OBJECT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 971: ENTERED_BY NUMBER := FND_API.G_MISS_NUM,

967: NOTE VARCHAR2(2000) := FND_API.G_MISS_CHAR,
968: NOTE_DETAIL VARCHAR2(32767) := FND_API.G_MISS_CHAR,
969: NOTE_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
970: NOTE_STATUS VARCHAR2(240) := FND_API.G_MISS_CHAR,
971: ENTERED_BY NUMBER := FND_API.G_MISS_NUM,
972: ENTERED_DATE DATE := FND_API.G_MISS_DATE,
973: SOURCE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
974: SOURCE_OBJECT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
975: NOTE_CONTEXT_ID_01 NUMBER := FND_API.G_MISS_NUM,

Line 972: ENTERED_DATE DATE := FND_API.G_MISS_DATE,

968: NOTE_DETAIL VARCHAR2(32767) := FND_API.G_MISS_CHAR,
969: NOTE_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
970: NOTE_STATUS VARCHAR2(240) := FND_API.G_MISS_CHAR,
971: ENTERED_BY NUMBER := FND_API.G_MISS_NUM,
972: ENTERED_DATE DATE := FND_API.G_MISS_DATE,
973: SOURCE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
974: SOURCE_OBJECT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
975: NOTE_CONTEXT_ID_01 NUMBER := FND_API.G_MISS_NUM,
976: NOTE_CONTEXT_TYPE_01 VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 973: SOURCE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,

969: NOTE_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
970: NOTE_STATUS VARCHAR2(240) := FND_API.G_MISS_CHAR,
971: ENTERED_BY NUMBER := FND_API.G_MISS_NUM,
972: ENTERED_DATE DATE := FND_API.G_MISS_DATE,
973: SOURCE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
974: SOURCE_OBJECT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
975: NOTE_CONTEXT_ID_01 NUMBER := FND_API.G_MISS_NUM,
976: NOTE_CONTEXT_TYPE_01 VARCHAR2(30) := FND_API.G_MISS_CHAR,
977: NOTE_CONTEXT_TYPE_ID_01 NUMBER := FND_API.G_MISS_NUM,

Line 974: SOURCE_OBJECT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

970: NOTE_STATUS VARCHAR2(240) := FND_API.G_MISS_CHAR,
971: ENTERED_BY NUMBER := FND_API.G_MISS_NUM,
972: ENTERED_DATE DATE := FND_API.G_MISS_DATE,
973: SOURCE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
974: SOURCE_OBJECT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
975: NOTE_CONTEXT_ID_01 NUMBER := FND_API.G_MISS_NUM,
976: NOTE_CONTEXT_TYPE_01 VARCHAR2(30) := FND_API.G_MISS_CHAR,
977: NOTE_CONTEXT_TYPE_ID_01 NUMBER := FND_API.G_MISS_NUM,
978: NOTE_CONTEXT_ID_02 NUMBER := FND_API.G_MISS_NUM,

Line 975: NOTE_CONTEXT_ID_01 NUMBER := FND_API.G_MISS_NUM,

971: ENTERED_BY NUMBER := FND_API.G_MISS_NUM,
972: ENTERED_DATE DATE := FND_API.G_MISS_DATE,
973: SOURCE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
974: SOURCE_OBJECT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
975: NOTE_CONTEXT_ID_01 NUMBER := FND_API.G_MISS_NUM,
976: NOTE_CONTEXT_TYPE_01 VARCHAR2(30) := FND_API.G_MISS_CHAR,
977: NOTE_CONTEXT_TYPE_ID_01 NUMBER := FND_API.G_MISS_NUM,
978: NOTE_CONTEXT_ID_02 NUMBER := FND_API.G_MISS_NUM,
979: NOTE_CONTEXT_TYPE_02 VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 976: NOTE_CONTEXT_TYPE_01 VARCHAR2(30) := FND_API.G_MISS_CHAR,

972: ENTERED_DATE DATE := FND_API.G_MISS_DATE,
973: SOURCE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
974: SOURCE_OBJECT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
975: NOTE_CONTEXT_ID_01 NUMBER := FND_API.G_MISS_NUM,
976: NOTE_CONTEXT_TYPE_01 VARCHAR2(30) := FND_API.G_MISS_CHAR,
977: NOTE_CONTEXT_TYPE_ID_01 NUMBER := FND_API.G_MISS_NUM,
978: NOTE_CONTEXT_ID_02 NUMBER := FND_API.G_MISS_NUM,
979: NOTE_CONTEXT_TYPE_02 VARCHAR2(30) := FND_API.G_MISS_CHAR,
980: NOTE_CONTEXT_TYPE_ID_02 NUMBER := FND_API.G_MISS_NUM,

Line 977: NOTE_CONTEXT_TYPE_ID_01 NUMBER := FND_API.G_MISS_NUM,

973: SOURCE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
974: SOURCE_OBJECT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
975: NOTE_CONTEXT_ID_01 NUMBER := FND_API.G_MISS_NUM,
976: NOTE_CONTEXT_TYPE_01 VARCHAR2(30) := FND_API.G_MISS_CHAR,
977: NOTE_CONTEXT_TYPE_ID_01 NUMBER := FND_API.G_MISS_NUM,
978: NOTE_CONTEXT_ID_02 NUMBER := FND_API.G_MISS_NUM,
979: NOTE_CONTEXT_TYPE_02 VARCHAR2(30) := FND_API.G_MISS_CHAR,
980: NOTE_CONTEXT_TYPE_ID_02 NUMBER := FND_API.G_MISS_NUM,
981: NOTE_CONTEXT_ID_03 NUMBER := FND_API.G_MISS_NUM,

Line 978: NOTE_CONTEXT_ID_02 NUMBER := FND_API.G_MISS_NUM,

974: SOURCE_OBJECT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
975: NOTE_CONTEXT_ID_01 NUMBER := FND_API.G_MISS_NUM,
976: NOTE_CONTEXT_TYPE_01 VARCHAR2(30) := FND_API.G_MISS_CHAR,
977: NOTE_CONTEXT_TYPE_ID_01 NUMBER := FND_API.G_MISS_NUM,
978: NOTE_CONTEXT_ID_02 NUMBER := FND_API.G_MISS_NUM,
979: NOTE_CONTEXT_TYPE_02 VARCHAR2(30) := FND_API.G_MISS_CHAR,
980: NOTE_CONTEXT_TYPE_ID_02 NUMBER := FND_API.G_MISS_NUM,
981: NOTE_CONTEXT_ID_03 NUMBER := FND_API.G_MISS_NUM,
982: NOTE_CONTEXT_TYPE_03 VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 979: NOTE_CONTEXT_TYPE_02 VARCHAR2(30) := FND_API.G_MISS_CHAR,

975: NOTE_CONTEXT_ID_01 NUMBER := FND_API.G_MISS_NUM,
976: NOTE_CONTEXT_TYPE_01 VARCHAR2(30) := FND_API.G_MISS_CHAR,
977: NOTE_CONTEXT_TYPE_ID_01 NUMBER := FND_API.G_MISS_NUM,
978: NOTE_CONTEXT_ID_02 NUMBER := FND_API.G_MISS_NUM,
979: NOTE_CONTEXT_TYPE_02 VARCHAR2(30) := FND_API.G_MISS_CHAR,
980: NOTE_CONTEXT_TYPE_ID_02 NUMBER := FND_API.G_MISS_NUM,
981: NOTE_CONTEXT_ID_03 NUMBER := FND_API.G_MISS_NUM,
982: NOTE_CONTEXT_TYPE_03 VARCHAR2(30) := FND_API.G_MISS_CHAR,
983: NOTE_CONTEXT_TYPE_ID_03 NUMBER := FND_API.G_MISS_NUM,

Line 980: NOTE_CONTEXT_TYPE_ID_02 NUMBER := FND_API.G_MISS_NUM,

976: NOTE_CONTEXT_TYPE_01 VARCHAR2(30) := FND_API.G_MISS_CHAR,
977: NOTE_CONTEXT_TYPE_ID_01 NUMBER := FND_API.G_MISS_NUM,
978: NOTE_CONTEXT_ID_02 NUMBER := FND_API.G_MISS_NUM,
979: NOTE_CONTEXT_TYPE_02 VARCHAR2(30) := FND_API.G_MISS_CHAR,
980: NOTE_CONTEXT_TYPE_ID_02 NUMBER := FND_API.G_MISS_NUM,
981: NOTE_CONTEXT_ID_03 NUMBER := FND_API.G_MISS_NUM,
982: NOTE_CONTEXT_TYPE_03 VARCHAR2(30) := FND_API.G_MISS_CHAR,
983: NOTE_CONTEXT_TYPE_ID_03 NUMBER := FND_API.G_MISS_NUM,
984: ATTRIBUTE_1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 981: NOTE_CONTEXT_ID_03 NUMBER := FND_API.G_MISS_NUM,

977: NOTE_CONTEXT_TYPE_ID_01 NUMBER := FND_API.G_MISS_NUM,
978: NOTE_CONTEXT_ID_02 NUMBER := FND_API.G_MISS_NUM,
979: NOTE_CONTEXT_TYPE_02 VARCHAR2(30) := FND_API.G_MISS_CHAR,
980: NOTE_CONTEXT_TYPE_ID_02 NUMBER := FND_API.G_MISS_NUM,
981: NOTE_CONTEXT_ID_03 NUMBER := FND_API.G_MISS_NUM,
982: NOTE_CONTEXT_TYPE_03 VARCHAR2(30) := FND_API.G_MISS_CHAR,
983: NOTE_CONTEXT_TYPE_ID_03 NUMBER := FND_API.G_MISS_NUM,
984: ATTRIBUTE_1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
985: ATTRIBUTE_2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 982: NOTE_CONTEXT_TYPE_03 VARCHAR2(30) := FND_API.G_MISS_CHAR,

978: NOTE_CONTEXT_ID_02 NUMBER := FND_API.G_MISS_NUM,
979: NOTE_CONTEXT_TYPE_02 VARCHAR2(30) := FND_API.G_MISS_CHAR,
980: NOTE_CONTEXT_TYPE_ID_02 NUMBER := FND_API.G_MISS_NUM,
981: NOTE_CONTEXT_ID_03 NUMBER := FND_API.G_MISS_NUM,
982: NOTE_CONTEXT_TYPE_03 VARCHAR2(30) := FND_API.G_MISS_CHAR,
983: NOTE_CONTEXT_TYPE_ID_03 NUMBER := FND_API.G_MISS_NUM,
984: ATTRIBUTE_1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
985: ATTRIBUTE_2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
986: ATTRIBUTE_3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 983: NOTE_CONTEXT_TYPE_ID_03 NUMBER := FND_API.G_MISS_NUM,

979: NOTE_CONTEXT_TYPE_02 VARCHAR2(30) := FND_API.G_MISS_CHAR,
980: NOTE_CONTEXT_TYPE_ID_02 NUMBER := FND_API.G_MISS_NUM,
981: NOTE_CONTEXT_ID_03 NUMBER := FND_API.G_MISS_NUM,
982: NOTE_CONTEXT_TYPE_03 VARCHAR2(30) := FND_API.G_MISS_CHAR,
983: NOTE_CONTEXT_TYPE_ID_03 NUMBER := FND_API.G_MISS_NUM,
984: ATTRIBUTE_1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
985: ATTRIBUTE_2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
986: ATTRIBUTE_3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
987: ATTRIBUTE_4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 984: ATTRIBUTE_1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

980: NOTE_CONTEXT_TYPE_ID_02 NUMBER := FND_API.G_MISS_NUM,
981: NOTE_CONTEXT_ID_03 NUMBER := FND_API.G_MISS_NUM,
982: NOTE_CONTEXT_TYPE_03 VARCHAR2(30) := FND_API.G_MISS_CHAR,
983: NOTE_CONTEXT_TYPE_ID_03 NUMBER := FND_API.G_MISS_NUM,
984: ATTRIBUTE_1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
985: ATTRIBUTE_2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
986: ATTRIBUTE_3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
987: ATTRIBUTE_4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
988: ATTRIBUTE_5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 985: ATTRIBUTE_2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

981: NOTE_CONTEXT_ID_03 NUMBER := FND_API.G_MISS_NUM,
982: NOTE_CONTEXT_TYPE_03 VARCHAR2(30) := FND_API.G_MISS_CHAR,
983: NOTE_CONTEXT_TYPE_ID_03 NUMBER := FND_API.G_MISS_NUM,
984: ATTRIBUTE_1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
985: ATTRIBUTE_2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
986: ATTRIBUTE_3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
987: ATTRIBUTE_4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
988: ATTRIBUTE_5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
989: ATTRIBUTE_6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 986: ATTRIBUTE_3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

982: NOTE_CONTEXT_TYPE_03 VARCHAR2(30) := FND_API.G_MISS_CHAR,
983: NOTE_CONTEXT_TYPE_ID_03 NUMBER := FND_API.G_MISS_NUM,
984: ATTRIBUTE_1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
985: ATTRIBUTE_2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
986: ATTRIBUTE_3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
987: ATTRIBUTE_4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
988: ATTRIBUTE_5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
989: ATTRIBUTE_6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
990: ATTRIBUTE_7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 987: ATTRIBUTE_4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

983: NOTE_CONTEXT_TYPE_ID_03 NUMBER := FND_API.G_MISS_NUM,
984: ATTRIBUTE_1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
985: ATTRIBUTE_2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
986: ATTRIBUTE_3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
987: ATTRIBUTE_4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
988: ATTRIBUTE_5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
989: ATTRIBUTE_6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
990: ATTRIBUTE_7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
991: ATTRIBUTE_8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 988: ATTRIBUTE_5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

984: ATTRIBUTE_1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
985: ATTRIBUTE_2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
986: ATTRIBUTE_3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
987: ATTRIBUTE_4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
988: ATTRIBUTE_5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
989: ATTRIBUTE_6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
990: ATTRIBUTE_7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
991: ATTRIBUTE_8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
992: ATTRIBUTE_9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 989: ATTRIBUTE_6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

985: ATTRIBUTE_2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
986: ATTRIBUTE_3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
987: ATTRIBUTE_4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
988: ATTRIBUTE_5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
989: ATTRIBUTE_6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
990: ATTRIBUTE_7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
991: ATTRIBUTE_8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
992: ATTRIBUTE_9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
993: ATTRIBUTE_10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 990: ATTRIBUTE_7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

986: ATTRIBUTE_3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
987: ATTRIBUTE_4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
988: ATTRIBUTE_5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
989: ATTRIBUTE_6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
990: ATTRIBUTE_7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
991: ATTRIBUTE_8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
992: ATTRIBUTE_9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
993: ATTRIBUTE_10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
994: ATTRIBUTE_11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 991: ATTRIBUTE_8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

987: ATTRIBUTE_4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
988: ATTRIBUTE_5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
989: ATTRIBUTE_6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
990: ATTRIBUTE_7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
991: ATTRIBUTE_8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
992: ATTRIBUTE_9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
993: ATTRIBUTE_10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
994: ATTRIBUTE_11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
995: ATTRIBUTE_12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 992: ATTRIBUTE_9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

988: ATTRIBUTE_5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
989: ATTRIBUTE_6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
990: ATTRIBUTE_7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
991: ATTRIBUTE_8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
992: ATTRIBUTE_9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
993: ATTRIBUTE_10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
994: ATTRIBUTE_11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
995: ATTRIBUTE_12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
996: ATTRIBUTE_13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 993: ATTRIBUTE_10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

989: ATTRIBUTE_6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
990: ATTRIBUTE_7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
991: ATTRIBUTE_8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
992: ATTRIBUTE_9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
993: ATTRIBUTE_10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
994: ATTRIBUTE_11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
995: ATTRIBUTE_12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
996: ATTRIBUTE_13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
997: ATTRIBUTE_14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 994: ATTRIBUTE_11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

990: ATTRIBUTE_7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
991: ATTRIBUTE_8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
992: ATTRIBUTE_9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
993: ATTRIBUTE_10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
994: ATTRIBUTE_11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
995: ATTRIBUTE_12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
996: ATTRIBUTE_13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
997: ATTRIBUTE_14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
998: ATTRIBUTE_15 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 995: ATTRIBUTE_12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

991: ATTRIBUTE_8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
992: ATTRIBUTE_9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
993: ATTRIBUTE_10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
994: ATTRIBUTE_11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
995: ATTRIBUTE_12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
996: ATTRIBUTE_13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
997: ATTRIBUTE_14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
998: ATTRIBUTE_15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
999: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 996: ATTRIBUTE_13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

992: ATTRIBUTE_9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
993: ATTRIBUTE_10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
994: ATTRIBUTE_11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
995: ATTRIBUTE_12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
996: ATTRIBUTE_13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
997: ATTRIBUTE_14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
998: ATTRIBUTE_15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
999: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
1000: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

Line 997: ATTRIBUTE_14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

993: ATTRIBUTE_10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
994: ATTRIBUTE_11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
995: ATTRIBUTE_12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
996: ATTRIBUTE_13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
997: ATTRIBUTE_14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
998: ATTRIBUTE_15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
999: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
1000: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
1001: CREATION_DATE DATE := FND_API.G_MISS_DATE,

Line 998: ATTRIBUTE_15 VARCHAR2(150) := FND_API.G_MISS_CHAR,

994: ATTRIBUTE_11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
995: ATTRIBUTE_12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
996: ATTRIBUTE_13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
997: ATTRIBUTE_14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
998: ATTRIBUTE_15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
999: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
1000: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
1001: CREATION_DATE DATE := FND_API.G_MISS_DATE,
1002: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

Line 999: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,

995: ATTRIBUTE_12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
996: ATTRIBUTE_13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
997: ATTRIBUTE_14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
998: ATTRIBUTE_15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
999: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
1000: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
1001: CREATION_DATE DATE := FND_API.G_MISS_DATE,
1002: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
1003: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

Line 1000: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

996: ATTRIBUTE_13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
997: ATTRIBUTE_14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
998: ATTRIBUTE_15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
999: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
1000: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
1001: CREATION_DATE DATE := FND_API.G_MISS_DATE,
1002: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
1003: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
1004: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM

Line 1001: CREATION_DATE DATE := FND_API.G_MISS_DATE,

997: ATTRIBUTE_14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
998: ATTRIBUTE_15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
999: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
1000: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
1001: CREATION_DATE DATE := FND_API.G_MISS_DATE,
1002: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
1003: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
1004: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
1005: );

Line 1002: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

998: ATTRIBUTE_15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
999: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
1000: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
1001: CREATION_DATE DATE := FND_API.G_MISS_DATE,
1002: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
1003: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
1004: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
1005: );
1006: TYPE notes_table IS TABLE OF notes_rec INDEX BY BINARY_INTEGER;

Line 1003: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

999: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
1000: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
1001: CREATION_DATE DATE := FND_API.G_MISS_DATE,
1002: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
1003: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
1004: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
1005: );
1006: TYPE notes_table IS TABLE OF notes_rec INDEX BY BINARY_INTEGER;
1007:

Line 1004: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM

1000: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
1001: CREATION_DATE DATE := FND_API.G_MISS_DATE,
1002: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
1003: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
1004: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
1005: );
1006: TYPE notes_table IS TABLE OF notes_rec INDEX BY BINARY_INTEGER;
1007:
1008: -----------------------------------------------------------------------

Line 1032: SR_CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,

1028: --This table will hold the contacts and contact information
1029: --for a Service Request customer
1030: --
1031: TYPE contacts_rec IS RECORD (
1032: SR_CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
1033: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
1034: CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
1035: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
1036: CONTACT_POINT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 1033: PARTY_ID NUMBER := FND_API.G_MISS_NUM,

1029: --for a Service Request customer
1030: --
1031: TYPE contacts_rec IS RECORD (
1032: SR_CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
1033: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
1034: CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
1035: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
1036: CONTACT_POINT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1037: CONTACT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 1034: CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,

1030: --
1031: TYPE contacts_rec IS RECORD (
1032: SR_CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
1033: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
1034: CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
1035: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
1036: CONTACT_POINT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1037: CONTACT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1038: party_role_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 1035: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,

1031: TYPE contacts_rec IS RECORD (
1032: SR_CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
1033: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
1034: CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
1035: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
1036: CONTACT_POINT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1037: CONTACT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1038: party_role_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
1039: start_date_active DATE := FND_API.G_MISS_DATE,

Line 1036: CONTACT_POINT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,

1032: SR_CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
1033: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
1034: CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
1035: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
1036: CONTACT_POINT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1037: CONTACT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1038: party_role_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
1039: start_date_active DATE := FND_API.G_MISS_DATE,
1040: end_date_active DATE := FND_API.G_MISS_DATE

Line 1037: CONTACT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,

1033: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
1034: CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
1035: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
1036: CONTACT_POINT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1037: CONTACT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1038: party_role_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
1039: start_date_active DATE := FND_API.G_MISS_DATE,
1040: end_date_active DATE := FND_API.G_MISS_DATE
1041: );

Line 1038: party_role_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

1034: CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
1035: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
1036: CONTACT_POINT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1037: CONTACT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1038: party_role_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
1039: start_date_active DATE := FND_API.G_MISS_DATE,
1040: end_date_active DATE := FND_API.G_MISS_DATE
1041: );
1042: TYPE contacts_table IS TABLE OF contacts_rec INDEX BY BINARY_INTEGER;

Line 1039: start_date_active DATE := FND_API.G_MISS_DATE,

1035: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
1036: CONTACT_POINT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1037: CONTACT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1038: party_role_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
1039: start_date_active DATE := FND_API.G_MISS_DATE,
1040: end_date_active DATE := FND_API.G_MISS_DATE
1041: );
1042: TYPE contacts_table IS TABLE OF contacts_rec INDEX BY BINARY_INTEGER;
1043:

Line 1040: end_date_active DATE := FND_API.G_MISS_DATE

1036: CONTACT_POINT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1037: CONTACT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
1038: party_role_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
1039: start_date_active DATE := FND_API.G_MISS_DATE,
1040: end_date_active DATE := FND_API.G_MISS_DATE
1041: );
1042: TYPE contacts_table IS TABLE OF contacts_rec INDEX BY BINARY_INTEGER;
1043:
1044: --

Line 1534: -- Default = FND_API.G_FALSE

1530: --
1531: -- Standard IN Parameters:
1532: -- p_api_version IN NUMBER Required
1533: -- p_init_msg_list IN VARCHAR2 Optional
1534: -- Default = FND_API.G_FALSE
1535: -- p_commit IN VARCHAR2 Optional
1536: -- Default = FND_API.G_FALSE
1537: -- p_validation_level IN NUMBER Optional
1538: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 1536: -- Default = FND_API.G_FALSE

1532: -- p_api_version IN NUMBER Required
1533: -- p_init_msg_list IN VARCHAR2 Optional
1534: -- Default = FND_API.G_FALSE
1535: -- p_commit IN VARCHAR2 Optional
1536: -- Default = FND_API.G_FALSE
1537: -- p_validation_level IN NUMBER Optional
1538: -- Default = FND_API.G_VALID_LEVEL_FULL
1539: --
1540: -- Standard OUT Parameters:

Line 1538: -- Default = FND_API.G_VALID_LEVEL_FULL

1534: -- Default = FND_API.G_FALSE
1535: -- p_commit IN VARCHAR2 Optional
1536: -- Default = FND_API.G_FALSE
1537: -- p_validation_level IN NUMBER Optional
1538: -- Default = FND_API.G_VALID_LEVEL_FULL
1539: --
1540: -- Standard OUT Parameters:
1541: -- x_return_status OUT VARCHAR2(1)
1542: -- x_msg_count OUT NUMBER

Line 1974: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

1970: --------------------------------------------------------------
1971:
1972: PROCEDURE Create_ServiceRequest(
1973: p_api_version IN NUMBER,
1974: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1975: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1976: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
1977: x_return_status OUT NOCOPY VARCHAR2,
1978: x_msg_count OUT NOCOPY NUMBER,

Line 1975: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

1971:
1972: PROCEDURE Create_ServiceRequest(
1973: p_api_version IN NUMBER,
1974: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1975: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1976: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
1977: x_return_status OUT NOCOPY VARCHAR2,
1978: x_msg_count OUT NOCOPY NUMBER,
1979: x_msg_data OUT NOCOPY VARCHAR2,

Line 1976: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,

1972: PROCEDURE Create_ServiceRequest(
1973: p_api_version IN NUMBER,
1974: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1975: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1976: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
1977: x_return_status OUT NOCOPY VARCHAR2,
1978: x_msg_count OUT NOCOPY NUMBER,
1979: x_msg_data OUT NOCOPY VARCHAR2,
1980: p_resp_appl_id IN NUMBER DEFAULT NULL,

Line 1984: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

1980: p_resp_appl_id IN NUMBER DEFAULT NULL,
1981: p_resp_id IN NUMBER DEFAULT NULL,
1982: p_user_id IN NUMBER,
1983: p_login_id IN NUMBER DEFAULT NULL,
1984: p_org_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
1985: p_request_id IN NUMBER DEFAULT NULL,
1986: p_request_number IN VARCHAR2 DEFAULT NULL,
1987: p_invocation_mode IN VARCHAR2 := 'NORMAL' ,
1988: p_service_request_rec IN service_request_rec_type,

Line 2018: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

2014: -- since several new OUT parameters have been added to the 11.5.9 signature
2015: -- in the form of a new record type, sr_create_out_rec_type
2016: PROCEDURE Create_ServiceRequest(
2017: p_api_version IN NUMBER,
2018: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2019: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2020: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
2021: x_return_status OUT NOCOPY VARCHAR2,
2022: x_msg_count OUT NOCOPY NUMBER,

Line 2019: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

2015: -- in the form of a new record type, sr_create_out_rec_type
2016: PROCEDURE Create_ServiceRequest(
2017: p_api_version IN NUMBER,
2018: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2019: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2020: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
2021: x_return_status OUT NOCOPY VARCHAR2,
2022: x_msg_count OUT NOCOPY NUMBER,
2023: x_msg_data OUT NOCOPY VARCHAR2,

Line 2020: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,

2016: PROCEDURE Create_ServiceRequest(
2017: p_api_version IN NUMBER,
2018: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2019: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2020: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
2021: x_return_status OUT NOCOPY VARCHAR2,
2022: x_msg_count OUT NOCOPY NUMBER,
2023: x_msg_data OUT NOCOPY VARCHAR2,
2024: p_resp_appl_id IN NUMBER DEFAULT NULL,

Line 2056: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

2052: as 3.0*/
2053:
2054: PROCEDURE Create_ServiceRequest(
2055: p_api_version IN NUMBER,
2056: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2057: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2058: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
2059: x_return_status OUT NOCOPY VARCHAR2,
2060: x_msg_count OUT NOCOPY NUMBER,

Line 2057: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

2053:
2054: PROCEDURE Create_ServiceRequest(
2055: p_api_version IN NUMBER,
2056: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2057: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2058: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
2059: x_return_status OUT NOCOPY VARCHAR2,
2060: x_msg_count OUT NOCOPY NUMBER,
2061: x_msg_data OUT NOCOPY VARCHAR2,

Line 2058: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,

2054: PROCEDURE Create_ServiceRequest(
2055: p_api_version IN NUMBER,
2056: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2057: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2058: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
2059: x_return_status OUT NOCOPY VARCHAR2,
2060: x_msg_count OUT NOCOPY NUMBER,
2061: x_msg_data OUT NOCOPY VARCHAR2,
2062: p_resp_appl_id IN NUMBER DEFAULT NULL,

Line 2094: -- Default = FND_API.G_FALSE

2090: -- Parameters :
2091: -- IN :
2092: -- p_api_version IN NUMBER Required
2093: -- p_init_msg_list IN VARCHAR2 Optional
2094: -- Default = FND_API.G_FALSE
2095: -- p_commit IN VARCHAR2 Optional
2096: -- Default = FND_API.G_FALSE
2097: -- p_validation_level IN NUMBER Optional
2098: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 2096: -- Default = FND_API.G_FALSE

2092: -- p_api_version IN NUMBER Required
2093: -- p_init_msg_list IN VARCHAR2 Optional
2094: -- Default = FND_API.G_FALSE
2095: -- p_commit IN VARCHAR2 Optional
2096: -- Default = FND_API.G_FALSE
2097: -- p_validation_level IN NUMBER Optional
2098: -- Default = FND_API.G_VALID_LEVEL_FULL
2099: -- p_request_id IN NUMBER Required
2100: -- p_object_version_number IN NUMBER Required for Web-Apps

Line 2098: -- Default = FND_API.G_VALID_LEVEL_FULL

2094: -- Default = FND_API.G_FALSE
2095: -- p_commit IN VARCHAR2 Optional
2096: -- Default = FND_API.G_FALSE
2097: -- p_validation_level IN NUMBER Optional
2098: -- Default = FND_API.G_VALID_LEVEL_FULL
2099: -- p_request_id IN NUMBER Required
2100: -- p_object_version_number IN NUMBER Required for Web-Apps
2101: -----------------------------------------------------------------
2102: -- No longer there in the API

Line 2120: -- Default = FND_API.G_FALSE

2116: -- p_service_request_rec IN service_request_rec_type Required
2117:
2118: -- p_update_desc_flex IN VARCHAR2(1) Optional
2119: -- Indicates whether the descriptive flexfields are being updated
2120: -- Default = FND_API.G_FALSE
2121:
2122: -- p_notes IN notes_table Optional
2123:
2124: -- p_contacts IN contacts_table Optional

Line 2134: -- Default = FND_API.G_FALSE

2130:
2131: -- p_called_by_workflow IN VARCHAR2(1)
2132: -- Indicates whether this API is being called by the active
2133: -- workflow process for the service request
2134: -- Default = FND_API.G_FALSE
2135:
2136: -- p_workflow_process_id IN NUMBER
2137: -- The workflow process id of the workflow process that is
2138: -- calling this API

Line 2399: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

2395: --------------------------------------------------------------
2396:
2397: PROCEDURE Update_ServiceRequest
2398: ( p_api_version IN NUMBER,
2399: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2400: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2401: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
2402: x_return_status OUT NOCOPY VARCHAR2,
2403: x_msg_count OUT NOCOPY NUMBER,

Line 2400: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

2396:
2397: PROCEDURE Update_ServiceRequest
2398: ( p_api_version IN NUMBER,
2399: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2400: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2401: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
2402: x_return_status OUT NOCOPY VARCHAR2,
2403: x_msg_count OUT NOCOPY NUMBER,
2404: x_msg_data OUT NOCOPY VARCHAR2,

Line 2401: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,

2397: PROCEDURE Update_ServiceRequest
2398: ( p_api_version IN NUMBER,
2399: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2400: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2401: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
2402: x_return_status OUT NOCOPY VARCHAR2,
2403: x_msg_count OUT NOCOPY NUMBER,
2404: x_msg_data OUT NOCOPY VARCHAR2,
2405: p_request_id IN NUMBER,

Line 2415: p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,

2411: p_last_update_login IN NUMBER DEFAULT NULL,
2412: p_last_update_date IN DATE,
2413: p_service_request_rec IN service_request_rec_type,
2414: p_invocation_mode IN VARCHAR2 := 'NORMAL',
2415: p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
2416: p_notes IN notes_table,
2417: p_contacts IN contacts_table,
2418: p_audit_comments IN VARCHAR2 DEFAULT NULL,
2419: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,

Line 2419: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,

2415: p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
2416: p_notes IN notes_table,
2417: p_contacts IN contacts_table,
2418: p_audit_comments IN VARCHAR2 DEFAULT NULL,
2419: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
2420: p_workflow_process_id IN NUMBER DEFAULT NULL,
2421: -- Commented out since these are now part of the out rec type --anmukher--08/08/03
2422: -- x_workflow_process_id OUT NOCOPY NUMBER,
2423: -- x_interaction_id OUT NOCOPY NUMBER,

Line 2441: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

2437: -- since several new OUT parameters have been added to the 11.5.9 signature
2438: -- in the form of a new record type, sr_update_out_rec_type
2439: PROCEDURE Update_ServiceRequest
2440: ( p_api_version IN NUMBER,
2441: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2442: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2443: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
2444: x_return_status OUT NOCOPY VARCHAR2,
2445: x_msg_count OUT NOCOPY NUMBER,

Line 2442: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

2438: -- in the form of a new record type, sr_update_out_rec_type
2439: PROCEDURE Update_ServiceRequest
2440: ( p_api_version IN NUMBER,
2441: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2442: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2443: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
2444: x_return_status OUT NOCOPY VARCHAR2,
2445: x_msg_count OUT NOCOPY NUMBER,
2446: x_msg_data OUT NOCOPY VARCHAR2,

Line 2443: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,

2439: PROCEDURE Update_ServiceRequest
2440: ( p_api_version IN NUMBER,
2441: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2442: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2443: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
2444: x_return_status OUT NOCOPY VARCHAR2,
2445: x_msg_count OUT NOCOPY NUMBER,
2446: x_msg_data OUT NOCOPY VARCHAR2,
2447: p_request_id IN NUMBER,

Line 2457: p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,

2453: p_last_update_login IN NUMBER DEFAULT NULL,
2454: p_last_update_date IN DATE,
2455: p_service_request_rec IN service_request_rec_type,
2456: p_invocation_mode IN VARCHAR2 := 'NORMAL',
2457: p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
2458: p_notes IN notes_table,
2459: p_contacts IN contacts_table,
2460: p_audit_comments IN VARCHAR2 DEFAULT NULL,
2461: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,

Line 2461: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,

2457: p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
2458: p_notes IN notes_table,
2459: p_contacts IN contacts_table,
2460: p_audit_comments IN VARCHAR2 DEFAULT NULL,
2461: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
2462: p_workflow_process_id IN NUMBER DEFAULT NULL,
2463: p_default_contract_sla_ind IN VARCHAR2 Default 'N',
2464: x_workflow_process_id OUT NOCOPY NUMBER,
2465: x_interaction_id OUT NOCOPY NUMBER

Line 2478: -- Default = FND_API.G_FALSE

2474: -- Parameters :
2475: -- IN :
2476: -- p_api_version IN NUMBER Required
2477: -- p_init_msg_list IN VARCHAR2 Optional
2478: -- Default = FND_API.G_FALSE
2479: -- p_commit IN VARCHAR2 Optional
2480: -- Default = FND_API.G_FALSE
2481: -- p_validation_level IN NUMBER Optional
2482: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 2480: -- Default = FND_API.G_FALSE

2476: -- p_api_version IN NUMBER Required
2477: -- p_init_msg_list IN VARCHAR2 Optional
2478: -- Default = FND_API.G_FALSE
2479: -- p_commit IN VARCHAR2 Optional
2480: -- Default = FND_API.G_FALSE
2481: -- p_validation_level IN NUMBER Optional
2482: -- Default = FND_API.G_VALID_LEVEL_FULL
2483: -- p_request_id IN NUMBER Required
2484: ----------------------------------------------------

Line 2482: -- Default = FND_API.G_VALID_LEVEL_FULL

2478: -- Default = FND_API.G_FALSE
2479: -- p_commit IN VARCHAR2 Optional
2480: -- Default = FND_API.G_FALSE
2481: -- p_validation_level IN NUMBER Optional
2482: -- Default = FND_API.G_VALID_LEVEL_FULL
2483: -- p_request_id IN NUMBER Required
2484: ----------------------------------------------------
2485: -- Removed from the api
2486: -- p_org_id IN NUMBER Optional

Line 2506: -- Default = FND_API.G_FALSE

2502: -- Default = NULL
2503: -- p_call_by_workflow IN VARCHAR2 Optional
2504: -- Indicates whether this API is being called by a workflow
2505: -- process
2506: -- Default = FND_API.G_FALSE
2507: -- p_workflow_process_id IN NUMBER Optional
2508: -- The workflow process id of the workflow process that is
2509: -- calling this API
2510: -- Default = NULL

Line 2556: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

2552: RETURN NUMBER;
2553:
2554: PROCEDURE Update_Status
2555: ( p_api_version IN NUMBER,
2556: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2557: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2558: p_resp_id IN NUMBER,
2559: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
2560: x_return_status OUT NOCOPY VARCHAR2,

Line 2557: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

2553:
2554: PROCEDURE Update_Status
2555: ( p_api_version IN NUMBER,
2556: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2557: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2558: p_resp_id IN NUMBER,
2559: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
2560: x_return_status OUT NOCOPY VARCHAR2,
2561: x_msg_count OUT NOCOPY NUMBER,

Line 2559: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,

2555: ( p_api_version IN NUMBER,
2556: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2557: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2558: p_resp_id IN NUMBER,
2559: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
2560: x_return_status OUT NOCOPY VARCHAR2,
2561: x_msg_count OUT NOCOPY NUMBER,
2562: x_msg_data OUT NOCOPY VARCHAR2,
2563: p_request_id IN NUMBER,

Line 2566: p_closed_date IN DATE DEFAULT fnd_api.g_miss_date,

2562: x_msg_data OUT NOCOPY VARCHAR2,
2563: p_request_id IN NUMBER,
2564: p_object_version_number IN NUMBER,
2565: p_status_id IN NUMBER,
2566: p_closed_date IN DATE DEFAULT fnd_api.g_miss_date,
2567: p_last_updated_by IN NUMBER,
2568: p_last_update_login IN NUMBER DEFAULT NULL,
2569: p_last_update_date IN DATE,
2570: p_audit_comments IN VARCHAR2 DEFAULT NULL,

Line 2571: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,

2567: p_last_updated_by IN NUMBER,
2568: p_last_update_login IN NUMBER DEFAULT NULL,
2569: p_last_update_date IN DATE,
2570: p_audit_comments IN VARCHAR2 DEFAULT NULL,
2571: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
2572: p_workflow_process_id IN NUMBER DEFAULT NULL,
2573: p_comments IN VARCHAR2 DEFAULT NULL,
2574: p_public_comment_flag IN VARCHAR2 DEFAULT fnd_api.g_false,
2575: p_parent_interaction_id IN NUMBER DEFAULT NULL,

Line 2574: p_public_comment_flag IN VARCHAR2 DEFAULT fnd_api.g_false,

2570: p_audit_comments IN VARCHAR2 DEFAULT NULL,
2571: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
2572: p_workflow_process_id IN NUMBER DEFAULT NULL,
2573: p_comments IN VARCHAR2 DEFAULT NULL,
2574: p_public_comment_flag IN VARCHAR2 DEFAULT fnd_api.g_false,
2575: p_parent_interaction_id IN NUMBER DEFAULT NULL,
2576: -- Added for 11.5.10 projects
2577: p_validate_sr_closure IN VARCHAR2 Default 'N',
2578: p_auto_close_child_entities IN VARCHAR2 Default 'N',

Line 2595: -- Default = FND_API.G_FALSE

2591: -- Parameters :
2592: -- IN :
2593: -- p_api_version IN NUMBER Required
2594: -- p_init_msg_list IN VARCHAR2 Optional
2595: -- Default = FND_API.G_FALSE
2596: -- p_commit IN VARCHAR2 Optional
2597: -- Default = FND_API.G_FALSE
2598: -- p_validation_level IN NUMBER Optional
2599: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 2597: -- Default = FND_API.G_FALSE

2593: -- p_api_version IN NUMBER Required
2594: -- p_init_msg_list IN VARCHAR2 Optional
2595: -- Default = FND_API.G_FALSE
2596: -- p_commit IN VARCHAR2 Optional
2597: -- Default = FND_API.G_FALSE
2598: -- p_validation_level IN NUMBER Optional
2599: -- Default = FND_API.G_VALID_LEVEL_FULL
2600: -- p_request_id IN NUMBER Required
2601: -- p_resp_id IN NUMBER Optional

Line 2599: -- Default = FND_API.G_VALID_LEVEL_FULL

2595: -- Default = FND_API.G_FALSE
2596: -- p_commit IN VARCHAR2 Optional
2597: -- Default = FND_API.G_FALSE
2598: -- p_validation_level IN NUMBER Optional
2599: -- Default = FND_API.G_VALID_LEVEL_FULL
2600: -- p_request_id IN NUMBER Required
2601: -- p_resp_id IN NUMBER Optional
2602: -- Default = NULL
2603: -- p_resp_appl_id IN NUMBER Optional

Line 2627: -- Default = FND_API.G_FALSE

2623: -- Default = NULL
2624: -- p_call_by_workflow IN VARCHAR2 Optional
2625: -- Indicates whether this API is being called by a workflow
2626: -- process
2627: -- Default = FND_API.G_FALSE
2628: -- p_workflow_process_id IN NUMBER Optional
2629: -- Default = NULL
2630: -- The workflow process id of the workflow process that is
2631: -- calling this API

Line 2667: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

2663: --------------------------------------------------------------------------
2664:
2665: PROCEDURE Update_Owner
2666: ( p_api_version IN NUMBER,
2667: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2668: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2669: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
2670: x_return_status OUT NOCOPY VARCHAR2,
2671: x_msg_count OUT NOCOPY NUMBER,

Line 2668: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

2664:
2665: PROCEDURE Update_Owner
2666: ( p_api_version IN NUMBER,
2667: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2668: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2669: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
2670: x_return_status OUT NOCOPY VARCHAR2,
2671: x_msg_count OUT NOCOPY NUMBER,
2672: x_msg_data OUT NOCOPY VARCHAR2,

Line 2669: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,

2665: PROCEDURE Update_Owner
2666: ( p_api_version IN NUMBER,
2667: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2668: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2669: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
2670: x_return_status OUT NOCOPY VARCHAR2,
2671: x_msg_count OUT NOCOPY NUMBER,
2672: x_msg_data OUT NOCOPY VARCHAR2,
2673: p_request_id IN NUMBER,

Line 2684: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,

2680: p_last_updated_by IN NUMBER,
2681: p_last_update_login IN NUMBER DEFAULT NULL,
2682: p_last_update_date IN DATE,
2683: p_audit_comments IN VARCHAR2 DEFAULT NULL,
2684: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
2685: p_workflow_process_id IN NUMBER DEFAULT NULL,
2686: p_comments IN VARCHAR2 DEFAULT NULL,
2687: p_public_comment_flag IN VARCHAR2 DEFAULT fnd_api.g_false,
2688: p_parent_interaction_id IN NUMBER DEFAULT NULL,

Line 2687: p_public_comment_flag IN VARCHAR2 DEFAULT fnd_api.g_false,

2683: p_audit_comments IN VARCHAR2 DEFAULT NULL,
2684: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
2685: p_workflow_process_id IN NUMBER DEFAULT NULL,
2686: p_comments IN VARCHAR2 DEFAULT NULL,
2687: p_public_comment_flag IN VARCHAR2 DEFAULT fnd_api.g_false,
2688: p_parent_interaction_id IN NUMBER DEFAULT NULL,
2689: x_interaction_id OUT NOCOPY NUMBER
2690: );
2691:

Line 2702: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE

2698: -- Pre-reqs : None
2699: -- Parameters :
2700: -- IN :
2701: -- p_api_version IN NUMBER Required
2702: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
2703: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
2704: -- p_request_id IN NUMBER Required
2705: -- p_change_flags IN AUDIT_FLAGS_REC_TYPE Required
2706: -- p_old_vals_rec IN AUDIT_VALS_REC_TYPE Optional

Line 2703: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE

2699: -- Parameters :
2700: -- IN :
2701: -- p_api_version IN NUMBER Required
2702: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
2703: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
2704: -- p_request_id IN NUMBER Required
2705: -- p_change_flags IN AUDIT_FLAGS_REC_TYPE Required
2706: -- p_old_vals_rec IN AUDIT_VALS_REC_TYPE Optional
2707: -- p_new_vals_rec IN AUDIT_VALS_REC_TYPE Optional

Line 2708: -- p_action_id IN NUMBER Optional Default = FND_API.G_MISS_NUM

2704: -- p_request_id IN NUMBER Required
2705: -- p_change_flags IN AUDIT_FLAGS_REC_TYPE Required
2706: -- p_old_vals_rec IN AUDIT_VALS_REC_TYPE Optional
2707: -- p_new_vals_rec IN AUDIT_VALS_REC_TYPE Optional
2708: -- p_action_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
2709: -- p_wf_process_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
2710: -- p_wf_process_itemkey IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
2711: -- p_user_id IN NUMBER Required
2712: -- p_login_id IN NUMBER Optional Default = NULL

Line 2709: -- p_wf_process_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

2705: -- p_change_flags IN AUDIT_FLAGS_REC_TYPE Required
2706: -- p_old_vals_rec IN AUDIT_VALS_REC_TYPE Optional
2707: -- p_new_vals_rec IN AUDIT_VALS_REC_TYPE Optional
2708: -- p_action_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
2709: -- p_wf_process_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
2710: -- p_wf_process_itemkey IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
2711: -- p_user_id IN NUMBER Required
2712: -- p_login_id IN NUMBER Optional Default = NULL
2713: -- p_comments IN VARCHAR2 Optional Default = NULL

Line 2710: -- p_wf_process_itemkey IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR

2706: -- p_old_vals_rec IN AUDIT_VALS_REC_TYPE Optional
2707: -- p_new_vals_rec IN AUDIT_VALS_REC_TYPE Optional
2708: -- p_action_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
2709: -- p_wf_process_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
2710: -- p_wf_process_itemkey IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
2711: -- p_user_id IN NUMBER Required
2712: -- p_login_id IN NUMBER Optional Default = NULL
2713: -- p_comments IN VARCHAR2 Optional Default = NULL
2714: --

Line 2729: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

2725: -- -------------------------------------------------------------------
2726:
2727: PROCEDURE Create_Audit_Record (
2728: p_api_version IN NUMBER,
2729: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2730: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2731: x_return_status OUT NOCOPY VARCHAR2,
2732: x_msg_count OUT NOCOPY NUMBER,
2733: x_msg_data OUT NOCOPY VARCHAR2,

Line 2730: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

2726:
2727: PROCEDURE Create_Audit_Record (
2728: p_api_version IN NUMBER,
2729: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2730: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2731: x_return_status OUT NOCOPY VARCHAR2,
2732: x_msg_count OUT NOCOPY NUMBER,
2733: x_msg_data OUT NOCOPY VARCHAR2,
2734: p_request_id IN NUMBER,

Line 2740: p_action_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

2736: --p_change_flags IN audit_flags_rec_type,
2737: --p_old_vals_rec IN audit_vals_rec_type DEFAULT G_MISS_AUDIT_VALS_REC,
2738: --p_new_vals_rec IN audit_vals_rec_type DEFAULT G_MISS_AUDIT_VALS_REC,
2739: p_audit_vals_rec IN SR_AUDIT_REC_TYPE,
2740: p_action_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
2741: p_wf_process_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
2742: p_wf_process_itemkey IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
2743: p_user_id IN NUMBER,
2744: p_login_id IN NUMBER DEFAULT NULL,

Line 2741: p_wf_process_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

2737: --p_old_vals_rec IN audit_vals_rec_type DEFAULT G_MISS_AUDIT_VALS_REC,
2738: --p_new_vals_rec IN audit_vals_rec_type DEFAULT G_MISS_AUDIT_VALS_REC,
2739: p_audit_vals_rec IN SR_AUDIT_REC_TYPE,
2740: p_action_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
2741: p_wf_process_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
2742: p_wf_process_itemkey IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
2743: p_user_id IN NUMBER,
2744: p_login_id IN NUMBER DEFAULT NULL,
2745: p_last_update_date IN DATE,

Line 2742: p_wf_process_itemkey IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

2738: --p_new_vals_rec IN audit_vals_rec_type DEFAULT G_MISS_AUDIT_VALS_REC,
2739: p_audit_vals_rec IN SR_AUDIT_REC_TYPE,
2740: p_action_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
2741: p_wf_process_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
2742: p_wf_process_itemkey IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
2743: p_user_id IN NUMBER,
2744: p_login_id IN NUMBER DEFAULT NULL,
2745: p_last_update_date IN DATE,
2746: p_creation_date IN DATE,

Line 2791: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE

2787:
2788: PROCEDURE Delete_ServiceRequest
2789: (
2790: p_api_version_number IN NUMBER := 1.0
2791: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2792: , p_commit IN VARCHAR2 := FND_API.G_FALSE
2793: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2794: , p_processing_set_id IN NUMBER
2795: , p_purge_set_id IN NUMBER

Line 2792: , p_commit IN VARCHAR2 := FND_API.G_FALSE

2788: PROCEDURE Delete_ServiceRequest
2789: (
2790: p_api_version_number IN NUMBER := 1.0
2791: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2792: , p_commit IN VARCHAR2 := FND_API.G_FALSE
2793: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2794: , p_processing_set_id IN NUMBER
2795: , p_purge_set_id IN NUMBER
2796: , p_purge_source_with_open_task IN VARCHAR2

Line 2793: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL

2789: (
2790: p_api_version_number IN NUMBER := 1.0
2791: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2792: , p_commit IN VARCHAR2 := FND_API.G_FALSE
2793: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2794: , p_processing_set_id IN NUMBER
2795: , p_purge_set_id IN NUMBER
2796: , p_purge_source_with_open_task IN VARCHAR2
2797: , p_audit_required IN VARCHAR2