DBA Data[Home] [Help]

APPS.OE_SHIPPING_INTEGRATION_PUB dependencies on OE_LINE_SECURITY

Line 1627: IF (OE_LINE_SECURITY.g_record.ato_line_id IS NULL) OR

1623: BEGIN
1624:
1625:
1626:
1627: IF (OE_LINE_SECURITY.g_record.ato_line_id IS NULL) OR
1628: (OE_LINE_SECURITY.g_record.ato_line_id = FND_API.G_MISS_NUM) OR
1629: (OE_LINE_SECURITY.g_record.item_type_code not in ('MODEL', 'CLASS')) OR
1630: (OE_LINE_SECURITY.g_record.line_id IS NULL) OR
1631: (OE_LINE_SECURITY.g_record.line_id = FND_API.G_MISS_NUM) OR

Line 1628: (OE_LINE_SECURITY.g_record.ato_line_id = FND_API.G_MISS_NUM) OR

1624:
1625:
1626:
1627: IF (OE_LINE_SECURITY.g_record.ato_line_id IS NULL) OR
1628: (OE_LINE_SECURITY.g_record.ato_line_id = FND_API.G_MISS_NUM) OR
1629: (OE_LINE_SECURITY.g_record.item_type_code not in ('MODEL', 'CLASS')) OR
1630: (OE_LINE_SECURITY.g_record.line_id IS NULL) OR
1631: (OE_LINE_SECURITY.g_record.line_id = FND_API.G_MISS_NUM) OR
1632: (OE_LINE_SECURITY.g_record.ato_line_id <> OE_LINE_SECURITY.g_record.line_id)

Line 1629: (OE_LINE_SECURITY.g_record.item_type_code not in ('MODEL', 'CLASS')) OR

1625:
1626:
1627: IF (OE_LINE_SECURITY.g_record.ato_line_id IS NULL) OR
1628: (OE_LINE_SECURITY.g_record.ato_line_id = FND_API.G_MISS_NUM) OR
1629: (OE_LINE_SECURITY.g_record.item_type_code not in ('MODEL', 'CLASS')) OR
1630: (OE_LINE_SECURITY.g_record.line_id IS NULL) OR
1631: (OE_LINE_SECURITY.g_record.line_id = FND_API.G_MISS_NUM) OR
1632: (OE_LINE_SECURITY.g_record.ato_line_id <> OE_LINE_SECURITY.g_record.line_id)
1633: THEN

Line 1630: (OE_LINE_SECURITY.g_record.line_id IS NULL) OR

1626:
1627: IF (OE_LINE_SECURITY.g_record.ato_line_id IS NULL) OR
1628: (OE_LINE_SECURITY.g_record.ato_line_id = FND_API.G_MISS_NUM) OR
1629: (OE_LINE_SECURITY.g_record.item_type_code not in ('MODEL', 'CLASS')) OR
1630: (OE_LINE_SECURITY.g_record.line_id IS NULL) OR
1631: (OE_LINE_SECURITY.g_record.line_id = FND_API.G_MISS_NUM) OR
1632: (OE_LINE_SECURITY.g_record.ato_line_id <> OE_LINE_SECURITY.g_record.line_id)
1633: THEN
1634: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);

Line 1631: (OE_LINE_SECURITY.g_record.line_id = FND_API.G_MISS_NUM) OR

1627: IF (OE_LINE_SECURITY.g_record.ato_line_id IS NULL) OR
1628: (OE_LINE_SECURITY.g_record.ato_line_id = FND_API.G_MISS_NUM) OR
1629: (OE_LINE_SECURITY.g_record.item_type_code not in ('MODEL', 'CLASS')) OR
1630: (OE_LINE_SECURITY.g_record.line_id IS NULL) OR
1631: (OE_LINE_SECURITY.g_record.line_id = FND_API.G_MISS_NUM) OR
1632: (OE_LINE_SECURITY.g_record.ato_line_id <> OE_LINE_SECURITY.g_record.line_id)
1633: THEN
1634: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1635: p_result := 0;

Line 1632: (OE_LINE_SECURITY.g_record.ato_line_id <> OE_LINE_SECURITY.g_record.line_id)

1628: (OE_LINE_SECURITY.g_record.ato_line_id = FND_API.G_MISS_NUM) OR
1629: (OE_LINE_SECURITY.g_record.item_type_code not in ('MODEL', 'CLASS')) OR
1630: (OE_LINE_SECURITY.g_record.line_id IS NULL) OR
1631: (OE_LINE_SECURITY.g_record.line_id = FND_API.G_MISS_NUM) OR
1632: (OE_LINE_SECURITY.g_record.ato_line_id <> OE_LINE_SECURITY.g_record.line_id)
1633: THEN
1634: OE_MSG_PUB.Update_Msg_Context(p_attribute_code => null);
1635: p_result := 0;
1636:

Line 1644: WHERE header_id = OE_LINE_SECURITY.g_record.header_id

1640:
1641: SELECT line_id
1642: INTO l_config_line_id
1643: FROM oe_order_lines
1644: WHERE header_id = OE_LINE_SECURITY.g_record.header_id
1645: AND ato_line_id = OE_LINE_SECURITY.g_record.line_id
1646: AND item_type_code = 'CONFIG';
1647:
1648: IF l_debug_level > 0 THEN

Line 1645: AND ato_line_id = OE_LINE_SECURITY.g_record.line_id

1641: SELECT line_id
1642: INTO l_config_line_id
1643: FROM oe_order_lines
1644: WHERE header_id = OE_LINE_SECURITY.g_record.header_id
1645: AND ato_line_id = OE_LINE_SECURITY.g_record.line_id
1646: AND item_type_code = 'CONFIG';
1647:
1648: IF l_debug_level > 0 THEN
1649: oe_debug_pub.add('Config line line_id' || l_config_line_id);