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 6577: x_adj_id_tbl OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE)

6573:
6574: /*Query both automatic and manual(applied) header and line adjs*/
6575: PROCEDURE Query_Price_Adj_All
6576: (p_quote_header_id IN NUMBER,
6577: x_adj_id_tbl OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE)
6578: IS
6579: l_adj_counter NUMBER;
6580: l_rel_counter NUMBER;
6581: l_adj_id_tbl JTF_NUMBER_TABLE;

Line 6581: l_adj_id_tbl JTF_NUMBER_TABLE;

6577: x_adj_id_tbl OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE)
6578: IS
6579: l_adj_counter NUMBER;
6580: l_rel_counter NUMBER;
6581: l_adj_id_tbl JTF_NUMBER_TABLE;
6582:
6583: BEGIN
6584: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
6585: aso_debug_pub.add('ASO_PRICING_CORE_PVT: Inside of the Query_Price_Adj_All',1,'Y');

Line 6886: p_qte_line_id_tbl IN JTF_NUMBER_TABLE,

6882: /*Query line adjs only*/
6883: /*only for the free lines before the second implicit call*/
6884: PROCEDURE Query_Price_Adj_Line
6885: (p_quote_header_id IN NUMBER,
6886: p_qte_line_id_tbl IN JTF_NUMBER_TABLE,
6887: x_adj_id_tbl OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE)
6888: IS
6889: l_adj_counter NUMBER;
6890: l_rel_counter NUMBER;

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

6883: /*only for the free lines before the second implicit call*/
6884: PROCEDURE Query_Price_Adj_Line
6885: (p_quote_header_id IN NUMBER,
6886: p_qte_line_id_tbl IN JTF_NUMBER_TABLE,
6887: x_adj_id_tbl OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE)
6888: IS
6889: l_adj_counter NUMBER;
6890: l_rel_counter NUMBER;
6891: l_adj_id_tbl JTF_NUMBER_TABLE;

Line 6891: l_adj_id_tbl JTF_NUMBER_TABLE;

6887: x_adj_id_tbl OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE)
6888: IS
6889: l_adj_counter NUMBER;
6890: l_rel_counter NUMBER;
6891: l_adj_id_tbl JTF_NUMBER_TABLE;
6892:
6893: BEGIN
6894: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
6895: aso_debug_pub.add('ASO_PRICING_CORE_PVT: Start of the Query_Price_Adj_line',1,'Y');

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

7034: G_LDET_CALC_CODE_TBL,
7035: G_LDET_CHG_REASON_CODE_TBL,
7036: G_LDET_CHG_REASON_TEXT_TBL
7037: FROM ASO_PRICE_ADJUSTMENTS adj,
7038: TABLE (CAST(P_Qte_Line_id_tbl AS JTF_NUMBER_TABLE)) Lines
7039: WHERE adj.QUOTE_HEADER_ID = p_quote_header_id
7040: AND adj.QUOTE_LINE_ID = Lines.column_value
7041: AND adj.QUOTE_LINE_ID IS NOT NULL
7042: AND adj.modifier_line_type_code = 'DIS';

Line 7064: p_qte_line_id_tbl IN JTF_NUMBER_TABLE,

7060:
7061: /*Query both header and line adjs*/
7062: PROCEDURE Query_Price_Adjustments
7063: (p_quote_header_id IN NUMBER,
7064: p_qte_line_id_tbl IN JTF_NUMBER_TABLE,
7065: x_adj_id_tbl OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE)
7066: IS
7067: l_adj_counter NUMBER;
7068: l_rel_counter NUMBER;

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

7061: /*Query both header and line adjs*/
7062: PROCEDURE Query_Price_Adjustments
7063: (p_quote_header_id IN NUMBER,
7064: p_qte_line_id_tbl IN JTF_NUMBER_TABLE,
7065: x_adj_id_tbl OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE)
7066: IS
7067: l_adj_counter NUMBER;
7068: l_rel_counter NUMBER;
7069: l_adj_id_tbl JTF_NUMBER_TABLE;

Line 7069: l_adj_id_tbl JTF_NUMBER_TABLE;

7065: x_adj_id_tbl OUT NOCOPY /* file.sql.39 change */ JTF_NUMBER_TABLE)
7066: IS
7067: l_adj_counter NUMBER;
7068: l_rel_counter NUMBER;
7069: l_adj_id_tbl JTF_NUMBER_TABLE;
7070:
7071: BEGIN
7072: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
7073: aso_debug_pub.add('ASO_PRICING_CORE_PVT: Start of the Query_Price_Adjustments',1,'Y');

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

