APPS.PA_REP_UTIL_SCREEN dependencies on PA_REP_UTIL_SCR_U1_TMP

Line 3016: delete from PA_REP_UTIL_SCR_U1_TMP;

3012: )
3013: IS
3014: BEGIN
3015:
3016: delete from PA_REP_UTIL_SCR_U1_TMP;
3017:
3018: /* */
3019: /* Case 1 for GE view */
3020: /* */

Line 3023: INSERT INTO PA_REP_UTIL_SCR_U1_TMP

3019: /* Case 1 for GE view */
3020: /* */
3021: PA_REP_UTIL_GLOB.SetU1Params(p_organization_id,p_period_type,p_period_name,to_number(p_period_year));
3022: IF (p_Period_Type=PA_REP_UTIL_GLOB.GetPeriodTypeGe) THEN
3023: INSERT INTO PA_REP_UTIL_SCR_U1_TMP
3024: (
3025: title_name
3026: , title_code
3027: , exp_organization_id

Line 3073: INSERT INTO PA_REP_UTIL_SCR_U1_TMP

3069: /* */
3070: /* Case 2 for GL view */
3071: /* */
3072: ELSIF (p_Period_Type=PA_REP_UTIL_GLOB.GetPeriodTypeGl) THEN
3073: INSERT INTO PA_REP_UTIL_SCR_U1_TMP
3074: (
3075: title_name
3076: , title_code
3077: , exp_organization_id

Line 3128: INSERT INTO PA_REP_UTIL_SCR_U1_TMP

3124: ELSIF (p_Period_Type=PA_REP_UTIL_GLOB.GetPeriodTypePa) THEN
3125: /* */
3126: /* Case 3 for PA view */
3127: /* */
3128: INSERT INTO PA_REP_UTIL_SCR_U1_TMP
3129: (
3130: title_name
3131: , title_code
3132: , exp_organization_id

Line 3183: INSERT INTO PA_REP_UTIL_SCR_U1_TMP

3179: /* */
3180: /* Case 4 for YR view */
3181: /* */
3182: ELSIF (p_Period_Type=PA_REP_UTIL_GLOB.GetPeriodTypeYr) THEN
3183: INSERT INTO PA_REP_UTIL_SCR_U1_TMP
3184: (
3185: title_name
3186: , title_code
3187: , exp_organization_id

Line 3231: INSERT INTO PA_REP_UTIL_SCR_U1_TMP

3227: /* */
3228: /* Case 5 for QR view */
3229: /* */
3230: ELSIF (p_Period_Type=PA_REP_UTIL_GLOB.GetPeriodTypeQr) THEN
3231: INSERT INTO PA_REP_UTIL_SCR_U1_TMP
3232: (
3233: title_name
3234: , title_code
3235: , exp_organization_id

Line 3282: UPDATE PA_REP_UTIL_SCR_U1_TMP U1

3278: );
3279: END IF;
3280:
3281: /* Commented for bug 5680366
3282: UPDATE PA_REP_UTIL_SCR_U1_TMP U1
3283: Set (emp_head_count, others_head_count) =
3284: (Select HC.emp_headcount,0
3285: From PA_RES_EMP_HCOUNT_V HC
3286: Where U1.exp_sub_organization_id = HC.organization_id