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.QP_MODIFIERS_ISETUP_IMP dependencies on FND_API

Line 250: , FND_API.G_MISS_NUM parentlistheaderid

246: , RA.term_id
247: --, B.TERMSID
248: , B.sourcesystemcode
249: , B.activeflag
250: , FND_API.G_MISS_NUM parentlistheaderid
251: , TO_DATE(B.startdateactivefirst,'YYYY-MM-DD HH24:MI:SS')
252: , TO_DATE(B.enddateactivefirst,'YYYY-MM-DD HH24:MI:SS')
253: , B.activedatefirsttype
254: , TO_DATE(B.startdateactivesecond,'YYYY-MM-DD HH24:MI:SS')

Line 269: , FND_API.G_MISS_NUM org_id -- added org_id for moac

265: , B.ptecode
266: , B.listsourcecode
267: , B.origsystemheaderref
268: , B.shareableflag
269: , FND_API.G_MISS_NUM org_id -- added org_id for moac
270: FROM QP_LIST_HEADER_TEMP B ,
271: RA_TERMS_TL RA
272: WHERE B.TERMSNAME = RA.NAME(+)
273: AND B.LANGUAGE = RA.LANGUAGE(+)

Line 308: --, FND_API.G_MISS_NUM inventoryitemid

304: , TO_DATE(LL.enddateactive,'YYYY-MM-DD HH24:MI:SS')
305: , TO_NUMBER(LL.estimaccrualrate)
306: --, LL.generateusingformulaid
307: , TL3.PRICE_FORMULA_ID
308: --, FND_API.G_MISS_NUM inventoryitemid
309: , KFV1.INVENTORY_ITEM_ID
310: , LL.lastupdatedby
311: , null lastupdatedate
312: , LL.lastupdatelogin

Line 313: , FND_API.G_MISS_NUM listheaderid

309: , KFV1.INVENTORY_ITEM_ID
310: , LL.lastupdatedby
311: , null lastupdatedate
312: , LL.lastupdatelogin
313: , FND_API.G_MISS_NUM listheaderid
314: , LL.listlineid
315: , LL.listlinetypecode
316: , TO_NUMBER(LL.listprice)
317: , LL.modifierlevelcode

Line 333: -- , FND_API.G_MISS_NUM relateditemid

329: , NULL programapplicationid
330: , NULL programid
331: , null programupdatedate
332: , LL.rebatetransactiontypecode
333: -- , FND_API.G_MISS_NUM relateditemid
334: , KFV2.INVENTORY_ITEM_ID
335: , relationshiptypeid
336: , LL.repriceflag
337: , NULL requestid

Line 349: , FND_API.G_MISS_NUM RltdModifierId

345: , LL.accrualflag
346: , TO_NUMBER(LL.pricinggroupsequence)
347: , LL.incompatibilitygrpcode
348: , LL.listlineno
349: , FND_API.G_MISS_NUM RltdModifierId
350: , FND_API.G_MISS_NUM FromRltdModifierId
351: , FND_API.G_MISS_NUM ToRltdModifierId
352: , FND_API.G_MISS_NUM RltdModifierGrpNo
353: , FND_API.G_MISS_CHAR RltdModifierGrpType

Line 350: , FND_API.G_MISS_NUM FromRltdModifierId

346: , TO_NUMBER(LL.pricinggroupsequence)
347: , LL.incompatibilitygrpcode
348: , LL.listlineno
349: , FND_API.G_MISS_NUM RltdModifierId
350: , FND_API.G_MISS_NUM FromRltdModifierId
351: , FND_API.G_MISS_NUM ToRltdModifierId
352: , FND_API.G_MISS_NUM RltdModifierGrpNo
353: , FND_API.G_MISS_CHAR RltdModifierGrpType
354: , LL.pricingphaseid

Line 351: , FND_API.G_MISS_NUM ToRltdModifierId

347: , LL.incompatibilitygrpcode
348: , LL.listlineno
349: , FND_API.G_MISS_NUM RltdModifierId
350: , FND_API.G_MISS_NUM FromRltdModifierId
351: , FND_API.G_MISS_NUM ToRltdModifierId
352: , FND_API.G_MISS_NUM RltdModifierGrpNo
353: , FND_API.G_MISS_CHAR RltdModifierGrpType
354: , LL.pricingphaseid
355: , TO_NUMBER(LL.productprecedence)

Line 352: , FND_API.G_MISS_NUM RltdModifierGrpNo

348: , LL.listlineno
349: , FND_API.G_MISS_NUM RltdModifierId
350: , FND_API.G_MISS_NUM FromRltdModifierId
351: , FND_API.G_MISS_NUM ToRltdModifierId
352: , FND_API.G_MISS_NUM RltdModifierGrpNo
353: , FND_API.G_MISS_CHAR RltdModifierGrpType
354: , LL.pricingphaseid
355: , TO_NUMBER(LL.productprecedence)
356: , TO_DATE(LL.expirationperiodstartdate,'YYYY-MM-DD HH24:MI:SS')

