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_AUTOCREATE_DOC dependencies on PO_HEADERS_ALL

Line 848: from po_headers_all

844:
845: if x_source_doc_po_header_id is not null then
846: select global_agreement_flag
847: into x_ga_flag
848: from po_headers_all
849: where po_header_id = x_source_doc_po_header_id;
850: end if;
851:
852: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,

Line 1420: l_gc_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;

1416: x_progress varchar2(300) := '000';
1417:
1418: --
1419:
1420: l_gc_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;
1421: l_currency PO_HEADERS_ALL.currency_code%TYPE;
1422: l_base_currency PO_HEADERS_ALL.currency_code%TYPE;
1423: l_rate PO_HEADERS_ALL.rate%TYPE;
1424: l_rate_date PO_HEADERS_ALL.rate_date%TYPE;

Line 1421: l_currency PO_HEADERS_ALL.currency_code%TYPE;

1417:
1418: --
1419:
1420: l_gc_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;
1421: l_currency PO_HEADERS_ALL.currency_code%TYPE;
1422: l_base_currency PO_HEADERS_ALL.currency_code%TYPE;
1423: l_rate PO_HEADERS_ALL.rate%TYPE;
1424: l_rate_date PO_HEADERS_ALL.rate_date%TYPE;
1425: l_rate_type PO_HEADERS_ALL.rate_type%TYPE;

Line 1422: l_base_currency PO_HEADERS_ALL.currency_code%TYPE;

1418: --
1419:
1420: l_gc_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;
1421: l_currency PO_HEADERS_ALL.currency_code%TYPE;
1422: l_base_currency PO_HEADERS_ALL.currency_code%TYPE;
1423: l_rate PO_HEADERS_ALL.rate%TYPE;
1424: l_rate_date PO_HEADERS_ALL.rate_date%TYPE;
1425: l_rate_type PO_HEADERS_ALL.rate_type%TYPE;
1426:

Line 1423: l_rate PO_HEADERS_ALL.rate%TYPE;

1419:
1420: l_gc_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;
1421: l_currency PO_HEADERS_ALL.currency_code%TYPE;
1422: l_base_currency PO_HEADERS_ALL.currency_code%TYPE;
1423: l_rate PO_HEADERS_ALL.rate%TYPE;
1424: l_rate_date PO_HEADERS_ALL.rate_date%TYPE;
1425: l_rate_type PO_HEADERS_ALL.rate_type%TYPE;
1426:
1427: -- bug4198095

Line 1424: l_rate_date PO_HEADERS_ALL.rate_date%TYPE;

1420: l_gc_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;
1421: l_currency PO_HEADERS_ALL.currency_code%TYPE;
1422: l_base_currency PO_HEADERS_ALL.currency_code%TYPE;
1423: l_rate PO_HEADERS_ALL.rate%TYPE;
1424: l_rate_date PO_HEADERS_ALL.rate_date%TYPE;
1425: l_rate_type PO_HEADERS_ALL.rate_type%TYPE;
1426:
1427: -- bug4198095
1428: -- No need to match local contract anymore after R12

Line 1425: l_rate_type PO_HEADERS_ALL.rate_type%TYPE;

1421: l_currency PO_HEADERS_ALL.currency_code%TYPE;
1422: l_base_currency PO_HEADERS_ALL.currency_code%TYPE;
1423: l_rate PO_HEADERS_ALL.rate%TYPE;
1424: l_rate_date PO_HEADERS_ALL.rate_date%TYPE;
1425: l_rate_type PO_HEADERS_ALL.rate_type%TYPE;
1426:
1427: -- bug4198095
1428: -- No need to match local contract anymore after R12
1429: l_current_org_id PO_HEADERS_ALL.org_id%TYPE;

Line 1429: l_current_org_id PO_HEADERS_ALL.org_id%TYPE;

