1076: PROCEDURE validate_accounting_class
1077: (
1078: x_return_status OUT NOCOPY VARCHAR2,
1079: x_msg_data OUT NOCOPY VARCHAR2,
1080: p_accounting_class IN WIP_ACCOUNTING_CLASSES.description%TYPE,
1081: p_x_accounting_class_code IN OUT NOCOPY WIP_ACCOUNTING_CLASSES.class_code%TYPE,
1082: p_x_accounting_class_org_id IN OUT NOCOPY WIP_ACCOUNTING_CLASSES.organization_id%TYPE
1083: )
1084: IS
1077: (
1078: x_return_status OUT NOCOPY VARCHAR2,
1079: x_msg_data OUT NOCOPY VARCHAR2,
1080: p_accounting_class IN WIP_ACCOUNTING_CLASSES.description%TYPE,
1081: p_x_accounting_class_code IN OUT NOCOPY WIP_ACCOUNTING_CLASSES.class_code%TYPE,
1082: p_x_accounting_class_org_id IN OUT NOCOPY WIP_ACCOUNTING_CLASSES.organization_id%TYPE
1083: )
1084: IS
1085:
1078: x_return_status OUT NOCOPY VARCHAR2,
1079: x_msg_data OUT NOCOPY VARCHAR2,
1080: p_accounting_class IN WIP_ACCOUNTING_CLASSES.description%TYPE,
1081: p_x_accounting_class_code IN OUT NOCOPY WIP_ACCOUNTING_CLASSES.class_code%TYPE,
1082: p_x_accounting_class_org_id IN OUT NOCOPY WIP_ACCOUNTING_CLASSES.organization_id%TYPE
1083: )
1084: IS
1085:
1086: l_accounting_class_code WIP_ACCOUNTING_CLASSES.class_code%TYPE;
1082: p_x_accounting_class_org_id IN OUT NOCOPY WIP_ACCOUNTING_CLASSES.organization_id%TYPE
1083: )
1084: IS
1085:
1086: l_accounting_class_code WIP_ACCOUNTING_CLASSES.class_code%TYPE;
1087: l_accounting_class_org_id WIP_ACCOUNTING_CLASSES.organization_id%TYPE;
1088:
1089: CURSOR get_rec_from_value ( c_accounting_class WIP_ACCOUNTING_CLASSES.description%TYPE )
1090: IS
1083: )
1084: IS
1085:
1086: l_accounting_class_code WIP_ACCOUNTING_CLASSES.class_code%TYPE;
1087: l_accounting_class_org_id WIP_ACCOUNTING_CLASSES.organization_id%TYPE;
1088:
1089: CURSOR get_rec_from_value ( c_accounting_class WIP_ACCOUNTING_CLASSES.description%TYPE )
1090: IS
1091: SELECT DISTINCT class_code,
1085:
1086: l_accounting_class_code WIP_ACCOUNTING_CLASSES.class_code%TYPE;
1087: l_accounting_class_org_id WIP_ACCOUNTING_CLASSES.organization_id%TYPE;
1088:
1089: CURSOR get_rec_from_value ( c_accounting_class WIP_ACCOUNTING_CLASSES.description%TYPE )
1090: IS
1091: SELECT DISTINCT class_code,
1092: organization_id
1093: FROM WIP_ACCOUNTING_CLASSES
1089: CURSOR get_rec_from_value ( c_accounting_class WIP_ACCOUNTING_CLASSES.description%TYPE )
1090: IS
1091: SELECT DISTINCT class_code,
1092: organization_id
1093: FROM WIP_ACCOUNTING_CLASSES
1094: WHERE description = c_accounting_class
1095: AND class_type = 6;
1096:
1097: CURSOR get_rec_from_id ( c_accounting_class_code WIP_ACCOUNTING_CLASSES.class_code%TYPE ,
1093: FROM WIP_ACCOUNTING_CLASSES
1094: WHERE description = c_accounting_class
1095: AND class_type = 6;
1096:
1097: CURSOR get_rec_from_id ( c_accounting_class_code WIP_ACCOUNTING_CLASSES.class_code%TYPE ,
1098: c_accounting_class_org_id WIP_ACCOUNTING_CLASSES.organization_id%TYPE )
1099: IS
1100: SELECT DISTINCT class_code,
1101: organization_id
1094: WHERE description = c_accounting_class
1095: AND class_type = 6;
1096:
1097: CURSOR get_rec_from_id ( c_accounting_class_code WIP_ACCOUNTING_CLASSES.class_code%TYPE ,
1098: c_accounting_class_org_id WIP_ACCOUNTING_CLASSES.organization_id%TYPE )
1099: IS
1100: SELECT DISTINCT class_code,
1101: organization_id
1102: FROM WIP_ACCOUNTING_CLASSES
1098: c_accounting_class_org_id WIP_ACCOUNTING_CLASSES.organization_id%TYPE )
1099: IS
1100: SELECT DISTINCT class_code,
1101: organization_id
1102: FROM WIP_ACCOUNTING_CLASSES
1103: WHERE class_code = c_accounting_class_code
1104: AND organization_id = c_accounting_class_org_id
1105: AND class_type = 6;
1106: