DBA Data[Home] [Help]

APPS.PON_NEGOTIATION_COPY_GRP dependencies on STANDARD

Line 622: -- OUT : x_msg_data VARCHAR2, the standard message data output parameter

618: -- 1 (for failure with error, check the
619: -- x_return_status if it is error or waring)
620: -- 1 or more (for Success with warning, check the x_return_status)
621: --
622: -- OUT : x_msg_data VARCHAR2, the standard message data output parameter
623: -- used to return the first message of the stack
624: --
625: -- Version : Current version 1.0
626: -- Previous version 1.0

Line 791: -- Standard call to check for call compatibility

787: --
788: SAVEPOINT PON_NEGOTIATION_COPY_GRP;
789:
790: --
791: -- Standard call to check for call compatibility
792: --
793: IF NOT FND_API.COMPATIBLE_API_CALL ( l_api_version,
794: p_api_version,
795: l_api_name,

Line 1555: -- OUT : x_msg_data VARCHAR2, the standard message data output parameter

1551: -- 1 (for failure with error, check the
1552: -- x_return_status if it is error or waring)
1553: -- 1 or more (for Success with warning, check the x_return_status)
1554: --
1555: -- OUT : x_msg_data VARCHAR2, the standard message data output parameter
1556: -- used to return the first message of the stack
1557: --
1558:
1559: --

Line 1938: l_standard_form pon_auction_headers_all.standard_form%TYPE;

1934: --
1935: l_is_document_federal NUMBER;
1936:
1937: -- clm printing project
1938: l_standard_form pon_auction_headers_all.standard_form%TYPE;
1939: l_document_format pon_auction_headers_all.document_format%TYPE;
1940:
1941: l_template_id NUMBER;
1942: l_doc_number VARCHAR2(50);

Line 2120: SELECT standard_form, document_format

2116: BEGIN
2117:
2118: IF (p_copy_type = g_amend_copy) THEN
2119:
2120: SELECT standard_form, document_format
2121: INTO l_standard_form, l_document_format
2122: FROM PO_PRINT_FORM_FORMATS
2123: WHERE document_type = 'PO_SOL_AMEND_STD_FORM';
2124:

Line 2121: INTO l_standard_form, l_document_format

2117:
2118: IF (p_copy_type = g_amend_copy) THEN
2119:
2120: SELECT standard_form, document_format
2121: INTO l_standard_form, l_document_format
2122: FROM PO_PRINT_FORM_FORMATS
2123: WHERE document_type = 'PO_SOL_AMEND_STD_FORM';
2124:
2125: ELSIF (p_copy_type = g_conformed_doc_copy) THEN

Line 2127: SELECT prev.standard_form, prev.document_format

2123: WHERE document_type = 'PO_SOL_AMEND_STD_FORM';
2124:
2125: ELSIF (p_copy_type = g_conformed_doc_copy) THEN
2126:
2127: SELECT prev.standard_form, prev.document_format
2128: INTO l_standard_form, l_document_format
2129: FROM pon_auction_headers_all prev, pon_auction_headers_all pah
2130: WHERE pah.auction_header_id = p_source_auction_header_id
2131: AND prev.auction_header_id = pah.AUCTION_HEADER_ID_PREV_AMEND;

Line 2128: INTO l_standard_form, l_document_format

2124:
2125: ELSIF (p_copy_type = g_conformed_doc_copy) THEN
2126:
2127: SELECT prev.standard_form, prev.document_format
2128: INTO l_standard_form, l_document_format
2129: FROM pon_auction_headers_all prev, pon_auction_headers_all pah
2130: WHERE pah.auction_header_id = p_source_auction_header_id
2131: AND prev.auction_header_id = pah.AUCTION_HEADER_ID_PREV_AMEND;
2132:

Line 2133: /* Bug : 16560215 : When copying draft amendments, standard form and

2129: FROM pon_auction_headers_all prev, pon_auction_headers_all pah
2130: WHERE pah.auction_header_id = p_source_auction_header_id
2131: AND prev.auction_header_id = pah.AUCTION_HEADER_ID_PREV_AMEND;
2132:
2133: /* Bug : 16560215 : When copying draft amendments, standard form and
2134: * document format should be copied from base document.
2135: */
2136: ELSIF (p_copy_type = g_draft_neg_copy) THEN
2137:

Line 2138: SELECT prev.standard_form, prev.document_format

2134: * document format should be copied from base document.
2135: */
2136: ELSIF (p_copy_type = g_draft_neg_copy) THEN
2137:
2138: SELECT prev.standard_form, prev.document_format
2139: INTO l_standard_form, l_document_format
2140: FROM pon_auction_headers_all prev, pon_auction_headers_all pah
2141: WHERE pah.auction_header_id = p_source_auction_header_id
2142: AND Nvl(pah.amendment_flag, 'N') = 'Y'

Line 2139: INTO l_standard_form, l_document_format

2135: */
2136: ELSIF (p_copy_type = g_draft_neg_copy) THEN
2137:
2138: SELECT prev.standard_form, prev.document_format
2139: INTO l_standard_form, l_document_format
2140: FROM pon_auction_headers_all prev, pon_auction_headers_all pah
2141: WHERE pah.auction_header_id = p_source_auction_header_id
2142: AND Nvl(pah.amendment_flag, 'N') = 'Y'
2143: AND prev.auction_header_id = pah.AUCTION_HEADER_ID_PREV_AMEND;

Line 2786: STANDARD_FORM,--

2782: SOLICITATION_TYPE, --
2783: UDA_TEMPLATE_ID, --
2784: UDA_TEMPLATE_DATE, --
2785: NO_OF_COPIES, --
2786: STANDARD_FORM,--
2787: DOCUMENT_FORMAT, --
2788: -- Begin Supplier Management: Bug 8993731
2789: SUPP_REG_QUAL_FLAG,
2790: SUPP_EVAL_FLAG,

Line 3308: Nvl(l_standard_form,standard_form),

3304: SOLICITATION_TYPE, --
3305: UDA_TEMPLATE_ID, --
3306: UDA_TEMPLATE_DATE, --
3307: NO_OF_COPIES, --
3308: Nvl(l_standard_form,standard_form),
3309: Nvl(l_document_format,document_format),
3310: -- Begin Supplier Management: Bug 8993731
3311: g_neg_style_raw.SUPP_REG_QUAL_FLAG,
3312: g_neg_style_raw.SUPP_EVAL_FLAG,

Line 3973: IF (g_auc_doctype_rule_data.CONTRACT_TYPE = 'STANDARD' ) THEN

3969: l_source_line_id(x) := NULL;
3970: l_requisition_number(x) := NULL;
3971: END IF;
3972:
3973: IF (g_auc_doctype_rule_data.CONTRACT_TYPE = 'STANDARD' ) THEN
3974: l_po_agreed_amount(x) := NULL;
3975: END IF;
3976:
3977: --

Line 10754: -- set it to STANDARD if fixed and default

10750: -- CONTRACT_TYPE Column is not applicable for RFI. So, it is NULL
10751: -- by the seeded bizrule (We are not hardcoding it to NULL as before).
10752: -- If it is applicable for the target doctype then check if it was displayable
10753: -- for source doctype_id. If it is true then carry on the old value. If it is false then
10754: -- set it to STANDARD if fixed and default
10755: -- values are NULL for a doctype. This was the logic implemented in
10756: -- the initialize() method of AuctionHeaderALLEOImpl
10757: --
10758: decode (R_CNTRCT.VALIDITY_FLAG,

Line 10764: '-1', 'STANDARD',

10760: 'Y', decode(R_OLD_CNTRCT.display_flag,
10761: 'Y', A.CONTRACT_TYPE,
10762: decode(NVL(R_CNTRCT.FIXED_VALUE,'-1'),
10763: '-1', decode(NVL(R_CNTRCT.DEFAULT_VALUE,'-1'),
10764: '-1', 'STANDARD',
10765: R_CNTRCT.DEFAULT_VALUE),
10766: R_CNTRCT.FIXED_VALUE))) CONTRACT_TYPE,
10767: --
10768: -- The PO_START_DATE will be defaulted to NULLwhen it is not applicable to the target

Line 10954: -- It is later set to NULL if the current Contract type is STANDARD

10950: -- The PO_MIN_REL_AMOUNT flag will be defaulted to NULL if not applicable to
10951: -- a doctype_id. It keeps the source document value if the target doctype_id
10952: -- ihas the display flag on. Otherwise it is always set as per the
10953: -- bizrule dictates. If the bizrule value is NULL then it is set to NULL.
10954: -- It is later set to NULL if the current Contract type is STANDARD
10955: --
10956: decode (R_MIN_REL_AMT.VALIDITY_FLAG,
10957: 'N',NULL,
10958: 'Y', decode( R_MIN_REL_AMT.display_flag,

Line 11622: -- a standard PO (setOutcomeAndDependentFields logic

11618: --
11619: -- This is a safeguard for setting BPA related attributes to
11620: -- NULL.
11621: -- The Blanket related fields are set to NULL when it is
11622: -- a standard PO (setOutcomeAndDependentFields logic
11623: -- from AuctionHeadersALLEOImpl)
11624: --
11625: IF (t_record.CONTRACT_TYPE = 'STANDARD' ) THEN
11626: -- Bug 3973611, keep the GA Flag to N in case of SPO

Line 11625: IF (t_record.CONTRACT_TYPE = 'STANDARD' ) THEN

11621: -- The Blanket related fields are set to NULL when it is
11622: -- a standard PO (setOutcomeAndDependentFields logic
11623: -- from AuctionHeadersALLEOImpl)
11624: --
11625: IF (t_record.CONTRACT_TYPE = 'STANDARD' ) THEN
11626: -- Bug 3973611, keep the GA Flag to N in case of SPO
11627: t_record.GLOBAL_AGREEMENT_FLAG := 'N';
11628: t_record.PO_START_DATE := NULL;
11629: t_record.PO_END_DATE := NULL;

Line 11795: ELSIF (p_contract_type ='STANDARD') THEN

11791: IF (p_contract_type = 'BLANKET') THEN
11792: l_po_doctype := 'PA_BLANKET';
11793: ELSIF (p_contract_type ='CONTRACT') THEN
11794: l_po_doctype := 'PA_CONTRACT';
11795: ELSIF (p_contract_type ='STANDARD') THEN
11796: l_po_doctype := 'PO_STANDARD';
11797: END IF;
11798:
11799: --

Line 11796: l_po_doctype := 'PO_STANDARD';

11792: l_po_doctype := 'PA_BLANKET';
11793: ELSIF (p_contract_type ='CONTRACT') THEN
11794: l_po_doctype := 'PA_CONTRACT';
11795: ELSIF (p_contract_type ='STANDARD') THEN
11796: l_po_doctype := 'PO_STANDARD';
11797: END IF;
11798:
11799: --
11800: -- Get site ID for the enterprise

Line 13041: -- OUT : x_msg_data VARCHAR2, the standard message data output parameter

13037: -- 1 (for failure with error, check the
13038: -- x_return_status if it is error or waring)
13039: -- 1 or more (for Success with warning, check the x_return_status)
13040: --
13041: -- OUT : x_msg_data VARCHAR2, the standard message data output parameter
13042: -- used to return the first message of the stack
13043: --
13044: -- Version : Current version 1.0
13045: -- Previous version 1.0