DBA Data[Home] [Help]

APPS.QA_RESULTS_API dependencies on STANDARD

Line 609: -- variables to follow standards as currently enforced

605: -- Bug 3489530 Last_update_date was missing from this sql
606: -- also made qa_last_update_date a bind variable so that the
607: -- time portion is stored properly
608: -- Finally rest of the sql string is also modified to use bind
609: -- variables to follow standards as currently enforced
610: value_string := 'SET qa_last_update_date = '|| ':current_date'||', '||
611: ' last_update_date = '|| ':current_date'||', '||
612: ' last_updated_by = '|| ':updated_by'||', '||
613: ' qa_last_updated_by = '|| ':updated_by'||', '||

Line 724: -- comply with coding standards

720: -- anagarwa Mon Mar 8 12:18:47 PST 2004
721: -- Bug 3489530 last_update_Date is added as bind variable so
722: -- we need to bind value here.
723: -- also updated_by and update login were made bind variables to
724: -- comply with coding standards
725: DBMS_SQL.BIND_VARIABLE(c1, ':current_date', x_sysdate);
726: DBMS_SQL.BIND_VARIABLE(c1, ':updated_by', p_who_last_updated_by);
727: DBMS_SQL.BIND_VARIABLE(c1, ':update_login', p_who_last_updated_by);
728: DBMS_SQL.BIND_VARIABLE(c1, ':txn_hdr_id', x_txn_header_id);