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.PA_COPY_CHANGE_DOC_PVT dependencies on PA_CONTROL_ITEMS

Line 28: copy_from_row pa_control_items%ROWTYPE;

24: l_from_type_id NUMBER;
25: l_relationship_id NUMBER;
26: l_commit VARCHAR2(1) := 'N';
27: l_old_supp_yn VARCHAR2(1) := 'N';
28: copy_from_row pa_control_items%ROWTYPE;
29:
30: l_action_id number := null;
31:
32: x_error_msg_code varchar2(100) := NULL;

Line 35: l_ci_number pa_control_items.ci_number%type := p_ci_number;

31:
32: x_error_msg_code varchar2(100) := NULL;
33:
34: l_ci_id number := null;
35: l_ci_number pa_control_items.ci_number%type := p_ci_number;
36: l_version_comments pa_control_items.version_comments%type := p_version_comments;
37: lx_ci_id number := null;
38: x_ci_number pa_control_items.ci_number%type := null;
39: l_audt_hist_num number := 0;

Line 36: l_version_comments pa_control_items.version_comments%type := p_version_comments;

32: x_error_msg_code varchar2(100) := NULL;
33:
34: l_ci_id number := null;
35: l_ci_number pa_control_items.ci_number%type := p_ci_number;
36: l_version_comments pa_control_items.version_comments%type := p_version_comments;
37: lx_ci_id number := null;
38: x_ci_number pa_control_items.ci_number%type := null;
39: l_audt_hist_num number := 0;
40:

Line 38: x_ci_number pa_control_items.ci_number%type := null;

34: l_ci_id number := null;
35: l_ci_number pa_control_items.ci_number%type := p_ci_number;
36: l_version_comments pa_control_items.version_comments%type := p_version_comments;
37: lx_ci_id number := null;
38: x_ci_number pa_control_items.ci_number%type := null;
39: l_audt_hist_num number := 0;
40:
41: x_supp_rowid varchar2(50) := null;
42: x_supp_ci_transaction_id number := null;

Line 53: SELECT * FROM pa_control_items

49: x_relationship_id number := NULL;
50:
51: CURSOR c_from_item
52: is
53: SELECT * FROM pa_control_items
54: WHERE ci_id = p_ci_id;
55:
56: CURSOR c_action_from
57: is

Line 91: from PA_CONTROL_ITEMS

87:
88: cursor c_vers_num
89: is
90: select max(nvl(version_number,0))
91: from PA_CONTROL_ITEMS
92: where ci_id = p_ci_id;
93:
94: cursor c_old_supp
95: is

Line 98: pa_control_items ci

94: cursor c_old_supp
95: is
96: select 'Y'
97: from pa_ci_impact_type_usage Usg,
98: pa_control_items ci
99: where usg.ci_type_id = ci.ci_type_id
100: and ci.ci_id = p_ci_id
101: and usg.impact_type_code = 'SUPPLIER';
102:

Line 126: PA_CONTROL_ITEMS_PKG.INSERT_ROW (

122: x_return_status := FND_API.G_RET_STS_ERROR;
123: end if;
124: close c_from_item;
125:
126: PA_CONTROL_ITEMS_PKG.INSERT_ROW (
127: copy_from_row.ci_type_id
128: ,copy_from_row.summary
129: ,copy_from_row.status_code
130: ,copy_from_row.owner_id

Line 228: p_object_type_from => 'PA_CONTROL_ITEMS',

224: LOOP
225:
226: PA_OBJECT_RELATIONSHIPS_PKG.INSERT_ROW(
227: p_user_id => fnd_global.user_id,
228: p_object_type_from => 'PA_CONTROL_ITEMS',
229: p_object_id_from1 => to_char(x_ci_id),
230: p_object_id_from2 => NULL,
231: p_object_id_from3 => NULL,
232: p_object_id_from4 => NULL,

Line 234: p_object_type_to => 'PA_CONTROL_ITEMS',

230: p_object_id_from2 => NULL,
231: p_object_id_from3 => NULL,
232: p_object_id_from4 => NULL,
233: p_object_id_from5 => NULL,
234: p_object_type_to => 'PA_CONTROL_ITEMS',
235: p_object_id_to1 => to_char(ci_obj_id_to1.object_id_to1),
236: p_object_id_to2 => NULL,
237: p_object_id_to3 => NULL,
238: p_object_id_to4 => NULL,

Line 275: pa_control_items_pvt.copy_related_items(

271: RAISE G_EXCEPTION_ERROR;
272: END IF;
273:
274: --Copying related items
275: pa_control_items_pvt.copy_related_items(
276: p_init_msg_list => 'F',
277: p_validate_only => 'F',
278: p_from_ci_id => p_ci_id,
279: p_to_ci_id => x_ci_id,

Line 426: update PA_CONTROL_ITEMS

422: END IF;
423:
424:
425:
426: update PA_CONTROL_ITEMS
427: set Current_Version_flag = 'N'
428: where ci_id = p_ci_id;
429:
430: update PA_CI_SUPPLIER_DETAILS

Line 493: l_version_number pa_control_items.version_number%type := null;

489:
490: lx_ci_id NUMBER := null;
491: lx_version_number NUMBER := null;
492:
493: l_version_number pa_control_items.version_number%type := null;
494: cursor c_vers_num
495: is
496: select max(nvl(version_number,0))
497: from PA_CONTROL_ITEMS

Line 497: from PA_CONTROL_ITEMS

493: l_version_number pa_control_items.version_number%type := null;
494: cursor c_vers_num
495: is
496: select max(nvl(version_number,0))
497: from PA_CONTROL_ITEMS
498: where ci_id = p_ci_id;
499:
500: l_sts_yn varchar2(1) := 'N';
501: cursor c_ci_approved

Line 508: from pa_control_items

504: from pa_project_statuses
505: where status_type='CONTROL_ITEM'
506: and project_system_status_code = 'CI_APPROVED'
507: and project_status_code in (select distinct(status_code)
508: from pa_control_items
509: where ci_id =p_ci_id );
510: BEGIN
511:
512: -- Initialize the Error Stack

Line 631: l_ci_number pa_control_items.ci_number%type := null;

627: API_ERROR EXCEPTION;
628:
629: l_ci_id NUMBER := p_ci_id;
630:
631: l_ci_number pa_control_items.ci_number%type := null;
632: l_version_comments pa_control_items.version_comments%type := null;
633:
634: l_old_supp_yn VARCHAR2(1) := 'N';
635:

Line 632: l_version_comments pa_control_items.version_comments%type := null;

628:
629: l_ci_id NUMBER := p_ci_id;
630:
631: l_ci_number pa_control_items.ci_number%type := null;
632: l_version_comments pa_control_items.version_comments%type := null;
633:
634: l_old_supp_yn VARCHAR2(1) := 'N';
635:
636: lx_ci_id NUMBER := null;

Line 642: FROM pa_control_items

638:
639: CURSOR c_from_item
640: is
641: SELECT ci_number,version_comments
642: FROM pa_control_items
643: WHERE ci_id = p_ci_id;
644:
645: l_src_ci_id NUMBER := null;
646: CURSOR c_src_item

Line 649: FROM pa_control_items

645: l_src_ci_id NUMBER := null;
646: CURSOR c_src_item
647: is
648: SELECT ci_id
649: FROM pa_control_items
650: WHERE original_ci_id = p_ci_id;
651:
652: l_version_number pa_control_items.version_number%type := null;
653: cursor c_vers_num

Line 652: l_version_number pa_control_items.version_number%type := null;

648: SELECT ci_id
649: FROM pa_control_items
650: WHERE original_ci_id = p_ci_id;
651:
652: l_version_number pa_control_items.version_number%type := null;
653: cursor c_vers_num
654: is
655: select max(nvl(version_number,0))
656: from PA_CONTROL_ITEMS

Line 656: from PA_CONTROL_ITEMS

652: l_version_number pa_control_items.version_number%type := null;
653: cursor c_vers_num
654: is
655: select max(nvl(version_number,0))
656: from PA_CONTROL_ITEMS
657: where ci_id = p_src_ci_id;
658:
659: cursor c_old_supp
660: is

Line 663: pa_control_items ci

659: cursor c_old_supp
660: is
661: select 'Y'
662: from pa_ci_impact_type_usage Usg,
663: pa_control_items ci
664: where usg.ci_type_id = ci.ci_type_id
665: and ci.ci_id = p_ci_id
666: and usg.impact_type_code = 'SUPPLIER';
667:

Line 676: from pa_control_items

672: from pa_project_statuses
673: where status_type='CONTROL_ITEM'
674: and project_system_status_code = 'CI_APPROVED'
675: and project_status_code in (select distinct(status_code)
676: from pa_control_items
677: where ci_id =p_src_ci_id );
678:
679: BEGIN
680:

Line 728: update PA_CONTROL_ITEMS

724: end if;
725: close c_vers_num;
726:
727: -- set the current version to no
728: update PA_CONTROL_ITEMS
729: set Current_Version_flag = 'N'
730: where ci_id = p_src_ci_id;
731:
732: update PA_CI_SUPPLIER_DETAILS

Line 739: update PA_CONTROL_ITEMS

735:
736: PA_CHNGE_DOC_POLICY_PVT.SET_CHNGE_DOC_VERS; -- sets policy to n
737:
738: -- set the selected version for copy current flag to yes
739: update PA_CONTROL_ITEMS
740: set Current_Version_flag = 'Y'
741: where ci_id = p_ci_id;
742:
743: PA_CHNGE_DOC_POLICY_PVT.RESET_CHNGE_DOC_VERS; -- sets policy to y

Line 787: update PA_CONTROL_ITEMS

783: END IF;
784:
785: PA_CHNGE_DOC_POLICY_PVT.SET_CHNGE_DOC_VERS; -- sets policy to n
786: -- sets the current ci id whic got versioned above source ci id
787: update PA_CONTROL_ITEMS
788: set source_ci_id = x_ci_id
789: where ci_id = p_src_ci_id;
790:
791: PA_CHNGE_DOC_POLICY_PVT.RESET_CHNGE_DOC_VERS; -- sets policy to y

Line 871: update PA_CONTROL_ITEMS

867: END IF;
868:
869: PA_CHNGE_DOC_POLICY_PVT.SET_CHNGE_DOC_VERS; -- sets to N end;
870:
871: update PA_CONTROL_ITEMS
872: set version_comments = p_version_comments
873: where ci_id = p_ci_id;
874:
875: PA_CHNGE_DOC_POLICY_PVT.RESET_CHNGE_DOC_VERS; -- sets to Y