DBA Data[Home] [Help]

APPS.FTE_SEL_GROUPS_PKG dependencies on FTE_SEL_RESULT_ATTRIBUTES

Line 495: select FTE_SEL_RESULT_ATTRIBUTES_S.NEXTVAL,

491: from fte_sel_result_assignments
492: where rule_id = xx_rule_id;
493:
494: cursor c_get_result_attributes(xx_result_id NUMBER) IS
495: select FTE_SEL_RESULT_ATTRIBUTES_S.NEXTVAL,
496: result_attribute_id,
497: result_id,
498: attribute_code,
499: attribute_value

Line 500: from fte_sel_result_Attributes

496: result_attribute_id,
497: result_id,
498: attribute_code,
499: attribute_value
500: from fte_sel_result_Attributes
501: where result_id = xx_result_id;
502:
503: TYPE TableNumbers is TABLE of NUMBER INDEX BY BINARY_INTEGER; -- table number type
504: TYPE TableVarchar30 is TABLE of VARCHAR2(30) INDEX BY BINARY_INTEGER; -- table varchar(30)

Line 598: -- 5b) FTE_SEL_RESULT_ATTRIBUTES

594: -- 3) FTE_SEL_RULES
595: -- 4) FTE_SEL_RULE_RESTRICTIONS
596: -- 5) FTE_SEL_RESULTS
597: -- 5a) FTE_SEL_RESULT_ASSIGNMENTS
598: -- 5b) FTE_SEL_RESULT_ATTRIBUTES
599: --
600:
601:
602:

Line 1074: INSERT INTO fte_sel_result_attributes (

1070: -- Copy the result attributes
1071: --
1072: IF (tt_resattr_attribute_id.COUNT > 0) THEN
1073: FORALL aa in tt_resattr_attribute_id.FIRST..tt_resattr_attribute_id.LAST
1074: INSERT INTO fte_sel_result_attributes (
1075: RESULT_ATTRIBUTE_ID,
1076: RESULT_ID,
1077: ATTRIBUTE_CODE,
1078: ATTRIBUTE_VALUE,