DBA Data[Home] [Help]

APPS.IGS_PR_GEN_006 dependencies on IGS_PR_S_SCRATCH_PAD

Line 751: p_message_name IN OUT NOCOPY IGS_PR_S_SCRATCH_PAD.MESSAGE_NAME%TYPE)

747: p_pra_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE,
748: p_pro_sequence_number IGS_PR_RU_OU.sequence_number%TYPE,
749: p_new_pra_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE,
750: p_new_pro_sequence_number IGS_PR_RU_OU.sequence_number%TYPE,
751: p_message_name IN OUT NOCOPY IGS_PR_S_SCRATCH_PAD.MESSAGE_NAME%TYPE)
752: IS
753: BEGIN -- prgpl_ins_poc
754: -- Prodecdure to create new IGS_PR_OU_RS, IGS_PR_OU_UNIT_SET
755: -- and IGS_PR_OU_UNIT records

Line 982: p_message_name IN OUT NOCOPY IGS_PR_S_SCRATCH_PAD.MESSAGE_NAME%TYPE)

978: p_new_spo_person_id IGS_PR_STDNT_PR_OU.person_id%TYPE,
979: p_new_spo_course_cd IGS_PR_STDNT_PR_OU.course_cd%TYPE,
980: p_new_spo_sequence_number IGS_PR_STDNT_PR_OU.sequence_number%TYPE,
981: p_call_again BOOLEAN,
982: p_message_name IN OUT NOCOPY IGS_PR_S_SCRATCH_PAD.MESSAGE_NAME%TYPE)
983: RETURN NUMBER
984: IS
985: BEGIN -- prgpl_ins_copy_pra
986: -- This local routine performs all of the logic and inserts of

Line 1485: v_ssp_sequence_number IGS_PR_s_scratch_pad.sequence_number%TYPE;

1481: v_sub_message_text IGS_RU_NAMED_RULE.rule_text%TYPE;
1482: v_fail_text_separator_posn NUMBER(4);
1483: v_rule_result IGS_RU_NAMED_RULE.rule_text%TYPE;
1484: v_rule_fail_text IGS_RU_NAMED_RULE.rule_text%TYPE;
1485: v_ssp_sequence_number IGS_PR_s_scratch_pad.sequence_number%TYPE;
1486: BEGIN
1487: -- set the default message number
1488: p_message_name := NULL;
1489: --Initialise a counter as a safety check that an infinite loop does not occur.