1: PACKAGE BODY fnd_flex_oracle_reports_apis AS
2: /* $Header: AFFFORAB.pls 120.1.12010000.1 2008/07/25 14:14:12 appldev ship $ */
3:
4: g_newline VARCHAR2(100);
5:
58:
59: --
60: -- Get the SELECT portion of my query for SQLGL/GL#/101 KFF
61: --
62: fnd_flex_oracle_reports_apis.flexsql
63: (p_appl_short_name => 'SQLGL',
64: p_code => 'GL#',
65: p_mode => fnd_flex_oracle_reports_apis.mode_select,
66: p_num => 101,
61: --
62: fnd_flex_oracle_reports_apis.flexsql
63: (p_appl_short_name => 'SQLGL',
64: p_code => 'GL#',
65: p_mode => fnd_flex_oracle_reports_apis.mode_select,
66: p_num => 101,
67: x_output => l_p_flexdata);
68:
69: --
68:
69: --
70: -- Get the WHERE portion of my query for SQLGL/GL#/101 KFF
71: --
72: fnd_flex_oracle_reports_apis.flexsql
73: (p_appl_short_name => 'SQLGL',
74: p_code => 'GL#',
75: p_mode => fnd_flex_oracle_reports_apis.mode_where,
76: p_num => 101,
71: --
72: fnd_flex_oracle_reports_apis.flexsql
73: (p_appl_short_name => 'SQLGL',
74: p_code => 'GL#',
75: p_mode => fnd_flex_oracle_reports_apis.mode_where,
76: p_num => 101,
77: p_display => 'GL_BALANCING',
78: p_operator => fnd_flex_oracle_reports_apis.operator_equal,
79: p_operand1 => l_p_operand1,
74: p_code => 'GL#',
75: p_mode => fnd_flex_oracle_reports_apis.mode_where,
76: p_num => 101,
77: p_display => 'GL_BALANCING',
78: p_operator => fnd_flex_oracle_reports_apis.operator_equal,
79: p_operand1 => l_p_operand1,
80: x_output => l_p_where);
81:
82:
87: END sample_package;
88:
89: BEGIN
90: g_newline := fnd_global.newline();
91: END fnd_flex_oracle_reports_apis;