1425: l_rate_type PO_HEADERS_ALL.rate_type%TYPE;
1426:
1427: -- bug4198095
1428: -- No need to match local contract anymore after R12
1429: l_current_org_id PO_HEADERS_ALL.org_id%TYPE;
1430:
1431: -- SQL What: Find available contract that is valid. First it
1432: -- finds local contracts; if none exists then find global contracts.
1433: -- Also, latest contract takes priority

Line 1442: FROM po_headers_all POH

1438: CURSOR c_contract_currency IS
1439: SELECT POH.po_header_id,
1440: POH.global_agreement_flag,
1441: POH.currency_code
1442: FROM po_headers_all POH
1443: WHERE POH.vendor_id = x_supplier_id
1444: AND POH.currency_code = nvl(x_item_currency, l_base_currency)
1445: AND POH.type_lookup_code = 'CONTRACT'
1446: /* R12 GCPA

Line 1474: FROM po_headers_all POH

1470: CURSOR c_contract IS
1471: SELECT POH.po_header_id,
1472: POH.global_agreement_flag,
1473: POH.currency_code
1474: FROM po_headers_all POH
1475: WHERE POH.vendor_id = x_supplier_id
1476: AND POH.type_lookup_code = 'CONTRACT'
1477: /* R12 GCPA
1478: + If Profile ALLOW_REFERENCING_CPA_UNDER_AMENDMENT is Y, then we can refer any Contract Which is approved Once

Line 1809: l_purchasing_org_id PO_HEADERS_ALL.org_id%TYPE; --

1805: x_progress varchar2(300);
1806:
1807: -- bug2821542
1808: l_validate_result VARCHAR2(1) := FND_API.G_TRUE;
1809: l_purchasing_org_id PO_HEADERS_ALL.org_id%TYPE; --
1810:
1811: begin
1812:
1813: x_org_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,

Line 2088: -- Modified the query to select from po_headers_all instead of po_headers.

2084: /*Bug 928568-removed the _all reference and used the striped table
2085: table instead */
2086:
2087: --
2088: -- Modified the query to select from po_headers_all instead of po_headers.
2089: select agent_id
2090: into x_agent_id
2091: from po_headers_all
2092: where po_header_id = x_source_doc_po_header_id;

Line 2091: from po_headers_all

2087: --
2088: -- Modified the query to select from po_headers_all instead of po_headers.
2089: select agent_id
2090: into x_agent_id
2091: from po_headers_all
2092: where po_header_id = x_source_doc_po_header_id;
2093: exception
2094: when NO_DATA_FOUND then
2095: x_agent_id := NULL;

Line 2178: --Modified the query to select from po_headers_all instead of po_headers

2174:
2175: begin
2176:
2177: --
2178: --Modified the query to select from po_headers_all instead of po_headers
2179: select agent_id
2180: into x_agent_id
2181: from po_headers_all
2182: where po_header_id = x_contract_id;

Line 2181: from po_headers_all

2177: --
2178: --Modified the query to select from po_headers_all instead of po_headers
2179: select agent_id
2180: into x_agent_id
2181: from po_headers_all
2182: where po_header_id = x_contract_id;
2183:
2184: exception
2185:

Line 3156: from po_headers_all

3152: /* FPI GA start */
3153: if (c1_source_doc_id is not null) then
3154: select global_agreement_flag
3155: into c1_ga_flag
3156: from po_headers_all
3157: where po_header_id = c1_source_doc_id;
3158: end if;
3159:
3160: /* FPI GA End */

Line 3320: from po_headers_all

3316: /* FPI GA start */
3317: if (c2_source_doc_id is not null) then
3318: select global_agreement_flag
3319: into c2_ga_flag
3320: from po_headers_all
3321: where po_header_id = c2_source_doc_id;
3322: end if;
3323:
3324: /* FPI GA End */

Line 3515: from po_headers_all

3511: if ((NVL(c1_source_doc_type_code,'BLANKET')='CONTRACT') ) then
3512:
3513: select vendor_contact_id
3514: into x_source_contact_id
3515: from po_headers_all
3516: where po_header_id=c2_contract_id;
3517:
3518: elsif (NVL(c2_ga_flag,'N')='Y') then -- For Global Aggrement.
3519:

Line 3522: from po_headers_all -- To take care of GAs in Diff Operating unit

3518: elsif (NVL(c2_ga_flag,'N')='Y') then -- For Global Aggrement.
3519:
3520: select vendor_contact_id
3521: into x_source_contact_id
3522: from po_headers_all -- To take care of GAs in Diff Operating unit
3523: where po_header_id=c2_source_doc_id;
3524: else
3525: x_source_contact_id := null;
3526: end if;

Line 3743: l_purchasing_org_id po_headers_all.org_id%TYPE; --

3739: x_progress varchar2(300);
3740:
3741: x_grouping_allowed varchar2(1); /* Bug 2974129 */
3742: x_group_code po_headers_interface.group_code%TYPE; /* Bug 2974129 */
3743: l_purchasing_org_id po_headers_all.org_id%TYPE; --
3744:
3745: --begin bug 3401653
3746: l_source_doc_currency_code po_headers_all.currency_code%TYPE := NULL;
3747: l_pou_currency_code po_headers_all.currency_code%TYPE;

Line 3746: l_source_doc_currency_code po_headers_all.currency_code%TYPE := NULL;

3742: x_group_code po_headers_interface.group_code%TYPE; /* Bug 2974129 */
3743: l_purchasing_org_id po_headers_all.org_id%TYPE; --
3744:
3745: --begin bug 3401653
3746: l_source_doc_currency_code po_headers_all.currency_code%TYPE := NULL;
3747: l_pou_currency_code po_headers_all.currency_code%TYPE;
3748: l_rou_currency_code po_headers_all.currency_code%TYPE;
3749: l_pou_sob_id gl_sets_of_books.set_of_books_id%TYPE;
3750: l_pou_default_rate_type po_headers_all.rate_type%TYPE;

Line 3747: l_pou_currency_code po_headers_all.currency_code%TYPE;

3743: l_purchasing_org_id po_headers_all.org_id%TYPE; --
3744:
3745: --begin bug 3401653
3746: l_source_doc_currency_code po_headers_all.currency_code%TYPE := NULL;
3747: l_pou_currency_code po_headers_all.currency_code%TYPE;
3748: l_rou_currency_code po_headers_all.currency_code%TYPE;
3749: l_pou_sob_id gl_sets_of_books.set_of_books_id%TYPE;
3750: l_pou_default_rate_type po_headers_all.rate_type%TYPE;
3751: l_interface_rate po_headers_all.rate%TYPE := NULL;

Line 3748: l_rou_currency_code po_headers_all.currency_code%TYPE;

3744:
3745: --begin bug 3401653
3746: l_source_doc_currency_code po_headers_all.currency_code%TYPE := NULL;
3747: l_pou_currency_code po_headers_all.currency_code%TYPE;
3748: l_rou_currency_code po_headers_all.currency_code%TYPE;
3749: l_pou_sob_id gl_sets_of_books.set_of_books_id%TYPE;
3750: l_pou_default_rate_type po_headers_all.rate_type%TYPE;
3751: l_interface_rate po_headers_all.rate%TYPE := NULL;
3752: l_interface_rate_type po_headers_all.rate_type%TYPE := NULL;

Line 3750: l_pou_default_rate_type po_headers_all.rate_type%TYPE;

3746: l_source_doc_currency_code po_headers_all.currency_code%TYPE := NULL;
3747: l_pou_currency_code po_headers_all.currency_code%TYPE;
3748: l_rou_currency_code po_headers_all.currency_code%TYPE;
3749: l_pou_sob_id gl_sets_of_books.set_of_books_id%TYPE;
3750: l_pou_default_rate_type po_headers_all.rate_type%TYPE;
3751: l_interface_rate po_headers_all.rate%TYPE := NULL;
3752: l_interface_rate_type po_headers_all.rate_type%TYPE := NULL;
3753: l_interface_rate_date po_headers_all.rate_date%TYPE := NULL;
3754: l_display_rate po_headers_all.rate%TYPE := NULL;

Line 3751: l_interface_rate po_headers_all.rate%TYPE := NULL;

3747: l_pou_currency_code po_headers_all.currency_code%TYPE;
3748: l_rou_currency_code po_headers_all.currency_code%TYPE;
3749: l_pou_sob_id gl_sets_of_books.set_of_books_id%TYPE;
3750: l_pou_default_rate_type po_headers_all.rate_type%TYPE;
3751: l_interface_rate po_headers_all.rate%TYPE := NULL;
3752: l_interface_rate_type po_headers_all.rate_type%TYPE := NULL;
3753: l_interface_rate_date po_headers_all.rate_date%TYPE := NULL;
3754: l_display_rate po_headers_all.rate%TYPE := NULL;
3755: --end bug 3401653

Line 3752: l_interface_rate_type po_headers_all.rate_type%TYPE := NULL;

3748: l_rou_currency_code po_headers_all.currency_code%TYPE;
3749: l_pou_sob_id gl_sets_of_books.set_of_books_id%TYPE;
3750: l_pou_default_rate_type po_headers_all.rate_type%TYPE;
3751: l_interface_rate po_headers_all.rate%TYPE := NULL;
3752: l_interface_rate_type po_headers_all.rate_type%TYPE := NULL;
3753: l_interface_rate_date po_headers_all.rate_date%TYPE := NULL;
3754: l_display_rate po_headers_all.rate%TYPE := NULL;
3755: --end bug 3401653
3756:

Line 3753: l_interface_rate_date po_headers_all.rate_date%TYPE := NULL;

3749: l_pou_sob_id gl_sets_of_books.set_of_books_id%TYPE;
3750: l_pou_default_rate_type po_headers_all.rate_type%TYPE;
3751: l_interface_rate po_headers_all.rate%TYPE := NULL;
3752: l_interface_rate_type po_headers_all.rate_type%TYPE := NULL;
3753: l_interface_rate_date po_headers_all.rate_date%TYPE := NULL;
3754: l_display_rate po_headers_all.rate%TYPE := NULL;
3755: --end bug 3401653
3756:
3757: begin

Line 3754: l_display_rate po_headers_all.rate%TYPE := NULL;

3750: l_pou_default_rate_type po_headers_all.rate_type%TYPE;
3751: l_interface_rate po_headers_all.rate%TYPE := NULL;
3752: l_interface_rate_type po_headers_all.rate_type%TYPE := NULL;
3753: l_interface_rate_date po_headers_all.rate_date%TYPE := NULL;
3754: l_display_rate po_headers_all.rate%TYPE := NULL;
3755: --end bug 3401653
3756:
3757: begin
3758:

Line 3839: from po_headers_all

3835:
3836: if x_source_doc_id is not null then
3837: select global_agreement_flag, currency_code
3838: into x_ga_flag, l_source_doc_currency_code
3839: from po_headers_all
3840: where po_header_id = x_source_doc_id;
3841: end if;
3842:
3843: /* Bug 2735730.

Line 3918: --Modified the query to select from po_headers_all instead of po_headers.

3914: /* Check to make sure the doc num is not a duplicate */
3915:
3916: begin
3917: --
3918: --Modified the query to select from po_headers_all instead of po_headers.
3919: select 'PO EXISTS'
3920: into x_found
3921: from po_headers_all
3922: where segment1 = x_document_num

Line 3921: from po_headers_all

3917: --
3918: --Modified the query to select from po_headers_all instead of po_headers.
3919: select 'PO EXISTS'
3920: into x_found
3921: from po_headers_all
3922: where segment1 = x_document_num
3923: and org_id = l_purchasing_org_id --
3924: and type_lookup_code IN ('STANDARD', 'PLANNED', 'BLANKET', 'CONTRACT');
3925:

Line 4281: from po_headers_all

