APPS.PA_PROJECT_REQUEST_PUB dependencies on PA_OBJECT_RELATIONSHIPS

Line 16: p_source_object IN pa_object_relationships.object_type_from%TYPE,

12: p_closed_date IN pa_project_requests.closed_date%TYPE,
13: p_source_type IN pa_project_requests.source_type%TYPE :='ORACLE_APPLICATION',
14: p_application_id IN pa_project_requests.application_id%TYPE,
15: p_source_id IN NUMBER,
16: p_source_object IN pa_object_relationships.object_type_from%TYPE,
17: p_source_reference IN pa_project_requests.source_reference%TYPE,
18: p_value IN pa_project_requests.value%TYPE,
19: p_currency_code IN pa_project_requests.currency_code%TYPE,
20: p_cust_party_id IN pa_project_requests.cust_party_id%TYPE,

Line 61: l_new_obj_rel_id PA_OBJECT_RELATIONSHIPS.OBJECT_RELATIONSHIP_ID%TYPE;

57: l_check_status_err EXCEPTION;
58: l_request_status_code pa_project_requests.status_code%TYPE;
59: l_msg_index_out NUMBER;
60: l_lead_id as_leads_all.lead_id%TYPE;
61: l_new_obj_rel_id PA_OBJECT_RELATIONSHIPS.OBJECT_RELATIONSHIP_ID%TYPE;
62: l_new_obj_rel_id2 PA_OBJECT_RELATIONSHIPS.OBJECT_RELATIONSHIP_ID%TYPE;
63: l_return_status VARCHAR2(1);
64: l_error_message_code fnd_new_messages.message_name%TYPE;
65: -- added for Bug: 4537865

Line 62: l_new_obj_rel_id2 PA_OBJECT_RELATIONSHIPS.OBJECT_RELATIONSHIP_ID%TYPE;

58: l_request_status_code pa_project_requests.status_code%TYPE;
59: l_msg_index_out NUMBER;
60: l_lead_id as_leads_all.lead_id%TYPE;
61: l_new_obj_rel_id PA_OBJECT_RELATIONSHIPS.OBJECT_RELATIONSHIP_ID%TYPE;
62: l_new_obj_rel_id2 PA_OBJECT_RELATIONSHIPS.OBJECT_RELATIONSHIP_ID%TYPE;
63: l_return_status VARCHAR2(1);
64: l_error_message_code fnd_new_messages.message_name%TYPE;
65: -- added for Bug: 4537865
66: l_new_msg_data VARCHAR2(2000);

Line 168: PA_PROJECT_REQUEST_PVT.debug('PA_PROJECT_REQUESTS_PUB.create_project_request: Calling PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW to form the relationship.' );

164: p_source_object IS NOT NULL THEN
165:
166: -- Form the relationship: from the source opportunity to the created project request.
167:
168: PA_PROJECT_REQUEST_PVT.debug('PA_PROJECT_REQUESTS_PUB.create_project_request: Calling PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW to form the relationship.' );
169:
170: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
171: p_user_id => FND_GLOBAL.USER_ID
172: ,p_object_type_from => p_source_object

Line 170: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

166: -- Form the relationship: from the source opportunity to the created project request.
167:
168: PA_PROJECT_REQUEST_PVT.debug('PA_PROJECT_REQUESTS_PUB.create_project_request: Calling PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW to form the relationship.' );
169:
170: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
171: p_user_id => FND_GLOBAL.USER_ID
172: ,p_object_type_from => p_source_object
173: ,p_object_id_from1 => p_source_id
174: ,p_object_id_from2 => NULL

Line 197: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(

193:
194: IF x_return_status = FND_API.G_RET_STS_SUCCESS THEN
195: -- Form the relationship: from the created project request to the source opportunity.
196:
197: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
198: p_user_id => FND_GLOBAL.USER_ID
199: ,p_object_type_from => 'PA_PROJECT_REQUESTS'
200: ,p_object_id_from1 => x_request_id
201: ,p_object_id_from2 => NULL