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.POA_DBI_NEG_PKG dependencies on BIS_PMV_PAGE_PARAMETER_TBL

Line 27: PROCEDURE status_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL

23: Savings Amount, Average Cycle time and their corresponding Changes. This SQL is called by the
24: Sourcing Summary Report
25: */
26:
27: PROCEDURE status_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL
28: ,x_custom_sql OUT NOCOPY VARCHAR2
29: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
30: IS
31: l_query varchar2(32000);

Line 319: PROCEDURE awd_status_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL

315: This procedure returns the SQL query to display the measures such as Award Amount, Projected Savings per Line,
316: and their corresponding change measures. This SQL is called by the Award Summary Report.
317: */
318:
319: PROCEDURE awd_status_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL
320: ,x_custom_sql OUT NOCOPY VARCHAR2
321: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
322: IS
323: l_query varchar2(32000);

Line 544: PROCEDURE avg_cycle_time_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL

540: phases such as Preparation Time, Bidding Time and Award and Analysis Time. It also displays the
541: Negotiation Line Count.
542: */
543:
544: PROCEDURE avg_cycle_time_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL
545: ,x_custom_sql OUT NOCOPY VARCHAR2
546: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
547: IS
548: l_query varchar2(32000);

Line 774: PROCEDURE realized_status_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL

770: This procedure returns the SQL query to display the measures such as Realized Savings, Negotiated
771: Amount, Non-Negotiated Amount and Percent Purchases Negotiated.
772: */
773:
774: PROCEDURE realized_status_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL
775: ,x_custom_sql OUT NOCOPY VARCHAR2
776: ,x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
777: IS
778: l_query varchar2(32000);

Line 1037: PROCEDURE awd_trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,

1033: /* Procedure Name : awd_trend_sql
1034: This procedure returns the SQL query to display the awarded amount as a trend.
1035: */
1036:
1037: PROCEDURE awd_trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
1038: x_custom_sql OUT NOCOPY VARCHAR2,
1039: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1040: IS
1041: l_query varchar2(32000);

Line 1128: PROCEDURE avg_cycle_trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,

1124: /* Procedure Name : avg_cycle_trend_sql
1125: This procedure returns the SQL query to display the average cycle time measures as a trend.
1126: */
1127:
1128: PROCEDURE avg_cycle_trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
1129: x_custom_sql OUT NOCOPY VARCHAR2,
1130: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1131: IS
1132: l_query varchar2(32000);

Line 1224: PROCEDURE prj_svng_trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,

1220: /* Procedure Name : prj_svng_trend_sql
1221: This procedure returns the SQL query to display the Projected Savings measures as a trend.
1222: */
1223:
1224: PROCEDURE prj_svng_trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
1225: x_custom_sql OUT NOCOPY VARCHAR2,
1226: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1227: IS
1228: l_query varchar2(32000);

Line 1316: PROCEDURE prj_svng_ln_trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,

1312: This procedure returns the SQL query to display the Projected Savings per Line measures as a trend.
1313: It also displays the Negotiation Lines count used to derive at the Savings per Line measure.
1314: */
1315:
1316: PROCEDURE prj_svng_ln_trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
1317: x_custom_sql OUT NOCOPY VARCHAR2,
1318: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1319: IS
1320: l_query varchar2(32000);

Line 1412: PROCEDURE real_svng_trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,

1408: /* Procedure Name : real_svng_trend_sql
1409: This procedure returns the SQL query to display the Realized Savings measure as a trend
1410: */
1411:
1412: PROCEDURE real_svng_trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
1413: x_custom_sql OUT NOCOPY VARCHAR2,
1414: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1415: IS
1416: l_query varchar2(32000);

Line 1503: PROCEDURE neg_po_trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,

1499: /* Procedure Name : neg_po_trend_sql
1500: This procedure returns the SQL query to display the Negotiated and Non-Negotiated Purchases Trend
1501: */
1502:
1503: PROCEDURE neg_po_trend_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
1504: x_custom_sql OUT NOCOPY VARCHAR2,
1505: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1506: IS
1507: l_query varchar2(32000);

Line 1604: PROCEDURE dtl_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,

1600: /* Procedure Name : dtl_sql
1601: This procedure returns the SQL query to display the Awarded and Completed Negotiation Lines detail.
1602: */
1603:
1604: PROCEDURE dtl_sql(p_param in BIS_PMV_PAGE_PARAMETER_TBL,
1605: x_custom_sql OUT NOCOPY VARCHAR2,
1606: x_custom_output OUT NOCOPY BIS_QUERY_ATTRIBUTES_TBL)
1607: IS
1608: l_query varchar2(32000);