[Home] [Help]
575: -- 1 (for failure with error, check the
576: -- x_return_status if it is error or waring)
577: -- 1 or more (for Success with warning, check the x_return_status)
578: --
579: -- OUT : x_msg_data VARCHAR2, the standard message data output parameter
580: -- used to return the first message of the stack
581: --
582: -- Version : Current version 1.0
583: -- Previous version 1.0
736: --
737: SAVEPOINT PON_NEGOTIATION_COPY_GRP;
738:
739: --
740: -- Standard call to check for call compatibility
741: --
742: IF NOT FND_API.COMPATIBLE_API_CALL ( l_api_version,
743: p_api_version,
744: l_api_name,
3076: l_source_line_id(x) := NULL;
3077: l_requisition_number(x) := NULL;
3078: END IF;
3079:
3080: IF (g_auc_doctype_rule_data.CONTRACT_TYPE = 'STANDARD' ) THEN
3081: l_po_agreed_amount(x) := NULL;
3082: END IF;
3083:
3084: --
9457: -- CONTRACT_TYPE Column is not applicable for RFI. So, it is NULL
9458: -- by the seeded bizrule (We are not hardcoding it to NULL as before).
9459: -- If it is applicable for the target doctype then check if it was displayable
9460: -- for source doctype_id. If it is true then carry on the old value. If it is false then
9461: -- set it to STANDARD if fixed and default
9462: -- values are NULL for a doctype. This was the logic implemented in
9463: -- the initialize() method of AuctionHeaderALLEOImpl
9464: --
9465: decode (R_CNTRCT.VALIDITY_FLAG,
9467: 'Y', decode(R_OLD_CNTRCT.display_flag,
9468: 'Y', A.CONTRACT_TYPE,
9469: decode(NVL(R_CNTRCT.FIXED_VALUE,'-1'),
9470: '-1', decode(NVL(R_CNTRCT.DEFAULT_VALUE,'-1'),
9471: '-1', 'STANDARD',
9472: R_CNTRCT.DEFAULT_VALUE),
9473: R_CNTRCT.FIXED_VALUE))) CONTRACT_TYPE,
9474: --
9475: -- The PO_START_DATE will be defaulted to NULLwhen it is not applicable to the target
9657: -- The PO_MIN_REL_AMOUNT flag will be defaulted to NULL if not applicable to
9658: -- a doctype_id. It keeps the source document value if the target doctype_id
9659: -- ihas the display flag on. Otherwise it is always set as per the
9660: -- bizrule dictates. If the bizrule value is NULL then it is set to NULL.
9661: -- It is later set to NULL if the current Contract type is STANDARD
9662: --
9663: decode (R_MIN_REL_AMT.VALIDITY_FLAG,
9664: 'N',NULL,
9665: 'Y', decode( R_MIN_REL_AMT.display_flag,
10279: --
10280: -- This is a safeguard for setting BPA related attributes to
10281: -- NULL.
10282: -- The Blanket related fields are set to NULL when it is
10283: -- a standard PO (setOutcomeAndDependentFields logic
10284: -- from AuctionHeadersALLEOImpl)
10285: --
10286: IF (t_record.CONTRACT_TYPE = 'STANDARD' ) THEN
10287: -- Bug 3973611, keep the GA Flag to N in case of SPO
10282: -- The Blanket related fields are set to NULL when it is
10283: -- a standard PO (setOutcomeAndDependentFields logic
10284: -- from AuctionHeadersALLEOImpl)
10285: --
10286: IF (t_record.CONTRACT_TYPE = 'STANDARD' ) THEN
10287: -- Bug 3973611, keep the GA Flag to N in case of SPO
10288: t_record.GLOBAL_AGREEMENT_FLAG := 'N';
10289: t_record.PO_START_DATE := NULL;
10290: t_record.PO_END_DATE := NULL;
10441: IF (p_contract_type = 'BLANKET') THEN
10442: l_po_doctype := 'PA_BLANKET';
10443: ELSIF (p_contract_type ='CONTRACT') THEN
10444: l_po_doctype := 'PA_CONTRACT';
10445: ELSIF (p_contract_type ='STANDARD') THEN
10446: l_po_doctype := 'PO_STANDARD';
10447: END IF;
10448:
10449: --
10442: l_po_doctype := 'PA_BLANKET';
10443: ELSIF (p_contract_type ='CONTRACT') THEN
10444: l_po_doctype := 'PA_CONTRACT';
10445: ELSIF (p_contract_type ='STANDARD') THEN
10446: l_po_doctype := 'PO_STANDARD';
10447: END IF;
10448:
10449: --
10450: -- Get site ID for the enterprise