4277:
4278: if x_source_doc_id is not null then
4279: select global_agreement_flag
4280: into x_ga_flag
4281: from po_headers_all
4282: where po_header_id = x_source_doc_id;
4283: end if;
4284:
4285: /* Bug 2735730.

Line 4450: l_vendor_site_id PO_HEADERS_ALL.vendor_site_id%TYPE := NULL; --

4446: x_agent_id number;
4447: x_org_id number;
4448: l_purchasing_org_id number; --
4449: x_progress varchar2(300);
4450: l_vendor_site_id PO_HEADERS_ALL.vendor_site_id%TYPE := NULL; --
4451:
4452: cursor c1 is /* x_group_id is a parameter */
4453: select interface_header_id,
4454: document_subtype,

Line 4716: l_purchasing_org_id PO_HEADERS_ALL.org_id%TYPE;

4712: x_org_id number;
4713: x_progress varchar2(300);
4714:
4715: --
4716: l_purchasing_org_id PO_HEADERS_ALL.org_id%TYPE;
4717: l_return_status VARCHAR2(1);
4718: l_msg_count NUMBER;
4719: l_msg_data FND_NEW_MESSAGES.message_text%TYPE;
4720: l_doc_number PO_HEADERS_ALL.segment1%TYPE;

Line 4720: l_doc_number PO_HEADERS_ALL.segment1%TYPE;

4716: l_purchasing_org_id PO_HEADERS_ALL.org_id%TYPE;
4717: l_return_status VARCHAR2(1);
4718: l_msg_count NUMBER;
4719: l_msg_data FND_NEW_MESSAGES.message_text%TYPE;
4720: l_doc_number PO_HEADERS_ALL.segment1%TYPE;
4721: --
4722:
4723: begin
4724:

Line 4860: l_style_id po_headers_all.style_id%TYPE; -- HTML Orders R12

4856: x_autocreated_doc_id number;
4857: l_open_form varchar2(200); --Bug#2982867
4858: l_view_po_url varchar2(1000); -- HTML Orders R12
4859: l_edit_po_url varchar2(1000); -- HTML Orders R12
4860: l_style_id po_headers_all.style_id%TYPE; -- HTML Orders R12
4861:
4862: x_progress varchar2(300);
4863:
4864: begin

Line 4910: --Modified the query to select from po_headers_all instead of

4906:
4907: if (x_doc_type_to_create = 'STANDARD') then
4908:
4909: --
4910: --Modified the query to select from po_headers_all instead of
4911: --po_headers.
4912: --< HTML Orders R12>
4913: -- selected style id
4914: select segment1,

Line 4918: from po_headers_all

