DBA Data[Home] [Help]

APPS.PO_REQCHANGEREQUESTWF_PVT dependencies on STANDARD

Line 1982: l_document_subtype := 'STANDARD';

1978: -- has to be in 'APPROVED' status, otherwise
1979: -- the api will fail. so change the document
1980: -- to 'APPROVED' status first.
1981: if(l_document_type= 'PO') then
1982: l_document_subtype := 'STANDARD';
1983:
1984: update po_headers_all
1985: set AUTHORIZATION_STATUS = 'APPROVED',
1986: approved_flag='Y',

Line 3436: note, this fix will not impact standard PO,

3432: end if;
3433: end if;
3434:
3435: /* bug 3916594: added condition to check for release
3436: note, this fix will not impact standard PO,
3437: as null<>null yields null
3438: */
3439: if(nvl(l_current_header_id, l_document_header_id)
3440: <>l_document_header_id

Line 4560: l_document_subtype:='STANDARD';

4556: from po_releases_all por, po_headers_all poh
4557: where por.po_release_id=l_document_id
4558: and por.po_header_id=poh.po_header_id;
4559: else
4560: l_document_subtype:='STANDARD';
4561:
4562: fnd_message.set_name ('PO','PO_WF_NOTIF_ORDER');
4563: l_document_type_disp := fnd_message.get;
4564:

Line 4701: --Standard code

4697: , xn_excl_tax_amount => l_tax_amount
4698: , xn_excl_nr_tax_amount => ln_jai_excl_nr_tax
4699: );
4700: ELSE
4701: --Standard code
4702: -- get old tax and tax dsp
4703: SELECT nvl(sum(nonrecoverable_tax), 0)
4704: into l_tax_amount
4705: FROM po_requisition_lines_all rl,

Line 8084: -- standard code

8080: , xn_excl_tax_amount => l_new_tax_currency
8081: , xn_excl_nr_tax_amount => ln_jai_excl_nr_tax
8082: );
8083: ELSE
8084: -- standard code
8085: SELECT nvl(sum(nvl(nonrecoverable_tax, 0)), 0)
8086: INTO l_new_tax_currency
8087: FROM po_requisition_lines_all rl,
8088: po_req_distributions_all rd

Line 8246: --Standard Code

8242: , xn_excl_tax_amount => l_tax_amount
8243: , xn_excl_nr_tax_amount => ln_jai_excl_nr_tax
8244: );
8245: ELSE
8246: --Standard Code
8247: SELECT nvl(sum(nonrecoverable_tax), 0)
8248: into l_tax_amount
8249: FROM po_requisition_lines_all rl,
8250: po_req_distributions_all rd

Line 8564: l_document_subtype := 'STANDARD';

8560: open l_get_group_id_po_csr;
8561: fetch l_get_group_id_po_csr
8562: into l_change_request_group_id, l_po_chg_itemtype, l_po_chg_itemkey;
8563: close l_get_group_id_po_csr;
8564: l_document_subtype := 'STANDARD';
8565: end if;
8566:
8567: PO_WF_UTIL_PKG.SetItemAttrText(itemtype => itemtype,
8568: itemkey => itemkey,

Line 9193: -- Standard API check of p_commit

9189: exit when l_index=l_last;
9190: l_index:=p_CanceledReqLineIDs_tbl.next(l_index);
9191: end loop;
9192:
9193: -- Standard API check of p_commit
9194: IF FND_API.to_boolean(p_commit) THEN
9195: COMMIT WORK;
9196: END IF;
9197:

Line 9256: -- End standard API initialization

9252: l_api_name, g_pkg_name) THEN
9253: RAISE FND_API.g_exc_unexpected_error;
9254: END IF;
9255: x_return_status := FND_API.g_ret_sts_success;
9256: -- End standard API initialization
9257:
9258: open change_request_group_id;
9259: fetch change_request_group_id into l_change_request_group_id;
9260: close change_request_group_id;

Line 10556: l_document_subtype:='STANDARD';

10552:
10553: IF (l_document_type = 'RELEASE') THEN
10554: l_document_subtype:='BLANKET';
10555: ELSE
10556: l_document_subtype:='STANDARD';
10557: END IF;
10558:
10559: l_progress := 'PO_ReqChangeRequestWF_PVT.Accept_Po_Changes: 03';
10560:

Line 11846: -- End standard API initialization

11842:
11843: RAISE fnd_api.g_exc_unexpected_error;
11844: END IF;
11845: x_return_status := fnd_api.g_ret_sts_success;
11846: -- End standard API initialization
11847: l_progress := '001';
11848:
11849: IF g_debug_stmt THEN
11850: po_debug.debug_var(l_log_head,l_progress,'p_req_header_id',p_req_header_id );