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 5036: OE_Blanket_Line_Security.g_check_all_cols_constraint := 'Y'; /* Bug # 5516348 */

5032: , p_line_rec.line_id
5033: , p_line_rec.line_number
5034: );
5035:
5036: OE_Blanket_Line_Security.g_check_all_cols_constraint := 'Y'; /* Bug # 5516348 */
5037: if l_debug_level > 0 then
5038: oe_debug_pub.add('Exiting OE_blanket_UTIL.INSERT_ROW', 1);
5039: end if;
5040:

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

5041: EXCEPTION
5042:
5043: WHEN OTHERS THEN
5044:
5045: OE_Blanket_Line_Security.g_check_all_cols_constraint := 'Y'; /* Bug # 5516348 */
5046: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5047: THEN
5048: OE_MSG_PUB.Add_Exc_Msg
5049: ( G_PKG_NAME

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

5183: -- , returned_amount = p_line_rec.returned_amount
5184: , line_number = p_line_rec.line_number --bug5894169
5185: WHERE line_id = p_line_rec.line_id;
5186:
5187: OE_Blanket_Line_Security.g_check_all_cols_constraint := 'Y'; /* Bug # 5516348 */
5188: if l_debug_level > 0 then
5189: oe_debug_pub.add('Exiting OE_Blanket_UTIL.UPDATE_ROW - LINE', 1);
5190: end if;
5191:

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

5192: EXCEPTION
5193:
5194:
5195: WHEN OTHERS THEN
5196: OE_Blanket_Line_Security.g_check_all_cols_constraint := 'Y'; /* Bug # 5516348 */
5197: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
5198: THEN
5199: OE_MSG_PUB.Add_Exc_Msg
5200: ( G_PKG_NAME

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

8540: oe_debug_pub.add('Enter OE_Blanket_Util.Returns_Exist');
8541: end if;
8542:
8543: If p_validation_entity_short_name = 'BLANKET_LINE' Then
8544: l_blanket_number := oe_blanket_line_security.g_record.order_number;
8545: l_blanket_line_number := oe_blanket_line_security.g_record.line_number;
8546:
8547: BEGIN
8548: Select 1 into p_result

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

8541: end if;
8542:
8543: If p_validation_entity_short_name = 'BLANKET_LINE' Then
8544: l_blanket_number := oe_blanket_line_security.g_record.order_number;
8545: l_blanket_line_number := oe_blanket_line_security.g_record.line_number;
8546:
8547: BEGIN
8548: Select 1 into p_result
8549: from oe_order_lines

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

8592: oe_debug_pub.add('Enter OE_Blanket_Util.Release_Lines_Exist');
8593: end if;
8594:
8595: If p_validation_entity_short_name = 'BLANKET_LINE' Then
8596: l_blanket_number := oe_blanket_line_security.g_record.order_number;
8597: l_blanket_line_number := oe_blanket_line_security.g_record.line_number;
8598:
8599: BEGIN
8600: Select 1 into p_result

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

8593: end if;
8594:
8595: If p_validation_entity_short_name = 'BLANKET_LINE' Then
8596: l_blanket_number := oe_blanket_line_security.g_record.order_number;
8597: l_blanket_line_number := oe_blanket_line_security.g_record.line_number;
8598:
8599: BEGIN
8600: Select 1 into p_result
8601: from oe_order_lines

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

8642: oe_debug_pub.add('Enter OE_Blanket_Util.Release_Lines_Exist');
8643: end if;
8644:
8645: If p_validation_entity_short_name = 'BLANKET_LINE' Then
8646: l_blanket_number := oe_blanket_line_security.g_record.order_number;
8647:
8648: BEGIN
8649: Select 1 into p_result
8650: from oe_order_headers_all

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

8690: oe_debug_pub.add('Enter OE_Blanket_Util.Open_Release_Lines_Exist');
8691: end if;
8692:
8693: If p_validation_entity_short_name = 'BLANKET_LINE' Then
8694: l_blanket_number := oe_blanket_line_security.g_record.order_number;
8695: l_blanket_line_number := oe_blanket_line_security.g_record.line_number;
8696:
8697: BEGIN
8698: Select 1 into p_result

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

8691: end if;
8692:
8693: If p_validation_entity_short_name = 'BLANKET_LINE' Then
8694: l_blanket_number := oe_blanket_line_security.g_record.order_number;
8695: l_blanket_line_number := oe_blanket_line_security.g_record.line_number;
8696:
8697: BEGIN
8698: Select 1 into p_result
8699: from oe_order_lines

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

8742: oe_debug_pub.add('Enter OE_Blanket_Util.Open_Release_Lines_Exist');
8743: end if;
8744:
8745: If p_validation_entity_short_name = 'BLANKET_LINE' Then
8746: l_blanket_number := oe_blanket_line_security.g_record.order_number;
8747:
8748: BEGIN
8749: Select 1 into p_result
8750: from oe_order_headers_all

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

8790: oe_debug_pub.add('Enter OE_Blanket_Util.Is_Expired');
8791: end if;
8792:
8793: If p_validation_entity_short_name = 'BLANKET_LINE' Then
8794: If (trunc(sysdate) >= OE_Blanket_Line_Security.g_record.start_date_active
8795: AND trunc(sysdate) <= trunc(nvl(OE_Blanket_Line_Security.g_record.end_date_active, sysdate)))
8796: Then
8797: p_result := 0;
8798: Else

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

8791: end if;
8792:
8793: If p_validation_entity_short_name = 'BLANKET_LINE' Then
8794: If (trunc(sysdate) >= OE_Blanket_Line_Security.g_record.start_date_active
8795: AND trunc(sysdate) <= trunc(nvl(OE_Blanket_Line_Security.g_record.end_date_active, sysdate)))
8796: Then
8797: p_result := 0;
8798: Else
8799: p_result := 1;