APPS.IGF_AW_AWARD_PKG dependencies on IGF_AW_AWARD_LEVEL_HIST

Line 69: g_award_change_source igf_aw_award_level_hist.AWARD_CHANGE_SOURCE_CODE%TYPE := 'CONCURRENT_PROCESS';

65: old_references igf_aw_award_all%ROWTYPE;
66: new_references igf_aw_award_all%ROWTYPE;
67: g_v_called_from VARCHAR2(30);
68: -- FA 157 - Global variables for Award change Source and Award history transaction id
69: g_award_change_source igf_aw_award_level_hist.AWARD_CHANGE_SOURCE_CODE%TYPE := 'CONCURRENT_PROCESS';
70: g_award_hist_tran_id igf_aw_award_level_hist.AWARD_HIST_TRAN_ID%TYPE;
71:
72:
73: PROCEDURE set_column_values (

Line 70: g_award_hist_tran_id igf_aw_award_level_hist.AWARD_HIST_TRAN_ID%TYPE;

66: new_references igf_aw_award_all%ROWTYPE;
67: g_v_called_from VARCHAR2(30);
68: -- FA 157 - Global variables for Award change Source and Award history transaction id
69: g_award_change_source igf_aw_award_level_hist.AWARD_CHANGE_SOURCE_CODE%TYPE := 'CONCURRENT_PROCESS';
70: g_award_hist_tran_id igf_aw_award_level_hist.AWARD_HIST_TRAN_ID%TYPE;
71:
72:
73: PROCEDURE set_column_values (
74: p_action IN VARCHAR2,

Line 898: FUNCTION isChangeIn_AwardAttribute(p_award_atrr_code IN IGF_AW_AWARD_LEVEL_HIST.AWARD_ATTRIB_CODE%TYPE)

894: -------------------------------------
895: (reverse chronological order - newest change first)
896: */
897:
898: FUNCTION isChangeIn_AwardAttribute(p_award_atrr_code IN IGF_AW_AWARD_LEVEL_HIST.AWARD_ATTRIB_CODE%TYPE)
899: return BOOLEAN
900: AS
901: l_changed BOOLEAN := FALSE;
902: BEGIN

Line 961: l_award_atrr_code IGF_AW_AWARD_LEVEL_HIST.AWARD_ATTRIB_CODE%TYPE;

957: CURSOR c_lookup_attribute is
958: SELECT lookup_code from igf_lookups_view
959: WHERE lookup_type = 'IGF_AW_AWARD_ATTRIBUTES';
960:
961: l_award_atrr_code IGF_AW_AWARD_LEVEL_HIST.AWARD_ATTRIB_CODE%TYPE;
962: l_awd_attr_changed BOOLEAN := FALSE;
963: l_row_id VARCHAR2(30) ;
964:
965: BEGIN

Line 977: igf_aw_award_level_hist_pkg.add_row

973: l_awd_attr_changed := isChangeIn_AwardAttribute(l_award_atrr_code);
974: l_row_id := null;
975: /* If award attributes Change, then insert / update */
976: IF (l_awd_attr_changed) THEN
977: igf_aw_award_level_hist_pkg.add_row
978: (
979: x_rowid => l_row_id,
980: x_award_id => old_references.AWARD_ID,
981: x_award_hist_tran_id => g_award_hist_tran_id,

Line 1554: l_award_atrr_code IGF_AW_AWARD_LEVEL_HIST.AWARD_ATTRIB_CODE%TYPE;

1550: CURSOR c_lookup_attribute is
1551: SELECT lookup_code from igf_lookups_view
1552: WHERE lookup_type = 'IGF_AW_AWARD_ATTRIBUTES';
1553:
1554: l_award_atrr_code IGF_AW_AWARD_LEVEL_HIST.AWARD_ATTRIB_CODE%TYPE;
1555: l_row_id VARCHAR2(30) ;
1556:
1557: BEGIN
1558: IF g_award_hist_tran_id IS NULL THEN

Line 1559: SELECT IGF_AW_AWARD_LEVEL_HIST_S.NEXTVAL INTO g_award_hist_tran_id from dual;

1555: l_row_id VARCHAR2(30) ;
1556:
1557: BEGIN
1558: IF g_award_hist_tran_id IS NULL THEN
1559: SELECT IGF_AW_AWARD_LEVEL_HIST_S.NEXTVAL INTO g_award_hist_tran_id from dual;
1560: END IF;
1561: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
1562: fnd_log.string( fnd_log.level_statement, 'igf.plsql.igf_aw_award_pkg.check_award_history ', 'Transaction Id = '||g_award_hist_tran_id );
1563: END IF;

Line 2026: p_award_change_source IN igf_aw_award_level_hist.AWARD_CHANGE_SOURCE_CODE%TYPE

2022: (reverse chronological order - newest change first)
2023: */
2024:
2025: PROCEDURE set_award_change_source (
2026: p_award_change_source IN igf_aw_award_level_hist.AWARD_CHANGE_SOURCE_CODE%TYPE
2027: ) AS
2028: BEGIN
2029: g_award_change_source := p_award_change_source ;
2030: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN