DBA Data[Home] [Help]

APPS.GR_FIELD_NAME_CLASSES_PUB dependencies on FND_RESPONSIBILITY

Line 131: from fnd_responsibility

127: and language = p_language;
128:
129: cursor resp_id_cur is
130: select 1
131: from fnd_responsibility
132: where responsibility_id = l_responsibility_id;
133:
134: cursor resp_name_cur is
135: select responsibility_id

Line 136: from fnd_responsibility_vl

132: where responsibility_id = l_responsibility_id;
133:
134: cursor resp_name_cur is
135: select responsibility_id
136: from fnd_responsibility_vl
137: where responsibility_name = l_responsibility;
138:
139: cursor label_class_resp1 is
140: select 1

Line 521: -- If a responsibility name is sent in, the responsibility id will be retrieved from FND_RESPONSIBILITY_VL.

517: 'SY_FIELDNAME');
518: RAISE FND_API.G_EXC_ERROR;
519: END IF;
520:
521: -- If a responsibility name is sent in, the responsibility id will be retrieved from FND_RESPONSIBILITY_VL.
522: -- If a responsibility id is sent in, it is validated against the FND_RESPONSIBILITY table.
523: -- An error message will be written to the log file if the value is invalid.
524:
525: IF l_responsibility_id IS NOT NULL THEN

Line 522: -- If a responsibility id is sent in, it is validated against the FND_RESPONSIBILITY table.

518: RAISE FND_API.G_EXC_ERROR;
519: END IF;
520:
521: -- If a responsibility name is sent in, the responsibility id will be retrieved from FND_RESPONSIBILITY_VL.
522: -- If a responsibility id is sent in, it is validated against the FND_RESPONSIBILITY table.
523: -- An error message will be written to the log file if the value is invalid.
524:
525: IF l_responsibility_id IS NOT NULL THEN
526: -- check if valid_id

Line 726: -- If a responsibility name is sent in, the responsibility id will be retrieved from FND_RESPONSIBILITY_VL.

722: l_responsibility := p_label_class_resp_tab(i).responsibility;
723: l_display_sequence := p_label_class_resp_tab(i).display_sequence;
724: l_allow_create_update := p_label_class_resp_tab(i).allow_create_update;
725:
726: -- If a responsibility name is sent in, the responsibility id will be retrieved from FND_RESPONSIBILITY_VL.
727: -- If a responsibility id is sent in, it is validated against the FND_RESPONSIBILITY table.
728: -- An error message will be written to the log file if the value is invalid.
729:
730: IF l_responsibility_id IS NOT NULL THEN

Line 727: -- If a responsibility id is sent in, it is validated against the FND_RESPONSIBILITY table.

723: l_display_sequence := p_label_class_resp_tab(i).display_sequence;
724: l_allow_create_update := p_label_class_resp_tab(i).allow_create_update;
725:
726: -- If a responsibility name is sent in, the responsibility id will be retrieved from FND_RESPONSIBILITY_VL.
727: -- If a responsibility id is sent in, it is validated against the FND_RESPONSIBILITY table.
728: -- An error message will be written to the log file if the value is invalid.
729:
730: IF l_responsibility_id IS NOT NULL THEN
731: -- check if valid_id

Line 919: -- If a responsibility name is sent in, the responsibility id will be retrieved from FND_RESPONSIBILITY_VL.

915: l_responsibility := p_label_class_resp_tab(i).responsibility;
916: l_display_sequence := p_label_class_resp_tab(i).display_sequence;
917: l_allow_create_update := p_label_class_resp_tab(i).allow_create_update;
918:
919: -- If a responsibility name is sent in, the responsibility id will be retrieved from FND_RESPONSIBILITY_VL.
920: -- If a responsibility id is sent in, it is validated against the FND_RESPONSIBILITY table.
921: -- An error message will be written to the log file if the value is invalid.
922:
923: IF l_responsibility_id IS NOT NULL THEN

Line 920: -- If a responsibility id is sent in, it is validated against the FND_RESPONSIBILITY table.

916: l_display_sequence := p_label_class_resp_tab(i).display_sequence;
917: l_allow_create_update := p_label_class_resp_tab(i).allow_create_update;
918:
919: -- If a responsibility name is sent in, the responsibility id will be retrieved from FND_RESPONSIBILITY_VL.
920: -- If a responsibility id is sent in, it is validated against the FND_RESPONSIBILITY table.
921: -- An error message will be written to the log file if the value is invalid.
922:
923: IF l_responsibility_id IS NOT NULL THEN
924: -- check if valid_id