APPS.PO_FUNDS_CHECKER dependencies on PO_ONLINE_REPORT_TEXT

Line 3149: -- Insert errors into po_online_report_text

3145: END po_fc_dist;
3146:
3147: /* ----------------------------------------------------------------------- */
3148:
3149: -- Insert errors into po_online_report_text
3150:
3151: FUNCTION po_err_insert RETURN BOOLEAN IS
3152:
3153: l_linemsg VARCHAR2(25);

Line 3157: l_reportid po_online_report_text.online_report_id%TYPE;

3153: l_linemsg VARCHAR2(25);
3154: l_shipmsg VARCHAR2(25);
3155: l_distmsg VARCHAR2(25);
3156:
3157: l_reportid po_online_report_text.online_report_id%TYPE;
3158:
3159: cursor report_seq is
3160: select po_online_report_text_s.nextval
3161: from dual;

Line 3160: select po_online_report_text_s.nextval

3156:
3157: l_reportid po_online_report_text.online_report_id%TYPE;
3158:
3159: cursor report_seq is
3160: select po_online_report_text_s.nextval
3161: from dual;
3162:
3163: BEGIN
3164:

Line 3178: insert into po_online_report_text(online_report_id,

3174: close report_seq;
3175:
3176: if g_doctyp = 'REQUISITION' then
3177:
3178: insert into po_online_report_text(online_report_id,
3179: last_update_login,
3180: last_updated_by,
3181: last_update_date,
3182: created_by,

Line 3216: 'Inserted ' || SQL%ROWCOUNT || ' Records into po_online_report_text' || g_delim;

3212: and prd.requisition_line_id = prl.requisition_line_id;
3213: -- FRKHAN bug 941171
3214: IF LENGTH (g_dbug) < x_max_length THEN
3215: g_dbug := g_dbug ||
3216: 'Inserted ' || SQL%ROWCOUNT || ' Records into po_online_report_text' || g_delim;
3217: END IF;
3218: elsif g_doctyp in ('PO', 'RELEASE') then
3219:
3220: insert into po_online_report_text(online_report_id,

Line 3220: insert into po_online_report_text(online_report_id,

3216: 'Inserted ' || SQL%ROWCOUNT || ' Records into po_online_report_text' || g_delim;
3217: END IF;
3218: elsif g_doctyp in ('PO', 'RELEASE') then
3219:
3220: insert into po_online_report_text(online_report_id,
3221: last_update_login,
3222: last_updated_by,
3223: last_update_date,
3224: created_by,

Line 3262: 'Inserted ' || SQL%ROWCOUNT || ' Records into po_online_report_text' || g_delim;

3258: and pod.line_location_id = poll.line_location_id;
3259: -- FRKHAN bug 941171
3260: IF LENGTH (g_dbug) < x_max_length THEN
3261: g_dbug := g_dbug ||
3262: 'Inserted ' || SQL%ROWCOUNT || ' Records into po_online_report_text' || g_delim;
3263: END IF;
3264: end if;
3265:
3266: return(TRUE);