Line 353: , FND_API.G_MISS_CHAR RltdModifierGrpType

349: , FND_API.G_MISS_NUM RltdModifierId
350: , FND_API.G_MISS_NUM FromRltdModifierId
351: , FND_API.G_MISS_NUM ToRltdModifierId
352: , FND_API.G_MISS_NUM RltdModifierGrpNo
353: , FND_API.G_MISS_CHAR RltdModifierGrpType
354: , LL.pricingphaseid
355: , TO_NUMBER(LL.productprecedence)
356: , TO_DATE(LL.expirationperiodstartdate,'YYYY-MM-DD HH24:MI:SS')
357: , TO_NUMBER(LL.numberexpirationperiods)

Line 361: , FND_API.G_MISS_NUM benefitpricelistlineid

357: , TO_NUMBER(LL.numberexpirationperiods)
358: , LL.expirationperioduom
359: , TO_DATE(LL.expirationdate,'YYYY-MM-DD HH24:MI:SS')
360: , TO_NUMBER(LL.estimglvalue)
361: , FND_API.G_MISS_NUM benefitpricelistlineid
362: , TO_NUMBER(LL.benefitlimit)
363: , LL.chargetypecode
364: , LL.chargesubtypecode
365: , TO_NUMBER(LL.benefitqty)

Line 373: , FND_API.G_MISS_NUM modifierparentindex

369: , LL.includeonreturnsflag
370: , null returnstatus
371: , null dbflag
372: , 'CREATE' operation
373: , FND_API.G_MISS_NUM modifierparentindex
374: , LL.qualificationind
375: , LL.netamountflag
376: , LL.accumattribute
377: , LL.continuouspricebreakflag

Line 423: , FND_API.G_MISS_NUM listlineid

419: , Q.excluderflag
420: , Q.lastupdatedby
421: , null lastupdatedate
422: , Q.lastupdatelogin
423: , FND_API.G_MISS_NUM listlineid
424: , Q.pricingattribute
425: , Q.pricingattributecontext
426: , FND_API.G_MISS_NUM pricingattributeid
427: , Q.pricingattrvaluefrom

Line 426: , FND_API.G_MISS_NUM pricingattributeid

422: , Q.lastupdatelogin
423: , FND_API.G_MISS_NUM listlineid
424: , Q.pricingattribute
425: , Q.pricingattributecontext
426: , FND_API.G_MISS_NUM pricingattributeid
427: , Q.pricingattrvaluefrom
428: , Q.pricingattrvalueto
429: , Q.productattribute
430: , Q.productattributecontext

Line 439: , FND_API.G_MISS_NUM listheaderid

435: , null programupdatedate
436: , Q.productattributedatatype
437: , Q.pricingattributedatatype
438: , Q.comparisonoperatorcode
439: , FND_API.G_MISS_NUM listheaderid
440: --, Q.pricingphaseid
441: , PP.PRICING_PHASE_ID
442: , null requestid
443: , TO_NUMBER(Q.pricingattrvaluefromnumber)

Line 485: , FND_API.G_MISS_NUM listheaderid

481: , Q.excluderflag
482: , Q.lastupdatedby
483: , null lastupdatedate
484: , Q.lastupdatelogin
485: , FND_API.G_MISS_NUM listheaderid
486: , Q.listlineid
487: , Q.programapplicationid
488: , Q.programid
489: , null programupdatedate

Line 496: , FND_API.G_MISS_NUM qualifierid

492: , Q.qualifierattrvalueto
493: , Q.qualifiercontext
494: , Q.qualifierdatatype
495: , TO_NUMBER(Q.qualifiergroupingno)
496: , FND_API.G_MISS_NUM qualifierid
497: , TO_NUMBER(Q.qualifierprecedence)
498: --, qualifierruleid
499: , QR2.QUALIFIER_RULE_ID
500: , NULL requestid

Line 514: , FND_API.G_MISS_CHAR qualify_hier_descendents_flag

510: , TO_NUMBER(Q.distinctrowcount)
511: , null return_status
512: , NULL db_flag
513: , 'CREATE' operation
514: , FND_API.G_MISS_CHAR qualify_hier_descendents_flag
515: FROM
516: QP_QUALIFIERS_TEMP Q,
517: QP_QUALIFIER_RULES QR1,
518: QP_QUALIFIER_RULES QR2

Line 626: l_MODIFIERS_tbl(j).list_line_id := FND_API.G_MISS_NUM;

