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.OE_BLANKET_UTIL dependencies on OE_BLANKET_LINE_SECURITY

Line 4842: OE_Blanket_Line_Security.g_check_all_cols_constraint := 'Y'; /* Bug # 5516348 */

4838: , p_line_rec.line_id
4839: , p_line_rec.line_number
4840: );
4841:
4842: OE_Blanket_Line_Security.g_check_all_cols_constraint := 'Y'; /* Bug # 5516348 */
4843: if l_debug_level > 0 then
4844: oe_debug_pub.add('Exiting OE_blanket_UTIL.INSERT_ROW', 1);
4845: end if;
4846:

Line 4851: OE_Blanket_Line_Security.g_check_all_cols_constraint := 'Y'; /* Bug # 5516348 */

4847: EXCEPTION
4848:
4849: WHEN OTHERS THEN
4850:
4851: OE_Blanket_Line_Security.g_check_all_cols_constraint := 'Y'; /* Bug # 5516348 */
4852: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4853: THEN
4854: OE_MSG_PUB.Add_Exc_Msg
4855: ( G_PKG_NAME

Line 4993: OE_Blanket_Line_Security.g_check_all_cols_constraint := 'Y'; /* Bug # 5516348 */

4989: -- , returned_amount = p_line_rec.returned_amount
4990: , line_number = p_line_rec.line_number --bug5894169
4991: WHERE line_id = p_line_rec.line_id;
4992:
4993: OE_Blanket_Line_Security.g_check_all_cols_constraint := 'Y'; /* Bug # 5516348 */
4994: if l_debug_level > 0 then
4995: oe_debug_pub.add('Exiting OE_Blanket_UTIL.UPDATE_ROW - LINE', 1);
4996: end if;
4997:

Line 5002: OE_Blanket_Line_Security.g_check_all_cols_constraint := 'Y'; /* Bug # 5516348 */

4998: EXCEPTION
4999:
5000:
5001: WHEN OTHERS THEN
5002: OE_Blanket_Line_Security.g_check_all_cols_constraint := 'Y'; /* Bug # 5516348 */
5003: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5004: THEN
5005: OE_MSG_PUB.Add_Exc_Msg
5006: ( G_PKG_NAME

Line 8347: l_blanket_number := oe_blanket_line_security.g_record.order_number;

8343: oe_debug_pub.add('Enter OE_Blanket_Util.Returns_Exist');
8344: end if;
8345:
8346: If p_validation_entity_short_name = 'BLANKET_LINE' Then
8347: l_blanket_number := oe_blanket_line_security.g_record.order_number;
8348: l_blanket_line_number := oe_blanket_line_security.g_record.line_number;
8349:
8350: BEGIN
8351: Select 1 into p_result

Line 8348: l_blanket_line_number := oe_blanket_line_security.g_record.line_number;

8344: end if;
8345:
8346: If p_validation_entity_short_name = 'BLANKET_LINE' Then
8347: l_blanket_number := oe_blanket_line_security.g_record.order_number;
8348: l_blanket_line_number := oe_blanket_line_security.g_record.line_number;
8349:
8350: BEGIN
8351: Select 1 into p_result
8352: from oe_order_lines

Line 8399: l_blanket_number := oe_blanket_line_security.g_record.order_number;

8395: oe_debug_pub.add('Enter OE_Blanket_Util.Release_Lines_Exist');
8396: end if;
8397:
8398: If p_validation_entity_short_name = 'BLANKET_LINE' Then
8399: l_blanket_number := oe_blanket_line_security.g_record.order_number;
8400: l_blanket_line_number := oe_blanket_line_security.g_record.line_number;
8401:
8402: BEGIN
8403: Select 1 into p_result

Line 8400: l_blanket_line_number := oe_blanket_line_security.g_record.line_number;

8396: end if;
8397:
8398: If p_validation_entity_short_name = 'BLANKET_LINE' Then
8399: l_blanket_number := oe_blanket_line_security.g_record.order_number;
8400: l_blanket_line_number := oe_blanket_line_security.g_record.line_number;
8401:
8402: BEGIN
8403: Select 1 into p_result
8404: from oe_order_lines

Line 8449: l_blanket_number := oe_blanket_line_security.g_record.order_number;

8445: oe_debug_pub.add('Enter OE_Blanket_Util.Release_Lines_Exist');
8446: end if;
8447:
8448: If p_validation_entity_short_name = 'BLANKET_LINE' Then
8449: l_blanket_number := oe_blanket_line_security.g_record.order_number;
8450:
8451: BEGIN
8452: Select 1 into p_result
8453: from oe_order_headers_all

Line 8497: l_blanket_number := oe_blanket_line_security.g_record.order_number;

8493: oe_debug_pub.add('Enter OE_Blanket_Util.Open_Release_Lines_Exist');
8494: end if;
8495:
8496: If p_validation_entity_short_name = 'BLANKET_LINE' Then
8497: l_blanket_number := oe_blanket_line_security.g_record.order_number;
8498: l_blanket_line_number := oe_blanket_line_security.g_record.line_number;
8499:
8500: BEGIN
8501: Select 1 into p_result

Line 8498: l_blanket_line_number := oe_blanket_line_security.g_record.line_number;

8494: end if;
8495:
8496: If p_validation_entity_short_name = 'BLANKET_LINE' Then
8497: l_blanket_number := oe_blanket_line_security.g_record.order_number;
8498: l_blanket_line_number := oe_blanket_line_security.g_record.line_number;
8499:
8500: BEGIN
8501: Select 1 into p_result
8502: from oe_order_lines

Line 8549: l_blanket_number := oe_blanket_line_security.g_record.order_number;

8545: oe_debug_pub.add('Enter OE_Blanket_Util.Open_Release_Lines_Exist');
8546: end if;
8547:
8548: If p_validation_entity_short_name = 'BLANKET_LINE' Then
8549: l_blanket_number := oe_blanket_line_security.g_record.order_number;
8550:
8551: BEGIN
8552: Select 1 into p_result
8553: from oe_order_headers_all

Line 8597: If (trunc(sysdate) >= OE_Blanket_Line_Security.g_record.start_date_active

8593: oe_debug_pub.add('Enter OE_Blanket_Util.Is_Expired');
8594: end if;
8595:
8596: If p_validation_entity_short_name = 'BLANKET_LINE' Then
8597: If (trunc(sysdate) >= OE_Blanket_Line_Security.g_record.start_date_active
8598: AND trunc(sysdate) <= trunc(nvl(OE_Blanket_Line_Security.g_record.end_date_active, sysdate)))
8599: Then
8600: p_result := 0;
8601: Else

Line 8598: AND trunc(sysdate) <= trunc(nvl(OE_Blanket_Line_Security.g_record.end_date_active, sysdate)))

8594: end if;
8595:
8596: If p_validation_entity_short_name = 'BLANKET_LINE' Then
8597: If (trunc(sysdate) >= OE_Blanket_Line_Security.g_record.start_date_active
8598: AND trunc(sysdate) <= trunc(nvl(OE_Blanket_Line_Security.g_record.end_date_active, sysdate)))
8599: Then
8600: p_result := 0;
8601: Else
8602: p_result := 1;