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 421: , FND_API.G_MISS_NUM listlineid

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

Line 424: , FND_API.G_MISS_NUM pricingattributeid

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

Line 437: , FND_API.G_MISS_NUM listheaderid

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

Line 483: , FND_API.G_MISS_NUM listheaderid

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

Line 494: , FND_API.G_MISS_NUM qualifierid

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

Line 512: , FND_API.G_MISS_CHAR qualify_hier_descendents_flag

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

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

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

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

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

Line 661: , p_init_msg_list=> FND_API.G_FALSE

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

Line 662: , p_return_values=> FND_API.G_FALSE

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

Line 663: , p_commit=> FND_API.G_FALSE

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

Line 688: WHEN FND_API.G_EXC_ERROR THEN

684: 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);
685: END LOOP;
686:
687: EXCEPTION
688: WHEN FND_API.G_EXC_ERROR THEN
689:
690: X_return_status := FND_API.G_RET_STS_ERROR;
691: --Get message count and data
692: --dbms_output.put_line('err msg 1 is : ' || x_msg_data);

Line 690: X_return_status := FND_API.G_RET_STS_ERROR;

686:
687: EXCEPTION
688: WHEN FND_API.G_EXC_ERROR THEN
689:
690: X_return_status := FND_API.G_RET_STS_ERROR;
691: --Get message count and data
692: --dbms_output.put_line('err msg 1 is : ' || x_msg_data);
693: 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;
694:

Line 695: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

691: --Get message count and data
692: --dbms_output.put_line('err msg 1 is : ' || x_msg_data);
693: 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;
694:
695: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
696:
697: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
698: --dbms_output.put_line(' msg count 2 is : ' || x_msg_count);
699: for k in 1 .. x_msg_count loop

Line 697: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

693: 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;
694:
695: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
696:
697: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
698: --dbms_output.put_line(' msg count 2 is : ' || x_msg_count);
699: for k in 1 .. x_msg_count loop
700: x_msg_data := oe_msg_pub.get( p_msg_index => k,
701: p_encoded => 'F'

Line 711: X_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

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