APPS.OE_BLANKET_UTIL dependencies on OE_BLANKET_HEADER_SECURITY

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

4271: , p_header_rec.default_DISCOUNT_PERCENT
4272: , p_header_rec.default_DISCOUNT_AMOUNT
4273: );
4274:
4275: OE_Blanket_Header_Security.g_check_all_cols_constraint := 'Y'; /* Bug # 5516348 */
4276: if l_debug_level > 0 then
4277: oe_debug_pub.add('Exiting OE_BLANKET_UTIL.INSERT_ROW- Header', 1);
4278: end if;
4279:

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

4279:
4280: EXCEPTION
4281:
4282: WHEN OTHERS THEN
4283: OE_Blanket_Header_Security.g_check_all_cols_constraint := 'Y'; /* Bug # 5516348 */
4284: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4285: THEN
4286: OE_MSG_PUB.Add_Exc_Msg
4287: ( G_PKG_NAME

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

4428: END_DATE_ACTIVE = p_header_rec.end_date_active
4429: WHERE order_number = p_header_rec.order_number
4430: AND END_DATE_ACTIVE IS NULL;
4431:
4432: OE_Blanket_Header_Security.g_check_all_cols_constraint := 'Y'; /* Bug # 5516348 */
4433: if l_debug_level > 0 then
4434: oe_debug_pub.add('Exiting OE_BLANKET_UTIL.UPDATE_ROW', 1);
4435: end if;
4436:

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

4437: EXCEPTION
4438:
4439: WHEN OTHERS THEN
4440:
4441: OE_Blanket_Header_Security.g_check_all_cols_constraint := 'Y'; /* Bug # 5516348 */
4442: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
4443: THEN
4444: OE_MSG_PUB.Add_Exc_Msg
4445: ( G_PKG_NAME

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

8359: p_result := 0;
8360: END;
8361:
8362: Else
8363: l_blanket_number := oe_blanket_header_security.g_record.order_number;
8364:
8365: BEGIN
8366: Select 1 into p_result
8367: from oe_order_lines

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

8410: p_result := 0;
8411: END;
8412:
8413: Else
8414: l_blanket_number := oe_blanket_header_security.g_record.order_number;
8415:
8416: BEGIN
8417: Select 1 into p_result
8418: from oe_order_lines

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

8458: p_result := 0;
8459: END;
8460:
8461: Else
8462: l_blanket_number := oe_blanket_header_security.g_record.order_number;
8463:
8464: BEGIN
8465: Select 1 into p_result
8466: from oe_order_headers_all

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

8509: p_result := 0;
8510: END;
8511:
8512: Else
8513: l_blanket_number := oe_blanket_header_security.g_record.order_number;
8514:
8515: BEGIN
8516: Select 1 into p_result
8517: from oe_order_lines

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

8559: p_result := 0;
8560: END;
8561:
8562: Else
8563: l_blanket_number := oe_blanket_header_security.g_record.order_number;
8564:
8565: BEGIN
8566: Select 1 into p_result
8567: from oe_order_headers_all

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

8601: Else
8602: p_result := 1;
8603: End If;
8604: Else
8605: If (trunc(sysdate) >= OE_Blanket_Header_Security.g_record.start_date_active
8606: AND trunc(sysdate) <= trunc(nvl(OE_Blanket_Header_Security.g_record.end_date_active, sysdate)))
8607: Then
8608: p_result := 0;
8609: Else

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

8602: p_result := 1;
8603: End If;
8604: Else
8605: If (trunc(sysdate) >= OE_Blanket_Header_Security.g_record.start_date_active
8606: AND trunc(sysdate) <= trunc(nvl(OE_Blanket_Header_Security.g_record.end_date_active, sysdate)))
8607: Then
8608: p_result := 0;
8609: Else
8610: p_result := 1;