7283: MODIFIER_MECHANISM_TYPE_CODE,
7284: CHANGE_REASON_CODE,
7285: CHANGE_REASON_TEXT
7286: FROM ASO_PRICE_ADJUSTMENTS adj,
7287: TABLE (CAST(P_Qte_Line_id_tbl AS JTF_NUMBER_TABLE)) Lines
7288: WHERE adj.QUOTE_HEADER_ID = p_quote_header_id
7289: AND adj.QUOTE_LINE_ID = Lines.column_value
7290: AND adj.QUOTE_LINE_ID IS NOT NULL
7291: AND (( NVL(adj.updated_flag,'N') = 'Y'

Line 7312: PROCEDURE Query_Relationships(p_qte_adj_id_tbl IN JTF_NUMBER_TABLE,

7308: END IF;
7309:
7310: END Query_price_Adjustments;
7311:
7312: PROCEDURE Query_Relationships(p_qte_adj_id_tbl IN JTF_NUMBER_TABLE,
7313: p_service_qte_line_id_tbl IN JTF_NUMBER_TABLE)
7314: IS
7315: BEGIN
7316:

Line 7313: p_service_qte_line_id_tbl IN JTF_NUMBER_TABLE)

7309:
7310: END Query_price_Adjustments;
7311:
7312: PROCEDURE Query_Relationships(p_qte_adj_id_tbl IN JTF_NUMBER_TABLE,
7313: p_service_qte_line_id_tbl IN JTF_NUMBER_TABLE)
7314: IS
7315: BEGIN
7316:
7317:

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

7337: G_RLTD_RLTD_LST_LN_ID_DEF_TBL
7338: FROM ASO_PRICE_ADJ_RELATIONSHIPS adj_rel,
7339: ASO_PRICE_ADJUSTMENTS dbadj,
7340: ASO_PRICE_ADJUSTMENTS dbadjrel,
7341: TABLE (CAST(p_qte_adj_id_tbl AS JTF_NUMBER_TABLE)) adj
7342: WHERE dbadj.quote_header_id = ASO_PRICING_INT.G_HEADER_REC.quote_header_id
7343: AND dbadjrel.quote_header_id = ASO_PRICING_INT.G_HEADER_REC.quote_header_id
7344: AND adj_rel.price_adjustment_id = adj.column_value
7345: AND dbadj.price_adjustment_id = adj_rel.price_adjustment_id

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

7354: ldets.quote_line_id related_quote_line_id,
7355: to_number(NULL),
7356: to_number(NULL)
7357: FROM ASO_QUOTE_LINE_DETAILS ldets,
7358: TABLE (CAST(P_service_Qte_Line_id_tbl AS JTF_NUMBER_TABLE)) serviceLines,
7359: ASO_QUOTE_LINES_ALL lines
7360: WHERE ldets.quote_line_id = serviceLines.column_value
7361: AND lines.quote_header_id = ASO_PRICING_INT.G_HEADER_REC.quote_header_id
7362: AND lines.quote_line_id = ldets.quote_line_id

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

7383: G_RLTD_RELATED_LINE_IND_TBL,
7384: G_RLTD_LST_LN_ID_DEF_TBL,
7385: G_RLTD_RLTD_LST_LN_ID_DEF_TBL
7386: FROM ASO_QUOTE_LINE_DETAILS ldets,
7387: TABLE (CAST(P_service_Qte_Line_id_tbl AS JTF_NUMBER_TABLE)) serviceLines,
7388: ASO_QUOTE_LINES_ALL lines
7389: WHERE ldets.quote_line_id = serviceLines.column_value
7390: AND lines.quote_header_id = ASO_PRICING_INT.G_HEADER_REC.quote_header_id
7391: AND lines.quote_line_id = ldets.quote_line_id

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

7413: G_RLTD_RLTD_LST_LN_ID_DEF_TBL
7414: FROM ASO_PRICE_ADJ_RELATIONSHIPS adj_rel,
7415: ASO_PRICE_ADJUSTMENTS dbadj,
7416: ASO_PRICE_ADJUSTMENTS dbadjrel,
7417: TABLE (CAST(p_qte_adj_id_tbl AS JTF_NUMBER_TABLE)) adj
7418: WHERE dbadj.quote_header_id = ASO_PRICING_INT.G_HEADER_REC.quote_header_id
7419: AND dbadjrel.quote_header_id = ASO_PRICING_INT.G_HEADER_REC.quote_header_id
7420: AND adj_rel.price_adjustment_id = adj.column_value
7421: AND dbadj.price_adjustment_id = adj_rel.price_adjustment_id

Line 10665: l_qte_line_id_tbl JTF_NUMBER_TABLE;

10661: l_return_status_text VARCHAR2(2000);
10662: l_message_text VARCHAR2(2000);
10663: x_pass_line VARCHAR2(10);
10664: l_adj_search_tbl Index_Link_Tbl_Type;
10665: l_qte_line_id_tbl JTF_NUMBER_TABLE;
10666: l_qte_adj_id_tbl JTF_NUMBER_TABLE;
10667: l_price_index Number;
10668: px_line_index_search_tbl ASO_PRICING_CORE_PVT.Index_Link_Tbl_Type;
10669: l_global_pls_tbl QP_PREQ_GRP.pls_integer_type;

Line 10666: l_qte_adj_id_tbl JTF_NUMBER_TABLE;

10662: l_message_text VARCHAR2(2000);
10663: x_pass_line VARCHAR2(10);
10664: l_adj_search_tbl Index_Link_Tbl_Type;
10665: l_qte_line_id_tbl JTF_NUMBER_TABLE;
10666: l_qte_adj_id_tbl JTF_NUMBER_TABLE;
10667: l_price_index Number;
10668: px_line_index_search_tbl ASO_PRICING_CORE_PVT.Index_Link_Tbl_Type;
10669: l_global_pls_tbl QP_PREQ_GRP.pls_integer_type;
10670: l_global_num_tbl QP_PREQ_GRP.NUMBER_TYPE;

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

11438: ELSE
11439: IF ASO_DEBUG_PUB.G_Debug_Flag = 'Y' THEN
11440: aso_debug_pub.add('ASO_PRICING_CORE_PVT: First quote_line_id in l_qte_line_id_tbl',1,'Y');
11441: END IF;
11442: l_Qte_Line_id_tbl := JTF_NUMBER_TABLE(lx_Qte_Line_Tbl(i).quote_line_id);
11443: END IF;
11444:
11445: --increment the line index
11446: px_line_index_search_tbl(l_qte_line_rec.quote_line_id) := l_price_index;