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.ASO_PRICING_CORE_PVT dependencies on JTF_NUMBER_TABLE

Line 6592: x_adj_id_tbl OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE)

6588:
6589: /*Query both automatic and manual(applied) header and line adjs*/
6590: PROCEDURE Query_Price_Adj_All
6591: (p_quote_header_id IN NUMBER,
6592: x_adj_id_tbl OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE)
6593: IS
6594: l_adj_counter NUMBER;
6595: l_rel_counter NUMBER;
6596: l_adj_id_tbl JTF_NUMBER_TABLE;

Line 6596: l_adj_id_tbl JTF_NUMBER_TABLE;

6592: x_adj_id_tbl OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE)
6593: IS
6594: l_adj_counter NUMBER;
6595: l_rel_counter NUMBER;
6596: l_adj_id_tbl JTF_NUMBER_TABLE;
6597:
6598: BEGIN
6599: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
6600: aso_debug_pub.add('ASO_PRICING_CORE_PVT: Inside of the Query_Price_Adj_All',1,'Y');

Line 6901: p_qte_line_id_tbl IN JTF_NUMBER_TABLE,

6897: /*Query line adjs only*/
6898: /*only for the free lines before the second implicit call*/
6899: PROCEDURE Query_Price_Adj_Line
6900: (p_quote_header_id IN NUMBER,
6901: p_qte_line_id_tbl IN JTF_NUMBER_TABLE,
6902: x_adj_id_tbl OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE)
6903: IS
6904: l_adj_counter NUMBER;
6905: l_rel_counter NUMBER;

Line 6902: x_adj_id_tbl OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE)

6898: /*only for the free lines before the second implicit call*/
6899: PROCEDURE Query_Price_Adj_Line
6900: (p_quote_header_id IN NUMBER,
6901: p_qte_line_id_tbl IN JTF_NUMBER_TABLE,
6902: x_adj_id_tbl OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE)
6903: IS
6904: l_adj_counter NUMBER;
6905: l_rel_counter NUMBER;
6906: l_adj_id_tbl JTF_NUMBER_TABLE;

Line 6906: l_adj_id_tbl JTF_NUMBER_TABLE;

6902: x_adj_id_tbl OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE)
6903: IS
6904: l_adj_counter NUMBER;
6905: l_rel_counter NUMBER;
6906: l_adj_id_tbl JTF_NUMBER_TABLE;
6907:
6908: BEGIN
6909: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
6910: aso_debug_pub.add('ASO_PRICING_CORE_PVT: Start of the Query_Price_Adj_line',1,'Y');

Line 7053: TABLE (CAST(P_Qte_Line_id_tbl AS JTF_NUMBER_TABLE)) Lines

7049: G_LDET_CALC_CODE_TBL,
7050: G_LDET_CHG_REASON_CODE_TBL,
7051: G_LDET_CHG_REASON_TEXT_TBL
7052: FROM ASO_PRICE_ADJUSTMENTS adj,
7053: TABLE (CAST(P_Qte_Line_id_tbl AS JTF_NUMBER_TABLE)) Lines
7054: WHERE adj.QUOTE_HEADER_ID = p_quote_header_id
7055: AND adj.QUOTE_LINE_ID = Lines.column_value
7056: AND adj.QUOTE_LINE_ID IS NOT NULL
7057: AND adj.modifier_line_type_code = 'DIS';

Line 7079: p_qte_line_id_tbl IN JTF_NUMBER_TABLE,

7075:
7076: /*Query both header and line adjs*/
7077: PROCEDURE Query_Price_Adjustments
7078: (p_quote_header_id IN NUMBER,
7079: p_qte_line_id_tbl IN JTF_NUMBER_TABLE,
7080: x_adj_id_tbl OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE)
7081: IS
7082: l_adj_counter NUMBER;
7083: l_rel_counter NUMBER;

Line 7080: x_adj_id_tbl OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE)

7076: /*Query both header and line adjs*/
7077: PROCEDURE Query_Price_Adjustments
7078: (p_quote_header_id IN NUMBER,
7079: p_qte_line_id_tbl IN JTF_NUMBER_TABLE,
7080: x_adj_id_tbl OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE)
7081: IS
7082: l_adj_counter NUMBER;
7083: l_rel_counter NUMBER;
7084: l_adj_id_tbl JTF_NUMBER_TABLE;

Line 7084: l_adj_id_tbl JTF_NUMBER_TABLE;

7080: x_adj_id_tbl OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE)
7081: IS
7082: l_adj_counter NUMBER;
7083: l_rel_counter NUMBER;
7084: l_adj_id_tbl JTF_NUMBER_TABLE;
7085:
7086: BEGIN
7087: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
7088: aso_debug_pub.add('ASO_PRICING_CORE_PVT: Start of the Query_Price_Adjustments',1,'Y');

Line 7303: TABLE (CAST(P_Qte_Line_id_tbl AS JTF_NUMBER_TABLE)) Lines

7299: MODIFIER_MECHANISM_TYPE_CODE,
7300: CHANGE_REASON_CODE,
7301: CHANGE_REASON_TEXT
7302: FROM ASO_PRICE_ADJUSTMENTS adj,
7303: TABLE (CAST(P_Qte_Line_id_tbl AS JTF_NUMBER_TABLE)) Lines
7304: WHERE adj.QUOTE_HEADER_ID = p_quote_header_id
7305: AND adj.QUOTE_LINE_ID = Lines.column_value
7306: AND adj.QUOTE_LINE_ID IS NOT NULL
7307: AND (( NVL(adj.updated_flag,'N') = 'Y'

Line 7328: PROCEDURE Query_Relationships(p_qte_adj_id_tbl IN JTF_NUMBER_TABLE,

7324: END IF;
7325:
7326: END Query_price_Adjustments;
7327:
7328: PROCEDURE Query_Relationships(p_qte_adj_id_tbl IN JTF_NUMBER_TABLE,
7329: p_service_qte_line_id_tbl IN JTF_NUMBER_TABLE)
7330: IS
7331: BEGIN
7332:

Line 7329: p_service_qte_line_id_tbl IN JTF_NUMBER_TABLE)

7325:
7326: END Query_price_Adjustments;
7327:
7328: PROCEDURE Query_Relationships(p_qte_adj_id_tbl IN JTF_NUMBER_TABLE,
7329: p_service_qte_line_id_tbl IN JTF_NUMBER_TABLE)
7330: IS
7331: BEGIN
7332:
7333:

Line 7357: TABLE (CAST(p_qte_adj_id_tbl AS JTF_NUMBER_TABLE)) adj

7353: G_RLTD_RLTD_LST_LN_ID_DEF_TBL
7354: FROM ASO_PRICE_ADJ_RELATIONSHIPS adj_rel,
7355: ASO_PRICE_ADJUSTMENTS dbadj,
7356: ASO_PRICE_ADJUSTMENTS dbadjrel,
7357: TABLE (CAST(p_qte_adj_id_tbl AS JTF_NUMBER_TABLE)) adj
7358: WHERE dbadj.quote_header_id = ASO_PRICING_INT.G_HEADER_REC.quote_header_id
7359: AND dbadjrel.quote_header_id = ASO_PRICING_INT.G_HEADER_REC.quote_header_id
7360: AND adj_rel.price_adjustment_id = adj.column_value
7361: AND dbadj.price_adjustment_id = adj_rel.price_adjustment_id

Line 7374: TABLE (CAST(P_service_Qte_Line_id_tbl AS JTF_NUMBER_TABLE)) serviceLines,

7370: ldets.quote_line_id related_quote_line_id,
7371: to_number(NULL),
7372: to_number(NULL)
7373: FROM ASO_QUOTE_LINE_DETAILS ldets,
7374: TABLE (CAST(P_service_Qte_Line_id_tbl AS JTF_NUMBER_TABLE)) serviceLines,
7375: ASO_QUOTE_LINES_ALL lines
7376: WHERE ldets.quote_line_id = serviceLines.column_value
7377: AND lines.quote_header_id = ASO_PRICING_INT.G_HEADER_REC.quote_header_id
7378: AND lines.quote_line_id = ldets.quote_line_id

Line 7403: TABLE (CAST(P_service_Qte_Line_id_tbl AS JTF_NUMBER_TABLE)) serviceLines,

7399: G_RLTD_RELATED_LINE_IND_TBL,
7400: G_RLTD_LST_LN_ID_DEF_TBL,
7401: G_RLTD_RLTD_LST_LN_ID_DEF_TBL
7402: FROM ASO_QUOTE_LINE_DETAILS ldets,
7403: TABLE (CAST(P_service_Qte_Line_id_tbl AS JTF_NUMBER_TABLE)) serviceLines,
7404: ASO_QUOTE_LINES_ALL lines
7405: WHERE ldets.quote_line_id = serviceLines.column_value
7406: AND lines.quote_header_id = ASO_PRICING_INT.G_HEADER_REC.quote_header_id
7407: AND lines.quote_line_id = ldets.quote_line_id

Line 7433: TABLE (CAST(p_qte_adj_id_tbl AS JTF_NUMBER_TABLE)) adj

7429: G_RLTD_RLTD_LST_LN_ID_DEF_TBL
7430: FROM ASO_PRICE_ADJ_RELATIONSHIPS adj_rel,
7431: ASO_PRICE_ADJUSTMENTS dbadj,
7432: ASO_PRICE_ADJUSTMENTS dbadjrel,
7433: TABLE (CAST(p_qte_adj_id_tbl AS JTF_NUMBER_TABLE)) adj
7434: WHERE dbadj.quote_header_id = ASO_PRICING_INT.G_HEADER_REC.quote_header_id
7435: AND dbadjrel.quote_header_id = ASO_PRICING_INT.G_HEADER_REC.quote_header_id
7436: AND adj_rel.price_adjustment_id = adj.column_value
7437: AND dbadj.price_adjustment_id = adj_rel.price_adjustment_id

Line 10682: l_qte_line_id_tbl JTF_NUMBER_TABLE;

10678: l_return_status_text VARCHAR2(2000);
10679: l_message_text VARCHAR2(2000);
10680: x_pass_line VARCHAR2(10);
10681: l_adj_search_tbl Index_Link_Tbl_Type;
10682: l_qte_line_id_tbl JTF_NUMBER_TABLE;
10683: l_qte_adj_id_tbl JTF_NUMBER_TABLE;
10684: l_price_index Number;
10685: px_line_index_search_tbl ASO_PRICING_CORE_PVT.Index_Link_Tbl_Type;
10686: l_global_pls_tbl QP_PREQ_GRP.pls_integer_type;

Line 10683: l_qte_adj_id_tbl JTF_NUMBER_TABLE;

10679: l_message_text VARCHAR2(2000);
10680: x_pass_line VARCHAR2(10);
10681: l_adj_search_tbl Index_Link_Tbl_Type;
10682: l_qte_line_id_tbl JTF_NUMBER_TABLE;
10683: l_qte_adj_id_tbl JTF_NUMBER_TABLE;
10684: l_price_index Number;
10685: px_line_index_search_tbl ASO_PRICING_CORE_PVT.Index_Link_Tbl_Type;
10686: l_global_pls_tbl QP_PREQ_GRP.pls_integer_type;
10687: l_global_num_tbl QP_PREQ_GRP.NUMBER_TYPE;

Line 11459: l_Qte_Line_id_tbl := JTF_NUMBER_TABLE(lx_Qte_Line_Tbl(i).quote_line_id);

11455: ELSE
11456: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
11457: aso_debug_pub.add('ASO_PRICING_CORE_PVT: First quote_line_id in l_qte_line_id_tbl',1,'Y');
11458: END IF;
11459: l_Qte_Line_id_tbl := JTF_NUMBER_TABLE(lx_Qte_Line_Tbl(i).quote_line_id);
11460: END IF;
11461:
11462: --increment the line index
11463: px_line_index_search_tbl(l_qte_line_rec.quote_line_id) := l_price_index;