2982: , p_result OUT NOCOPY /* file.sql.39 change */ NUMBER
2983: )
2984: IS
2985:
2986: l_line_id NUMBER := oe_line_security.g_record.line_id;
2987: l_header_id NUMBER := oe_line_security.g_record.header_id;
2988: l_ato_line_id NUMBER := oe_line_security.g_record.ato_line_id;
2989: l_item_type_code VARCHAR2(30) := oe_line_security.g_record.item_type_code;
2990: l_source_type_code VARCHAR2(30) := oe_line_security.g_record.source_type_code;
2983: )
2984: IS
2985:
2986: l_line_id NUMBER := oe_line_security.g_record.line_id;
2987: l_header_id NUMBER := oe_line_security.g_record.header_id;
2988: l_ato_line_id NUMBER := oe_line_security.g_record.ato_line_id;
2989: l_item_type_code VARCHAR2(30) := oe_line_security.g_record.item_type_code;
2990: l_source_type_code VARCHAR2(30) := oe_line_security.g_record.source_type_code;
2991: l_operation VARCHAR2(30) := oe_line_security.g_record.operation;
2984: IS
2985:
2986: l_line_id NUMBER := oe_line_security.g_record.line_id;
2987: l_header_id NUMBER := oe_line_security.g_record.header_id;
2988: l_ato_line_id NUMBER := oe_line_security.g_record.ato_line_id;
2989: l_item_type_code VARCHAR2(30) := oe_line_security.g_record.item_type_code;
2990: l_source_type_code VARCHAR2(30) := oe_line_security.g_record.source_type_code;
2991: l_operation VARCHAR2(30) := oe_line_security.g_record.operation;
2992:
2985:
2986: l_line_id NUMBER := oe_line_security.g_record.line_id;
2987: l_header_id NUMBER := oe_line_security.g_record.header_id;
2988: l_ato_line_id NUMBER := oe_line_security.g_record.ato_line_id;
2989: l_item_type_code VARCHAR2(30) := oe_line_security.g_record.item_type_code;
2990: l_source_type_code VARCHAR2(30) := oe_line_security.g_record.source_type_code;
2991: l_operation VARCHAR2(30) := oe_line_security.g_record.operation;
2992:
2993: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2986: l_line_id NUMBER := oe_line_security.g_record.line_id;
2987: l_header_id NUMBER := oe_line_security.g_record.header_id;
2988: l_ato_line_id NUMBER := oe_line_security.g_record.ato_line_id;
2989: l_item_type_code VARCHAR2(30) := oe_line_security.g_record.item_type_code;
2990: l_source_type_code VARCHAR2(30) := oe_line_security.g_record.source_type_code;
2991: l_operation VARCHAR2(30) := oe_line_security.g_record.operation;
2992:
2993: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2994:
2987: l_header_id NUMBER := oe_line_security.g_record.header_id;
2988: l_ato_line_id NUMBER := oe_line_security.g_record.ato_line_id;
2989: l_item_type_code VARCHAR2(30) := oe_line_security.g_record.item_type_code;
2990: l_source_type_code VARCHAR2(30) := oe_line_security.g_record.source_type_code;
2991: l_operation VARCHAR2(30) := oe_line_security.g_record.operation;
2992:
2993: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2994:
2995: l_po_header_id NUMBER;
3123: , p_scope IN VARCHAR2
3124: , p_result OUT NOCOPY /* file.sql.39 change */ NUMBER
3125: )
3126: IS
3127: l_line_id NUMBER := oe_line_security.g_record.line_id;
3128: l_header_id NUMBER := oe_line_security.g_record.header_id;
3129: l_drop_ship_flag VARCHAR2(1);
3130: l_source_type_code VARCHAR2(10) := oe_line_security.g_record.source_type_code;
3131:
3124: , p_result OUT NOCOPY /* file.sql.39 change */ NUMBER
3125: )
3126: IS
3127: l_line_id NUMBER := oe_line_security.g_record.line_id;
3128: l_header_id NUMBER := oe_line_security.g_record.header_id;
3129: l_drop_ship_flag VARCHAR2(1);
3130: l_source_type_code VARCHAR2(10) := oe_line_security.g_record.source_type_code;
3131:
3132: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3126: IS
3127: l_line_id NUMBER := oe_line_security.g_record.line_id;
3128: l_header_id NUMBER := oe_line_security.g_record.header_id;
3129: l_drop_ship_flag VARCHAR2(1);
3130: l_source_type_code VARCHAR2(10) := oe_line_security.g_record.source_type_code;
3131:
3132: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
3133:
3134: BEGIN