4914: select segment1,
4915: style_id
4916: into x_segment1,
4917: l_style_id
4918: from po_headers_all
4919: where po_header_id = x_autocreated_doc_id;
4920:
4921:
4922: po_wf_util_pkg.SetItemAttrText (itemtype => itemtype,

Line 4958: from po_headers_all poh, --

4954: select poh.segment1,
4955: por.release_num
4956: into x_segment1,
4957: x_release_num
4958: from po_headers_all poh, --
4959: po_releases por
4960: where por.po_release_id = x_autocreated_doc_id
4961: and por.po_header_id = poh.po_header_id;
4962:

Line 5054: l_doc_type_to_create po_headers_all.type_lookup_code%TYPE;

5050: x_auto_approve_doc varchar2(1);
5051: x_progress varchar2(300);
5052:
5053: --
5054: l_doc_type_to_create po_headers_all.type_lookup_code%TYPE;
5055: l_doc_type po_document_types_all_b.document_type_code%TYPE;
5056: l_doc_subtype po_document_types_all_b.document_subtype%TYPE;
5057: l_po_header_id po_headers_all.po_header_id%TYPE;
5058: l_po_release_id po_releases_all.po_release_id%TYPE;

Line 5057: l_po_header_id po_headers_all.po_header_id%TYPE;

5053: --
5054: l_doc_type_to_create po_headers_all.type_lookup_code%TYPE;
5055: l_doc_type po_document_types_all_b.document_type_code%TYPE;
5056: l_doc_subtype po_document_types_all_b.document_subtype%TYPE;
5057: l_po_header_id po_headers_all.po_header_id%TYPE;
5058: l_po_release_id po_releases_all.po_release_id%TYPE;
5059: l_return_status VARCHAR2(1);
5060: --
5061:

Line 5193: l_consigned_consumption_flag po_headers_all.consigned_consumption_flag%TYPE;

5189: l_document_num po_headers.segment1%type;
5190: /* RETROACTIVE FPI END */
5191:
5192: /* */
5193: l_consigned_consumption_flag po_headers_all.consigned_consumption_flag%TYPE;
5194: /* */
5195:
5196: l_purchasing_org_id po_headers_all.org_id%TYPE; --
5197:

Line 5196: l_purchasing_org_id po_headers_all.org_id%TYPE; --

5192: /* */
5193: l_consigned_consumption_flag po_headers_all.consigned_consumption_flag%TYPE;
5194: /* */
5195:
5196: l_purchasing_org_id po_headers_all.org_id%TYPE; --
5197:
5198: /* BUG 4638656 */
5199: l_tp_header_id ece_tp_details.tp_header_id%TYPE;
5200: l_edi_flag ece_tp_details.edi_flag%TYPE;

Line 6419: l_vendor_site_id PO_HEADERS_ALL.vendor_site_id%TYPE; --

6415: x_progress varchar2(300) := '000';
6416: x_contract_id_valid number;
6417: x_contract_currency_code varchar2(25);
6418: x_source_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;
6419: l_vendor_site_id PO_HEADERS_ALL.vendor_site_id%TYPE; --
6420: l_base_currency PO_HEADERS_ALL.currency_code%TYPE;
6421: begin
6422:
6423: /* When the source doc and source line was put onto the req line

Line 6420: l_base_currency PO_HEADERS_ALL.currency_code%TYPE;

6416: x_contract_id_valid number;
6417: x_contract_currency_code varchar2(25);
6418: x_source_currency_code PO_REQUISITION_LINES_ALL.currency_code%TYPE;
6419: l_vendor_site_id PO_HEADERS_ALL.vendor_site_id%TYPE; --
6420: l_base_currency PO_HEADERS_ALL.currency_code%TYPE;
6421: begin
6422:
6423: /* When the source doc and source line was put onto the req line
6424: * it was all validated to make sure it was ok.

Line 6475: from po_headers_all POH -- : Use ALL table

6471: -- SQL Why: The reference cannot be used if it is not valid
6472:
6473: select POH.po_header_id, poh.currency_code
6474: into x_contract_id_valid, x_contract_currency_code
6475: from po_headers_all POH -- : Use ALL table
6476: where
6477: POH.po_header_id = x_source_doc_po_header_id
6478: and POH.type_lookup_code = 'CONTRACT'
6479: and nvl(POH.cancel_flag,'N') = 'N'

Line 6706: from po_headers_all

6702:
6703: if x_source_doc_po_header_id is not null then
6704: select org_id
6705: into x_owning_org_id
6706: from po_headers_all
6707: where po_header_id = x_source_doc_po_header_id;
6708: end if;
6709:
6710: if nvl(x_ga_flag,'N') = 'Y' and

Line 6744: from po_headers_all poh

6740:
6741: --Check the referenced GA for cancel/finally closed status
6742: select 'Y'
6743: into x_ref_is_valid
6744: from po_headers_all poh
6745: where poh.po_header_id = p_ga_po_header_id and
6746: nvl(poh.cancel_flag, 'N') = 'N' and
6747: nvl(poh.closed_code, 'OPEN') <> 'FINALLY CLOSED';
6748:

Line 6840: x_org_id PO_HEADERS_ALL.org_id%TYPE;

6836: actid IN NUMBER,
6837: funcmode IN VARCHAR2,
6838: resultout OUT NOCOPY VARCHAR2
6839: ) IS
6840: x_org_id PO_HEADERS_ALL.org_id%TYPE;
6841: x_progress VARCHAR2(300);
6842: x_source_doc_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
6843: x_source_doc_type_code PO_HEADERS_ALL.from_type_lookup_code%TYPE;
6844: x_ga_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;

Line 6842: x_source_doc_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;

6838: resultout OUT NOCOPY VARCHAR2
6839: ) IS
6840: x_org_id PO_HEADERS_ALL.org_id%TYPE;
6841: x_progress VARCHAR2(300);
6842: x_source_doc_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
6843: x_source_doc_type_code PO_HEADERS_ALL.from_type_lookup_code%TYPE;
6844: x_ga_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;
6845: l_return_status VARCHAR2(1) := 'N';
6846:

Line 6843: x_source_doc_type_code PO_HEADERS_ALL.from_type_lookup_code%TYPE;

6839: ) IS
6840: x_org_id PO_HEADERS_ALL.org_id%TYPE;
6841: x_progress VARCHAR2(300);
6842: x_source_doc_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
6843: x_source_doc_type_code PO_HEADERS_ALL.from_type_lookup_code%TYPE;
6844: x_ga_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;
6845: l_return_status VARCHAR2(1) := 'N';
6846:
6847: BEGIN

Line 6844: x_ga_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;

6840: x_org_id PO_HEADERS_ALL.org_id%TYPE;
6841: x_progress VARCHAR2(300);
6842: x_source_doc_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
6843: x_source_doc_type_code PO_HEADERS_ALL.from_type_lookup_code%TYPE;
6844: x_ga_flag PO_HEADERS_ALL.global_agreement_flag%TYPE;
6845: l_return_status VARCHAR2(1) := 'N';
6846:
6847: BEGIN
6848: --Set org context

Line 6888: FROM po_headers_all poh,

6884: BEGIN
6885:
6886: SELECT 'Y'
6887: INTO l_return_status
6888: FROM po_headers_all poh,
6889: per_people_f ppf,
6890: financials_system_parameters fsp
6891: WHERE poh.agent_id = ppf.person_id
6892: AND ppf.business_group_id = fsp.business_group_id

Line 6972: x_org_id PO_HEADERS_ALL.org_id%TYPE;

6968: actid IN NUMBER,
6969: funcmode IN VARCHAR2,
6970: resultout OUT NOCOPY VARCHAR2
6971: ) IS
6972: x_org_id PO_HEADERS_ALL.org_id%TYPE;
6973: x_progress VARCHAR2(300);
6974: x_contract_id NUMBER;
6975: l_return_status VARCHAR2(1) := 'N';
6976:

Line 7000: FROM po_headers_all poh,

6996: IF x_contract_id IS NOT NULL THEN
6997: BEGIN
6998: SELECT 'Y'
6999: INTO l_return_status
7000: FROM po_headers_all poh,
7001: per_people_f ppf,
7002: financials_system_parameters fsp
7003: WHERE poh.agent_id = ppf.person_id
7004: AND ppf.business_group_id = fsp.business_group_id

Line 7088: l_org_id PO_HEADERS_ALL.org_id%TYPE;

7084: funcmode IN VARCHAR2,
7085: resultout OUT NOCOPY VARCHAR2
7086: ) IS
7087:
7088: l_org_id PO_HEADERS_ALL.org_id%TYPE;
7089: l_purchasing_org_id PO_HEADERS_ALL.org_id%TYPE;
7090: x_progress VARCHAR2(300);
7091:
7092: BEGIN

Line 7089: l_purchasing_org_id PO_HEADERS_ALL.org_id%TYPE;

7085: resultout OUT NOCOPY VARCHAR2
7086: ) IS
7087:
7088: l_org_id PO_HEADERS_ALL.org_id%TYPE;
7089: l_purchasing_org_id PO_HEADERS_ALL.org_id%TYPE;
7090: x_progress VARCHAR2(300);
7091:
7092: BEGIN
7093:

Line 7337: l_purchasing_org_id PO_HEADERS_ALL.org_id%TYPE;

7333: p_suggested_vendor_site_id IN NUMBER
7334: )
7335: IS
7336:
7337: l_purchasing_org_id PO_HEADERS_ALL.org_id%TYPE;
7338: l_progress VARCHAR2(300);
7339:
7340: BEGIN
7341: