APPS.OKC_XPRT_RULE_PVT dependencies on OKC_XPRT_RULE_HDRS_ALL_S

Line 1028: -- Rule_Id => Can be generated from sequence OKC_XPRT_RULE_HDRS_ALL_S

1024: -- Set Policy context
1025: mo_global.set_policy_context ('S', TO_CHAR (p_rule_header_rec.org_id));
1026: -- Validate Rule Header
1027: -- Rules
1028: -- Rule_Id => Can be generated from sequence OKC_XPRT_RULE_HDRS_ALL_S
1029: -- Org_Id => Derive or get it from the user input
1030: -- Intent => User must pass the intent and the allowed values are 'B', 'S'
1031: -- Status_Code => Default to 'DRAFT'
1032: -- Rule_Name,CONDITION_EXPR_CODE,RULE_TYPE,

Line 1038: SELECT okc_xprt_rule_hdrs_all_s.NEXTVAL

1034: -- CREATED_BY,CREATION_DATE,LAST_UPDATED_BY,LAST_UPDATE_DATE
1035: validate_header (p_rule_header_rec => p_rule_header_rec);
1036:
1037: /*-- Get the rule id from Sequnce
1038: SELECT okc_xprt_rule_hdrs_all_s.NEXTVAL
1039: INTO p_rule_header_rec.rule_id
1040: FROM DUAL;*/
1041:
1042: -- Insert into Rule Header

Line 1065: VALUES (okc_xprt_rule_hdrs_all_s.NEXTVAL,

1061: program_update_date,
1062: rule_type,
1063: line_level_flag
1064: )
1065: VALUES (okc_xprt_rule_hdrs_all_s.NEXTVAL,
1066: p_rule_header_rec.org_id, p_rule_header_rec.intent,
1067: p_rule_header_rec.status_code,
1068: p_rule_header_rec.rule_name,
1069: p_rule_header_rec.rule_description,