APPS.PO_WF_BUILD_ACCOUNT_INIT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 1344

                       x_insert_if_new                IN BOOLEAN,
                       x_account_generation_flow_type IN VARCHAR2,
                       x_coa_id                       IN NUMBER,
                       x_ship_to_ou_coa_id            IN NUMBER,
                       x_gl_encumbered_date           IN DATE,
                       x_dest_charge_account_id       IN OUT NOCOPY NUMBER,
                       x_dest_charge_account_flex     IN OUT NOCOPY VARCHAR2,
                       x_dest_charge_account_desc     IN OUT NOCOPY VARCHAR2,
                       x_dest_charge_success          IN OUT NOCOPY BOOLEAN,
                       x_dest_variance_account_id     IN OUT NOCOPY NUMBER,
                       x_dest_variance_account_flex   IN OUT NOCOPY VARCHAR2,
                       x_dest_variance_account_desc   IN OUT NOCOPY VARCHAR2,
                       x_dest_variance_success        IN OUT NOCOPY BOOLEAN,
                       x_success                      IN OUT NOCOPY BOOLEAN,
                       FB_ERROR_MSG                   IN OUT NOCOPY VARCHAR2,
                       x_new_combination              IN OUT NOCOPY BOOLEAN)
IS
  ccid                         GL_CODE_COMBINATIONS.code_combination_id%TYPE;

Line: 1420

                       x_insert_if_new,
                       ccid,
                       concat_segs,
                       concat_ids,
                       concat_descrs,
                       FB_ERROR_MSG,
                       x_new_combination);

Line: 1516

                     x_insert_if_new,
                     ccid,
                     concat_segs,
                     concat_ids,
                     concat_descrs,
                     FB_ERROR_MSG,
                     x_new_combination );

Line: 1736

  x_insert_if_new              BOOLEAN := TRUE;

Line: 1934

                        x_insert_if_new,
                        ccid,
                        concat_segs,
                        concat_ids,
                        concat_descrs,
                        FB_ERROR_MSG,
                        x_new_combination );

Line: 2079

                                      x_insert_if_new,
                                      ccid,
                                      concat_segs,
                                      concat_ids,
                                      concat_descrs,
                                      FB_ERROR_MSG,
                                      x_new_combination );

Line: 2180

                                      x_insert_if_new,
                                      ccid,
                                      concat_segs,
                                      concat_ids,
                                      concat_descrs,
                                      FB_ERROR_MSG,
                                      x_new_combination );

Line: 2238

                                      x_insert_if_new,
                                      ccid,
                                      concat_segs,
                                      concat_ids,
                                      concat_descrs,
                                      FB_ERROR_MSG,
                                      x_new_combination);

Line: 2328

                      x_insert_if_new,                -- IN BOOLEAN,
                      x_account_generation_flow_type, -- IN VARCHAR2,
                      x_coa_id,                       -- IN NUMBER,
                      x_ship_to_ou_coa_id,            -- IN NUMBER,
                      x_gl_encumbered_date,           -- IN DATE,
                      x_dest_charge_account_id,       -- IN OUT NUMBER,
                      x_dest_charge_account_flex,     -- IN OUT NUMBER,
                      x_dest_charge_account_desc,     -- IN OUT NUMBER,
                      x_dest_charge_success,          -- IN OUT NOCOPY BOOLEAN
                      x_dest_variance_account_id,     -- IN OUT NUMBER,
                      x_dest_variance_account_flex,   -- IN OUT NUMBER,
                      x_dest_variance_account_desc,   -- IN OUT NUMBER
                      x_dest_variance_success,        -- IN OUT NOCOPY BOOLEAN
                      x_success,                      -- IN OUT BOOLEAN
                      FB_ERROR_MSG,                   -- IN OUT VARCHAR2
                      x_new_combination);             -- IN OUT BOOLEAN