APPS.OE_BLANKET_UTIL dependencies on OE_BLANKET_HEADER_SECURITY

Line 4469: OE_Blanket_Header_Security.g_check_all_cols_constraint := 'Y'; /* Bug # 5516348 */

4465: , p_header_rec.default_DISCOUNT_PERCENT
4466: , p_header_rec.default_DISCOUNT_AMOUNT
4467: );
4468:
4469: OE_Blanket_Header_Security.g_check_all_cols_constraint := 'Y'; /* Bug # 5516348 */
4470: if l_debug_level > 0 then
4471: oe_debug_pub.add('Exiting OE_BLANKET_UTIL.INSERT_ROW- Header', 1);
4472: end if;
4473:

Line 4477: OE_Blanket_Header_Security.g_check_all_cols_constraint := 'Y'; /* Bug # 5516348 */

4473:
4474: EXCEPTION
4475:
4476: WHEN OTHERS THEN
4477: OE_Blanket_Header_Security.g_check_all_cols_constraint := 'Y'; /* Bug # 5516348 */
4478: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4479: THEN
4480: OE_MSG_PUB.Add_Exc_Msg
4481: ( G_PKG_NAME

Line 4626: OE_Blanket_Header_Security.g_check_all_cols_constraint := 'Y'; /* Bug # 5516348 */

4622: END_DATE_ACTIVE = p_header_rec.end_date_active
4623: WHERE order_number = p_header_rec.order_number
4624: AND END_DATE_ACTIVE IS NULL;
4625:
4626: OE_Blanket_Header_Security.g_check_all_cols_constraint := 'Y'; /* Bug # 5516348 */
4627: if l_debug_level > 0 then
4628: oe_debug_pub.add('Exiting OE_BLANKET_UTIL.UPDATE_ROW', 1);
4629: end if;
4630:

Line 4635: OE_Blanket_Header_Security.g_check_all_cols_constraint := 'Y'; /* Bug # 5516348 */

4631: EXCEPTION
4632:
4633: WHEN OTHERS THEN
4634:
4635: OE_Blanket_Header_Security.g_check_all_cols_constraint := 'Y'; /* Bug # 5516348 */
4636: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4637: THEN
4638: OE_MSG_PUB.Add_Exc_Msg
4639: ( G_PKG_NAME

Line 8560: l_blanket_number := oe_blanket_header_security.g_record.order_number;

8556: p_result := 0;
8557: END;
8558:
8559: Else
8560: l_blanket_number := oe_blanket_header_security.g_record.order_number;
8561:
8562: BEGIN
8563: Select 1 into p_result
8564: from oe_order_lines

Line 8611: l_blanket_number := oe_blanket_header_security.g_record.order_number;

8607: p_result := 0;
8608: END;
8609:
8610: Else
8611: l_blanket_number := oe_blanket_header_security.g_record.order_number;
8612:
8613: BEGIN
8614: Select 1 into p_result
8615: from oe_order_lines

Line 8659: l_blanket_number := oe_blanket_header_security.g_record.order_number;

8655: p_result := 0;
8656: END;
8657:
8658: Else
8659: l_blanket_number := oe_blanket_header_security.g_record.order_number;
8660:
8661: BEGIN
8662: Select 1 into p_result
8663: from oe_order_headers_all

Line 8710: l_blanket_number := oe_blanket_header_security.g_record.order_number;

8706: p_result := 0;
8707: END;
8708:
8709: Else
8710: l_blanket_number := oe_blanket_header_security.g_record.order_number;
8711:
8712: BEGIN
8713: Select 1 into p_result
8714: from oe_order_lines

Line 8760: l_blanket_number := oe_blanket_header_security.g_record.order_number;

8756: p_result := 0;
8757: END;
8758:
8759: Else
8760: l_blanket_number := oe_blanket_header_security.g_record.order_number;
8761:
8762: BEGIN
8763: Select 1 into p_result
8764: from oe_order_headers_all

Line 8802: If (trunc(sysdate) >= OE_Blanket_Header_Security.g_record.start_date_active

8798: Else
8799: p_result := 1;
8800: End If;
8801: Else
8802: If (trunc(sysdate) >= OE_Blanket_Header_Security.g_record.start_date_active
8803: AND trunc(sysdate) <= trunc(nvl(OE_Blanket_Header_Security.g_record.end_date_active, sysdate)))
8804: Then
8805: p_result := 0;
8806: Else

Line 8803: AND trunc(sysdate) <= trunc(nvl(OE_Blanket_Header_Security.g_record.end_date_active, sysdate)))

8799: p_result := 1;
8800: End If;
8801: Else
8802: If (trunc(sysdate) >= OE_Blanket_Header_Security.g_record.start_date_active
8803: AND trunc(sysdate) <= trunc(nvl(OE_Blanket_Header_Security.g_record.end_date_active, sysdate)))
8804: Then
8805: p_result := 0;
8806: Else
8807: p_result := 1;