DBA Data[Home] [Help]

APPS.IGS_PR_VAL_SPO dependencies on IGS_PR_GEN_006

Line 41: IF IGS_PR_GEN_006.IGS_PR_UPD_SCA_STATUS (

37: BEGIN
38: -- Process saved rows.
39: FOR v_index IN 1..gv_table_index - 1 LOOP
40: -- Validate student progression outcome
41: IF IGS_PR_GEN_006.IGS_PR_UPD_SCA_STATUS (
42: gt_rowid_table(v_index).person_id,
43: gt_rowid_table(v_index).course_cd,
44: NULL,
45: NULL,

Line 1622: IF IGS_PR_GEN_006.IGS_PR_GET_SPO_EXPIRY (

1618: v_apply_automatically_ind := NULL;
1619: END IF;
1620: IF v_apply_automatically_ind IS NULL OR
1621: v_apply_automatically_ind = 'N' THEN
1622: IF IGS_PR_GEN_006.IGS_PR_GET_SPO_EXPIRY (
1623: p_person_id,
1624: p_course_cd,
1625: p_sequence_number,
1626: NULL,

Line 1932: IF IGS_PR_GEN_006.IGS_PR_GET_SPO_EXPIRY (

1928: (v_apply_automatically_ind IS NULL OR
1929: v_apply_automatically_ind = 'N') THEN
1930: CLOSE c_spo_pro;
1931: -- The outcome cannot be approved if it will already have expired
1932: IF IGS_PR_GEN_006.IGS_PR_GET_SPO_EXPIRY (
1933: p_person_id,
1934: p_course_cd,
1935: p_sequence_number,
1936: NULL,