APPS.PA_REP_UTIL_SCREEN dependencies on PA_REP_UTIL_SCR_U1_TMP

Line 2993: delete from PA_REP_UTIL_SCR_U1_TMP;

2989: )
2990: IS
2991: BEGIN
2992:
2993: delete from PA_REP_UTIL_SCR_U1_TMP;
2994:
2995: /* */
2996: /* Case 1 for GE view */
2997: /* */

Line 3000: INSERT INTO PA_REP_UTIL_SCR_U1_TMP

2996: /* Case 1 for GE view */
2997: /* */
2998: PA_REP_UTIL_GLOB.SetU1Params(p_organization_id,p_period_type,p_period_name,to_number(p_period_year));
2999: IF (p_Period_Type=PA_REP_UTIL_GLOB.GetPeriodTypeGe) THEN
3000: INSERT INTO PA_REP_UTIL_SCR_U1_TMP
3001: (
3002: title_name
3003: , title_code
3004: , exp_organization_id

Line 3050: INSERT INTO PA_REP_UTIL_SCR_U1_TMP

3046: /* */
3047: /* Case 2 for GL view */
3048: /* */
3049: ELSIF (p_Period_Type=PA_REP_UTIL_GLOB.GetPeriodTypeGl) THEN
3050: INSERT INTO PA_REP_UTIL_SCR_U1_TMP
3051: (
3052: title_name
3053: , title_code
3054: , exp_organization_id

Line 3105: INSERT INTO PA_REP_UTIL_SCR_U1_TMP

3101: ELSIF (p_Period_Type=PA_REP_UTIL_GLOB.GetPeriodTypePa) THEN
3102: /* */
3103: /* Case 3 for PA view */
3104: /* */
3105: INSERT INTO PA_REP_UTIL_SCR_U1_TMP
3106: (
3107: title_name
3108: , title_code
3109: , exp_organization_id

Line 3160: INSERT INTO PA_REP_UTIL_SCR_U1_TMP

3156: /* */
3157: /* Case 4 for YR view */
3158: /* */
3159: ELSIF (p_Period_Type=PA_REP_UTIL_GLOB.GetPeriodTypeYr) THEN
3160: INSERT INTO PA_REP_UTIL_SCR_U1_TMP
3161: (
3162: title_name
3163: , title_code
3164: , exp_organization_id

Line 3208: INSERT INTO PA_REP_UTIL_SCR_U1_TMP

3204: /* */
3205: /* Case 5 for QR view */
3206: /* */
3207: ELSIF (p_Period_Type=PA_REP_UTIL_GLOB.GetPeriodTypeQr) THEN
3208: INSERT INTO PA_REP_UTIL_SCR_U1_TMP
3209: (
3210: title_name
3211: , title_code
3212: , exp_organization_id

Line 3259: UPDATE PA_REP_UTIL_SCR_U1_TMP U1

3255: );
3256: END IF;
3257:
3258: /* Commented for bug 5680366
3259: UPDATE PA_REP_UTIL_SCR_U1_TMP U1
3260: Set (emp_head_count, others_head_count) =
3261: (Select HC.emp_headcount,0
3262: From PA_RES_EMP_HCOUNT_V HC
3263: Where U1.exp_sub_organization_id = HC.organization_id