DBA Data[Home] [Help]

APPS.AHL_RM_ROUTE_UTIL dependencies on WIP_ACCOUNTING_CLASSES

Line 1086: p_accounting_class IN WIP_ACCOUNTING_CLASSES.description%TYPE,

1082: PROCEDURE validate_accounting_class
1083: (
1084: x_return_status OUT NOCOPY VARCHAR2,
1085: x_msg_data OUT NOCOPY VARCHAR2,
1086: p_accounting_class IN WIP_ACCOUNTING_CLASSES.description%TYPE,
1087: p_x_accounting_class_code IN OUT NOCOPY WIP_ACCOUNTING_CLASSES.class_code%TYPE,
1088: p_x_accounting_class_org_id IN OUT NOCOPY WIP_ACCOUNTING_CLASSES.organization_id%TYPE
1089: )
1090: IS

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

1083: (
1084: x_return_status OUT NOCOPY VARCHAR2,
1085: x_msg_data OUT NOCOPY VARCHAR2,
1086: p_accounting_class IN WIP_ACCOUNTING_CLASSES.description%TYPE,
1087: p_x_accounting_class_code IN OUT NOCOPY WIP_ACCOUNTING_CLASSES.class_code%TYPE,
1088: p_x_accounting_class_org_id IN OUT NOCOPY WIP_ACCOUNTING_CLASSES.organization_id%TYPE
1089: )
1090: IS
1091:

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

1084: x_return_status OUT NOCOPY VARCHAR2,
1085: x_msg_data OUT NOCOPY VARCHAR2,
1086: p_accounting_class IN WIP_ACCOUNTING_CLASSES.description%TYPE,
1087: p_x_accounting_class_code IN OUT NOCOPY WIP_ACCOUNTING_CLASSES.class_code%TYPE,
1088: p_x_accounting_class_org_id IN OUT NOCOPY WIP_ACCOUNTING_CLASSES.organization_id%TYPE
1089: )
1090: IS
1091:
1092: l_accounting_class_code WIP_ACCOUNTING_CLASSES.class_code%TYPE;

Line 1092: l_accounting_class_code WIP_ACCOUNTING_CLASSES.class_code%TYPE;

1088: p_x_accounting_class_org_id IN OUT NOCOPY WIP_ACCOUNTING_CLASSES.organization_id%TYPE
1089: )
1090: IS
1091:
1092: l_accounting_class_code WIP_ACCOUNTING_CLASSES.class_code%TYPE;
1093: l_accounting_class_org_id WIP_ACCOUNTING_CLASSES.organization_id%TYPE;
1094:
1095: CURSOR get_rec_from_value ( c_accounting_class WIP_ACCOUNTING_CLASSES.description%TYPE )
1096: IS

Line 1093: l_accounting_class_org_id WIP_ACCOUNTING_CLASSES.organization_id%TYPE;

1089: )
1090: IS
1091:
1092: l_accounting_class_code WIP_ACCOUNTING_CLASSES.class_code%TYPE;
1093: l_accounting_class_org_id WIP_ACCOUNTING_CLASSES.organization_id%TYPE;
1094:
1095: CURSOR get_rec_from_value ( c_accounting_class WIP_ACCOUNTING_CLASSES.description%TYPE )
1096: IS
1097: SELECT DISTINCT class_code,

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

1091:
1092: l_accounting_class_code WIP_ACCOUNTING_CLASSES.class_code%TYPE;
1093: l_accounting_class_org_id WIP_ACCOUNTING_CLASSES.organization_id%TYPE;
1094:
1095: CURSOR get_rec_from_value ( c_accounting_class WIP_ACCOUNTING_CLASSES.description%TYPE )
1096: IS
1097: SELECT DISTINCT class_code,
1098: organization_id
1099: FROM WIP_ACCOUNTING_CLASSES

Line 1099: FROM WIP_ACCOUNTING_CLASSES

1095: CURSOR get_rec_from_value ( c_accounting_class WIP_ACCOUNTING_CLASSES.description%TYPE )
1096: IS
1097: SELECT DISTINCT class_code,
1098: organization_id
1099: FROM WIP_ACCOUNTING_CLASSES
1100: WHERE description = c_accounting_class
1101: AND class_type = 6;
1102:
1103: CURSOR get_rec_from_id ( c_accounting_class_code WIP_ACCOUNTING_CLASSES.class_code%TYPE ,

Line 1103: CURSOR get_rec_from_id ( c_accounting_class_code WIP_ACCOUNTING_CLASSES.class_code%TYPE ,

1099: FROM WIP_ACCOUNTING_CLASSES
1100: WHERE description = c_accounting_class
1101: AND class_type = 6;
1102:
1103: CURSOR get_rec_from_id ( c_accounting_class_code WIP_ACCOUNTING_CLASSES.class_code%TYPE ,
1104: c_accounting_class_org_id WIP_ACCOUNTING_CLASSES.organization_id%TYPE )
1105: IS
1106: SELECT DISTINCT class_code,
1107: organization_id

Line 1104: c_accounting_class_org_id WIP_ACCOUNTING_CLASSES.organization_id%TYPE )

1100: WHERE description = c_accounting_class
1101: AND class_type = 6;
1102:
1103: CURSOR get_rec_from_id ( c_accounting_class_code WIP_ACCOUNTING_CLASSES.class_code%TYPE ,
1104: c_accounting_class_org_id WIP_ACCOUNTING_CLASSES.organization_id%TYPE )
1105: IS
1106: SELECT DISTINCT class_code,
1107: organization_id
1108: FROM WIP_ACCOUNTING_CLASSES

Line 1108: FROM WIP_ACCOUNTING_CLASSES

1104: c_accounting_class_org_id WIP_ACCOUNTING_CLASSES.organization_id%TYPE )
1105: IS
1106: SELECT DISTINCT class_code,
1107: organization_id
1108: FROM WIP_ACCOUNTING_CLASSES
1109: WHERE class_code = c_accounting_class_code
1110: AND organization_id = c_accounting_class_org_id
1111: AND class_type = 6;
1112: