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: );
222: --------------------------------------------------------------------------

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: );
222: --------------------------------------------------------------------------
223: -- Start of comments

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

371: -- p_inventory_item_id OUT NUMBER
372: -- Returned iff customer_product_id is passed
373: -- Identifies an item for a customer product
374: -- p_return_status OUT VARCHAR2(1)
375: -- FND_API.G_RET_STS_SUCCESS => all non-missing fields are valid
376: -- FND_API.G_RET_STS_ERROR => one or more non-missing fields
377: -- are invalid
378: -- Notes :
379: -- Please take into considerations the following dependencies when

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

372: -- Returned iff customer_product_id is passed
373: -- Identifies an item for a customer product
374: -- p_return_status OUT VARCHAR2(1)
375: -- FND_API.G_RET_STS_SUCCESS => all non-missing fields are valid
376: -- FND_API.G_RET_STS_ERROR => one or more non-missing fields
377: -- are invalid
378: -- Notes :
379: -- Please take into considerations the following dependencies when
380: -- passing in parameters and record fields. For example, the status of

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

410: -- Set up record types to be used for the audit record API
411: -----------------------------------------------------------
412: /*************** Comment out these 3 audit recs and use New Audit Rec **
413: TYPE audit_flags_rec_type IS RECORD (
414: change_status VARCHAR2(1) := FND_API.G_FALSE,
415: change_owner VARCHAR2(1) := FND_API.G_FALSE,
416: change_group VARCHAR2(1) := FND_API.G_FALSE,
417: change_group_type VARCHAR2(1) := FND_API.G_FALSE,
418: change_assigned_time VARCHAR2(1) := FND_API.G_FALSE,

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

411: -----------------------------------------------------------
412: /*************** Comment out these 3 audit recs and use New Audit Rec **
413: TYPE audit_flags_rec_type IS RECORD (
414: change_status VARCHAR2(1) := FND_API.G_FALSE,
415: change_owner VARCHAR2(1) := FND_API.G_FALSE,
416: change_group VARCHAR2(1) := FND_API.G_FALSE,
417: change_group_type VARCHAR2(1) := FND_API.G_FALSE,
418: change_assigned_time VARCHAR2(1) := FND_API.G_FALSE,
419: change_platform_org_id VARCHAR2(1) := FND_API.G_FALSE,

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

412: /*************** Comment out these 3 audit recs and use New Audit Rec **
413: TYPE audit_flags_rec_type IS RECORD (
414: change_status VARCHAR2(1) := FND_API.G_FALSE,
415: change_owner VARCHAR2(1) := FND_API.G_FALSE,
416: change_group VARCHAR2(1) := FND_API.G_FALSE,
417: change_group_type VARCHAR2(1) := FND_API.G_FALSE,
418: change_assigned_time VARCHAR2(1) := FND_API.G_FALSE,
419: change_platform_org_id VARCHAR2(1) := FND_API.G_FALSE,
420: change_type VARCHAR2(1) := FND_API.G_FALSE,

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

413: TYPE audit_flags_rec_type IS RECORD (
414: change_status VARCHAR2(1) := FND_API.G_FALSE,
415: change_owner VARCHAR2(1) := FND_API.G_FALSE,
416: change_group VARCHAR2(1) := FND_API.G_FALSE,
417: change_group_type VARCHAR2(1) := FND_API.G_FALSE,
418: change_assigned_time VARCHAR2(1) := FND_API.G_FALSE,
419: change_platform_org_id VARCHAR2(1) := FND_API.G_FALSE,
420: change_type VARCHAR2(1) := FND_API.G_FALSE,
421: change_urgency VARCHAR2(1) := FND_API.G_FALSE,

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

414: change_status VARCHAR2(1) := FND_API.G_FALSE,
415: change_owner VARCHAR2(1) := FND_API.G_FALSE,
416: change_group VARCHAR2(1) := FND_API.G_FALSE,
417: change_group_type VARCHAR2(1) := FND_API.G_FALSE,
418: change_assigned_time VARCHAR2(1) := FND_API.G_FALSE,
419: change_platform_org_id VARCHAR2(1) := FND_API.G_FALSE,
420: change_type VARCHAR2(1) := FND_API.G_FALSE,
421: change_urgency VARCHAR2(1) := FND_API.G_FALSE,
422: change_severity VARCHAR2(1) := FND_API.G_FALSE,

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

415: change_owner VARCHAR2(1) := FND_API.G_FALSE,
416: change_group VARCHAR2(1) := FND_API.G_FALSE,
417: change_group_type VARCHAR2(1) := FND_API.G_FALSE,
418: change_assigned_time VARCHAR2(1) := FND_API.G_FALSE,
419: change_platform_org_id VARCHAR2(1) := FND_API.G_FALSE,
420: change_type VARCHAR2(1) := FND_API.G_FALSE,
421: change_urgency VARCHAR2(1) := FND_API.G_FALSE,
422: change_severity VARCHAR2(1) := FND_API.G_FALSE,
423: change_exp_res_date VARCHAR2(1) := FND_API.G_FALSE,

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

416: change_group VARCHAR2(1) := FND_API.G_FALSE,
417: change_group_type VARCHAR2(1) := FND_API.G_FALSE,
418: change_assigned_time VARCHAR2(1) := FND_API.G_FALSE,
419: change_platform_org_id VARCHAR2(1) := FND_API.G_FALSE,
420: change_type VARCHAR2(1) := FND_API.G_FALSE,
421: change_urgency VARCHAR2(1) := FND_API.G_FALSE,
422: change_severity VARCHAR2(1) := FND_API.G_FALSE,
423: change_exp_res_date VARCHAR2(1) := FND_API.G_FALSE,
424: new_action VARCHAR2(1) := FND_API.G_FALSE,

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

417: change_group_type VARCHAR2(1) := FND_API.G_FALSE,
418: change_assigned_time VARCHAR2(1) := FND_API.G_FALSE,
419: change_platform_org_id VARCHAR2(1) := FND_API.G_FALSE,
420: change_type VARCHAR2(1) := FND_API.G_FALSE,
421: change_urgency VARCHAR2(1) := FND_API.G_FALSE,
422: change_severity VARCHAR2(1) := FND_API.G_FALSE,
423: change_exp_res_date VARCHAR2(1) := FND_API.G_FALSE,
424: new_action VARCHAR2(1) := FND_API.G_FALSE,
425: new_workflow VARCHAR2(1) := FND_API.G_FALSE,

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

418: change_assigned_time VARCHAR2(1) := FND_API.G_FALSE,
419: change_platform_org_id VARCHAR2(1) := FND_API.G_FALSE,
420: change_type VARCHAR2(1) := FND_API.G_FALSE,
421: change_urgency VARCHAR2(1) := FND_API.G_FALSE,
422: change_severity VARCHAR2(1) := FND_API.G_FALSE,
423: change_exp_res_date VARCHAR2(1) := FND_API.G_FALSE,
424: new_action VARCHAR2(1) := FND_API.G_FALSE,
425: new_workflow VARCHAR2(1) := FND_API.G_FALSE,
426: change_obligation_date VARCHAR2(1) := FND_API.G_FALSE,

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

419: change_platform_org_id VARCHAR2(1) := FND_API.G_FALSE,
420: change_type VARCHAR2(1) := FND_API.G_FALSE,
421: change_urgency VARCHAR2(1) := FND_API.G_FALSE,
422: change_severity VARCHAR2(1) := FND_API.G_FALSE,
423: change_exp_res_date VARCHAR2(1) := FND_API.G_FALSE,
424: new_action VARCHAR2(1) := FND_API.G_FALSE,
425: new_workflow VARCHAR2(1) := FND_API.G_FALSE,
426: change_obligation_date VARCHAR2(1) := FND_API.G_FALSE,
427: change_site_id VARCHAR2(1) := FND_API.G_FALSE,

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

420: change_type VARCHAR2(1) := FND_API.G_FALSE,
421: change_urgency VARCHAR2(1) := FND_API.G_FALSE,
422: change_severity VARCHAR2(1) := FND_API.G_FALSE,
423: change_exp_res_date VARCHAR2(1) := FND_API.G_FALSE,
424: new_action VARCHAR2(1) := FND_API.G_FALSE,
425: new_workflow VARCHAR2(1) := FND_API.G_FALSE,
426: change_obligation_date VARCHAR2(1) := FND_API.G_FALSE,
427: change_site_id VARCHAR2(1) := FND_API.G_FALSE,
428: change_contact_id VARCHAR2(1) := FND_API.G_FALSE,

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

421: change_urgency VARCHAR2(1) := FND_API.G_FALSE,
422: change_severity VARCHAR2(1) := FND_API.G_FALSE,
423: change_exp_res_date VARCHAR2(1) := FND_API.G_FALSE,
424: new_action VARCHAR2(1) := FND_API.G_FALSE,
425: new_workflow VARCHAR2(1) := FND_API.G_FALSE,
426: change_obligation_date VARCHAR2(1) := FND_API.G_FALSE,
427: change_site_id VARCHAR2(1) := FND_API.G_FALSE,
428: change_contact_id VARCHAR2(1) := FND_API.G_FALSE,
429: change_bill_to_contact_id VARCHAR2(1) := FND_API.G_FALSE,

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

422: change_severity VARCHAR2(1) := FND_API.G_FALSE,
423: change_exp_res_date VARCHAR2(1) := FND_API.G_FALSE,
424: new_action VARCHAR2(1) := FND_API.G_FALSE,
425: new_workflow VARCHAR2(1) := FND_API.G_FALSE,
426: change_obligation_date VARCHAR2(1) := FND_API.G_FALSE,
427: change_site_id VARCHAR2(1) := FND_API.G_FALSE,
428: change_contact_id VARCHAR2(1) := FND_API.G_FALSE,
429: change_bill_to_contact_id VARCHAR2(1) := FND_API.G_FALSE,
430: change_ship_to_contact_id VARCHAR2(1) := FND_API.G_FALSE,

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

423: change_exp_res_date VARCHAR2(1) := FND_API.G_FALSE,
424: new_action VARCHAR2(1) := FND_API.G_FALSE,
425: new_workflow VARCHAR2(1) := FND_API.G_FALSE,
426: change_obligation_date VARCHAR2(1) := FND_API.G_FALSE,
427: change_site_id VARCHAR2(1) := FND_API.G_FALSE,
428: change_contact_id VARCHAR2(1) := FND_API.G_FALSE,
429: change_bill_to_contact_id VARCHAR2(1) := FND_API.G_FALSE,
430: change_ship_to_contact_id VARCHAR2(1) := FND_API.G_FALSE,
431: change_incident_date VARCHAR2(1) := FND_API.G_FALSE,

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

424: new_action VARCHAR2(1) := FND_API.G_FALSE,
425: new_workflow VARCHAR2(1) := FND_API.G_FALSE,
426: change_obligation_date VARCHAR2(1) := FND_API.G_FALSE,
427: change_site_id VARCHAR2(1) := FND_API.G_FALSE,
428: change_contact_id VARCHAR2(1) := FND_API.G_FALSE,
429: change_bill_to_contact_id VARCHAR2(1) := FND_API.G_FALSE,
430: change_ship_to_contact_id VARCHAR2(1) := FND_API.G_FALSE,
431: change_incident_date VARCHAR2(1) := FND_API.G_FALSE,
432: change_close_date VARCHAR2(1) := FND_API.G_FALSE,

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

425: new_workflow VARCHAR2(1) := FND_API.G_FALSE,
426: change_obligation_date VARCHAR2(1) := FND_API.G_FALSE,
427: change_site_id VARCHAR2(1) := FND_API.G_FALSE,
428: change_contact_id VARCHAR2(1) := FND_API.G_FALSE,
429: change_bill_to_contact_id VARCHAR2(1) := FND_API.G_FALSE,
430: change_ship_to_contact_id VARCHAR2(1) := FND_API.G_FALSE,
431: change_incident_date VARCHAR2(1) := FND_API.G_FALSE,
432: change_close_date VARCHAR2(1) := FND_API.G_FALSE,
433: change_customer_product_id VARCHAR2(1) := FND_API.G_FALSE,

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

426: change_obligation_date VARCHAR2(1) := FND_API.G_FALSE,
427: change_site_id VARCHAR2(1) := FND_API.G_FALSE,
428: change_contact_id VARCHAR2(1) := FND_API.G_FALSE,
429: change_bill_to_contact_id VARCHAR2(1) := FND_API.G_FALSE,
430: change_ship_to_contact_id VARCHAR2(1) := FND_API.G_FALSE,
431: change_incident_date VARCHAR2(1) := FND_API.G_FALSE,
432: change_close_date VARCHAR2(1) := FND_API.G_FALSE,
433: change_customer_product_id VARCHAR2(1) := FND_API.G_FALSE,
434: change_platform_id VARCHAR2(1) := FND_API.G_FALSE,

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

427: change_site_id VARCHAR2(1) := FND_API.G_FALSE,
428: change_contact_id VARCHAR2(1) := FND_API.G_FALSE,
429: change_bill_to_contact_id VARCHAR2(1) := FND_API.G_FALSE,
430: change_ship_to_contact_id VARCHAR2(1) := FND_API.G_FALSE,
431: change_incident_date VARCHAR2(1) := FND_API.G_FALSE,
432: change_close_date VARCHAR2(1) := FND_API.G_FALSE,
433: change_customer_product_id VARCHAR2(1) := FND_API.G_FALSE,
434: change_platform_id VARCHAR2(1) := FND_API.G_FALSE,
435: change_plat_ver_id VARCHAR2(1) := FND_API.G_FALSE,

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

428: change_contact_id VARCHAR2(1) := FND_API.G_FALSE,
429: change_bill_to_contact_id VARCHAR2(1) := FND_API.G_FALSE,
430: change_ship_to_contact_id VARCHAR2(1) := FND_API.G_FALSE,
431: change_incident_date VARCHAR2(1) := FND_API.G_FALSE,
432: change_close_date VARCHAR2(1) := FND_API.G_FALSE,
433: change_customer_product_id VARCHAR2(1) := FND_API.G_FALSE,
434: change_platform_id VARCHAR2(1) := FND_API.G_FALSE,
435: change_plat_ver_id VARCHAR2(1) := FND_API.G_FALSE,
436: change_cp_comp_id VARCHAR2(1) := FND_API.G_FALSE,

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

429: change_bill_to_contact_id VARCHAR2(1) := FND_API.G_FALSE,
430: change_ship_to_contact_id VARCHAR2(1) := FND_API.G_FALSE,
431: change_incident_date VARCHAR2(1) := FND_API.G_FALSE,
432: change_close_date VARCHAR2(1) := FND_API.G_FALSE,
433: change_customer_product_id VARCHAR2(1) := FND_API.G_FALSE,
434: change_platform_id VARCHAR2(1) := FND_API.G_FALSE,
435: change_plat_ver_id VARCHAR2(1) := FND_API.G_FALSE,
436: change_cp_comp_id VARCHAR2(1) := FND_API.G_FALSE,
437: change_cp_pro_rev VARCHAR2(1) := FND_API.G_FALSE,

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

430: change_ship_to_contact_id VARCHAR2(1) := FND_API.G_FALSE,
431: change_incident_date VARCHAR2(1) := FND_API.G_FALSE,
432: change_close_date VARCHAR2(1) := FND_API.G_FALSE,
433: change_customer_product_id VARCHAR2(1) := FND_API.G_FALSE,
434: change_platform_id VARCHAR2(1) := FND_API.G_FALSE,
435: change_plat_ver_id VARCHAR2(1) := FND_API.G_FALSE,
436: change_cp_comp_id VARCHAR2(1) := FND_API.G_FALSE,
437: change_cp_pro_rev VARCHAR2(1) := FND_API.G_FALSE,
438: change_cp_comp_ver_id VARCHAR2(1) := FND_API.G_FALSE,

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

431: change_incident_date VARCHAR2(1) := FND_API.G_FALSE,
432: change_close_date VARCHAR2(1) := FND_API.G_FALSE,
433: change_customer_product_id VARCHAR2(1) := FND_API.G_FALSE,
434: change_platform_id VARCHAR2(1) := FND_API.G_FALSE,
435: change_plat_ver_id VARCHAR2(1) := FND_API.G_FALSE,
436: change_cp_comp_id VARCHAR2(1) := FND_API.G_FALSE,
437: change_cp_pro_rev VARCHAR2(1) := FND_API.G_FALSE,
438: change_cp_comp_ver_id VARCHAR2(1) := FND_API.G_FALSE,
439: change_cp_comp_ver VARCHAR2(1) := FND_API.G_FALSE,

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

432: change_close_date VARCHAR2(1) := FND_API.G_FALSE,
433: change_customer_product_id VARCHAR2(1) := FND_API.G_FALSE,
434: change_platform_id VARCHAR2(1) := FND_API.G_FALSE,
435: change_plat_ver_id VARCHAR2(1) := FND_API.G_FALSE,
436: change_cp_comp_id VARCHAR2(1) := FND_API.G_FALSE,
437: change_cp_pro_rev VARCHAR2(1) := FND_API.G_FALSE,
438: change_cp_comp_ver_id VARCHAR2(1) := FND_API.G_FALSE,
439: change_cp_comp_ver VARCHAR2(1) := FND_API.G_FALSE,
440: change_cp_subcomp_id VARCHAR2(1) := FND_API.G_FALSE,

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

433: change_customer_product_id VARCHAR2(1) := FND_API.G_FALSE,
434: change_platform_id VARCHAR2(1) := FND_API.G_FALSE,
435: change_plat_ver_id VARCHAR2(1) := FND_API.G_FALSE,
436: change_cp_comp_id VARCHAR2(1) := FND_API.G_FALSE,
437: change_cp_pro_rev VARCHAR2(1) := FND_API.G_FALSE,
438: change_cp_comp_ver_id VARCHAR2(1) := FND_API.G_FALSE,
439: change_cp_comp_ver VARCHAR2(1) := FND_API.G_FALSE,
440: change_cp_subcomp_id VARCHAR2(1) := FND_API.G_FALSE,
441: change_cp_subcomp_ver VARCHAR2(1) := FND_API.G_FALSE,

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

434: change_platform_id VARCHAR2(1) := FND_API.G_FALSE,
435: change_plat_ver_id VARCHAR2(1) := FND_API.G_FALSE,
436: change_cp_comp_id VARCHAR2(1) := FND_API.G_FALSE,
437: change_cp_pro_rev VARCHAR2(1) := FND_API.G_FALSE,
438: change_cp_comp_ver_id VARCHAR2(1) := FND_API.G_FALSE,
439: change_cp_comp_ver VARCHAR2(1) := FND_API.G_FALSE,
440: change_cp_subcomp_id VARCHAR2(1) := FND_API.G_FALSE,
441: change_cp_subcomp_ver VARCHAR2(1) := FND_API.G_FALSE,
442: change_cp_subcomp_ver_id VARCHAR2(1) := FND_API.G_FALSE,

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

435: change_plat_ver_id VARCHAR2(1) := FND_API.G_FALSE,
436: change_cp_comp_id VARCHAR2(1) := FND_API.G_FALSE,
437: change_cp_pro_rev VARCHAR2(1) := FND_API.G_FALSE,
438: change_cp_comp_ver_id VARCHAR2(1) := FND_API.G_FALSE,
439: change_cp_comp_ver VARCHAR2(1) := FND_API.G_FALSE,
440: change_cp_subcomp_id VARCHAR2(1) := FND_API.G_FALSE,
441: change_cp_subcomp_ver VARCHAR2(1) := FND_API.G_FALSE,
442: change_cp_subcomp_ver_id VARCHAR2(1) := FND_API.G_FALSE,
443: change_language_id VARCHAR2(1) := FND_API.G_FALSE,

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

436: change_cp_comp_id VARCHAR2(1) := FND_API.G_FALSE,
437: change_cp_pro_rev VARCHAR2(1) := FND_API.G_FALSE,
438: change_cp_comp_ver_id VARCHAR2(1) := FND_API.G_FALSE,
439: change_cp_comp_ver VARCHAR2(1) := FND_API.G_FALSE,
440: change_cp_subcomp_id VARCHAR2(1) := FND_API.G_FALSE,
441: change_cp_subcomp_ver VARCHAR2(1) := FND_API.G_FALSE,
442: change_cp_subcomp_ver_id VARCHAR2(1) := FND_API.G_FALSE,
443: change_language_id VARCHAR2(1) := FND_API.G_FALSE,
444: change_cp_rev_id VARCHAR2(1) := FND_API.G_FALSE,

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

437: change_cp_pro_rev VARCHAR2(1) := FND_API.G_FALSE,
438: change_cp_comp_ver_id VARCHAR2(1) := FND_API.G_FALSE,
439: change_cp_comp_ver VARCHAR2(1) := FND_API.G_FALSE,
440: change_cp_subcomp_id VARCHAR2(1) := FND_API.G_FALSE,
441: change_cp_subcomp_ver VARCHAR2(1) := FND_API.G_FALSE,
442: change_cp_subcomp_ver_id VARCHAR2(1) := FND_API.G_FALSE,
443: change_language_id VARCHAR2(1) := FND_API.G_FALSE,
444: change_cp_rev_id VARCHAR2(1) := FND_API.G_FALSE,
445: change_inv_item_rev VARCHAR2(1) := FND_API.G_FALSE,

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

438: change_cp_comp_ver_id VARCHAR2(1) := FND_API.G_FALSE,
439: change_cp_comp_ver VARCHAR2(1) := FND_API.G_FALSE,
440: change_cp_subcomp_id VARCHAR2(1) := FND_API.G_FALSE,
441: change_cp_subcomp_ver VARCHAR2(1) := FND_API.G_FALSE,
442: change_cp_subcomp_ver_id VARCHAR2(1) := FND_API.G_FALSE,
443: change_language_id VARCHAR2(1) := FND_API.G_FALSE,
444: change_cp_rev_id VARCHAR2(1) := FND_API.G_FALSE,
445: change_inv_item_rev VARCHAR2(1) := FND_API.G_FALSE,
446: change_inv_comp_id VARCHAR2(1) := FND_API.G_FALSE,

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

439: change_cp_comp_ver VARCHAR2(1) := FND_API.G_FALSE,
440: change_cp_subcomp_id VARCHAR2(1) := FND_API.G_FALSE,
441: change_cp_subcomp_ver VARCHAR2(1) := FND_API.G_FALSE,
442: change_cp_subcomp_ver_id VARCHAR2(1) := FND_API.G_FALSE,
443: change_language_id VARCHAR2(1) := FND_API.G_FALSE,
444: change_cp_rev_id VARCHAR2(1) := FND_API.G_FALSE,
445: change_inv_item_rev VARCHAR2(1) := FND_API.G_FALSE,
446: change_inv_comp_id VARCHAR2(1) := FND_API.G_FALSE,
447: change_inv_comp_ver VARCHAR2(1) := FND_API.G_FALSE,

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

440: change_cp_subcomp_id VARCHAR2(1) := FND_API.G_FALSE,
441: change_cp_subcomp_ver VARCHAR2(1) := FND_API.G_FALSE,
442: change_cp_subcomp_ver_id VARCHAR2(1) := FND_API.G_FALSE,
443: change_language_id VARCHAR2(1) := FND_API.G_FALSE,
444: change_cp_rev_id VARCHAR2(1) := FND_API.G_FALSE,
445: change_inv_item_rev VARCHAR2(1) := FND_API.G_FALSE,
446: change_inv_comp_id VARCHAR2(1) := FND_API.G_FALSE,
447: change_inv_comp_ver VARCHAR2(1) := FND_API.G_FALSE,
448: change_inv_subcomp_id VARCHAR2(1) := FND_API.G_FALSE,

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

441: change_cp_subcomp_ver VARCHAR2(1) := FND_API.G_FALSE,
442: change_cp_subcomp_ver_id VARCHAR2(1) := FND_API.G_FALSE,
443: change_language_id VARCHAR2(1) := FND_API.G_FALSE,
444: change_cp_rev_id VARCHAR2(1) := FND_API.G_FALSE,
445: change_inv_item_rev VARCHAR2(1) := FND_API.G_FALSE,
446: change_inv_comp_id VARCHAR2(1) := FND_API.G_FALSE,
447: change_inv_comp_ver VARCHAR2(1) := FND_API.G_FALSE,
448: change_inv_subcomp_id VARCHAR2(1) := FND_API.G_FALSE,
449: change_inv_subcomp_ver VARCHAR2(1) := FND_API.G_FALSE,

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

442: change_cp_subcomp_ver_id VARCHAR2(1) := FND_API.G_FALSE,
443: change_language_id VARCHAR2(1) := FND_API.G_FALSE,
444: change_cp_rev_id VARCHAR2(1) := FND_API.G_FALSE,
445: change_inv_item_rev VARCHAR2(1) := FND_API.G_FALSE,
446: change_inv_comp_id VARCHAR2(1) := FND_API.G_FALSE,
447: change_inv_comp_ver VARCHAR2(1) := FND_API.G_FALSE,
448: change_inv_subcomp_id VARCHAR2(1) := FND_API.G_FALSE,
449: change_inv_subcomp_ver VARCHAR2(1) := FND_API.G_FALSE,
450: change_territory_id VARCHAR2(1) := FND_API.G_FALSE,

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

443: change_language_id VARCHAR2(1) := FND_API.G_FALSE,
444: change_cp_rev_id VARCHAR2(1) := FND_API.G_FALSE,
445: change_inv_item_rev VARCHAR2(1) := FND_API.G_FALSE,
446: change_inv_comp_id VARCHAR2(1) := FND_API.G_FALSE,
447: change_inv_comp_ver VARCHAR2(1) := FND_API.G_FALSE,
448: change_inv_subcomp_id VARCHAR2(1) := FND_API.G_FALSE,
449: change_inv_subcomp_ver VARCHAR2(1) := FND_API.G_FALSE,
450: change_territory_id VARCHAR2(1) := FND_API.G_FALSE,
451: change_resource_type VARCHAR2(1) := FND_API.G_FALSE

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

444: change_cp_rev_id VARCHAR2(1) := FND_API.G_FALSE,
445: change_inv_item_rev VARCHAR2(1) := FND_API.G_FALSE,
446: change_inv_comp_id VARCHAR2(1) := FND_API.G_FALSE,
447: change_inv_comp_ver VARCHAR2(1) := FND_API.G_FALSE,
448: change_inv_subcomp_id VARCHAR2(1) := FND_API.G_FALSE,
449: change_inv_subcomp_ver VARCHAR2(1) := FND_API.G_FALSE,
450: change_territory_id VARCHAR2(1) := FND_API.G_FALSE,
451: change_resource_type VARCHAR2(1) := FND_API.G_FALSE
452: );

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

445: change_inv_item_rev VARCHAR2(1) := FND_API.G_FALSE,
446: change_inv_comp_id VARCHAR2(1) := FND_API.G_FALSE,
447: change_inv_comp_ver VARCHAR2(1) := FND_API.G_FALSE,
448: change_inv_subcomp_id VARCHAR2(1) := FND_API.G_FALSE,
449: change_inv_subcomp_ver VARCHAR2(1) := FND_API.G_FALSE,
450: change_territory_id VARCHAR2(1) := FND_API.G_FALSE,
451: change_resource_type VARCHAR2(1) := FND_API.G_FALSE
452: );
453:

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

446: change_inv_comp_id VARCHAR2(1) := FND_API.G_FALSE,
447: change_inv_comp_ver VARCHAR2(1) := FND_API.G_FALSE,
448: change_inv_subcomp_id VARCHAR2(1) := FND_API.G_FALSE,
449: change_inv_subcomp_ver VARCHAR2(1) := FND_API.G_FALSE,
450: change_territory_id VARCHAR2(1) := FND_API.G_FALSE,
451: change_resource_type VARCHAR2(1) := FND_API.G_FALSE
452: );
453:
454: TYPE audit_vals_rec_type IS RECORD (

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

447: change_inv_comp_ver VARCHAR2(1) := FND_API.G_FALSE,
448: change_inv_subcomp_id VARCHAR2(1) := FND_API.G_FALSE,
449: change_inv_subcomp_ver VARCHAR2(1) := FND_API.G_FALSE,
450: change_territory_id VARCHAR2(1) := FND_API.G_FALSE,
451: change_resource_type VARCHAR2(1) := FND_API.G_FALSE
452: );
453:
454: TYPE audit_vals_rec_type IS RECORD (
455: status_id NUMBER := FND_API.G_MISS_NUM,

Line 455: status_id NUMBER := FND_API.G_MISS_NUM,

451: change_resource_type VARCHAR2(1) := FND_API.G_FALSE
452: );
453:
454: TYPE audit_vals_rec_type IS RECORD (
455: status_id NUMBER := FND_API.G_MISS_NUM,
456: owner_id NUMBER := FND_API.G_MISS_NUM,
457: group_id NUMBER := FND_API.G_MISS_NUM,
458: group_type VARCHAR2(30) :=FND_API.G_MISS_CHAR,
459: owner_assigned_time DATE := FND_API.G_MISS_DATE,

Line 456: owner_id NUMBER := FND_API.G_MISS_NUM,

452: );
453:
454: TYPE audit_vals_rec_type IS RECORD (
455: status_id NUMBER := FND_API.G_MISS_NUM,
456: owner_id NUMBER := FND_API.G_MISS_NUM,
457: group_id NUMBER := FND_API.G_MISS_NUM,
458: group_type VARCHAR2(30) :=FND_API.G_MISS_CHAR,
459: owner_assigned_time DATE := FND_API.G_MISS_DATE,
460: inv_platform_org_id NUMBER := FND_API.G_MISS_NUM,

Line 457: group_id NUMBER := FND_API.G_MISS_NUM,

453:
454: TYPE audit_vals_rec_type IS RECORD (
455: status_id NUMBER := FND_API.G_MISS_NUM,
456: owner_id NUMBER := FND_API.G_MISS_NUM,
457: group_id NUMBER := FND_API.G_MISS_NUM,
458: group_type VARCHAR2(30) :=FND_API.G_MISS_CHAR,
459: owner_assigned_time DATE := FND_API.G_MISS_DATE,
460: inv_platform_org_id NUMBER := FND_API.G_MISS_NUM,
461: type_id NUMBER := FND_API.G_MISS_NUM,

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

454: TYPE audit_vals_rec_type IS RECORD (
455: status_id NUMBER := FND_API.G_MISS_NUM,
456: owner_id NUMBER := FND_API.G_MISS_NUM,
457: group_id NUMBER := FND_API.G_MISS_NUM,
458: group_type VARCHAR2(30) :=FND_API.G_MISS_CHAR,
459: owner_assigned_time DATE := FND_API.G_MISS_DATE,
460: inv_platform_org_id NUMBER := FND_API.G_MISS_NUM,
461: type_id NUMBER := FND_API.G_MISS_NUM,
462: urgency_id NUMBER := FND_API.G_MISS_NUM,

Line 459: owner_assigned_time DATE := FND_API.G_MISS_DATE,

455: status_id NUMBER := FND_API.G_MISS_NUM,
456: owner_id NUMBER := FND_API.G_MISS_NUM,
457: group_id NUMBER := FND_API.G_MISS_NUM,
458: group_type VARCHAR2(30) :=FND_API.G_MISS_CHAR,
459: owner_assigned_time DATE := FND_API.G_MISS_DATE,
460: inv_platform_org_id NUMBER := FND_API.G_MISS_NUM,
461: type_id NUMBER := FND_API.G_MISS_NUM,
462: urgency_id NUMBER := FND_API.G_MISS_NUM,
463: severity_id NUMBER := FND_API.G_MISS_NUM,

Line 460: inv_platform_org_id NUMBER := FND_API.G_MISS_NUM,

456: owner_id NUMBER := FND_API.G_MISS_NUM,
457: group_id NUMBER := FND_API.G_MISS_NUM,
458: group_type VARCHAR2(30) :=FND_API.G_MISS_CHAR,
459: owner_assigned_time DATE := FND_API.G_MISS_DATE,
460: inv_platform_org_id NUMBER := FND_API.G_MISS_NUM,
461: type_id NUMBER := FND_API.G_MISS_NUM,
462: urgency_id NUMBER := FND_API.G_MISS_NUM,
463: severity_id NUMBER := FND_API.G_MISS_NUM,
464: exp_res_date DATE := FND_API.G_MISS_DATE,

Line 461: type_id NUMBER := FND_API.G_MISS_NUM,

457: group_id NUMBER := FND_API.G_MISS_NUM,
458: group_type VARCHAR2(30) :=FND_API.G_MISS_CHAR,
459: owner_assigned_time DATE := FND_API.G_MISS_DATE,
460: inv_platform_org_id NUMBER := FND_API.G_MISS_NUM,
461: type_id NUMBER := FND_API.G_MISS_NUM,
462: urgency_id NUMBER := FND_API.G_MISS_NUM,
463: severity_id NUMBER := FND_API.G_MISS_NUM,
464: exp_res_date DATE := FND_API.G_MISS_DATE,
465: obligation_date DATE := FND_API.G_MISS_DATE,

Line 462: urgency_id NUMBER := FND_API.G_MISS_NUM,

458: group_type VARCHAR2(30) :=FND_API.G_MISS_CHAR,
459: owner_assigned_time DATE := FND_API.G_MISS_DATE,
460: inv_platform_org_id NUMBER := FND_API.G_MISS_NUM,
461: type_id NUMBER := FND_API.G_MISS_NUM,
462: urgency_id NUMBER := FND_API.G_MISS_NUM,
463: severity_id NUMBER := FND_API.G_MISS_NUM,
464: exp_res_date DATE := FND_API.G_MISS_DATE,
465: obligation_date DATE := FND_API.G_MISS_DATE,
466: site_id NUMBER := FND_API.G_MISS_NUM,

Line 463: severity_id NUMBER := FND_API.G_MISS_NUM,

459: owner_assigned_time DATE := FND_API.G_MISS_DATE,
460: inv_platform_org_id NUMBER := FND_API.G_MISS_NUM,
461: type_id NUMBER := FND_API.G_MISS_NUM,
462: urgency_id NUMBER := FND_API.G_MISS_NUM,
463: severity_id NUMBER := FND_API.G_MISS_NUM,
464: exp_res_date DATE := FND_API.G_MISS_DATE,
465: obligation_date DATE := FND_API.G_MISS_DATE,
466: site_id NUMBER := FND_API.G_MISS_NUM,
467: contact_id NUMBER := FND_API.G_MISS_NUM,

Line 464: exp_res_date DATE := FND_API.G_MISS_DATE,

460: inv_platform_org_id NUMBER := FND_API.G_MISS_NUM,
461: type_id NUMBER := FND_API.G_MISS_NUM,
462: urgency_id NUMBER := FND_API.G_MISS_NUM,
463: severity_id NUMBER := FND_API.G_MISS_NUM,
464: exp_res_date DATE := FND_API.G_MISS_DATE,
465: obligation_date DATE := FND_API.G_MISS_DATE,
466: site_id NUMBER := FND_API.G_MISS_NUM,
467: contact_id NUMBER := FND_API.G_MISS_NUM,
468: bill_to_contact_id NUMBER := FND_API.G_MISS_NUM,

Line 465: obligation_date DATE := FND_API.G_MISS_DATE,

461: type_id NUMBER := FND_API.G_MISS_NUM,
462: urgency_id NUMBER := FND_API.G_MISS_NUM,
463: severity_id NUMBER := FND_API.G_MISS_NUM,
464: exp_res_date DATE := FND_API.G_MISS_DATE,
465: obligation_date DATE := FND_API.G_MISS_DATE,
466: site_id NUMBER := FND_API.G_MISS_NUM,
467: contact_id NUMBER := FND_API.G_MISS_NUM,
468: bill_to_contact_id NUMBER := FND_API.G_MISS_NUM,
469: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,

Line 466: site_id NUMBER := FND_API.G_MISS_NUM,

462: urgency_id NUMBER := FND_API.G_MISS_NUM,
463: severity_id NUMBER := FND_API.G_MISS_NUM,
464: exp_res_date DATE := FND_API.G_MISS_DATE,
465: obligation_date DATE := FND_API.G_MISS_DATE,
466: site_id NUMBER := FND_API.G_MISS_NUM,
467: contact_id NUMBER := FND_API.G_MISS_NUM,
468: bill_to_contact_id NUMBER := FND_API.G_MISS_NUM,
469: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,
470: incident_date DATE := FND_API.G_MISS_DATE,

Line 467: contact_id NUMBER := FND_API.G_MISS_NUM,

463: severity_id NUMBER := FND_API.G_MISS_NUM,
464: exp_res_date DATE := FND_API.G_MISS_DATE,
465: obligation_date DATE := FND_API.G_MISS_DATE,
466: site_id NUMBER := FND_API.G_MISS_NUM,
467: contact_id NUMBER := FND_API.G_MISS_NUM,
468: bill_to_contact_id NUMBER := FND_API.G_MISS_NUM,
469: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,
470: incident_date DATE := FND_API.G_MISS_DATE,
471: close_date DATE := FND_API.G_MISS_DATE,

Line 468: bill_to_contact_id NUMBER := FND_API.G_MISS_NUM,

464: exp_res_date DATE := FND_API.G_MISS_DATE,
465: obligation_date DATE := FND_API.G_MISS_DATE,
466: site_id NUMBER := FND_API.G_MISS_NUM,
467: contact_id NUMBER := FND_API.G_MISS_NUM,
468: bill_to_contact_id NUMBER := FND_API.G_MISS_NUM,
469: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,
470: incident_date DATE := FND_API.G_MISS_DATE,
471: close_date DATE := FND_API.G_MISS_DATE,
472: customer_product_id NUMBER := FND_API.G_MISS_NUM,

Line 469: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,

465: obligation_date DATE := FND_API.G_MISS_DATE,
466: site_id NUMBER := FND_API.G_MISS_NUM,
467: contact_id NUMBER := FND_API.G_MISS_NUM,
468: bill_to_contact_id NUMBER := FND_API.G_MISS_NUM,
469: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,
470: incident_date DATE := FND_API.G_MISS_DATE,
471: close_date DATE := FND_API.G_MISS_DATE,
472: customer_product_id NUMBER := FND_API.G_MISS_NUM,
473: platform_id NUMBER := FND_API.G_MISS_NUM,

Line 470: incident_date DATE := FND_API.G_MISS_DATE,

466: site_id NUMBER := FND_API.G_MISS_NUM,
467: contact_id NUMBER := FND_API.G_MISS_NUM,
468: bill_to_contact_id NUMBER := FND_API.G_MISS_NUM,
469: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,
470: incident_date DATE := FND_API.G_MISS_DATE,
471: close_date DATE := FND_API.G_MISS_DATE,
472: customer_product_id NUMBER := FND_API.G_MISS_NUM,
473: platform_id NUMBER := FND_API.G_MISS_NUM,
474: platform_version_id NUMBER := FND_API.G_MISS_NUM,

Line 471: close_date DATE := FND_API.G_MISS_DATE,

467: contact_id NUMBER := FND_API.G_MISS_NUM,
468: bill_to_contact_id NUMBER := FND_API.G_MISS_NUM,
469: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,
470: incident_date DATE := FND_API.G_MISS_DATE,
471: close_date DATE := FND_API.G_MISS_DATE,
472: customer_product_id NUMBER := FND_API.G_MISS_NUM,
473: platform_id NUMBER := FND_API.G_MISS_NUM,
474: platform_version_id NUMBER := FND_API.G_MISS_NUM,
475: cp_component_id NUMBER := FND_API.G_MISS_NUM,

Line 472: customer_product_id NUMBER := FND_API.G_MISS_NUM,

468: bill_to_contact_id NUMBER := FND_API.G_MISS_NUM,
469: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,
470: incident_date DATE := FND_API.G_MISS_DATE,
471: close_date DATE := FND_API.G_MISS_DATE,
472: customer_product_id NUMBER := FND_API.G_MISS_NUM,
473: platform_id NUMBER := FND_API.G_MISS_NUM,
474: platform_version_id NUMBER := FND_API.G_MISS_NUM,
475: cp_component_id NUMBER := FND_API.G_MISS_NUM,
476: product_revision VARCHAR2(240):= FND_API.G_MISS_CHAR,

Line 473: platform_id NUMBER := FND_API.G_MISS_NUM,

469: ship_to_contact_id NUMBER := FND_API.G_MISS_NUM,
470: incident_date DATE := FND_API.G_MISS_DATE,
471: close_date DATE := FND_API.G_MISS_DATE,
472: customer_product_id NUMBER := FND_API.G_MISS_NUM,
473: platform_id NUMBER := FND_API.G_MISS_NUM,
474: platform_version_id NUMBER := FND_API.G_MISS_NUM,
475: cp_component_id NUMBER := FND_API.G_MISS_NUM,
476: product_revision VARCHAR2(240):= FND_API.G_MISS_CHAR,
477: cp_component_version_id NUMBER := FND_API.G_MISS_NUM,

Line 474: platform_version_id NUMBER := FND_API.G_MISS_NUM,

470: incident_date DATE := FND_API.G_MISS_DATE,
471: close_date DATE := FND_API.G_MISS_DATE,
472: customer_product_id NUMBER := FND_API.G_MISS_NUM,
473: platform_id NUMBER := FND_API.G_MISS_NUM,
474: platform_version_id NUMBER := FND_API.G_MISS_NUM,
475: cp_component_id NUMBER := FND_API.G_MISS_NUM,
476: product_revision VARCHAR2(240):= FND_API.G_MISS_CHAR,
477: cp_component_version_id NUMBER := FND_API.G_MISS_NUM,
478: component_version VARCHAR2(3):= FND_API.G_MISS_CHAR,

Line 475: cp_component_id NUMBER := FND_API.G_MISS_NUM,

471: close_date DATE := FND_API.G_MISS_DATE,
472: customer_product_id NUMBER := FND_API.G_MISS_NUM,
473: platform_id NUMBER := FND_API.G_MISS_NUM,
474: platform_version_id NUMBER := FND_API.G_MISS_NUM,
475: cp_component_id NUMBER := FND_API.G_MISS_NUM,
476: product_revision VARCHAR2(240):= FND_API.G_MISS_CHAR,
477: cp_component_version_id NUMBER := FND_API.G_MISS_NUM,
478: component_version VARCHAR2(3):= FND_API.G_MISS_CHAR,
479: cp_subcomponent_id NUMBER := FND_API.G_MISS_NUM,

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

472: customer_product_id NUMBER := FND_API.G_MISS_NUM,
473: platform_id NUMBER := FND_API.G_MISS_NUM,
474: platform_version_id NUMBER := FND_API.G_MISS_NUM,
475: cp_component_id NUMBER := FND_API.G_MISS_NUM,
476: product_revision VARCHAR2(240):= FND_API.G_MISS_CHAR,
477: cp_component_version_id NUMBER := FND_API.G_MISS_NUM,
478: component_version VARCHAR2(3):= FND_API.G_MISS_CHAR,
479: cp_subcomponent_id NUMBER := FND_API.G_MISS_NUM,
480: cp_subcomponent_version_id NUMBER := FND_API.G_MISS_NUM,

Line 477: cp_component_version_id NUMBER := FND_API.G_MISS_NUM,

473: platform_id NUMBER := FND_API.G_MISS_NUM,
474: platform_version_id NUMBER := FND_API.G_MISS_NUM,
475: cp_component_id NUMBER := FND_API.G_MISS_NUM,
476: product_revision VARCHAR2(240):= FND_API.G_MISS_CHAR,
477: cp_component_version_id NUMBER := FND_API.G_MISS_NUM,
478: component_version VARCHAR2(3):= FND_API.G_MISS_CHAR,
479: cp_subcomponent_id NUMBER := FND_API.G_MISS_NUM,
480: cp_subcomponent_version_id NUMBER := FND_API.G_MISS_NUM,
481: subcomponent_version VARCHAR2(3):= FND_API.G_MISS_CHAR,

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

474: platform_version_id NUMBER := FND_API.G_MISS_NUM,
475: cp_component_id NUMBER := FND_API.G_MISS_NUM,
476: product_revision VARCHAR2(240):= FND_API.G_MISS_CHAR,
477: cp_component_version_id NUMBER := FND_API.G_MISS_NUM,
478: component_version VARCHAR2(3):= FND_API.G_MISS_CHAR,
479: cp_subcomponent_id NUMBER := FND_API.G_MISS_NUM,
480: cp_subcomponent_version_id NUMBER := FND_API.G_MISS_NUM,
481: subcomponent_version VARCHAR2(3):= FND_API.G_MISS_CHAR,
482: language_id NUMBER := FND_API.G_MISS_NUM,

Line 479: cp_subcomponent_id NUMBER := FND_API.G_MISS_NUM,

475: cp_component_id NUMBER := FND_API.G_MISS_NUM,
476: product_revision VARCHAR2(240):= FND_API.G_MISS_CHAR,
477: cp_component_version_id NUMBER := FND_API.G_MISS_NUM,
478: component_version VARCHAR2(3):= FND_API.G_MISS_CHAR,
479: cp_subcomponent_id NUMBER := FND_API.G_MISS_NUM,
480: cp_subcomponent_version_id NUMBER := FND_API.G_MISS_NUM,
481: subcomponent_version VARCHAR2(3):= FND_API.G_MISS_CHAR,
482: language_id NUMBER := FND_API.G_MISS_NUM,
483: cp_revision_id NUMBER := FND_API.G_MISS_NUM,

Line 480: cp_subcomponent_version_id NUMBER := FND_API.G_MISS_NUM,

476: product_revision VARCHAR2(240):= FND_API.G_MISS_CHAR,
477: cp_component_version_id NUMBER := FND_API.G_MISS_NUM,
478: component_version VARCHAR2(3):= FND_API.G_MISS_CHAR,
479: cp_subcomponent_id NUMBER := FND_API.G_MISS_NUM,
480: cp_subcomponent_version_id NUMBER := FND_API.G_MISS_NUM,
481: subcomponent_version VARCHAR2(3):= FND_API.G_MISS_CHAR,
482: language_id NUMBER := FND_API.G_MISS_NUM,
483: cp_revision_id NUMBER := FND_API.G_MISS_NUM,
484: inv_item_revision VARCHAR2(240) := FND_API.G_MISS_CHAR,

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

477: cp_component_version_id NUMBER := FND_API.G_MISS_NUM,
478: component_version VARCHAR2(3):= FND_API.G_MISS_CHAR,
479: cp_subcomponent_id NUMBER := FND_API.G_MISS_NUM,
480: cp_subcomponent_version_id NUMBER := FND_API.G_MISS_NUM,
481: subcomponent_version VARCHAR2(3):= FND_API.G_MISS_CHAR,
482: language_id NUMBER := FND_API.G_MISS_NUM,
483: cp_revision_id NUMBER := FND_API.G_MISS_NUM,
484: inv_item_revision VARCHAR2(240) := FND_API.G_MISS_CHAR,
485: inv_component_id NUMBER := FND_API.G_MISS_NUM,

Line 482: language_id NUMBER := FND_API.G_MISS_NUM,

478: component_version VARCHAR2(3):= FND_API.G_MISS_CHAR,
479: cp_subcomponent_id NUMBER := FND_API.G_MISS_NUM,
480: cp_subcomponent_version_id NUMBER := FND_API.G_MISS_NUM,
481: subcomponent_version VARCHAR2(3):= FND_API.G_MISS_CHAR,
482: language_id NUMBER := FND_API.G_MISS_NUM,
483: cp_revision_id NUMBER := FND_API.G_MISS_NUM,
484: inv_item_revision VARCHAR2(240) := FND_API.G_MISS_CHAR,
485: inv_component_id NUMBER := FND_API.G_MISS_NUM,
486: inv_component_version VARCHAR2(90) := FND_API.G_MISS_CHAR,

Line 483: cp_revision_id NUMBER := FND_API.G_MISS_NUM,

479: cp_subcomponent_id NUMBER := FND_API.G_MISS_NUM,
480: cp_subcomponent_version_id NUMBER := FND_API.G_MISS_NUM,
481: subcomponent_version VARCHAR2(3):= FND_API.G_MISS_CHAR,
482: language_id NUMBER := FND_API.G_MISS_NUM,
483: cp_revision_id NUMBER := FND_API.G_MISS_NUM,
484: inv_item_revision VARCHAR2(240) := FND_API.G_MISS_CHAR,
485: inv_component_id NUMBER := FND_API.G_MISS_NUM,
486: inv_component_version VARCHAR2(90) := FND_API.G_MISS_CHAR,
487: inv_subcomponent_id NUMBER := FND_API.G_MISS_NUM,

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

480: cp_subcomponent_version_id NUMBER := FND_API.G_MISS_NUM,
481: subcomponent_version VARCHAR2(3):= FND_API.G_MISS_CHAR,
482: language_id NUMBER := FND_API.G_MISS_NUM,
483: cp_revision_id NUMBER := FND_API.G_MISS_NUM,
484: inv_item_revision VARCHAR2(240) := FND_API.G_MISS_CHAR,
485: inv_component_id NUMBER := FND_API.G_MISS_NUM,
486: inv_component_version VARCHAR2(90) := FND_API.G_MISS_CHAR,
487: inv_subcomponent_id NUMBER := FND_API.G_MISS_NUM,
488: inv_subcomponent_version VARCHAR2(90) := FND_API.G_MISS_CHAR,

Line 485: inv_component_id NUMBER := FND_API.G_MISS_NUM,

481: subcomponent_version VARCHAR2(3):= FND_API.G_MISS_CHAR,
482: language_id NUMBER := FND_API.G_MISS_NUM,
483: cp_revision_id NUMBER := FND_API.G_MISS_NUM,
484: inv_item_revision VARCHAR2(240) := FND_API.G_MISS_CHAR,
485: inv_component_id NUMBER := FND_API.G_MISS_NUM,
486: inv_component_version VARCHAR2(90) := FND_API.G_MISS_CHAR,
487: inv_subcomponent_id NUMBER := FND_API.G_MISS_NUM,
488: inv_subcomponent_version VARCHAR2(90) := FND_API.G_MISS_CHAR,
489: territory_id NUMBER := FND_API.G_MISS_NUM,

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

482: language_id NUMBER := FND_API.G_MISS_NUM,
483: cp_revision_id NUMBER := FND_API.G_MISS_NUM,
484: inv_item_revision VARCHAR2(240) := FND_API.G_MISS_CHAR,
485: inv_component_id NUMBER := FND_API.G_MISS_NUM,
486: inv_component_version VARCHAR2(90) := FND_API.G_MISS_CHAR,
487: inv_subcomponent_id NUMBER := FND_API.G_MISS_NUM,
488: inv_subcomponent_version VARCHAR2(90) := FND_API.G_MISS_CHAR,
489: territory_id NUMBER := FND_API.G_MISS_NUM,
490: resource_type VARCHAR2(30) := FND_API.G_MISS_CHAR

Line 487: inv_subcomponent_id NUMBER := FND_API.G_MISS_NUM,

483: cp_revision_id NUMBER := FND_API.G_MISS_NUM,
484: inv_item_revision VARCHAR2(240) := FND_API.G_MISS_CHAR,
485: inv_component_id NUMBER := FND_API.G_MISS_NUM,
486: inv_component_version VARCHAR2(90) := FND_API.G_MISS_CHAR,
487: inv_subcomponent_id NUMBER := FND_API.G_MISS_NUM,
488: inv_subcomponent_version VARCHAR2(90) := FND_API.G_MISS_CHAR,
489: territory_id NUMBER := FND_API.G_MISS_NUM,
490: resource_type VARCHAR2(30) := FND_API.G_MISS_CHAR
491: );

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

484: inv_item_revision VARCHAR2(240) := FND_API.G_MISS_CHAR,
485: inv_component_id NUMBER := FND_API.G_MISS_NUM,
486: inv_component_version VARCHAR2(90) := FND_API.G_MISS_CHAR,
487: inv_subcomponent_id NUMBER := FND_API.G_MISS_NUM,
488: inv_subcomponent_version VARCHAR2(90) := FND_API.G_MISS_CHAR,
489: territory_id NUMBER := FND_API.G_MISS_NUM,
490: resource_type VARCHAR2(30) := FND_API.G_MISS_CHAR
491: );
492: G_MISS_AUDIT_VALS_REC audit_vals_rec_type;

Line 489: territory_id NUMBER := FND_API.G_MISS_NUM,

485: inv_component_id NUMBER := FND_API.G_MISS_NUM,
486: inv_component_version VARCHAR2(90) := FND_API.G_MISS_CHAR,
487: inv_subcomponent_id NUMBER := FND_API.G_MISS_NUM,
488: inv_subcomponent_version VARCHAR2(90) := FND_API.G_MISS_CHAR,
489: territory_id NUMBER := FND_API.G_MISS_NUM,
490: resource_type VARCHAR2(30) := FND_API.G_MISS_CHAR
491: );
492: G_MISS_AUDIT_VALS_REC audit_vals_rec_type;
493: ********** End of Comments - Use the Ne Audit Record ***/

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

486: inv_component_version VARCHAR2(90) := FND_API.G_MISS_CHAR,
487: inv_subcomponent_id NUMBER := FND_API.G_MISS_NUM,
488: inv_subcomponent_version VARCHAR2(90) := FND_API.G_MISS_CHAR,
489: territory_id NUMBER := FND_API.G_MISS_NUM,
490: resource_type VARCHAR2(30) := FND_API.G_MISS_CHAR
491: );
492: G_MISS_AUDIT_VALS_REC audit_vals_rec_type;
493: ********** End of Comments - Use the Ne Audit Record ***/
494:

Line 914: NOTE_ID NUMBER := FND_API.G_MISS_NUM,

910: -- A table within a record type is not possible. That's why I defined
911: -- three context fields in the following record type.
912: --
913: TYPE notes_rec IS RECORD (
914: NOTE_ID NUMBER := FND_API.G_MISS_NUM,
915: NOTE VARCHAR2(2000) := FND_API.G_MISS_CHAR,
916: NOTE_DETAIL VARCHAR2(32767) := FND_API.G_MISS_CHAR,
917: NOTE_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
918: NOTE_STATUS VARCHAR2(240) := FND_API.G_MISS_CHAR,

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

911: -- three context fields in the following record type.
912: --
913: TYPE notes_rec IS RECORD (
914: NOTE_ID NUMBER := FND_API.G_MISS_NUM,
915: NOTE VARCHAR2(2000) := FND_API.G_MISS_CHAR,
916: NOTE_DETAIL VARCHAR2(32767) := FND_API.G_MISS_CHAR,
917: NOTE_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
918: NOTE_STATUS VARCHAR2(240) := FND_API.G_MISS_CHAR,
919: ENTERED_BY NUMBER := FND_API.G_MISS_NUM,

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

912: --
913: TYPE notes_rec IS RECORD (
914: NOTE_ID NUMBER := FND_API.G_MISS_NUM,
915: NOTE VARCHAR2(2000) := FND_API.G_MISS_CHAR,
916: NOTE_DETAIL VARCHAR2(32767) := FND_API.G_MISS_CHAR,
917: NOTE_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
918: NOTE_STATUS VARCHAR2(240) := FND_API.G_MISS_CHAR,
919: ENTERED_BY NUMBER := FND_API.G_MISS_NUM,
920: ENTERED_DATE DATE := FND_API.G_MISS_DATE,

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

913: TYPE notes_rec IS RECORD (
914: NOTE_ID NUMBER := FND_API.G_MISS_NUM,
915: NOTE VARCHAR2(2000) := FND_API.G_MISS_CHAR,
916: NOTE_DETAIL VARCHAR2(32767) := FND_API.G_MISS_CHAR,
917: NOTE_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
918: NOTE_STATUS VARCHAR2(240) := FND_API.G_MISS_CHAR,
919: ENTERED_BY NUMBER := FND_API.G_MISS_NUM,
920: ENTERED_DATE DATE := FND_API.G_MISS_DATE,
921: SOURCE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,

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

914: NOTE_ID NUMBER := FND_API.G_MISS_NUM,
915: NOTE VARCHAR2(2000) := FND_API.G_MISS_CHAR,
916: NOTE_DETAIL VARCHAR2(32767) := FND_API.G_MISS_CHAR,
917: NOTE_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
918: NOTE_STATUS VARCHAR2(240) := FND_API.G_MISS_CHAR,
919: ENTERED_BY NUMBER := FND_API.G_MISS_NUM,
920: ENTERED_DATE DATE := FND_API.G_MISS_DATE,
921: SOURCE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
922: SOURCE_OBJECT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 919: ENTERED_BY NUMBER := FND_API.G_MISS_NUM,

915: NOTE VARCHAR2(2000) := FND_API.G_MISS_CHAR,
916: NOTE_DETAIL VARCHAR2(32767) := FND_API.G_MISS_CHAR,
917: NOTE_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
918: NOTE_STATUS VARCHAR2(240) := FND_API.G_MISS_CHAR,
919: ENTERED_BY NUMBER := FND_API.G_MISS_NUM,
920: ENTERED_DATE DATE := FND_API.G_MISS_DATE,
921: SOURCE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
922: SOURCE_OBJECT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
923: NOTE_CONTEXT_ID_01 NUMBER := FND_API.G_MISS_NUM,

Line 920: ENTERED_DATE DATE := FND_API.G_MISS_DATE,

916: NOTE_DETAIL VARCHAR2(32767) := FND_API.G_MISS_CHAR,
917: NOTE_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
918: NOTE_STATUS VARCHAR2(240) := FND_API.G_MISS_CHAR,
919: ENTERED_BY NUMBER := FND_API.G_MISS_NUM,
920: ENTERED_DATE DATE := FND_API.G_MISS_DATE,
921: SOURCE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
922: SOURCE_OBJECT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
923: NOTE_CONTEXT_ID_01 NUMBER := FND_API.G_MISS_NUM,
924: NOTE_CONTEXT_TYPE_01 VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 921: SOURCE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,

917: NOTE_TYPE VARCHAR2(240) := FND_API.G_MISS_CHAR,
918: NOTE_STATUS VARCHAR2(240) := FND_API.G_MISS_CHAR,
919: ENTERED_BY NUMBER := FND_API.G_MISS_NUM,
920: ENTERED_DATE DATE := FND_API.G_MISS_DATE,
921: SOURCE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
922: SOURCE_OBJECT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
923: NOTE_CONTEXT_ID_01 NUMBER := FND_API.G_MISS_NUM,
924: NOTE_CONTEXT_TYPE_01 VARCHAR2(30) := FND_API.G_MISS_CHAR,
925: NOTE_CONTEXT_TYPE_ID_01 NUMBER := FND_API.G_MISS_NUM,

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

918: NOTE_STATUS VARCHAR2(240) := FND_API.G_MISS_CHAR,
919: ENTERED_BY NUMBER := FND_API.G_MISS_NUM,
920: ENTERED_DATE DATE := FND_API.G_MISS_DATE,
921: SOURCE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
922: SOURCE_OBJECT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
923: NOTE_CONTEXT_ID_01 NUMBER := FND_API.G_MISS_NUM,
924: NOTE_CONTEXT_TYPE_01 VARCHAR2(30) := FND_API.G_MISS_CHAR,
925: NOTE_CONTEXT_TYPE_ID_01 NUMBER := FND_API.G_MISS_NUM,
926: NOTE_CONTEXT_ID_02 NUMBER := FND_API.G_MISS_NUM,

Line 923: NOTE_CONTEXT_ID_01 NUMBER := FND_API.G_MISS_NUM,

919: ENTERED_BY NUMBER := FND_API.G_MISS_NUM,
920: ENTERED_DATE DATE := FND_API.G_MISS_DATE,
921: SOURCE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
922: SOURCE_OBJECT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
923: NOTE_CONTEXT_ID_01 NUMBER := FND_API.G_MISS_NUM,
924: NOTE_CONTEXT_TYPE_01 VARCHAR2(30) := FND_API.G_MISS_CHAR,
925: NOTE_CONTEXT_TYPE_ID_01 NUMBER := FND_API.G_MISS_NUM,
926: NOTE_CONTEXT_ID_02 NUMBER := FND_API.G_MISS_NUM,
927: NOTE_CONTEXT_TYPE_02 VARCHAR2(30) := FND_API.G_MISS_CHAR,

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

920: ENTERED_DATE DATE := FND_API.G_MISS_DATE,
921: SOURCE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
922: SOURCE_OBJECT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
923: NOTE_CONTEXT_ID_01 NUMBER := FND_API.G_MISS_NUM,
924: NOTE_CONTEXT_TYPE_01 VARCHAR2(30) := FND_API.G_MISS_CHAR,
925: NOTE_CONTEXT_TYPE_ID_01 NUMBER := FND_API.G_MISS_NUM,
926: NOTE_CONTEXT_ID_02 NUMBER := FND_API.G_MISS_NUM,
927: NOTE_CONTEXT_TYPE_02 VARCHAR2(30) := FND_API.G_MISS_CHAR,
928: NOTE_CONTEXT_TYPE_ID_02 NUMBER := FND_API.G_MISS_NUM,

Line 925: NOTE_CONTEXT_TYPE_ID_01 NUMBER := FND_API.G_MISS_NUM,

921: SOURCE_OBJECT_ID NUMBER := FND_API.G_MISS_NUM,
922: SOURCE_OBJECT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
923: NOTE_CONTEXT_ID_01 NUMBER := FND_API.G_MISS_NUM,
924: NOTE_CONTEXT_TYPE_01 VARCHAR2(30) := FND_API.G_MISS_CHAR,
925: NOTE_CONTEXT_TYPE_ID_01 NUMBER := FND_API.G_MISS_NUM,
926: NOTE_CONTEXT_ID_02 NUMBER := FND_API.G_MISS_NUM,
927: NOTE_CONTEXT_TYPE_02 VARCHAR2(30) := FND_API.G_MISS_CHAR,
928: NOTE_CONTEXT_TYPE_ID_02 NUMBER := FND_API.G_MISS_NUM,
929: NOTE_CONTEXT_ID_03 NUMBER := FND_API.G_MISS_NUM,

Line 926: NOTE_CONTEXT_ID_02 NUMBER := FND_API.G_MISS_NUM,

922: SOURCE_OBJECT_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
923: NOTE_CONTEXT_ID_01 NUMBER := FND_API.G_MISS_NUM,
924: NOTE_CONTEXT_TYPE_01 VARCHAR2(30) := FND_API.G_MISS_CHAR,
925: NOTE_CONTEXT_TYPE_ID_01 NUMBER := FND_API.G_MISS_NUM,
926: NOTE_CONTEXT_ID_02 NUMBER := FND_API.G_MISS_NUM,
927: NOTE_CONTEXT_TYPE_02 VARCHAR2(30) := FND_API.G_MISS_CHAR,
928: NOTE_CONTEXT_TYPE_ID_02 NUMBER := FND_API.G_MISS_NUM,
929: NOTE_CONTEXT_ID_03 NUMBER := FND_API.G_MISS_NUM,
930: NOTE_CONTEXT_TYPE_03 VARCHAR2(30) := FND_API.G_MISS_CHAR,

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

923: NOTE_CONTEXT_ID_01 NUMBER := FND_API.G_MISS_NUM,
924: NOTE_CONTEXT_TYPE_01 VARCHAR2(30) := FND_API.G_MISS_CHAR,
925: NOTE_CONTEXT_TYPE_ID_01 NUMBER := FND_API.G_MISS_NUM,
926: NOTE_CONTEXT_ID_02 NUMBER := FND_API.G_MISS_NUM,
927: NOTE_CONTEXT_TYPE_02 VARCHAR2(30) := FND_API.G_MISS_CHAR,
928: NOTE_CONTEXT_TYPE_ID_02 NUMBER := FND_API.G_MISS_NUM,
929: NOTE_CONTEXT_ID_03 NUMBER := FND_API.G_MISS_NUM,
930: NOTE_CONTEXT_TYPE_03 VARCHAR2(30) := FND_API.G_MISS_CHAR,
931: NOTE_CONTEXT_TYPE_ID_03 NUMBER := FND_API.G_MISS_NUM,

Line 928: NOTE_CONTEXT_TYPE_ID_02 NUMBER := FND_API.G_MISS_NUM,

924: NOTE_CONTEXT_TYPE_01 VARCHAR2(30) := FND_API.G_MISS_CHAR,
925: NOTE_CONTEXT_TYPE_ID_01 NUMBER := FND_API.G_MISS_NUM,
926: NOTE_CONTEXT_ID_02 NUMBER := FND_API.G_MISS_NUM,
927: NOTE_CONTEXT_TYPE_02 VARCHAR2(30) := FND_API.G_MISS_CHAR,
928: NOTE_CONTEXT_TYPE_ID_02 NUMBER := FND_API.G_MISS_NUM,
929: NOTE_CONTEXT_ID_03 NUMBER := FND_API.G_MISS_NUM,
930: NOTE_CONTEXT_TYPE_03 VARCHAR2(30) := FND_API.G_MISS_CHAR,
931: NOTE_CONTEXT_TYPE_ID_03 NUMBER := FND_API.G_MISS_NUM,
932: ATTRIBUTE_1 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 929: NOTE_CONTEXT_ID_03 NUMBER := FND_API.G_MISS_NUM,

925: NOTE_CONTEXT_TYPE_ID_01 NUMBER := FND_API.G_MISS_NUM,
926: NOTE_CONTEXT_ID_02 NUMBER := FND_API.G_MISS_NUM,
927: NOTE_CONTEXT_TYPE_02 VARCHAR2(30) := FND_API.G_MISS_CHAR,
928: NOTE_CONTEXT_TYPE_ID_02 NUMBER := FND_API.G_MISS_NUM,
929: NOTE_CONTEXT_ID_03 NUMBER := FND_API.G_MISS_NUM,
930: NOTE_CONTEXT_TYPE_03 VARCHAR2(30) := FND_API.G_MISS_CHAR,
931: NOTE_CONTEXT_TYPE_ID_03 NUMBER := FND_API.G_MISS_NUM,
932: ATTRIBUTE_1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
933: ATTRIBUTE_2 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

926: NOTE_CONTEXT_ID_02 NUMBER := FND_API.G_MISS_NUM,
927: NOTE_CONTEXT_TYPE_02 VARCHAR2(30) := FND_API.G_MISS_CHAR,
928: NOTE_CONTEXT_TYPE_ID_02 NUMBER := FND_API.G_MISS_NUM,
929: NOTE_CONTEXT_ID_03 NUMBER := FND_API.G_MISS_NUM,
930: NOTE_CONTEXT_TYPE_03 VARCHAR2(30) := FND_API.G_MISS_CHAR,
931: NOTE_CONTEXT_TYPE_ID_03 NUMBER := FND_API.G_MISS_NUM,
932: ATTRIBUTE_1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
933: ATTRIBUTE_2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
934: ATTRIBUTE_3 VARCHAR2(150) := FND_API.G_MISS_CHAR,

Line 931: NOTE_CONTEXT_TYPE_ID_03 NUMBER := FND_API.G_MISS_NUM,

927: NOTE_CONTEXT_TYPE_02 VARCHAR2(30) := FND_API.G_MISS_CHAR,
928: NOTE_CONTEXT_TYPE_ID_02 NUMBER := FND_API.G_MISS_NUM,
929: NOTE_CONTEXT_ID_03 NUMBER := FND_API.G_MISS_NUM,
930: NOTE_CONTEXT_TYPE_03 VARCHAR2(30) := FND_API.G_MISS_CHAR,
931: NOTE_CONTEXT_TYPE_ID_03 NUMBER := FND_API.G_MISS_NUM,
932: ATTRIBUTE_1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
933: ATTRIBUTE_2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
934: ATTRIBUTE_3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
935: ATTRIBUTE_4 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

928: NOTE_CONTEXT_TYPE_ID_02 NUMBER := FND_API.G_MISS_NUM,
929: NOTE_CONTEXT_ID_03 NUMBER := FND_API.G_MISS_NUM,
930: NOTE_CONTEXT_TYPE_03 VARCHAR2(30) := FND_API.G_MISS_CHAR,
931: NOTE_CONTEXT_TYPE_ID_03 NUMBER := FND_API.G_MISS_NUM,
932: ATTRIBUTE_1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
933: ATTRIBUTE_2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
934: ATTRIBUTE_3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
935: ATTRIBUTE_4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
936: ATTRIBUTE_5 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

929: NOTE_CONTEXT_ID_03 NUMBER := FND_API.G_MISS_NUM,
930: NOTE_CONTEXT_TYPE_03 VARCHAR2(30) := FND_API.G_MISS_CHAR,
931: NOTE_CONTEXT_TYPE_ID_03 NUMBER := FND_API.G_MISS_NUM,
932: ATTRIBUTE_1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
933: ATTRIBUTE_2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
934: ATTRIBUTE_3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
935: ATTRIBUTE_4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
936: ATTRIBUTE_5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
937: ATTRIBUTE_6 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

930: NOTE_CONTEXT_TYPE_03 VARCHAR2(30) := FND_API.G_MISS_CHAR,
931: NOTE_CONTEXT_TYPE_ID_03 NUMBER := FND_API.G_MISS_NUM,
932: ATTRIBUTE_1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
933: ATTRIBUTE_2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
934: ATTRIBUTE_3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
935: ATTRIBUTE_4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
936: ATTRIBUTE_5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
937: ATTRIBUTE_6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
938: ATTRIBUTE_7 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

931: NOTE_CONTEXT_TYPE_ID_03 NUMBER := FND_API.G_MISS_NUM,
932: ATTRIBUTE_1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
933: ATTRIBUTE_2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
934: ATTRIBUTE_3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
935: ATTRIBUTE_4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
936: ATTRIBUTE_5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
937: ATTRIBUTE_6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
938: ATTRIBUTE_7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
939: ATTRIBUTE_8 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

932: ATTRIBUTE_1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
933: ATTRIBUTE_2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
934: ATTRIBUTE_3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
935: ATTRIBUTE_4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
936: ATTRIBUTE_5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
937: ATTRIBUTE_6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
938: ATTRIBUTE_7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
939: ATTRIBUTE_8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
940: ATTRIBUTE_9 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

933: ATTRIBUTE_2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
934: ATTRIBUTE_3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
935: ATTRIBUTE_4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
936: ATTRIBUTE_5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
937: ATTRIBUTE_6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
938: ATTRIBUTE_7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
939: ATTRIBUTE_8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
940: ATTRIBUTE_9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
941: ATTRIBUTE_10 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

934: ATTRIBUTE_3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
935: ATTRIBUTE_4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
936: ATTRIBUTE_5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
937: ATTRIBUTE_6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
938: ATTRIBUTE_7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
939: ATTRIBUTE_8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
940: ATTRIBUTE_9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
941: ATTRIBUTE_10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
942: ATTRIBUTE_11 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

935: ATTRIBUTE_4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
936: ATTRIBUTE_5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
937: ATTRIBUTE_6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
938: ATTRIBUTE_7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
939: ATTRIBUTE_8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
940: ATTRIBUTE_9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
941: ATTRIBUTE_10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
942: ATTRIBUTE_11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
943: ATTRIBUTE_12 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

936: ATTRIBUTE_5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
937: ATTRIBUTE_6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
938: ATTRIBUTE_7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
939: ATTRIBUTE_8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
940: ATTRIBUTE_9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
941: ATTRIBUTE_10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
942: ATTRIBUTE_11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
943: ATTRIBUTE_12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
944: ATTRIBUTE_13 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

937: ATTRIBUTE_6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
938: ATTRIBUTE_7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
939: ATTRIBUTE_8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
940: ATTRIBUTE_9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
941: ATTRIBUTE_10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
942: ATTRIBUTE_11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
943: ATTRIBUTE_12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
944: ATTRIBUTE_13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
945: ATTRIBUTE_14 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

938: ATTRIBUTE_7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
939: ATTRIBUTE_8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
940: ATTRIBUTE_9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
941: ATTRIBUTE_10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
942: ATTRIBUTE_11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
943: ATTRIBUTE_12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
944: ATTRIBUTE_13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
945: ATTRIBUTE_14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
946: ATTRIBUTE_15 VARCHAR2(150) := FND_API.G_MISS_CHAR,

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

939: ATTRIBUTE_8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
940: ATTRIBUTE_9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
941: ATTRIBUTE_10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
942: ATTRIBUTE_11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
943: ATTRIBUTE_12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
944: ATTRIBUTE_13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
945: ATTRIBUTE_14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
946: ATTRIBUTE_15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
947: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,

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

940: ATTRIBUTE_9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
941: ATTRIBUTE_10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
942: ATTRIBUTE_11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
943: ATTRIBUTE_12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
944: ATTRIBUTE_13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
945: ATTRIBUTE_14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
946: ATTRIBUTE_15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
947: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
948: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

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

941: ATTRIBUTE_10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
942: ATTRIBUTE_11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
943: ATTRIBUTE_12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
944: ATTRIBUTE_13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
945: ATTRIBUTE_14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
946: ATTRIBUTE_15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
947: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
948: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
949: CREATION_DATE DATE := FND_API.G_MISS_DATE,

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

942: ATTRIBUTE_11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
943: ATTRIBUTE_12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
944: ATTRIBUTE_13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
945: ATTRIBUTE_14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
946: ATTRIBUTE_15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
947: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
948: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
949: CREATION_DATE DATE := FND_API.G_MISS_DATE,
950: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

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

943: ATTRIBUTE_12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
944: ATTRIBUTE_13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
945: ATTRIBUTE_14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
946: ATTRIBUTE_15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
947: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
948: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
949: CREATION_DATE DATE := FND_API.G_MISS_DATE,
950: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
951: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

Line 948: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,

944: ATTRIBUTE_13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
945: ATTRIBUTE_14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
946: ATTRIBUTE_15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
947: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
948: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
949: CREATION_DATE DATE := FND_API.G_MISS_DATE,
950: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
951: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
952: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM

Line 949: CREATION_DATE DATE := FND_API.G_MISS_DATE,

945: ATTRIBUTE_14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
946: ATTRIBUTE_15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
947: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
948: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
949: CREATION_DATE DATE := FND_API.G_MISS_DATE,
950: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
951: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
952: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
953: );

Line 950: CREATED_BY NUMBER := FND_API.G_MISS_NUM,

946: ATTRIBUTE_15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
947: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
948: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
949: CREATION_DATE DATE := FND_API.G_MISS_DATE,
950: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
951: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
952: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
953: );
954: TYPE notes_table IS TABLE OF notes_rec INDEX BY BINARY_INTEGER;

Line 951: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,

947: CONTEXT VARCHAR2(30) := FND_API.G_MISS_CHAR,
948: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
949: CREATION_DATE DATE := FND_API.G_MISS_DATE,
950: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
951: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
952: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
953: );
954: TYPE notes_table IS TABLE OF notes_rec INDEX BY BINARY_INTEGER;
955:

Line 952: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM

948: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
949: CREATION_DATE DATE := FND_API.G_MISS_DATE,
950: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
951: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
952: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM
953: );
954: TYPE notes_table IS TABLE OF notes_rec INDEX BY BINARY_INTEGER;
955:
956: -----------------------------------------------------------------------

Line 980: SR_CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,

976: --This table will hold the contacts and contact information
977: --for a Service Request customer
978: --
979: TYPE contacts_rec IS RECORD (
980: SR_CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
981: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
982: CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
983: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
984: CONTACT_POINT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 981: PARTY_ID NUMBER := FND_API.G_MISS_NUM,

977: --for a Service Request customer
978: --
979: TYPE contacts_rec IS RECORD (
980: SR_CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
981: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
982: CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
983: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
984: CONTACT_POINT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
985: CONTACT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,

Line 982: CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,

978: --
979: TYPE contacts_rec IS RECORD (
980: SR_CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
981: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
982: CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
983: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
984: CONTACT_POINT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
985: CONTACT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
986: party_role_code VARCHAR2(30) := FND_API.G_MISS_CHAR,

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

979: TYPE contacts_rec IS RECORD (
980: SR_CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
981: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
982: CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
983: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
984: CONTACT_POINT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
985: CONTACT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
986: party_role_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
987: start_date_active DATE := FND_API.G_MISS_DATE,

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

980: SR_CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
981: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
982: CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
983: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
984: CONTACT_POINT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
985: CONTACT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
986: party_role_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
987: start_date_active DATE := FND_API.G_MISS_DATE,
988: end_date_active DATE := FND_API.G_MISS_DATE

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

981: PARTY_ID NUMBER := FND_API.G_MISS_NUM,
982: CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
983: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
984: CONTACT_POINT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
985: CONTACT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
986: party_role_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
987: start_date_active DATE := FND_API.G_MISS_DATE,
988: end_date_active DATE := FND_API.G_MISS_DATE
989: );

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

982: CONTACT_POINT_ID NUMBER := FND_API.G_MISS_NUM,
983: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
984: CONTACT_POINT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
985: CONTACT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
986: party_role_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
987: start_date_active DATE := FND_API.G_MISS_DATE,
988: end_date_active DATE := FND_API.G_MISS_DATE
989: );
990: TYPE contacts_table IS TABLE OF contacts_rec INDEX BY BINARY_INTEGER;

Line 987: start_date_active DATE := FND_API.G_MISS_DATE,

983: PRIMARY_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
984: CONTACT_POINT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
985: CONTACT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
986: party_role_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
987: start_date_active DATE := FND_API.G_MISS_DATE,
988: end_date_active DATE := FND_API.G_MISS_DATE
989: );
990: TYPE contacts_table IS TABLE OF contacts_rec INDEX BY BINARY_INTEGER;
991:

Line 988: end_date_active DATE := FND_API.G_MISS_DATE

984: CONTACT_POINT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
985: CONTACT_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
986: party_role_code VARCHAR2(30) := FND_API.G_MISS_CHAR,
987: start_date_active DATE := FND_API.G_MISS_DATE,
988: end_date_active DATE := FND_API.G_MISS_DATE
989: );
990: TYPE contacts_table IS TABLE OF contacts_rec INDEX BY BINARY_INTEGER;
991:
992: --

Line 1455: -- Default = FND_API.G_FALSE

1451: --
1452: -- Standard IN Parameters:
1453: -- p_api_version IN NUMBER Required
1454: -- p_init_msg_list IN VARCHAR2 Optional
1455: -- Default = FND_API.G_FALSE
1456: -- p_commit IN VARCHAR2 Optional
1457: -- Default = FND_API.G_FALSE
1458: -- p_validation_level IN NUMBER Optional
1459: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 1457: -- Default = FND_API.G_FALSE

1453: -- p_api_version IN NUMBER Required
1454: -- p_init_msg_list IN VARCHAR2 Optional
1455: -- Default = FND_API.G_FALSE
1456: -- p_commit IN VARCHAR2 Optional
1457: -- Default = FND_API.G_FALSE
1458: -- p_validation_level IN NUMBER Optional
1459: -- Default = FND_API.G_VALID_LEVEL_FULL
1460: --
1461: -- Standard OUT Parameters:

Line 1459: -- Default = FND_API.G_VALID_LEVEL_FULL

1455: -- Default = FND_API.G_FALSE
1456: -- p_commit IN VARCHAR2 Optional
1457: -- Default = FND_API.G_FALSE
1458: -- p_validation_level IN NUMBER Optional
1459: -- Default = FND_API.G_VALID_LEVEL_FULL
1460: --
1461: -- Standard OUT Parameters:
1462: -- x_return_status OUT VARCHAR2(1)
1463: -- x_msg_count OUT NUMBER

Line 1895: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

1891: --------------------------------------------------------------
1892:
1893: PROCEDURE Create_ServiceRequest(
1894: p_api_version IN NUMBER,
1895: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1896: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1897: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
1898: x_return_status OUT NOCOPY VARCHAR2,
1899: x_msg_count OUT NOCOPY NUMBER,

Line 1896: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

1892:
1893: PROCEDURE Create_ServiceRequest(
1894: p_api_version IN NUMBER,
1895: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1896: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1897: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
1898: x_return_status OUT NOCOPY VARCHAR2,
1899: x_msg_count OUT NOCOPY NUMBER,
1900: x_msg_data OUT NOCOPY VARCHAR2,

Line 1897: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,

1893: PROCEDURE Create_ServiceRequest(
1894: p_api_version IN NUMBER,
1895: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1896: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1897: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
1898: x_return_status OUT NOCOPY VARCHAR2,
1899: x_msg_count OUT NOCOPY NUMBER,
1900: x_msg_data OUT NOCOPY VARCHAR2,
1901: p_resp_appl_id IN NUMBER DEFAULT NULL,

Line 1939: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

1935: -- since several new OUT parameters have been added to the 11.5.9 signature
1936: -- in the form of a new record type, sr_create_out_rec_type
1937: PROCEDURE Create_ServiceRequest(
1938: p_api_version IN NUMBER,
1939: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1940: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1941: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
1942: x_return_status OUT NOCOPY VARCHAR2,
1943: x_msg_count OUT NOCOPY NUMBER,

Line 1940: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

1936: -- in the form of a new record type, sr_create_out_rec_type
1937: PROCEDURE Create_ServiceRequest(
1938: p_api_version IN NUMBER,
1939: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1940: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1941: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
1942: x_return_status OUT NOCOPY VARCHAR2,
1943: x_msg_count OUT NOCOPY NUMBER,
1944: x_msg_data OUT NOCOPY VARCHAR2,

Line 1941: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,

1937: PROCEDURE Create_ServiceRequest(
1938: p_api_version IN NUMBER,
1939: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1940: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1941: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
1942: x_return_status OUT NOCOPY VARCHAR2,
1943: x_msg_count OUT NOCOPY NUMBER,
1944: x_msg_data OUT NOCOPY VARCHAR2,
1945: p_resp_appl_id IN NUMBER DEFAULT NULL,

Line 1977: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

1973: as 3.0*/
1974:
1975: PROCEDURE Create_ServiceRequest(
1976: p_api_version IN NUMBER,
1977: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
1978: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
1979: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
1980: x_return_status OUT NOCOPY VARCHAR2,
1981: x_msg_count OUT NOCOPY NUMBER,

Line 1978: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

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

Line 1979: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,

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

Line 2015: -- Default = FND_API.G_FALSE

2011: -- Parameters :
2012: -- IN :
2013: -- p_api_version IN NUMBER Required
2014: -- p_init_msg_list IN VARCHAR2 Optional
2015: -- Default = FND_API.G_FALSE
2016: -- p_commit IN VARCHAR2 Optional
2017: -- Default = FND_API.G_FALSE
2018: -- p_validation_level IN NUMBER Optional
2019: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 2017: -- Default = FND_API.G_FALSE

2013: -- p_api_version IN NUMBER Required
2014: -- p_init_msg_list IN VARCHAR2 Optional
2015: -- Default = FND_API.G_FALSE
2016: -- p_commit IN VARCHAR2 Optional
2017: -- Default = FND_API.G_FALSE
2018: -- p_validation_level IN NUMBER Optional
2019: -- Default = FND_API.G_VALID_LEVEL_FULL
2020: -- p_request_id IN NUMBER Required
2021: -- p_object_version_number IN NUMBER Required for Web-Apps

Line 2019: -- Default = FND_API.G_VALID_LEVEL_FULL

2015: -- Default = FND_API.G_FALSE
2016: -- p_commit IN VARCHAR2 Optional
2017: -- Default = FND_API.G_FALSE
2018: -- p_validation_level IN NUMBER Optional
2019: -- Default = FND_API.G_VALID_LEVEL_FULL
2020: -- p_request_id IN NUMBER Required
2021: -- p_object_version_number IN NUMBER Required for Web-Apps
2022: -----------------------------------------------------------------
2023: -- No longer there in the API

Line 2041: -- Default = FND_API.G_FALSE

2037: -- p_service_request_rec IN service_request_rec_type Required
2038:
2039: -- p_update_desc_flex IN VARCHAR2(1) Optional
2040: -- Indicates whether the descriptive flexfields are being updated
2041: -- Default = FND_API.G_FALSE
2042:
2043: -- p_notes IN notes_table Optional
2044:
2045: -- p_contacts IN contacts_table Optional

Line 2055: -- Default = FND_API.G_FALSE

2051:
2052: -- p_called_by_workflow IN VARCHAR2(1)
2053: -- Indicates whether this API is being called by the active
2054: -- workflow process for the service request
2055: -- Default = FND_API.G_FALSE
2056:
2057: -- p_workflow_process_id IN NUMBER
2058: -- The workflow process id of the workflow process that is
2059: -- calling this API

Line 2320: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

2316: --------------------------------------------------------------
2317:
2318: PROCEDURE Update_ServiceRequest
2319: ( p_api_version IN NUMBER,
2320: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2321: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2322: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
2323: x_return_status OUT NOCOPY VARCHAR2,
2324: x_msg_count OUT NOCOPY NUMBER,

Line 2321: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

2317:
2318: PROCEDURE Update_ServiceRequest
2319: ( p_api_version IN NUMBER,
2320: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2321: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2322: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
2323: x_return_status OUT NOCOPY VARCHAR2,
2324: x_msg_count OUT NOCOPY NUMBER,
2325: x_msg_data OUT NOCOPY VARCHAR2,

Line 2322: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,

2318: PROCEDURE Update_ServiceRequest
2319: ( p_api_version IN NUMBER,
2320: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2321: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2322: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
2323: x_return_status OUT NOCOPY VARCHAR2,
2324: x_msg_count OUT NOCOPY NUMBER,
2325: x_msg_data OUT NOCOPY VARCHAR2,
2326: p_request_id IN NUMBER,

Line 2336: p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,

2332: p_last_update_login IN NUMBER DEFAULT NULL,
2333: p_last_update_date IN DATE,
2334: p_service_request_rec IN service_request_rec_type,
2335: p_invocation_mode IN VARCHAR2 := 'NORMAL',
2336: p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
2337: p_notes IN notes_table,
2338: p_contacts IN contacts_table,
2339: p_audit_comments IN VARCHAR2 DEFAULT NULL,
2340: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,

Line 2340: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,

2336: p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
2337: p_notes IN notes_table,
2338: p_contacts IN contacts_table,
2339: p_audit_comments IN VARCHAR2 DEFAULT NULL,
2340: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
2341: p_workflow_process_id IN NUMBER DEFAULT NULL,
2342: -- Commented out since these are now part of the out rec type --anmukher--08/08/03
2343: -- x_workflow_process_id OUT NOCOPY NUMBER,
2344: -- x_interaction_id OUT NOCOPY NUMBER,

Line 2360: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

2356: -- since several new OUT parameters have been added to the 11.5.9 signature
2357: -- in the form of a new record type, sr_update_out_rec_type
2358: PROCEDURE Update_ServiceRequest
2359: ( p_api_version IN NUMBER,
2360: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2361: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2362: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
2363: x_return_status OUT NOCOPY VARCHAR2,
2364: x_msg_count OUT NOCOPY NUMBER,

Line 2361: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

2357: -- in the form of a new record type, sr_update_out_rec_type
2358: PROCEDURE Update_ServiceRequest
2359: ( p_api_version IN NUMBER,
2360: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2361: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2362: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
2363: x_return_status OUT NOCOPY VARCHAR2,
2364: x_msg_count OUT NOCOPY NUMBER,
2365: x_msg_data OUT NOCOPY VARCHAR2,

Line 2362: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,

2358: PROCEDURE Update_ServiceRequest
2359: ( p_api_version IN NUMBER,
2360: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2361: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2362: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
2363: x_return_status OUT NOCOPY VARCHAR2,
2364: x_msg_count OUT NOCOPY NUMBER,
2365: x_msg_data OUT NOCOPY VARCHAR2,
2366: p_request_id IN NUMBER,

Line 2376: p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,

2372: p_last_update_login IN NUMBER DEFAULT NULL,
2373: p_last_update_date IN DATE,
2374: p_service_request_rec IN service_request_rec_type,
2375: p_invocation_mode IN VARCHAR2 := 'NORMAL',
2376: p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
2377: p_notes IN notes_table,
2378: p_contacts IN contacts_table,
2379: p_audit_comments IN VARCHAR2 DEFAULT NULL,
2380: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,

Line 2380: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,

2376: p_update_desc_flex IN VARCHAR2 DEFAULT fnd_api.g_false,
2377: p_notes IN notes_table,
2378: p_contacts IN contacts_table,
2379: p_audit_comments IN VARCHAR2 DEFAULT NULL,
2380: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
2381: p_workflow_process_id IN NUMBER DEFAULT NULL,
2382: p_default_contract_sla_ind IN VARCHAR2 Default 'N',
2383: x_workflow_process_id OUT NOCOPY NUMBER,
2384: x_interaction_id OUT NOCOPY NUMBER

Line 2397: -- Default = FND_API.G_FALSE

2393: -- Parameters :
2394: -- IN :
2395: -- p_api_version IN NUMBER Required
2396: -- p_init_msg_list IN VARCHAR2 Optional
2397: -- Default = FND_API.G_FALSE
2398: -- p_commit IN VARCHAR2 Optional
2399: -- Default = FND_API.G_FALSE
2400: -- p_validation_level IN NUMBER Optional
2401: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 2399: -- Default = FND_API.G_FALSE

2395: -- p_api_version IN NUMBER Required
2396: -- p_init_msg_list IN VARCHAR2 Optional
2397: -- Default = FND_API.G_FALSE
2398: -- p_commit IN VARCHAR2 Optional
2399: -- Default = FND_API.G_FALSE
2400: -- p_validation_level IN NUMBER Optional
2401: -- Default = FND_API.G_VALID_LEVEL_FULL
2402: -- p_request_id IN NUMBER Required
2403: ----------------------------------------------------

Line 2401: -- Default = FND_API.G_VALID_LEVEL_FULL

2397: -- Default = FND_API.G_FALSE
2398: -- p_commit IN VARCHAR2 Optional
2399: -- Default = FND_API.G_FALSE
2400: -- p_validation_level IN NUMBER Optional
2401: -- Default = FND_API.G_VALID_LEVEL_FULL
2402: -- p_request_id IN NUMBER Required
2403: ----------------------------------------------------
2404: -- Removed from the api
2405: -- p_org_id IN NUMBER Optional

Line 2425: -- Default = FND_API.G_FALSE

2421: -- Default = NULL
2422: -- p_call_by_workflow IN VARCHAR2 Optional
2423: -- Indicates whether this API is being called by a workflow
2424: -- process
2425: -- Default = FND_API.G_FALSE
2426: -- p_workflow_process_id IN NUMBER Optional
2427: -- The workflow process id of the workflow process that is
2428: -- calling this API
2429: -- Default = NULL

Line 2475: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

2471: RETURN NUMBER;
2472:
2473: PROCEDURE Update_Status
2474: ( p_api_version IN NUMBER,
2475: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2476: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2477: p_resp_id IN NUMBER,
2478: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
2479: x_return_status OUT NOCOPY VARCHAR2,

Line 2476: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

2472:
2473: PROCEDURE Update_Status
2474: ( p_api_version IN NUMBER,
2475: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2476: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2477: p_resp_id IN NUMBER,
2478: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
2479: x_return_status OUT NOCOPY VARCHAR2,
2480: x_msg_count OUT NOCOPY NUMBER,

Line 2478: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,

2474: ( p_api_version IN NUMBER,
2475: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2476: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2477: p_resp_id IN NUMBER,
2478: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
2479: x_return_status OUT NOCOPY VARCHAR2,
2480: x_msg_count OUT NOCOPY NUMBER,
2481: x_msg_data OUT NOCOPY VARCHAR2,
2482: p_request_id IN NUMBER,

Line 2485: p_closed_date IN DATE DEFAULT fnd_api.g_miss_date,

2481: x_msg_data OUT NOCOPY VARCHAR2,
2482: p_request_id IN NUMBER,
2483: p_object_version_number IN NUMBER,
2484: p_status_id IN NUMBER,
2485: p_closed_date IN DATE DEFAULT fnd_api.g_miss_date,
2486: p_last_updated_by IN NUMBER,
2487: p_last_update_login IN NUMBER DEFAULT NULL,
2488: p_last_update_date IN DATE,
2489: p_audit_comments IN VARCHAR2 DEFAULT NULL,

Line 2490: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,

2486: p_last_updated_by IN NUMBER,
2487: p_last_update_login IN NUMBER DEFAULT NULL,
2488: p_last_update_date IN DATE,
2489: p_audit_comments IN VARCHAR2 DEFAULT NULL,
2490: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
2491: p_workflow_process_id IN NUMBER DEFAULT NULL,
2492: p_comments IN VARCHAR2 DEFAULT NULL,
2493: p_public_comment_flag IN VARCHAR2 DEFAULT fnd_api.g_false,
2494: p_parent_interaction_id IN NUMBER DEFAULT NULL,

Line 2493: p_public_comment_flag IN VARCHAR2 DEFAULT fnd_api.g_false,

2489: p_audit_comments IN VARCHAR2 DEFAULT NULL,
2490: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
2491: p_workflow_process_id IN NUMBER DEFAULT NULL,
2492: p_comments IN VARCHAR2 DEFAULT NULL,
2493: p_public_comment_flag IN VARCHAR2 DEFAULT fnd_api.g_false,
2494: p_parent_interaction_id IN NUMBER DEFAULT NULL,
2495: -- Added for 11.5.10 projects
2496: p_validate_sr_closure IN VARCHAR2 Default 'N',
2497: p_auto_close_child_entities IN VARCHAR2 Default 'N',

Line 2512: -- Default = FND_API.G_FALSE

2508: -- Parameters :
2509: -- IN :
2510: -- p_api_version IN NUMBER Required
2511: -- p_init_msg_list IN VARCHAR2 Optional
2512: -- Default = FND_API.G_FALSE
2513: -- p_commit IN VARCHAR2 Optional
2514: -- Default = FND_API.G_FALSE
2515: -- p_validation_level IN NUMBER Optional
2516: -- Default = FND_API.G_VALID_LEVEL_FULL

Line 2514: -- Default = FND_API.G_FALSE

2510: -- p_api_version IN NUMBER Required
2511: -- p_init_msg_list IN VARCHAR2 Optional
2512: -- Default = FND_API.G_FALSE
2513: -- p_commit IN VARCHAR2 Optional
2514: -- Default = FND_API.G_FALSE
2515: -- p_validation_level IN NUMBER Optional
2516: -- Default = FND_API.G_VALID_LEVEL_FULL
2517: -- p_request_id IN NUMBER Required
2518: -- p_resp_id IN NUMBER Optional

Line 2516: -- Default = FND_API.G_VALID_LEVEL_FULL

2512: -- Default = FND_API.G_FALSE
2513: -- p_commit IN VARCHAR2 Optional
2514: -- Default = FND_API.G_FALSE
2515: -- p_validation_level IN NUMBER Optional
2516: -- Default = FND_API.G_VALID_LEVEL_FULL
2517: -- p_request_id IN NUMBER Required
2518: -- p_resp_id IN NUMBER Optional
2519: -- Default = NULL
2520: -- p_resp_appl_id IN NUMBER Optional

Line 2544: -- Default = FND_API.G_FALSE

2540: -- Default = NULL
2541: -- p_call_by_workflow IN VARCHAR2 Optional
2542: -- Indicates whether this API is being called by a workflow
2543: -- process
2544: -- Default = FND_API.G_FALSE
2545: -- p_workflow_process_id IN NUMBER Optional
2546: -- Default = NULL
2547: -- The workflow process id of the workflow process that is
2548: -- calling this API

Line 2584: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,

2580: --------------------------------------------------------------------------
2581:
2582: PROCEDURE Update_Owner
2583: ( p_api_version IN NUMBER,
2584: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2585: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2586: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
2587: x_return_status OUT NOCOPY VARCHAR2,
2588: x_msg_count OUT NOCOPY NUMBER,

Line 2585: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,

2581:
2582: PROCEDURE Update_Owner
2583: ( p_api_version IN NUMBER,
2584: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2585: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2586: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
2587: x_return_status OUT NOCOPY VARCHAR2,
2588: x_msg_count OUT NOCOPY NUMBER,
2589: x_msg_data OUT NOCOPY VARCHAR2,

Line 2586: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,

2582: PROCEDURE Update_Owner
2583: ( p_api_version IN NUMBER,
2584: p_init_msg_list IN VARCHAR2 DEFAULT fnd_api.g_false,
2585: p_commit IN VARCHAR2 DEFAULT fnd_api.g_false,
2586: p_validation_level IN NUMBER DEFAULT fnd_api.g_valid_level_full,
2587: x_return_status OUT NOCOPY VARCHAR2,
2588: x_msg_count OUT NOCOPY NUMBER,
2589: x_msg_data OUT NOCOPY VARCHAR2,
2590: p_request_id IN NUMBER,

Line 2601: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,

2597: p_last_updated_by IN NUMBER,
2598: p_last_update_login IN NUMBER DEFAULT NULL,
2599: p_last_update_date IN DATE,
2600: p_audit_comments IN VARCHAR2 DEFAULT NULL,
2601: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
2602: p_workflow_process_id IN NUMBER DEFAULT NULL,
2603: p_comments IN VARCHAR2 DEFAULT NULL,
2604: p_public_comment_flag IN VARCHAR2 DEFAULT fnd_api.g_false,
2605: p_parent_interaction_id IN NUMBER DEFAULT NULL,

Line 2604: p_public_comment_flag IN VARCHAR2 DEFAULT fnd_api.g_false,

2600: p_audit_comments IN VARCHAR2 DEFAULT NULL,
2601: p_called_by_workflow IN VARCHAR2 DEFAULT fnd_api.g_false,
2602: p_workflow_process_id IN NUMBER DEFAULT NULL,
2603: p_comments IN VARCHAR2 DEFAULT NULL,
2604: p_public_comment_flag IN VARCHAR2 DEFAULT fnd_api.g_false,
2605: p_parent_interaction_id IN NUMBER DEFAULT NULL,
2606: x_interaction_id OUT NOCOPY NUMBER
2607: );
2608:

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

2615: -- Pre-reqs : None
2616: -- Parameters :
2617: -- IN :
2618: -- p_api_version IN NUMBER Required
2619: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
2620: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
2621: -- p_request_id IN NUMBER Required
2622: -- p_change_flags IN AUDIT_FLAGS_REC_TYPE Required
2623: -- p_old_vals_rec IN AUDIT_VALS_REC_TYPE Optional

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

2616: -- Parameters :
2617: -- IN :
2618: -- p_api_version IN NUMBER Required
2619: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API.G_FALSE
2620: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
2621: -- p_request_id IN NUMBER Required
2622: -- p_change_flags IN AUDIT_FLAGS_REC_TYPE Required
2623: -- p_old_vals_rec IN AUDIT_VALS_REC_TYPE Optional
2624: -- p_new_vals_rec IN AUDIT_VALS_REC_TYPE Optional

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

2621: -- p_request_id IN NUMBER Required
2622: -- p_change_flags IN AUDIT_FLAGS_REC_TYPE Required
2623: -- p_old_vals_rec IN AUDIT_VALS_REC_TYPE Optional
2624: -- p_new_vals_rec IN AUDIT_VALS_REC_TYPE Optional
2625: -- p_action_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
2626: -- p_wf_process_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
2627: -- p_wf_process_itemkey IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
2628: -- p_user_id IN NUMBER Required
2629: -- p_login_id IN NUMBER Optional Default = NULL

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

2622: -- p_change_flags IN AUDIT_FLAGS_REC_TYPE Required
2623: -- p_old_vals_rec IN AUDIT_VALS_REC_TYPE Optional
2624: -- p_new_vals_rec IN AUDIT_VALS_REC_TYPE Optional
2625: -- p_action_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
2626: -- p_wf_process_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
2627: -- p_wf_process_itemkey IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
2628: -- p_user_id IN NUMBER Required
2629: -- p_login_id IN NUMBER Optional Default = NULL
2630: -- p_comments IN VARCHAR2 Optional Default = NULL

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

2623: -- p_old_vals_rec IN AUDIT_VALS_REC_TYPE Optional
2624: -- p_new_vals_rec IN AUDIT_VALS_REC_TYPE Optional
2625: -- p_action_id IN NUMBER Optional Default = FND_API.G_MISS_NUM
2626: -- p_wf_process_name IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
2627: -- p_wf_process_itemkey IN VARCHAR2 Optional Default = FND_API.G_MISS_CHAR
2628: -- p_user_id IN NUMBER Required
2629: -- p_login_id IN NUMBER Optional Default = NULL
2630: -- p_comments IN VARCHAR2 Optional Default = NULL
2631: --

Line 2646: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,

2642: -- -------------------------------------------------------------------
2643:
2644: PROCEDURE Create_Audit_Record (
2645: p_api_version IN NUMBER,
2646: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2647: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2648: x_return_status OUT NOCOPY VARCHAR2,
2649: x_msg_count OUT NOCOPY NUMBER,
2650: x_msg_data OUT NOCOPY VARCHAR2,

Line 2647: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,

2643:
2644: PROCEDURE Create_Audit_Record (
2645: p_api_version IN NUMBER,
2646: p_init_msg_list IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2647: p_commit IN VARCHAR2 DEFAULT FND_API.G_FALSE,
2648: x_return_status OUT NOCOPY VARCHAR2,
2649: x_msg_count OUT NOCOPY NUMBER,
2650: x_msg_data OUT NOCOPY VARCHAR2,
2651: p_request_id IN NUMBER,

Line 2657: p_action_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,

2653: --p_change_flags IN audit_flags_rec_type,
2654: --p_old_vals_rec IN audit_vals_rec_type DEFAULT G_MISS_AUDIT_VALS_REC,
2655: --p_new_vals_rec IN audit_vals_rec_type DEFAULT G_MISS_AUDIT_VALS_REC,
2656: p_audit_vals_rec IN SR_AUDIT_REC_TYPE,
2657: p_action_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
2658: p_wf_process_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
2659: p_wf_process_itemkey IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
2660: p_user_id IN NUMBER,
2661: p_login_id IN NUMBER DEFAULT NULL,

Line 2658: p_wf_process_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

2654: --p_old_vals_rec IN audit_vals_rec_type DEFAULT G_MISS_AUDIT_VALS_REC,
2655: --p_new_vals_rec IN audit_vals_rec_type DEFAULT G_MISS_AUDIT_VALS_REC,
2656: p_audit_vals_rec IN SR_AUDIT_REC_TYPE,
2657: p_action_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
2658: p_wf_process_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
2659: p_wf_process_itemkey IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
2660: p_user_id IN NUMBER,
2661: p_login_id IN NUMBER DEFAULT NULL,
2662: p_last_update_date IN DATE,

Line 2659: p_wf_process_itemkey IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,

2655: --p_new_vals_rec IN audit_vals_rec_type DEFAULT G_MISS_AUDIT_VALS_REC,
2656: p_audit_vals_rec IN SR_AUDIT_REC_TYPE,
2657: p_action_id IN NUMBER DEFAULT FND_API.G_MISS_NUM,
2658: p_wf_process_name IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
2659: p_wf_process_itemkey IN VARCHAR2 DEFAULT FND_API.G_MISS_CHAR,
2660: p_user_id IN NUMBER,
2661: p_login_id IN NUMBER DEFAULT NULL,
2662: p_last_update_date IN DATE,
2663: p_creation_date IN DATE,

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

2704:
2705: PROCEDURE Delete_ServiceRequest
2706: (
2707: p_api_version_number IN NUMBER := 1.0
2708: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2709: , p_commit IN VARCHAR2 := FND_API.G_FALSE
2710: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2711: , p_processing_set_id IN NUMBER
2712: , p_purge_set_id IN NUMBER

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

2705: PROCEDURE Delete_ServiceRequest
2706: (
2707: p_api_version_number IN NUMBER := 1.0
2708: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2709: , p_commit IN VARCHAR2 := FND_API.G_FALSE
2710: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2711: , p_processing_set_id IN NUMBER
2712: , p_purge_set_id IN NUMBER
2713: , p_purge_source_with_open_task IN VARCHAR2

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

2706: (
2707: p_api_version_number IN NUMBER := 1.0
2708: , p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE
2709: , p_commit IN VARCHAR2 := FND_API.G_FALSE
2710: , p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL
2711: , p_processing_set_id IN NUMBER
2712: , p_purge_set_id IN NUMBER
2713: , p_purge_source_with_open_task IN VARCHAR2
2714: , p_audit_required IN VARCHAR2