DBA Data[Home] [Help]

APPS.AHL_RM_ROUTE_UTIL dependencies on WIP_ACCOUNTING_CLASSES

Line 1080: p_accounting_class IN WIP_ACCOUNTING_CLASSES.description%TYPE,

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

Line 1081: p_x_accounting_class_code IN OUT NOCOPY WIP_ACCOUNTING_CLASSES.class_code%TYPE,

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:

Line 1082: p_x_accounting_class_org_id IN OUT NOCOPY WIP_ACCOUNTING_CLASSES.organization_id%TYPE

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;

Line 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

Line 1087: l_accounting_class_org_id 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
1091: SELECT DISTINCT class_code,

Line 1089: CURSOR get_rec_from_value ( c_accounting_class WIP_ACCOUNTING_CLASSES.description%TYPE )

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

Line 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 ,

Line 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

Line 1098: c_accounting_class_org_id WIP_ACCOUNTING_CLASSES.organization_id%TYPE )

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

Line 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: