APPS.OKC_NUMBER_SCHEME_GRP dependencies on OKC_NUMBER_SCHEMES_B

Line 635: Update OKC_NUMBER_SCHEMES_B SET

631: x_out_string := l_out;
632:
633: IF p_update_db=FND_API.G_TRUE THEN
634:
635: Update OKC_NUMBER_SCHEMES_B SET
636: num_scheme_preview = x_out_string,
637: object_version_number = object_version_number+1,
638: creation_date = sysdate,
639: created_by = Fnd_Global.User_Id,

Line 734: SELECT number_article_yn from OKC_NUMBER_SCHEMES_B

730: AND nvl(summary_amend_operation_code,'?') <> 'DELETED'
731: Order by section_sequence;
732:
733: cursor l_get_num_scheme IS
734: SELECT number_article_yn from OKC_NUMBER_SCHEMES_B
735: where num_scheme_id=p_num_scheme_id;
736:
737: cursor l_get_num_scheme_dtl IS
738: SELECT num_sequence_code,sequence_level,concatenation_yn,end_character from OKC_NUMBER_SCHEME_DTLS

Line 1537: SELECT number_article_yn from OKC_NUMBER_SCHEMES_B

1533: and rt.object_id = p_doc_id)
1534: Order by display_seq;
1535:
1536: cursor l_get_num_scheme IS
1537: SELECT number_article_yn from OKC_NUMBER_SCHEMES_B
1538: where num_scheme_id=p_num_scheme_id;
1539:
1540: cursor l_get_num_scheme_dtl IS
1541: SELECT num_sequence_code,sequence_level,concatenation_yn,end_character from OKC_NUMBER_SCHEME_DTLS