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.EDR_EVENT_RELATIONSHIP_PVT dependencies on PARENT_CHILD_REC

Line 375: (PARENT_CHILD_RECORD IN PARENT_CHILD_TBL)

371:
372:
373: -- Bug 3667036: Start
374: PROCEDURE ESTABLISH_RELATIONSHIP
375: (PARENT_CHILD_RECORD IN PARENT_CHILD_TBL)
376: AS
377: L_RETURN_STATUS VARCHAR2(10);
378: L_MSG_COUNT NUMBER;
379: L_MSG_DATA VARCHAR2(2000);

Line 385: FOR I IN 1..PARENT_CHILD_RECORD.count loop

381: L_CHILD_EVENT_NAME VARCHAR2(80);
382: L_CHILD_EVENT_KEY VARCHAR2(240);
383: BEGIN
384:
385: FOR I IN 1..PARENT_CHILD_RECORD.count loop
386:
387: L_CHILD_EVENT_NAME := parent_child_record(i).child_event_name;
388:
389: if length(l_child_event_name) = 0 then

Line 387: L_CHILD_EVENT_NAME := parent_child_record(i).child_event_name;

383: BEGIN
384:
385: FOR I IN 1..PARENT_CHILD_RECORD.count loop
386:
387: L_CHILD_EVENT_NAME := parent_child_record(i).child_event_name;
388:
389: if length(l_child_event_name) = 0 then
390:
391: edr_ctx_pkg.set_secure_attr;

Line 394: where document_id = parent_child_record(i).child_erecord_id;

390:
391: edr_ctx_pkg.set_secure_attr;
392: select event_name,event_key into l_child_event_name,l_child_event_key
393: from edr_psig_documents
394: where document_id = parent_child_record(i).child_erecord_id;
395: edr_ctx_pkg.unset_secure_attr;
396: edr_event_relationship_pub.CREATE_RELATIONSHIP
397: (p_api_version => 1.0,
398: p_init_msg_list => FND_API.G_FALSE,

Line 404: p_parent_erecord_id => PARENT_CHILD_RECORD(i).PARENT_ERECORD_ID,

400: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
401: x_return_status => L_RETURN_STATUS,
402: x_msg_count => L_MSG_COUNT,
403: x_msg_data => L_MSG_DATA,
404: p_parent_erecord_id => PARENT_CHILD_RECORD(i).PARENT_ERECORD_ID,
405: p_parent_event_name => PARENT_CHILD_RECORD(i).PARENT_EVENT_NAME,
406: p_parent_event_key => PARENT_CHILD_RECORD(i).PARENT_EVENT_KEY,
407: p_child_erecord_id => PARENT_CHILD_RECORD(i).CHILD_ERECORD_ID,
408: p_child_event_name => L_CHILD_EVENT_NAME,

Line 405: p_parent_event_name => PARENT_CHILD_RECORD(i).PARENT_EVENT_NAME,

401: x_return_status => L_RETURN_STATUS,
402: x_msg_count => L_MSG_COUNT,
403: x_msg_data => L_MSG_DATA,
404: p_parent_erecord_id => PARENT_CHILD_RECORD(i).PARENT_ERECORD_ID,
405: p_parent_event_name => PARENT_CHILD_RECORD(i).PARENT_EVENT_NAME,
406: p_parent_event_key => PARENT_CHILD_RECORD(i).PARENT_EVENT_KEY,
407: p_child_erecord_id => PARENT_CHILD_RECORD(i).CHILD_ERECORD_ID,
408: p_child_event_name => L_CHILD_EVENT_NAME,
409: p_child_event_key => L_CHILD_EVENT_KEY,

Line 406: p_parent_event_key => PARENT_CHILD_RECORD(i).PARENT_EVENT_KEY,

402: x_msg_count => L_MSG_COUNT,
403: x_msg_data => L_MSG_DATA,
404: p_parent_erecord_id => PARENT_CHILD_RECORD(i).PARENT_ERECORD_ID,
405: p_parent_event_name => PARENT_CHILD_RECORD(i).PARENT_EVENT_NAME,
406: p_parent_event_key => PARENT_CHILD_RECORD(i).PARENT_EVENT_KEY,
407: p_child_erecord_id => PARENT_CHILD_RECORD(i).CHILD_ERECORD_ID,
408: p_child_event_name => L_CHILD_EVENT_NAME,
409: p_child_event_key => L_CHILD_EVENT_KEY,
410: x_relationship_id => L_RELATIONSHIP_ID);

Line 407: p_child_erecord_id => PARENT_CHILD_RECORD(i).CHILD_ERECORD_ID,

403: x_msg_data => L_MSG_DATA,
404: p_parent_erecord_id => PARENT_CHILD_RECORD(i).PARENT_ERECORD_ID,
405: p_parent_event_name => PARENT_CHILD_RECORD(i).PARENT_EVENT_NAME,
406: p_parent_event_key => PARENT_CHILD_RECORD(i).PARENT_EVENT_KEY,
407: p_child_erecord_id => PARENT_CHILD_RECORD(i).CHILD_ERECORD_ID,
408: p_child_event_name => L_CHILD_EVENT_NAME,
409: p_child_event_key => L_CHILD_EVENT_KEY,
410: x_relationship_id => L_RELATIONSHIP_ID);
411:

Line 423: p_parent_erecord_id => PARENT_CHILD_RECORD(i).PARENT_ERECORD_ID,

419: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
420: x_return_status => L_RETURN_STATUS,
421: x_msg_count => L_MSG_COUNT,
422: x_msg_data => L_MSG_DATA,
423: p_parent_erecord_id => PARENT_CHILD_RECORD(i).PARENT_ERECORD_ID,
424: p_parent_event_name => PARENT_CHILD_RECORD(i).PARENT_EVENT_NAME,
425: p_parent_event_key => PARENT_CHILD_RECORD(i).PARENT_EVENT_KEY,
426: p_child_erecord_id => PARENT_CHILD_RECORD(i).CHILD_ERECORD_ID,
427: p_child_event_name => PARENT_CHILD_RECORD(i).CHILD_EVENT_NAME,

Line 424: p_parent_event_name => PARENT_CHILD_RECORD(i).PARENT_EVENT_NAME,

420: x_return_status => L_RETURN_STATUS,
421: x_msg_count => L_MSG_COUNT,
422: x_msg_data => L_MSG_DATA,
423: p_parent_erecord_id => PARENT_CHILD_RECORD(i).PARENT_ERECORD_ID,
424: p_parent_event_name => PARENT_CHILD_RECORD(i).PARENT_EVENT_NAME,
425: p_parent_event_key => PARENT_CHILD_RECORD(i).PARENT_EVENT_KEY,
426: p_child_erecord_id => PARENT_CHILD_RECORD(i).CHILD_ERECORD_ID,
427: p_child_event_name => PARENT_CHILD_RECORD(i).CHILD_EVENT_NAME,
428: p_child_event_key => PARENT_CHILD_RECORD(i).CHILD_EVENT_KEY,

Line 425: p_parent_event_key => PARENT_CHILD_RECORD(i).PARENT_EVENT_KEY,

421: x_msg_count => L_MSG_COUNT,
422: x_msg_data => L_MSG_DATA,
423: p_parent_erecord_id => PARENT_CHILD_RECORD(i).PARENT_ERECORD_ID,
424: p_parent_event_name => PARENT_CHILD_RECORD(i).PARENT_EVENT_NAME,
425: p_parent_event_key => PARENT_CHILD_RECORD(i).PARENT_EVENT_KEY,
426: p_child_erecord_id => PARENT_CHILD_RECORD(i).CHILD_ERECORD_ID,
427: p_child_event_name => PARENT_CHILD_RECORD(i).CHILD_EVENT_NAME,
428: p_child_event_key => PARENT_CHILD_RECORD(i).CHILD_EVENT_KEY,
429: x_relationship_id => L_RELATIONSHIP_ID);

Line 426: p_child_erecord_id => PARENT_CHILD_RECORD(i).CHILD_ERECORD_ID,

422: x_msg_data => L_MSG_DATA,
423: p_parent_erecord_id => PARENT_CHILD_RECORD(i).PARENT_ERECORD_ID,
424: p_parent_event_name => PARENT_CHILD_RECORD(i).PARENT_EVENT_NAME,
425: p_parent_event_key => PARENT_CHILD_RECORD(i).PARENT_EVENT_KEY,
426: p_child_erecord_id => PARENT_CHILD_RECORD(i).CHILD_ERECORD_ID,
427: p_child_event_name => PARENT_CHILD_RECORD(i).CHILD_EVENT_NAME,
428: p_child_event_key => PARENT_CHILD_RECORD(i).CHILD_EVENT_KEY,
429: x_relationship_id => L_RELATIONSHIP_ID);
430:

Line 427: p_child_event_name => PARENT_CHILD_RECORD(i).CHILD_EVENT_NAME,

423: p_parent_erecord_id => PARENT_CHILD_RECORD(i).PARENT_ERECORD_ID,
424: p_parent_event_name => PARENT_CHILD_RECORD(i).PARENT_EVENT_NAME,
425: p_parent_event_key => PARENT_CHILD_RECORD(i).PARENT_EVENT_KEY,
426: p_child_erecord_id => PARENT_CHILD_RECORD(i).CHILD_ERECORD_ID,
427: p_child_event_name => PARENT_CHILD_RECORD(i).CHILD_EVENT_NAME,
428: p_child_event_key => PARENT_CHILD_RECORD(i).CHILD_EVENT_KEY,
429: x_relationship_id => L_RELATIONSHIP_ID);
430:
431: end if;

Line 428: p_child_event_key => PARENT_CHILD_RECORD(i).CHILD_EVENT_KEY,

424: p_parent_event_name => PARENT_CHILD_RECORD(i).PARENT_EVENT_NAME,
425: p_parent_event_key => PARENT_CHILD_RECORD(i).PARENT_EVENT_KEY,
426: p_child_erecord_id => PARENT_CHILD_RECORD(i).CHILD_ERECORD_ID,
427: p_child_event_name => PARENT_CHILD_RECORD(i).CHILD_EVENT_NAME,
428: p_child_event_key => PARENT_CHILD_RECORD(i).CHILD_EVENT_KEY,
429: x_relationship_id => L_RELATIONSHIP_ID);
430:
431: end if;
432: