22:
23:
24: BEGIN
25: -- Reset all the global variables to NULL or to the default value
26: fii_ar_util_pkg.reset_globals;
27:
28: -- Get the parameters and set the global variables
29: fii_ar_util_pkg.get_parameters(p_page_parameter_tbl);
30:
25: -- Reset all the global variables to NULL or to the default value
26: fii_ar_util_pkg.reset_globals;
27:
28: -- Get the parameters and set the global variables
29: fii_ar_util_pkg.get_parameters(p_page_parameter_tbl);
30:
31: l_cust_id := fii_ar_util_pkg.g_party_id;
32: l_cust_acct_id := fii_ar_util_pkg.g_cust_account_id;
33:
27:
28: -- Get the parameters and set the global variables
29: fii_ar_util_pkg.get_parameters(p_page_parameter_tbl);
30:
31: l_cust_id := fii_ar_util_pkg.g_party_id;
32: l_cust_acct_id := fii_ar_util_pkg.g_cust_account_id;
33:
34: -- Populate global temp table based on the parameters chosen
35: fii_ar_util_pkg.populate_summary_gt_tables;
28: -- Get the parameters and set the global variables
29: fii_ar_util_pkg.get_parameters(p_page_parameter_tbl);
30:
31: l_cust_id := fii_ar_util_pkg.g_party_id;
32: l_cust_acct_id := fii_ar_util_pkg.g_cust_account_id;
33:
34: -- Populate global temp table based on the parameters chosen
35: fii_ar_util_pkg.populate_summary_gt_tables;
36:
31: l_cust_id := fii_ar_util_pkg.g_party_id;
32: l_cust_acct_id := fii_ar_util_pkg.g_cust_account_id;
33:
34: -- Populate global temp table based on the parameters chosen
35: fii_ar_util_pkg.populate_summary_gt_tables;
36:
37: -- Only add the join on cust_acct_id if we have a specific customer acct
38: -- selected
39:
99:
100:
101:
102:
103: fii_ar_util_pkg.bind_variable
104: (p_sqlstmt => l_sqlstmt,
105: p_page_parameter_tbl => p_page_parameter_tbl,
106: p_sql_output => p_rec_act_detail_sql,
107: p_bind_output_table => p_rec_act_detail_output);