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.PO_CHANGEORDERWF_PVT dependencies on PO_DOCUMENT_TYPES_ALL

Line 695: l_can_doc_type po_document_types_all.document_type_code%TYPE;

691: l_can_line_id number;
692: l_can_line_loc_id number;
693: l_can_reason po_change_requests.request_reason%TYPE;
694: l_cancel_backing_req po_change_requests.cancel_backing_req%TYPE;
695: l_can_doc_type po_document_types_all.document_type_code%TYPE;
696: l_can_doc_subtype po_document_types_all.document_subtype%TYPE;
697: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;
698: l_return_status varchar2(1);
699: x_progress varchar2(3);

Line 696: l_can_doc_subtype po_document_types_all.document_subtype%TYPE;

692: l_can_line_loc_id number;
693: l_can_reason po_change_requests.request_reason%TYPE;
694: l_cancel_backing_req po_change_requests.cancel_backing_req%TYPE;
695: l_can_doc_type po_document_types_all.document_type_code%TYPE;
696: l_can_doc_subtype po_document_types_all.document_subtype%TYPE;
697: l_type_lookup_code po_headers_all.type_lookup_code%TYPE;
698: l_return_status varchar2(1);
699: x_progress varchar2(3);
700: l_ship_can_err_msg varchar2(2000) := fnd_message.get_string('PO','PO_CHN_CAN_SHIP_ERR');

Line 935: l_document_type_code po_document_types_all.DOCUMENT_TYPE_CODE%TYPE;

931: l_Revision_Num number;
932: l_Accepted_Flag varchar2(1) := p_flag;
933: -- l_Acceptance_Lookup_Code varchar2(25);
934: l_document_id number;
935: l_document_type_code po_document_types_all.DOCUMENT_TYPE_CODE%TYPE;
936: l_acceptance_note PO_ACCEPTANCES.note%TYPE; --bug 2178922
937: l_rspndr_usr_name fnd_user.user_name%TYPE := '';
938: l_accepting_party varchar2(1);
939: begin

Line 1095: l_document_type_code po_document_types_all.DOCUMENT_TYPE_CODE%TYPE;

1091: l_progress varchar2(3) := '000';
1092: l_acceptance_result varchar2(30);
1093: l_org_id number;
1094: l_document_id number;
1095: l_document_type_code po_document_types_all.DOCUMENT_TYPE_CODE%TYPE;
1096: l_vendor po_vendors.vendor_name%TYPE;
1097: --l_accp_type varchar2(100);
1098: x_supp_user_name varchar2(100);
1099: x_supplier_displayname varchar2(100);

Line 1256: l_document_type_code po_document_types_all.DOCUMENT_TYPE_CODE%TYPE;

1252: l_org_id number;
1253: l_agent_id number;
1254: l_document_id number;
1255: l_document_num po_headers_all.segment1%TYPE;
1256: l_document_type_code po_document_types_all.DOCUMENT_TYPE_CODE%TYPE;
1257: l_document_subtype po_document_types_all.DOCUMENT_SUBTYPE%TYPE;
1258: l_seq number;
1259: l_item_key po_headers_all.wf_item_key%TYPE;
1260: l_item_type po_headers_all.wf_item_type%TYPE;

Line 1257: l_document_subtype po_document_types_all.DOCUMENT_SUBTYPE%TYPE;

1253: l_agent_id number;
1254: l_document_id number;
1255: l_document_num po_headers_all.segment1%TYPE;
1256: l_document_type_code po_document_types_all.DOCUMENT_TYPE_CODE%TYPE;
1257: l_document_subtype po_document_types_all.DOCUMENT_SUBTYPE%TYPE;
1258: l_seq number;
1259: l_item_key po_headers_all.wf_item_key%TYPE;
1260: l_item_type po_headers_all.wf_item_type%TYPE;
1261: l_workflow_process PO_DOCUMENT_TYPES_V.WF_APPROVAL_PROCESS%TYPE;

Line 1492: l_document_type_code po_document_types_all.DOCUMENT_TYPE_CODE%TYPE;

1488: funcmode in varchar2,
1489: resultout out NOCOPY varchar2)
1490: IS
1491: l_document_id number;
1492: l_document_type_code po_document_types_all.DOCUMENT_TYPE_CODE%TYPE;
1493: l_revision_num number;
1494: x_progress varchar2(3) := '000';
1495: l_return_status varchar2(1);
1496: BEGIN

Line 6065: l_document_type po_document_types_all.document_type_code%TYPE;

6061: funcmode in varchar2,
6062: resultout out NOCOPY varchar2)
6063: IS
6064: l_document_id number;
6065: l_document_type po_document_types_all.document_type_code%TYPE;
6066: l_header_id number;
6067: l_release_id number;
6068: l_revision_num number;
6069: x_progress varchar2(3) := '000';

Line 6126: l_document_type po_document_types_all.document_type_code%TYPE;

6122: funcmode in varchar2,
6123: resultout out NOCOPY varchar2)
6124: IS
6125: l_document_id number;
6126: l_document_type po_document_types_all.document_type_code%TYPE;
6127: l_acc_flag varchar2(1);
6128: x_progress varchar2(3) := '000';
6129: BEGIN
6130: l_document_id := wf_engine.GetItemAttrNumber(itemtype => itemtype,

Line 6174: l_document_type po_document_types_all.document_type_code%TYPE;

6170: resultout out NOCOPY varchar2)
6171: IS
6172: l_document_id number;
6173: p_header_id number;
6174: l_document_type po_document_types_all.document_type_code%TYPE;
6175: l_authorization_status po_headers_all.authorization_status%TYPE;
6176: l_acceptance_required_flag po_headers_all.acceptance_required_flag%TYPE; -- fix for bug 4946410
6177: l_supplier_user_id number;
6178: l_change_request_group_id number;

Line 6219: t_document_type po_document_types_all.document_type_code%TYPE := null;

6215: l_vendor_id NUMBER;
6216: x_resultout varchar2(100):=null;
6217: l_users WF_DIRECTORY.UserTable;
6218: l_user_name varchar2(100);
6219: t_document_type po_document_types_all.document_type_code%TYPE := null;
6220: u1 pls_integer := 0;
6221: --Bug 6722239 - End
6222:
6223: x_progress varchar2(100) := '000';

Line 6728: l_document_type po_document_types_all.document_type_code%TYPE;

6724: funcmode in varchar2,
6725: resultout out NOCOPY varchar2)
6726: IS
6727: l_document_id number;
6728: l_document_type po_document_types_all.document_type_code%TYPE;
6729: l_seq number;
6730: l_item_key varchar2(2000);
6731: x_progress varchar2(3) := '000';
6732: BEGIN

Line 6773: l_doc_type po_document_types_all.document_type_code%TYPE;

6769: l_chg_req_grp_id number;
6770: l_header_id number;
6771: l_release_id number;
6772: l_doc_id number;
6773: l_doc_type po_document_types_all.document_type_code%TYPE;
6774: l_doc_subtype po_document_types_all.document_subtype%TYPE;
6775: l_employee_id number;
6776: l_acc_req_flag VARCHAR2(10);
6777:

Line 6774: l_doc_subtype po_document_types_all.document_subtype%TYPE;

6770: l_header_id number;
6771: l_release_id number;
6772: l_doc_id number;
6773: l_doc_type po_document_types_all.document_type_code%TYPE;
6774: l_doc_subtype po_document_types_all.document_subtype%TYPE;
6775: l_employee_id number;
6776: l_acc_req_flag VARCHAR2(10);
6777:
6778: x_progress varchar2(3) := '000';

Line 6867: l_document_type po_document_types_all.document_type_code%TYPE;

6863: funcmode in varchar2,
6864: resultout out NOCOPY varchar2)
6865: IS
6866: l_document_id number;
6867: l_document_type po_document_types_all.document_type_code%TYPE;
6868: l_count number;
6869: l_cancel_app_count number; /* fix for bug 3864512 */
6870: x_progress varchar2(100) := '000';
6871: l_change_request_group_id number := null;

Line 7013: --l_doc_type po_document_types_all.document_type_code%TYPE;

7009: l_buyer_agent_id number;
7010: l_responded_by_id number;
7011: l_buyer_username fnd_user.user_name%TYPE;
7012: l_buyer_disp_name varchar2(2000);
7013: --l_doc_type po_document_types_all.document_type_code%TYPE;
7014: l_document_id number;
7015: l_po_style varchar2(10);
7016: x_return_status varchar2(1);
7017: x_complex_flag varchar2(1);

Line 7318: l_doc_type po_document_types_all.document_type_code%TYPE;

7314:
7315: l_authorization_status po_headers_all.authorization_status%TYPE;
7316: l_add_changes_accepted NUMBER;
7317:
7318: l_doc_type po_document_types_all.document_type_code%TYPE;
7319: l_doc_subtype po_document_types_all.document_subtype%TYPE;
7320: l_id number;
7321: l_action po_lookup_codes.lookup_code%TYPE;
7322: l_acc_id number;

Line 7319: l_doc_subtype po_document_types_all.document_subtype%TYPE;

7315: l_authorization_status po_headers_all.authorization_status%TYPE;
7316: l_add_changes_accepted NUMBER;
7317:
7318: l_doc_type po_document_types_all.document_type_code%TYPE;
7319: l_doc_subtype po_document_types_all.document_subtype%TYPE;
7320: l_id number;
7321: l_action po_lookup_codes.lookup_code%TYPE;
7322: l_acc_id number;
7323: l_rej_id number;