622: l := l + 1;
623: END LOOP;
624: CLOSE qp_pricing_attributes_CUR;
625:
626: l_MODIFIERS_tbl(j).list_line_id := FND_API.G_MISS_NUM;
627:
628: j := j + 1;
629: END LOOP;
630: CLOSE qp_modifier_list_line_CUR;

Line 650: l_MODIFIER_LIST_rec.list_header_id := FND_API.G_MISS_NUM;

646: CLOSE qp_qualifiers_CUR;
647:
648:
649:
650: l_MODIFIER_LIST_rec.list_header_id := FND_API.G_MISS_NUM;
651:
652: i := i + 1;
653:
654: BEGIN

Line 663: , p_init_msg_list=> FND_API.G_FALSE

659: l_x_PRICING_ATTR_tbl := l_PRICING_ATTR_tbl;
660:
661: QP_Modifiers_PUB.Process_Modifiers(
662: p_api_version_number=> 1.0
663: , p_init_msg_list=> FND_API.G_FALSE
664: , p_return_values=> FND_API.G_FALSE
665: , p_commit=> FND_API.G_FALSE
666: , x_return_status=> x_return_status
667: , x_msg_count=>x_msg_count

Line 664: , p_return_values=> FND_API.G_FALSE

660:
661: QP_Modifiers_PUB.Process_Modifiers(
662: p_api_version_number=> 1.0
663: , p_init_msg_list=> FND_API.G_FALSE
664: , p_return_values=> FND_API.G_FALSE
665: , p_commit=> FND_API.G_FALSE
666: , x_return_status=> x_return_status
667: , x_msg_count=>x_msg_count
668: , x_msg_data=>x_msg_data

Line 665: , p_commit=> FND_API.G_FALSE

661: QP_Modifiers_PUB.Process_Modifiers(
662: p_api_version_number=> 1.0
663: , p_init_msg_list=> FND_API.G_FALSE
664: , p_return_values=> FND_API.G_FALSE
665: , p_commit=> FND_API.G_FALSE
666: , x_return_status=> x_return_status
667: , x_msg_count=>x_msg_count
668: , x_msg_data=>x_msg_data
669: ,p_MODIFIER_LIST_rec=> l_MODIFIER_LIST_rec

Line 690: WHEN FND_API.G_EXC_ERROR THEN

686: X_G_MSG_DATA := X_G_MSG_DATA || FND_GLOBAL.NewLine || FND_GLOBAL.NewLine || x_msg_data || ' :: ListHeaderId in the Input XML file is : ' || to_char(mListHeaderId);
687: END LOOP;
688:
689: EXCEPTION
690: WHEN FND_API.G_EXC_ERROR THEN
691:
692: X_return_status := FND_API.G_RET_STS_ERROR;
693: --Get message count and data
694: --dbms_output.put_line('err msg 1 is : ' || x_msg_data);

Line 692: X_return_status := FND_API.G_RET_STS_ERROR;

688:
689: EXCEPTION
690: WHEN FND_API.G_EXC_ERROR THEN
691:
692: X_return_status := FND_API.G_RET_STS_ERROR;
693: --Get message count and data
694: --dbms_output.put_line('err msg 1 is : ' || x_msg_data);
695: X_G_MSG_DATA := X_G_MSG_DATA || FND_GLOBAL.NewLine || FND_GLOBAL.NewLine || x_msg_data || ' :: ListHeaderId in the Input XML file is : ' || mListHeaderId;
696:

Line 697: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

693: --Get message count and data
694: --dbms_output.put_line('err msg 1 is : ' || x_msg_data);
695: X_G_MSG_DATA := X_G_MSG_DATA || FND_GLOBAL.NewLine || FND_GLOBAL.NewLine || x_msg_data || ' :: ListHeaderId in the Input XML file is : ' || mListHeaderId;
696:
697: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
698:
699: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
700: --dbms_output.put_line(' msg count 2 is : ' || x_msg_count);
701: for k in 1 .. x_msg_count loop

Line 699: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

695: X_G_MSG_DATA := X_G_MSG_DATA || FND_GLOBAL.NewLine || FND_GLOBAL.NewLine || x_msg_data || ' :: ListHeaderId in the Input XML file is : ' || mListHeaderId;
696:
697: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
698:
699: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
700: --dbms_output.put_line(' msg count 2 is : ' || x_msg_count);
701: for k in 1 .. x_msg_count loop
702: x_msg_data := oe_msg_pub.get( p_msg_index => k,
703: p_encoded => 'F'

Line 713: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

709:
710:
711: WHEN OTHERS THEN
712:
713: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
714: --dbms_output.put_line(' msg count 2 is : ' || x_msg_count);
715: for k in 1 .. x_msg_count loop
716: x_msg_data := oe_msg_pub.get( p_msg_index => k,
717: p_encoded => 'F'