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 STANDARD

Line 3828: * If the source doc is a quotation then we are going to create a standard po.

3824:
3825: x_batch_id := x_interface_header_id;
3826:
3827: /* If the source doc is a blanket then we are going to create a blanket release.
3828: * If the source doc is a quotation then we are going to create a standard po.
3829: */
3830:
3831: /* FPI GA - If ga flag is Y then we create a standard PO */
3832:

Line 3831: /* FPI GA - If ga flag is Y then we create a standard PO */

3827: /* If the source doc is a blanket then we are going to create a blanket release.
3828: * If the source doc is a quotation then we are going to create a standard po.
3829: */
3830:
3831: /* FPI GA - If ga flag is Y then we create a standard PO */
3832:
3833: -- Bug 2695074 getting the ga flag from the db as the attribute does not have any value
3834: -- in this process
3835:

Line 3847: * we should still create a Standard PO. Hence x_doc_type_to_create

3843: /* Bug 2735730.
3844: * If x_source_doc_id is null, then it would be only in the case
3845: * when the supplier is set up as a consigned enabled and the
3846: * destination type is INVENTORY for the requisition. In this case,
3847: * we should still create a Standard PO. Hence x_doc_type_to_create
3848: * should be STANDARD in this case.
3849: */
3850: if (x_source_doc_id is null) then
3851: x_doc_type_to_create := 'STANDARD';

Line 3848: * should be STANDARD in this case.

3844: * If x_source_doc_id is null, then it would be only in the case
3845: * when the supplier is set up as a consigned enabled and the
3846: * destination type is INVENTORY for the requisition. In this case,
3847: * we should still create a Standard PO. Hence x_doc_type_to_create
3848: * should be STANDARD in this case.
3849: */
3850: if (x_source_doc_id is null) then
3851: x_doc_type_to_create := 'STANDARD';
3852: else

Line 3851: x_doc_type_to_create := 'STANDARD';

3847: * we should still create a Standard PO. Hence x_doc_type_to_create
3848: * should be STANDARD in this case.
3849: */
3850: if (x_source_doc_id is null) then
3851: x_doc_type_to_create := 'STANDARD';
3852: else
3853: if (x_source_doc_type_code = 'BLANKET')
3854: and nvl(x_ga_flag,'N') = 'N' then -- FPI GA
3855: x_doc_type_to_create := 'RELEASE';

Line 3857: x_doc_type_to_create := 'STANDARD';

3853: if (x_source_doc_type_code = 'BLANKET')
3854: and nvl(x_ga_flag,'N') = 'N' then -- FPI GA
3855: x_doc_type_to_create := 'RELEASE';
3856: else
3857: x_doc_type_to_create := 'STANDARD';
3858: end if;
3859: end if;
3860:
3861:

Line 3862: if (x_doc_type_to_create = 'STANDARD') then

3858: end if;
3859: end if;
3860:
3861:
3862: if (x_doc_type_to_create = 'STANDARD') then
3863:
3864: /* Whether automatic numbering is on our not, we are going to use
3865: * the automatic number from the unique identifier table. This is
3866: * as per req import. If however we have an po num (eg. emergency po)

Line 3924: and type_lookup_code IN ('STANDARD', 'PLANNED', 'BLANKET', 'CONTRACT');

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:
3926: exception
3927: when NO_DATA_FOUND then
3928: null;

Line 4276: /* FPI GA - If ga flag is Y then we create a standard PO */

4272:
4273: x_created_by := to_number(FND_PROFILE.VALUE('user_id'));
4274: x_last_updated_by := to_number(FND_PROFILE.VALUE('user_id'));
4275:
4276: /* FPI GA - If ga flag is Y then we create a standard PO */
4277:
4278: if x_source_doc_id is not null then
4279: select global_agreement_flag
4280: into x_ga_flag

Line 4289: * we should still create a Standard PO. Hence x_doc_type_to_create

4285: /* Bug 2735730.
4286: * If x_source_doc_id is null, then it would be only in the case
4287: * when the supplier is set up as a consigned enabled and the
4288: * destination type is INVENTORY for the requisition. In this case,
4289: * we should still create a Standard PO. Hence x_doc_type_to_create
4290: * should be STANDARD in this case.
4291: */
4292: if (x_source_doc_id is null) then
4293: x_doc_type_to_create := 'STANDARD';

Line 4290: * should be STANDARD in this case.

4286: * If x_source_doc_id is null, then it would be only in the case
4287: * when the supplier is set up as a consigned enabled and the
4288: * destination type is INVENTORY for the requisition. In this case,
4289: * we should still create a Standard PO. Hence x_doc_type_to_create
4290: * should be STANDARD in this case.
4291: */
4292: if (x_source_doc_id is null) then
4293: x_doc_type_to_create := 'STANDARD';
4294: else

Line 4293: x_doc_type_to_create := 'STANDARD';

4289: * we should still create a Standard PO. Hence x_doc_type_to_create
4290: * should be STANDARD in this case.
4291: */
4292: if (x_source_doc_id is null) then
4293: x_doc_type_to_create := 'STANDARD';
4294: else
4295: if (x_source_doc_type_code = 'BLANKET')
4296: and nvl(x_ga_flag,'N') = 'N' then -- FPI GA
4297: x_doc_type_to_create := 'RELEASE';

Line 4299: x_doc_type_to_create := 'STANDARD';

4295: if (x_source_doc_type_code = 'BLANKET')
4296: and nvl(x_ga_flag,'N') = 'N' then -- FPI GA
4297: x_doc_type_to_create := 'RELEASE';
4298: else
4299: x_doc_type_to_create := 'STANDARD';
4300: end if;
4301: end if;
4302:
4303: if (x_doc_type_to_create = 'STANDARD') then

Line 4303: if (x_doc_type_to_create = 'STANDARD') then

4299: x_doc_type_to_create := 'STANDARD';
4300: end if;
4301: end if;
4302:
4303: if (x_doc_type_to_create = 'STANDARD') then
4304: x_action_type_code_line := NULL;
4305: x_line_num := NULL;
4306:
4307: --

Line 4699: * standard po or blanket release

4695: *
4696: * Procedure: create_doc
4697: *
4698: * Description: Calls backend autocreate package to create the
4699: * standard po or blanket release
4700: *
4701: *
4702: **************************************************************************/
4703: procedure create_doc (itemtype IN VARCHAR2,

Line 4884: * This will return either 'Standard PO' or 'Release'

4880: aname => 'AGENT_ID');
4881:
4882:
4883: /* Get the displayed value from po_lookup_codes so it will be translated
4884: * This will return either 'Standard PO' or 'Release'
4885: */
4886: --
4887: if (x_doc_type_to_create = 'STANDARD') then
4888: x_doc_type_created_disp:= PO_DOC_STYLE_PVT.get_style_display_name(x_autocreated_doc_id);

Line 4887: if (x_doc_type_to_create = 'STANDARD') then

4883: /* Get the displayed value from po_lookup_codes so it will be translated
4884: * This will return either 'Standard PO' or 'Release'
4885: */
4886: --
4887: if (x_doc_type_to_create = 'STANDARD') then
4888: x_doc_type_created_disp:= PO_DOC_STYLE_PVT.get_style_display_name(x_autocreated_doc_id);
4889: else --releases
4890:
4891: select displayed_field

Line 4907: if (x_doc_type_to_create = 'STANDARD') then

4903: avalue => x_doc_type_created_disp);
4904:
4905: /* Get the document number created */
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.

Line 4942: IF PO_DOC_STYLE_GRP.is_standard_doc_style(l_style_id) = 'Y' THEN

4938: p_po_header_id => x_autocreated_doc_id,
4939: p_doc_subtype => x_doc_type_to_create,
4940: p_mode => 'update');
4941:
4942: IF PO_DOC_STYLE_GRP.is_standard_doc_style(l_style_id) = 'Y' THEN
4943: l_open_form := 'PO_POXPOEPO:PO_HEADER_ID="' || '&' ||
4944: 'AUTOCREATED_DOC_ID"' ||
4945: ' ACCESS_LEVEL_CODE="MODIFY"' ||
4946: ' POXPOEPO_CALLING_FORM="POXSTNOT"';

Line 5101: l_doc_subtype := PO_CONSTANTS_SV.STANDARD;

5097: itemkey => itemkey,
5098: aname => 'AUTOCREATED_DOC_ID');
5099: ELSE
5100: l_doc_type := PO_CONSTANTS_SV.PO;
5101: l_doc_subtype := PO_CONSTANTS_SV.STANDARD;
5102: l_po_header_id := po_wf_util_pkg.GetItemAttrNumber
5103: (itemtype => itemtype,
5104: itemkey => itemkey,
5105: aname => 'AUTOCREATED_DOC_ID');

Line 5250: /* STANDARD */

5246: if (x_doc_type_to_create = 'RELEASE') then
5247: x_doc_type := 'RELEASE';
5248: x_doc_subtype := 'BLANKET';
5249: else
5250: /* STANDARD */
5251: x_doc_type := 'PO';
5252: x_doc_subtype := 'STANDARD';
5253: end if;
5254:

Line 5252: x_doc_subtype := 'STANDARD';

5248: x_doc_subtype := 'BLANKET';
5249: else
5250: /* STANDARD */
5251: x_doc_type := 'PO';
5252: x_doc_subtype := 'STANDARD';
5253: end if;
5254:
5255: /* Need to get item_type and workflow process from po_document_types.
5256: * They may be different based on the doc/org.

Line 5702: l_style_id := PO_DOC_STYLE_GRP.get_standard_doc_style; --

5698: /* Get the group_id since we only want to process lines belonging
5699: * to the same group. We need to get the group_id before opening
5700: * the cursor since it is a parameter to the cursor.
5701: */
5702: l_style_id := PO_DOC_STYLE_GRP.get_standard_doc_style; --
5703:
5704: x_group_id := po_wf_util_pkg.GetItemAttrNumber (itemtype => itemtype,
5705: itemkey => itemkey,
5706: aname => 'GROUP_ID');