eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_BUDGETAPPROVAL_PVT dependencies on FND_DSQL

Line 842: FND_DSQL.init;

838: x_budget_prod := FALSE;
839: x_exclude_prod := FALSE;
840: SAVEPOINT denorm_product_for_one_budget;
841:
842: FND_DSQL.init;
843: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
844: FND_DSQL.add_text('SELECT ''FUND'', ''N'', product_id FROM (');
845: -- Get all product qualifiers for 'FUND'
846: OPEN c_get_products(p_budget_id, 'FUND', 'N');

Line 843: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');

839: x_exclude_prod := FALSE;
840: SAVEPOINT denorm_product_for_one_budget;
841:
842: FND_DSQL.init;
843: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
844: FND_DSQL.add_text('SELECT ''FUND'', ''N'', product_id FROM (');
845: -- Get all product qualifiers for 'FUND'
846: OPEN c_get_products(p_budget_id, 'FUND', 'N');
847: LOOP

Line 844: FND_DSQL.add_text('SELECT ''FUND'', ''N'', product_id FROM (');

840: SAVEPOINT denorm_product_for_one_budget;
841:
842: FND_DSQL.init;
843: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
844: FND_DSQL.add_text('SELECT ''FUND'', ''N'', product_id FROM (');
845: -- Get all product qualifiers for 'FUND'
846: OPEN c_get_products(p_budget_id, 'FUND', 'N');
847: LOOP
848: FETCH c_get_products INTO l_attr_value,l_excluded_flag,l_attribute;

Line 855: FND_DSQL.add_text('(');

851: x_budget_prod := TRUE;
852: END IF;
853:
854: IF c_get_products%ROWCOUNT = 1 THEN -- for first row.
855: FND_DSQL.add_text('(');
856: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
857: ( p_context => 'ITEM',
858: p_attribute => l_attribute,
859: p_attr_value_from => l_attr_value,

Line 864: FND_DSQL.add_text(')');

860: p_attr_value_to => NULL,
861: p_comparison => NULL,
862: p_type => 'PROD'
863: );
864: FND_DSQL.add_text(')');
865: ELSE
866: FND_DSQL.add_text('UNION (');
867: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
868: ( p_context => 'ITEM',

Line 866: FND_DSQL.add_text('UNION (');

862: p_type => 'PROD'
863: );
864: FND_DSQL.add_text(')');
865: ELSE
866: FND_DSQL.add_text('UNION (');
867: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
868: ( p_context => 'ITEM',
869: p_attribute => l_attribute,
870: p_attr_value_from => l_attr_value,

Line 875: FND_DSQL.add_text(')');

871: p_attr_value_to => NULL,
872: p_comparison => NULL,
873: p_type => 'PROD'
874: );
875: FND_DSQL.add_text(')');
876: END IF;
877:
878: END LOOP;
879:

Line 881: FND_DSQL.add_text(')');

877:
878: END LOOP;
879:
880: CLOSE c_get_products;
881: FND_DSQL.add_text(')');
882:
883: IF x_budget_prod THEN
884:
885: l_denorm_csr := DBMS_SQL.open_cursor;

Line 886: FND_DSQL.set_cursor(l_denorm_csr);

882:
883: IF x_budget_prod THEN
884:
885: l_denorm_csr := DBMS_SQL.open_cursor;
886: FND_DSQL.set_cursor(l_denorm_csr);
887:
888: l_stmt_denorm := FND_DSQL.get_text(FALSE);
889: --dbms_output.put_line('budget query:' || l_stmt_denorm);
890: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);

Line 888: l_stmt_denorm := FND_DSQL.get_text(FALSE);

884:
885: l_denorm_csr := DBMS_SQL.open_cursor;
886: FND_DSQL.set_cursor(l_denorm_csr);
887:
888: l_stmt_denorm := FND_DSQL.get_text(FALSE);
889: --dbms_output.put_line('budget query:' || l_stmt_denorm);
890: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
891: FND_DSQL.do_binds;
892: l_ignore := DBMS_SQL.execute(l_denorm_csr);

Line 891: FND_DSQL.do_binds;

887:
888: l_stmt_denorm := FND_DSQL.get_text(FALSE);
889: --dbms_output.put_line('budget query:' || l_stmt_denorm);
890: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
891: FND_DSQL.do_binds;
892: l_ignore := DBMS_SQL.execute(l_denorm_csr);
893: END IF;
894:
895: FND_DSQL.init;

Line 895: FND_DSQL.init;

891: FND_DSQL.do_binds;
892: l_ignore := DBMS_SQL.execute(l_denorm_csr);
893: END IF;
894:
895: FND_DSQL.init;
896: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
897: FND_DSQL.add_text('SELECT ''FUND'', ''Y'', product_id FROM (');
898: -- for exclude product of FUND.
899:

Line 896: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');

892: l_ignore := DBMS_SQL.execute(l_denorm_csr);
893: END IF;
894:
895: FND_DSQL.init;
896: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
897: FND_DSQL.add_text('SELECT ''FUND'', ''Y'', product_id FROM (');
898: -- for exclude product of FUND.
899:
900: OPEN c_get_products(p_budget_id,'FUND','Y');

Line 897: FND_DSQL.add_text('SELECT ''FUND'', ''Y'', product_id FROM (');

893: END IF;
894:
895: FND_DSQL.init;
896: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
897: FND_DSQL.add_text('SELECT ''FUND'', ''Y'', product_id FROM (');
898: -- for exclude product of FUND.
899:
900: OPEN c_get_products(p_budget_id,'FUND','Y');
901: LOOP

Line 910: FND_DSQL.add_text('(');

906: END IF;
907:
908: IF c_get_products%ROWCOUNT = 1 THEN
909: -- l_exclude_sql := '(' || l_temp_sql || ')';
910: FND_DSQL.add_text('(');
911: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
912: ( p_context => 'ITEM',
913: p_attribute => l_attribute,
914: p_attr_value_from => l_attr_value,

Line 919: FND_DSQL.add_text(')');

915: p_attr_value_to => NULL,
916: p_comparison => NULL,
917: p_type => 'PROD'
918: );
919: FND_DSQL.add_text(')');
920: ELSE
921: --l_exclude_sql := l_exclude_sql || ' UNION (' || l_temp_sql || ')';
922: FND_DSQL.add_text('UNION (');
923: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql

Line 922: FND_DSQL.add_text('UNION (');

918: );
919: FND_DSQL.add_text(')');
920: ELSE
921: --l_exclude_sql := l_exclude_sql || ' UNION (' || l_temp_sql || ')';
922: FND_DSQL.add_text('UNION (');
923: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
924: ( p_context => 'ITEM',
925: p_attribute => l_attribute,
926: p_attr_value_from => l_attr_value,

Line 931: FND_DSQL.add_text(')');

927: p_attr_value_to => NULL,
928: p_comparison => NULL,
929: p_type => 'PROD'
930: );
931: FND_DSQL.add_text(')');
932: END IF;
933:
934: END LOOP;
935: CLOSE c_get_products;

Line 936: FND_DSQL.add_text(')');

932: END IF;
933:
934: END LOOP;
935: CLOSE c_get_products;
936: FND_DSQL.add_text(')');
937:
938: IF x_exclude_prod THEN
939: l_denorm_csr := DBMS_SQL.open_cursor;
940: FND_DSQL.set_cursor(l_denorm_csr);

Line 940: FND_DSQL.set_cursor(l_denorm_csr);

936: FND_DSQL.add_text(')');
937:
938: IF x_exclude_prod THEN
939: l_denorm_csr := DBMS_SQL.open_cursor;
940: FND_DSQL.set_cursor(l_denorm_csr);
941: l_stmt_denorm := FND_DSQL.get_text(FALSE);
942: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
943: FND_DSQL.do_binds;
944: l_ignore := DBMS_SQL.execute(l_denorm_csr);

Line 941: l_stmt_denorm := FND_DSQL.get_text(FALSE);

937:
938: IF x_exclude_prod THEN
939: l_denorm_csr := DBMS_SQL.open_cursor;
940: FND_DSQL.set_cursor(l_denorm_csr);
941: l_stmt_denorm := FND_DSQL.get_text(FALSE);
942: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
943: FND_DSQL.do_binds;
944: l_ignore := DBMS_SQL.execute(l_denorm_csr);
945: END IF;

Line 943: FND_DSQL.do_binds;

939: l_denorm_csr := DBMS_SQL.open_cursor;
940: FND_DSQL.set_cursor(l_denorm_csr);
941: l_stmt_denorm := FND_DSQL.get_text(FALSE);
942: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
943: FND_DSQL.do_binds;
944: l_ignore := DBMS_SQL.execute(l_denorm_csr);
945: END IF;
946:
947: EXCEPTION

Line 996: FND_DSQL.init;

992: x_budget_mark := FALSE;
993: x_exclude_mark := FALSE;
994: SAVEPOINT denorm_market_for_one_budget;
995:
996: FND_DSQL.init;
997: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
998: FND_DSQL.add_text('SELECT ''FUND'', ''N'', party_id FROM (');
999:
1000: OPEN c_get_budget_market_qualifiers('N');

Line 997: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');

993: x_exclude_mark := FALSE;
994: SAVEPOINT denorm_market_for_one_budget;
995:
996: FND_DSQL.init;
997: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
998: FND_DSQL.add_text('SELECT ''FUND'', ''N'', party_id FROM (');
999:
1000: OPEN c_get_budget_market_qualifiers('N');
1001:

Line 998: FND_DSQL.add_text('SELECT ''FUND'', ''N'', party_id FROM (');

994: SAVEPOINT denorm_market_for_one_budget;
995:
996: FND_DSQL.init;
997: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
998: FND_DSQL.add_text('SELECT ''FUND'', ''N'', party_id FROM (');
999:
1000: OPEN c_get_budget_market_qualifiers('N');
1001:
1002: -- Get all market qualifiers for 'FUND'

Line 1041: FND_DSQL.add_text('(');

1037: l_attr_value := l_segment_id;
1038:
1039: IF c_get_budget_market_qualifiers%ROWCOUNT = 1 THEN -- for first row.
1040: -- l_budget_product_sql := '(' || l_temp_sql || ')';
1041: FND_DSQL.add_text('(');
1042: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
1043: ( p_context => l_context,
1044: p_attribute => l_attribute,
1045: p_attr_value_from => l_attr_value,

Line 1050: FND_DSQL.add_text(')');

1046: p_attr_value_to => NULL,
1047: p_comparison => '=',
1048: p_type => 'ELIG'
1049: );
1050: FND_DSQL.add_text(')');
1051: ELSE
1052: --l_budget_product_sql := l_budget_product_sql || ' UNION (' || l_temp_sql || ')';
1053: FND_DSQL.add_text('UNION (');
1054: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql

Line 1053: FND_DSQL.add_text('UNION (');

1049: );
1050: FND_DSQL.add_text(')');
1051: ELSE
1052: --l_budget_product_sql := l_budget_product_sql || ' UNION (' || l_temp_sql || ')';
1053: FND_DSQL.add_text('UNION (');
1054: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
1055: ( p_context => l_context,
1056: p_attribute => l_attribute,
1057: p_attr_value_from => l_attr_value,

Line 1062: FND_DSQL.add_text(')');

1058: p_attr_value_to => NULL,
1059: p_comparison => '=',
1060: p_type => 'ELIG'
1061: );
1062: FND_DSQL.add_text(')');
1063: END IF;
1064: ----dbms_output.put_line('budget:' || l_temp_sql );
1065:
1066: END LOOP;

Line 1068: FND_DSQL.add_text(')');

1064: ----dbms_output.put_line('budget:' || l_temp_sql );
1065:
1066: END LOOP;
1067: CLOSE c_get_budget_market_qualifiers;
1068: FND_DSQL.add_text(')');
1069:
1070: IF x_budget_mark THEN
1071: l_denorm_csr := DBMS_SQL.open_cursor;
1072: FND_DSQL.set_cursor(l_denorm_csr);

Line 1072: FND_DSQL.set_cursor(l_denorm_csr);

1068: FND_DSQL.add_text(')');
1069:
1070: IF x_budget_mark THEN
1071: l_denorm_csr := DBMS_SQL.open_cursor;
1072: FND_DSQL.set_cursor(l_denorm_csr);
1073: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1074: -- l_budget_market_sql := l_stmt_denorm;
1075: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1076: FND_DSQL.do_binds;

Line 1073: l_stmt_denorm := FND_DSQL.get_text(FALSE);

1069:
1070: IF x_budget_mark THEN
1071: l_denorm_csr := DBMS_SQL.open_cursor;
1072: FND_DSQL.set_cursor(l_denorm_csr);
1073: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1074: -- l_budget_market_sql := l_stmt_denorm;
1075: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1076: FND_DSQL.do_binds;
1077: l_ignore := DBMS_SQL.execute(l_denorm_csr);

Line 1076: FND_DSQL.do_binds;

1072: FND_DSQL.set_cursor(l_denorm_csr);
1073: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1074: -- l_budget_market_sql := l_stmt_denorm;
1075: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1076: FND_DSQL.do_binds;
1077: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1078: --dbms_output.put_line(l_ignore);
1079: END IF;
1080:

Line 1081: FND_DSQL.init;

1077: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1078: --dbms_output.put_line(l_ignore);
1079: END IF;
1080:
1081: FND_DSQL.init;
1082: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1083: FND_DSQL.add_text('SELECT ''FUND'', ''Y'', party_id FROM (');
1084:
1085: OPEN c_get_budget_market_qualifiers('Y');

Line 1082: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');

1078: --dbms_output.put_line(l_ignore);
1079: END IF;
1080:
1081: FND_DSQL.init;
1082: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1083: FND_DSQL.add_text('SELECT ''FUND'', ''Y'', party_id FROM (');
1084:
1085: OPEN c_get_budget_market_qualifiers('Y');
1086: -- Get all excluded market qualifiers for 'FUND'

Line 1083: FND_DSQL.add_text('SELECT ''FUND'', ''Y'', party_id FROM (');

1079: END IF;
1080:
1081: FND_DSQL.init;
1082: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1083: FND_DSQL.add_text('SELECT ''FUND'', ''Y'', party_id FROM (');
1084:
1085: OPEN c_get_budget_market_qualifiers('Y');
1086: -- Get all excluded market qualifiers for 'FUND'
1087: LOOP

Line 1125: FND_DSQL.add_text('(');

1121: l_attr_value := l_segment_id;
1122:
1123: IF c_get_budget_market_qualifiers%ROWCOUNT = 1 THEN -- for first row.
1124: -- l_budget_product_sql := '(' || l_temp_sql || ')';
1125: FND_DSQL.add_text('(');
1126: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
1127: ( p_context => l_context,
1128: p_attribute => l_attribute,
1129: p_attr_value_from => l_attr_value,

Line 1134: FND_DSQL.add_text(')');

1130: p_attr_value_to => NULL,
1131: p_comparison => '=',
1132: p_type => 'ELIG'
1133: );
1134: FND_DSQL.add_text(')');
1135: ELSE
1136: --l_budget_product_sql := l_budget_product_sql || ' UNION (' || l_temp_sql || ')';
1137: FND_DSQL.add_text('UNION (');
1138: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql

Line 1137: FND_DSQL.add_text('UNION (');

1133: );
1134: FND_DSQL.add_text(')');
1135: ELSE
1136: --l_budget_product_sql := l_budget_product_sql || ' UNION (' || l_temp_sql || ')';
1137: FND_DSQL.add_text('UNION (');
1138: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
1139: ( p_context => l_context,
1140: p_attribute => l_attribute,
1141: p_attr_value_from => l_attr_value,

Line 1146: FND_DSQL.add_text(')');

1142: p_attr_value_to => NULL,
1143: p_comparison => '=',
1144: p_type => 'ELIG'
1145: );
1146: FND_DSQL.add_text(')');
1147: END IF;
1148:
1149: END LOOP;
1150: CLOSE c_get_budget_market_qualifiers;

Line 1151: FND_DSQL.add_text(')');

1147: END IF;
1148:
1149: END LOOP;
1150: CLOSE c_get_budget_market_qualifiers;
1151: FND_DSQL.add_text(')');
1152: IF x_exclude_mark THEN
1153: l_denorm_csr := DBMS_SQL.open_cursor;
1154: FND_DSQL.set_cursor(l_denorm_csr);
1155: l_stmt_denorm := FND_DSQL.get_text(FALSE);

Line 1154: FND_DSQL.set_cursor(l_denorm_csr);

1150: CLOSE c_get_budget_market_qualifiers;
1151: FND_DSQL.add_text(')');
1152: IF x_exclude_mark THEN
1153: l_denorm_csr := DBMS_SQL.open_cursor;
1154: FND_DSQL.set_cursor(l_denorm_csr);
1155: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1156: --dbms_output.put_line('Budget exclude query:' || l_stmt_denorm);
1157: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1158: FND_DSQL.do_binds;

Line 1155: l_stmt_denorm := FND_DSQL.get_text(FALSE);

1151: FND_DSQL.add_text(')');
1152: IF x_exclude_mark THEN
1153: l_denorm_csr := DBMS_SQL.open_cursor;
1154: FND_DSQL.set_cursor(l_denorm_csr);
1155: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1156: --dbms_output.put_line('Budget exclude query:' || l_stmt_denorm);
1157: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1158: FND_DSQL.do_binds;
1159: l_ignore := DBMS_SQL.execute(l_denorm_csr);

Line 1158: FND_DSQL.do_binds;

1154: FND_DSQL.set_cursor(l_denorm_csr);
1155: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1156: --dbms_output.put_line('Budget exclude query:' || l_stmt_denorm);
1157: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1158: FND_DSQL.do_binds;
1159: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1160: --dbms_output.put_line(l_ignore);
1161: END IF;
1162:

Line 1255: FND_DSQL.init;

1251: l_exclude_only := TRUE;
1252: END IF;
1253:
1254:
1255: FND_DSQL.init;
1256: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1257: FND_DSQL.add_text('SELECT ''OFFR'', ''N'', product_id FROM (' );
1258: IF p_offer_type IN ('LUMPSUM', 'SCAN_DATA') THEN
1259: OPEN c_get_products(p_object_id,'OFFR','N');

Line 1256: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');

1252: END IF;
1253:
1254:
1255: FND_DSQL.init;
1256: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1257: FND_DSQL.add_text('SELECT ''OFFR'', ''N'', product_id FROM (' );
1258: IF p_offer_type IN ('LUMPSUM', 'SCAN_DATA') THEN
1259: OPEN c_get_products(p_object_id,'OFFR','N');
1260: LOOP

Line 1257: FND_DSQL.add_text('SELECT ''OFFR'', ''N'', product_id FROM (' );

1253:
1254:
1255: FND_DSQL.init;
1256: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1257: FND_DSQL.add_text('SELECT ''OFFR'', ''N'', product_id FROM (' );
1258: IF p_offer_type IN ('LUMPSUM', 'SCAN_DATA') THEN
1259: OPEN c_get_products(p_object_id,'OFFR','N');
1260: LOOP
1261: FETCH c_get_products INTO l_attr_value,l_excluded_flag,l_attribute;

Line 1269: FND_DSQL.add_text('(');

1265: END IF;
1266:
1267: IF c_get_products%ROWCOUNT = 1 THEN
1268: -- l_offer_product_sql := '(' || l_temp_sql || ')';
1269: FND_DSQL.add_text('(');
1270: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
1271: ( p_context => 'ITEM',
1272: p_attribute => l_attribute,
1273: p_attr_value_from => l_attr_value,

Line 1278: FND_DSQL.add_text(')');

1274: p_attr_value_to => NULL,
1275: p_comparison => NULL,
1276: p_type => 'PROD'
1277: );
1278: FND_DSQL.add_text(')');
1279: ELSE
1280: --l_offer_product_sql := l_offer_product_sql || ' UNION (' || l_temp_sql || ')';
1281: FND_DSQL.add_text('UNION (');
1282: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql

Line 1281: FND_DSQL.add_text('UNION (');

1277: );
1278: FND_DSQL.add_text(')');
1279: ELSE
1280: --l_offer_product_sql := l_offer_product_sql || ' UNION (' || l_temp_sql || ')';
1281: FND_DSQL.add_text('UNION (');
1282: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
1283: ( p_context => 'ITEM',
1284: p_attribute => l_attribute,
1285: p_attr_value_from => l_attr_value,

Line 1290: FND_DSQL.add_text(')');

1286: p_attr_value_to => NULL,
1287: p_comparison => NULL,
1288: p_type => 'PROD'
1289: );
1290: FND_DSQL.add_text(')');
1291: END IF;
1292: END LOOP;
1293: CLOSE c_get_products;
1294:

Line 1315: FND_DSQL.add_text(')');

1311: RAISE fnd_api.G_EXC_ERROR;
1312: END IF;
1313:
1314: END IF;
1315: FND_DSQL.add_text(')');
1316:
1317: IF l_offer_product_sql IS NULL AND l_offer_prod = FALSE THEN
1318: x_return_status := fnd_api.g_ret_sts_success;
1319: x_valid_flag := fnd_api.g_false;

Line 1325: FND_DSQL.set_cursor(l_denorm_csr);

1321: END IF;
1322:
1323: IF l_offer_product_sql IS NOT NULL OR l_offer_prod THEN
1324: l_denorm_csr := DBMS_SQL.open_cursor;
1325: FND_DSQL.set_cursor(l_denorm_csr);
1326: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1327: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1328: FND_DSQL.do_binds;
1329: l_ignore := DBMS_SQL.execute(l_denorm_csr);

Line 1326: l_stmt_denorm := FND_DSQL.get_text(FALSE);

1322:
1323: IF l_offer_product_sql IS NOT NULL OR l_offer_prod THEN
1324: l_denorm_csr := DBMS_SQL.open_cursor;
1325: FND_DSQL.set_cursor(l_denorm_csr);
1326: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1327: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1328: FND_DSQL.do_binds;
1329: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1330: --dbms_output.put_line(l_ignore);

Line 1328: FND_DSQL.do_binds;

1324: l_denorm_csr := DBMS_SQL.open_cursor;
1325: FND_DSQL.set_cursor(l_denorm_csr);
1326: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1327: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1328: FND_DSQL.do_binds;
1329: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1330: --dbms_output.put_line(l_ignore);
1331: END IF;
1332:

Line 1453: FND_DSQL.init;

1449: x_valid_flag := fnd_api.G_TRUE;
1450:
1451: EXECUTE IMMEDIATE 'DELETE FROM ozf_temp_eligibility';
1452:
1453: FND_DSQL.init;
1454: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1455: FND_DSQL.add_text('SELECT ''FUND'', ''N'', product_id FROM (');
1456: -- Get all product qualifiers for 'FUND'
1457: OPEN c_get_budget_products('N');

Line 1454: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');

1450:
1451: EXECUTE IMMEDIATE 'DELETE FROM ozf_temp_eligibility';
1452:
1453: FND_DSQL.init;
1454: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1455: FND_DSQL.add_text('SELECT ''FUND'', ''N'', product_id FROM (');
1456: -- Get all product qualifiers for 'FUND'
1457: OPEN c_get_budget_products('N');
1458: LOOP

Line 1455: FND_DSQL.add_text('SELECT ''FUND'', ''N'', product_id FROM (');

1451: EXECUTE IMMEDIATE 'DELETE FROM ozf_temp_eligibility';
1452:
1453: FND_DSQL.init;
1454: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1455: FND_DSQL.add_text('SELECT ''FUND'', ''N'', product_id FROM (');
1456: -- Get all product qualifiers for 'FUND'
1457: OPEN c_get_budget_products('N');
1458: LOOP
1459: FETCH c_get_budget_products INTO l_attr_value,l_excluded_flag,l_attribute;

Line 1467: FND_DSQL.add_text('(');

1463: l_budget_prod := TRUE;
1464: END IF;
1465:
1466: IF c_get_budget_products%ROWCOUNT = 1 THEN -- for first row.
1467: FND_DSQL.add_text('(');
1468: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
1469: ( p_context => 'ITEM',
1470: p_attribute => l_attribute,
1471: p_attr_value_from => l_attr_value,

Line 1476: FND_DSQL.add_text(')');

1472: p_attr_value_to => NULL,
1473: p_comparison => NULL,
1474: p_type => 'PROD'
1475: );
1476: FND_DSQL.add_text(')');
1477: ELSE
1478: FND_DSQL.add_text('UNION (');
1479: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
1480: ( p_context => 'ITEM',

Line 1478: FND_DSQL.add_text('UNION (');

1474: p_type => 'PROD'
1475: );
1476: FND_DSQL.add_text(')');
1477: ELSE
1478: FND_DSQL.add_text('UNION (');
1479: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
1480: ( p_context => 'ITEM',
1481: p_attribute => l_attribute,
1482: p_attr_value_from => l_attr_value,

Line 1487: FND_DSQL.add_text(')');

1483: p_attr_value_to => NULL,
1484: p_comparison => NULL,
1485: p_type => 'PROD'
1486: );
1487: FND_DSQL.add_text(')');
1488: END IF;
1489: --dbms_output.put_line('validate_product_by_all_lines: budget:');
1490: --dbms_output.put_line('validate_product_by_all_lines: budget:' || l_temp_sql);
1491:

Line 1494: FND_DSQL.add_text(')');

1490: --dbms_output.put_line('validate_product_by_all_lines: budget:' || l_temp_sql);
1491:
1492: END LOOP;
1493: CLOSE c_get_budget_products;
1494: FND_DSQL.add_text(')');
1495:
1496: IF l_budget_prod THEN
1497: l_denorm_csr := DBMS_SQL.open_cursor;
1498: FND_DSQL.set_cursor(l_denorm_csr);

Line 1498: FND_DSQL.set_cursor(l_denorm_csr);

1494: FND_DSQL.add_text(')');
1495:
1496: IF l_budget_prod THEN
1497: l_denorm_csr := DBMS_SQL.open_cursor;
1498: FND_DSQL.set_cursor(l_denorm_csr);
1499: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1500: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1501: FND_DSQL.do_binds;
1502: l_ignore := DBMS_SQL.execute(l_denorm_csr);

Line 1499: l_stmt_denorm := FND_DSQL.get_text(FALSE);

1495:
1496: IF l_budget_prod THEN
1497: l_denorm_csr := DBMS_SQL.open_cursor;
1498: FND_DSQL.set_cursor(l_denorm_csr);
1499: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1500: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1501: FND_DSQL.do_binds;
1502: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1503: --dbms_output.put_line(l_ignore);

Line 1501: FND_DSQL.do_binds;

1497: l_denorm_csr := DBMS_SQL.open_cursor;
1498: FND_DSQL.set_cursor(l_denorm_csr);
1499: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1500: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1501: FND_DSQL.do_binds;
1502: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1503: --dbms_output.put_line(l_ignore);
1504: END IF;
1505:

Line 1506: FND_DSQL.init;

1502: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1503: --dbms_output.put_line(l_ignore);
1504: END IF;
1505:
1506: FND_DSQL.init;
1507: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1508: FND_DSQL.add_text('SELECT ''FUND'', ''Y'', product_id FROM (');
1509: -- for exclude product of FUND.
1510:

Line 1507: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');

1503: --dbms_output.put_line(l_ignore);
1504: END IF;
1505:
1506: FND_DSQL.init;
1507: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1508: FND_DSQL.add_text('SELECT ''FUND'', ''Y'', product_id FROM (');
1509: -- for exclude product of FUND.
1510:
1511: OPEN c_get_budget_products('Y');

Line 1508: FND_DSQL.add_text('SELECT ''FUND'', ''Y'', product_id FROM (');

1504: END IF;
1505:
1506: FND_DSQL.init;
1507: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1508: FND_DSQL.add_text('SELECT ''FUND'', ''Y'', product_id FROM (');
1509: -- for exclude product of FUND.
1510:
1511: OPEN c_get_budget_products('Y');
1512: LOOP

Line 1522: FND_DSQL.add_text('(');

1518: END IF;
1519:
1520: IF c_get_budget_products%ROWCOUNT = 1 THEN
1521: -- l_exclude_sql := '(' || l_temp_sql || ')';
1522: FND_DSQL.add_text('(');
1523: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
1524: ( p_context => 'ITEM',
1525: p_attribute => l_attribute,
1526: p_attr_value_from => l_attr_value,

Line 1531: FND_DSQL.add_text(')');

1527: p_attr_value_to => NULL,
1528: p_comparison => NULL,
1529: p_type => 'PROD'
1530: );
1531: FND_DSQL.add_text(')');
1532: ELSE
1533: --l_exclude_sql := l_exclude_sql || ' UNION (' || l_temp_sql || ')';
1534: FND_DSQL.add_text('UNION (');
1535: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql

Line 1534: FND_DSQL.add_text('UNION (');

1530: );
1531: FND_DSQL.add_text(')');
1532: ELSE
1533: --l_exclude_sql := l_exclude_sql || ' UNION (' || l_temp_sql || ')';
1534: FND_DSQL.add_text('UNION (');
1535: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
1536: ( p_context => 'ITEM',
1537: p_attribute => l_attribute,
1538: p_attr_value_from => l_attr_value,

Line 1543: FND_DSQL.add_text(')');

1539: p_attr_value_to => NULL,
1540: p_comparison => NULL,
1541: p_type => 'PROD'
1542: );
1543: FND_DSQL.add_text(')');
1544: END IF;
1545:
1546: END LOOP;
1547: CLOSE c_get_budget_products;

Line 1548: FND_DSQL.add_text(')');

1544: END IF;
1545:
1546: END LOOP;
1547: CLOSE c_get_budget_products;
1548: FND_DSQL.add_text(')');
1549:
1550: IF l_exclude_prod THEN
1551: l_denorm_csr := DBMS_SQL.open_cursor;
1552: FND_DSQL.set_cursor(l_denorm_csr);

Line 1552: FND_DSQL.set_cursor(l_denorm_csr);

1548: FND_DSQL.add_text(')');
1549:
1550: IF l_exclude_prod THEN
1551: l_denorm_csr := DBMS_SQL.open_cursor;
1552: FND_DSQL.set_cursor(l_denorm_csr);
1553: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1554: --dbms_output.put_line('validate_product_by_all_lines: in budget exclude');
1555: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1556: FND_DSQL.do_binds;

Line 1553: l_stmt_denorm := FND_DSQL.get_text(FALSE);

1549:
1550: IF l_exclude_prod THEN
1551: l_denorm_csr := DBMS_SQL.open_cursor;
1552: FND_DSQL.set_cursor(l_denorm_csr);
1553: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1554: --dbms_output.put_line('validate_product_by_all_lines: in budget exclude');
1555: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1556: FND_DSQL.do_binds;
1557: l_ignore := DBMS_SQL.execute(l_denorm_csr);

Line 1556: FND_DSQL.do_binds;

1552: FND_DSQL.set_cursor(l_denorm_csr);
1553: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1554: --dbms_output.put_line('validate_product_by_all_lines: in budget exclude');
1555: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1556: FND_DSQL.do_binds;
1557: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1558: --dbms_output.put_line(l_ignore);
1559: END IF;
1560: -- not product eligibility for budget, validation is true.

Line 1571: FND_DSQL.init;

1567: IF l_budget_prod = FALSE AND l_exclude_prod = TRUE THEN
1568: l_exclude_only := TRUE;
1569: END IF;
1570:
1571: FND_DSQL.init;
1572: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1573: FND_DSQL.add_text('SELECT ''OFFR'', ''N'', product_id FROM (' );
1574: IF p_offer_type IN ('LUMPSUM', 'SCAN_DATA') THEN
1575: OPEN c_get_offer_products;

Line 1572: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');

1568: l_exclude_only := TRUE;
1569: END IF;
1570:
1571: FND_DSQL.init;
1572: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1573: FND_DSQL.add_text('SELECT ''OFFR'', ''N'', product_id FROM (' );
1574: IF p_offer_type IN ('LUMPSUM', 'SCAN_DATA') THEN
1575: OPEN c_get_offer_products;
1576: LOOP

Line 1573: FND_DSQL.add_text('SELECT ''OFFR'', ''N'', product_id FROM (' );

1569: END IF;
1570:
1571: FND_DSQL.init;
1572: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1573: FND_DSQL.add_text('SELECT ''OFFR'', ''N'', product_id FROM (' );
1574: IF p_offer_type IN ('LUMPSUM', 'SCAN_DATA') THEN
1575: OPEN c_get_offer_products;
1576: LOOP
1577: FETCH c_get_offer_products INTO l_attr_value,l_excluded_flag,l_attribute;

Line 1585: FND_DSQL.add_text('(');

1581: END IF;
1582:
1583: IF c_get_offer_products%ROWCOUNT = 1 THEN
1584: -- l_offer_product_sql := '(' || l_temp_sql || ')';
1585: FND_DSQL.add_text('(');
1586: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
1587: ( p_context => 'ITEM',
1588: p_attribute => l_attribute,
1589: p_attr_value_from => l_attr_value,

Line 1594: FND_DSQL.add_text(')');

1590: p_attr_value_to => NULL,
1591: p_comparison => NULL,
1592: p_type => 'PROD'
1593: );
1594: FND_DSQL.add_text(')');
1595: ELSE
1596: --l_offer_product_sql := l_offer_product_sql || ' UNION (' || l_temp_sql || ')';
1597: FND_DSQL.add_text('UNION (');
1598: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql

Line 1597: FND_DSQL.add_text('UNION (');

1593: );
1594: FND_DSQL.add_text(')');
1595: ELSE
1596: --l_offer_product_sql := l_offer_product_sql || ' UNION (' || l_temp_sql || ')';
1597: FND_DSQL.add_text('UNION (');
1598: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
1599: ( p_context => 'ITEM',
1600: p_attribute => l_attribute,
1601: p_attr_value_from => l_attr_value,

Line 1606: FND_DSQL.add_text(')');

1602: p_attr_value_to => NULL,
1603: p_comparison => NULL,
1604: p_type => 'PROD'
1605: );
1606: FND_DSQL.add_text(')');
1607: END IF;
1608: END LOOP;
1609: CLOSE c_get_offer_products;
1610:

Line 1629: FND_DSQL.add_text(')');

1625: x_return_status := l_return_status;
1626: RAISE fnd_api.G_EXC_ERROR;
1627: END IF;
1628: END IF;
1629: FND_DSQL.add_text(')');
1630:
1631: IF l_offer_product_sql IS NULL AND l_offer_prod = FALSE THEN
1632: x_return_status := fnd_api.g_ret_sts_success;
1633: x_valid_flag := fnd_api.g_false;

Line 1639: FND_DSQL.set_cursor(l_denorm_csr);

1635: END IF;
1636:
1637: IF l_offer_product_sql IS NOT NULL OR l_offer_prod THEN
1638: l_denorm_csr := DBMS_SQL.open_cursor;
1639: FND_DSQL.set_cursor(l_denorm_csr);
1640: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1641: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1642: FND_DSQL.do_binds;
1643: l_ignore := DBMS_SQL.execute(l_denorm_csr);

Line 1640: l_stmt_denorm := FND_DSQL.get_text(FALSE);

1636:
1637: IF l_offer_product_sql IS NOT NULL OR l_offer_prod THEN
1638: l_denorm_csr := DBMS_SQL.open_cursor;
1639: FND_DSQL.set_cursor(l_denorm_csr);
1640: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1641: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1642: FND_DSQL.do_binds;
1643: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1644: --dbms_output.put_line(l_ignore);

Line 1642: FND_DSQL.do_binds;

1638: l_denorm_csr := DBMS_SQL.open_cursor;
1639: FND_DSQL.set_cursor(l_denorm_csr);
1640: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1641: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1642: FND_DSQL.do_binds;
1643: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1644: --dbms_output.put_line(l_ignore);
1645: END IF;
1646:

Line 1787: FND_DSQL.init;

1783: OPEN c_get_offer_customer;
1784: FETCH c_get_offer_customer INTO l_offer_type, l_offer_qualifier_id;
1785: CLOSE c_get_offer_customer;
1786:
1787: FND_DSQL.init;
1788: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1789: FND_DSQL.add_text('SELECT ''OFFR'', ''N'', party_id FROM (' );
1790:
1791: IF l_offer_type IN ('LUMPSUM', 'SCAN_DATA') THEN

Line 1788: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');

1784: FETCH c_get_offer_customer INTO l_offer_type, l_offer_qualifier_id;
1785: CLOSE c_get_offer_customer;
1786:
1787: FND_DSQL.init;
1788: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1789: FND_DSQL.add_text('SELECT ''OFFR'', ''N'', party_id FROM (' );
1790:
1791: IF l_offer_type IN ('LUMPSUM', 'SCAN_DATA') THEN
1792: -- for lumpsum and scandata, market eligibility can be only one customer

Line 1789: FND_DSQL.add_text('SELECT ''OFFR'', ''N'', party_id FROM (' );

1785: CLOSE c_get_offer_customer;
1786:
1787: FND_DSQL.init;
1788: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1789: FND_DSQL.add_text('SELECT ''OFFR'', ''N'', party_id FROM (' );
1790:
1791: IF l_offer_type IN ('LUMPSUM', 'SCAN_DATA') THEN
1792: -- for lumpsum and scandata, market eligibility can be only one customer
1793: IF l_offer_qualifier_id IS NULL THEN

Line 1831: FND_DSQL.add_text(')');

1827: x_return_status := l_return_status;
1828: RAISE fnd_api.G_EXC_ERROR;
1829: END IF;
1830: END IF;
1831: FND_DSQL.add_text(')');
1832:
1833: IF l_offer_market_sql IS NULL AND l_offer_mark = FALSE THEN
1834: x_return_status := fnd_api.g_ret_sts_success;
1835: x_valid_flag := fnd_api.g_false;

Line 1839: FND_DSQL.set_cursor(l_denorm_csr);

1835: x_valid_flag := fnd_api.g_false;
1836: RETURN;
1837: ELSE
1838: l_denorm_csr := DBMS_SQL.open_cursor;
1839: FND_DSQL.set_cursor(l_denorm_csr);
1840: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1841: --dbms_output.put_line('offer query: '|| l_stmt_denorm);
1842: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1843: l_offer_market_sql := l_stmt_denorm;

Line 1840: l_stmt_denorm := FND_DSQL.get_text(FALSE);

1836: RETURN;
1837: ELSE
1838: l_denorm_csr := DBMS_SQL.open_cursor;
1839: FND_DSQL.set_cursor(l_denorm_csr);
1840: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1841: --dbms_output.put_line('offer query: '|| l_stmt_denorm);
1842: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1843: l_offer_market_sql := l_stmt_denorm;
1844: FND_DSQL.do_binds;

Line 1844: FND_DSQL.do_binds;

1840: l_stmt_denorm := FND_DSQL.get_text(FALSE);
1841: --dbms_output.put_line('offer query: '|| l_stmt_denorm);
1842: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
1843: l_offer_market_sql := l_stmt_denorm;
1844: FND_DSQL.do_binds;
1845: l_ignore := DBMS_SQL.execute(l_denorm_csr);
1846: --dbms_output.put_line(l_ignore);
1847: END IF;
1848:

Line 1972: FND_DSQL.init;

1968: --set_budget_org(p_budget_id => p_actbudget_id);
1969:
1970: EXECUTE IMMEDIATE 'DELETE FROM ozf_temp_eligibility';
1971:
1972: FND_DSQL.init;
1973: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1974: FND_DSQL.add_text('SELECT ''FUND'', ''N'', party_id FROM (');
1975:
1976: OPEN c_get_budget_market_qualifiers('N');

Line 1973: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');

1969:
1970: EXECUTE IMMEDIATE 'DELETE FROM ozf_temp_eligibility';
1971:
1972: FND_DSQL.init;
1973: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1974: FND_DSQL.add_text('SELECT ''FUND'', ''N'', party_id FROM (');
1975:
1976: OPEN c_get_budget_market_qualifiers('N');
1977:

Line 1974: FND_DSQL.add_text('SELECT ''FUND'', ''N'', party_id FROM (');

1970: EXECUTE IMMEDIATE 'DELETE FROM ozf_temp_eligibility';
1971:
1972: FND_DSQL.init;
1973: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
1974: FND_DSQL.add_text('SELECT ''FUND'', ''N'', party_id FROM (');
1975:
1976: OPEN c_get_budget_market_qualifiers('N');
1977:
1978: -- Get all market qualifiers for 'FUND'

Line 2016: FND_DSQL.add_text('(');

2012: l_attr_value := l_segment_id;
2013:
2014: IF c_get_budget_market_qualifiers%ROWCOUNT = 1 THEN -- for first row.
2015: -- l_budget_product_sql := '(' || l_temp_sql || ')';
2016: FND_DSQL.add_text('(');
2017: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
2018: ( p_context => l_context,
2019: p_attribute => l_attribute,
2020: p_attr_value_from => l_attr_value,

Line 2025: FND_DSQL.add_text(')');

2021: p_attr_value_to => NULL,
2022: p_comparison => '=',
2023: p_type => 'ELIG'
2024: );
2025: FND_DSQL.add_text(')');
2026: ELSE
2027: --l_budget_product_sql := l_budget_product_sql || ' UNION (' || l_temp_sql || ')';
2028: FND_DSQL.add_text('UNION (');
2029: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql

Line 2028: FND_DSQL.add_text('UNION (');

2024: );
2025: FND_DSQL.add_text(')');
2026: ELSE
2027: --l_budget_product_sql := l_budget_product_sql || ' UNION (' || l_temp_sql || ')';
2028: FND_DSQL.add_text('UNION (');
2029: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
2030: ( p_context => l_context,
2031: p_attribute => l_attribute,
2032: p_attr_value_from => l_attr_value,

Line 2037: FND_DSQL.add_text(')');

2033: p_attr_value_to => NULL,
2034: p_comparison => '=',
2035: p_type => 'ELIG'
2036: );
2037: FND_DSQL.add_text(')');
2038: END IF;
2039: --dbms_output.put_line('validate_market_by_all_lines: budget:' || l_temp_sql );
2040:
2041: END LOOP;

Line 2043: FND_DSQL.add_text(')');

2039: --dbms_output.put_line('validate_market_by_all_lines: budget:' || l_temp_sql );
2040:
2041: END LOOP;
2042: CLOSE c_get_budget_market_qualifiers;
2043: FND_DSQL.add_text(')');
2044:
2045: IF l_budget_mark THEN
2046: l_denorm_csr := DBMS_SQL.open_cursor;
2047: FND_DSQL.set_cursor(l_denorm_csr);

Line 2047: FND_DSQL.set_cursor(l_denorm_csr);

2043: FND_DSQL.add_text(')');
2044:
2045: IF l_budget_mark THEN
2046: l_denorm_csr := DBMS_SQL.open_cursor;
2047: FND_DSQL.set_cursor(l_denorm_csr);
2048: l_stmt_denorm := FND_DSQL.get_text(FALSE);
2049: l_budget_market_sql := l_stmt_denorm;
2050: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
2051: FND_DSQL.do_binds;

Line 2048: l_stmt_denorm := FND_DSQL.get_text(FALSE);

2044:
2045: IF l_budget_mark THEN
2046: l_denorm_csr := DBMS_SQL.open_cursor;
2047: FND_DSQL.set_cursor(l_denorm_csr);
2048: l_stmt_denorm := FND_DSQL.get_text(FALSE);
2049: l_budget_market_sql := l_stmt_denorm;
2050: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
2051: FND_DSQL.do_binds;
2052: l_ignore := DBMS_SQL.execute(l_denorm_csr);

Line 2051: FND_DSQL.do_binds;

2047: FND_DSQL.set_cursor(l_denorm_csr);
2048: l_stmt_denorm := FND_DSQL.get_text(FALSE);
2049: l_budget_market_sql := l_stmt_denorm;
2050: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
2051: FND_DSQL.do_binds;
2052: l_ignore := DBMS_SQL.execute(l_denorm_csr);
2053: --dbms_output.put_line(l_ignore);
2054: END IF;
2055:

Line 2056: FND_DSQL.init;

2052: l_ignore := DBMS_SQL.execute(l_denorm_csr);
2053: --dbms_output.put_line(l_ignore);
2054: END IF;
2055:
2056: FND_DSQL.init;
2057: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
2058: FND_DSQL.add_text('SELECT ''FUND'', ''Y'', party_id FROM (');
2059:
2060: OPEN c_get_budget_market_qualifiers('Y');

Line 2057: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');

2053: --dbms_output.put_line(l_ignore);
2054: END IF;
2055:
2056: FND_DSQL.init;
2057: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
2058: FND_DSQL.add_text('SELECT ''FUND'', ''Y'', party_id FROM (');
2059:
2060: OPEN c_get_budget_market_qualifiers('Y');
2061: -- Get all excluded market qualifiers for 'FUND'

Line 2058: FND_DSQL.add_text('SELECT ''FUND'', ''Y'', party_id FROM (');

2054: END IF;
2055:
2056: FND_DSQL.init;
2057: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
2058: FND_DSQL.add_text('SELECT ''FUND'', ''Y'', party_id FROM (');
2059:
2060: OPEN c_get_budget_market_qualifiers('Y');
2061: -- Get all excluded market qualifiers for 'FUND'
2062: LOOP

Line 2099: FND_DSQL.add_text('(');

2095: l_attr_value := l_segment_id;
2096:
2097: IF c_get_budget_market_qualifiers%ROWCOUNT = 1 THEN -- for first row.
2098: -- l_budget_product_sql := '(' || l_temp_sql || ')';
2099: FND_DSQL.add_text('(');
2100: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
2101: ( p_context => l_context,
2102: p_attribute => l_attribute,
2103: p_attr_value_from => l_attr_value,

Line 2108: FND_DSQL.add_text(')');

2104: p_attr_value_to => NULL,
2105: p_comparison => '=',
2106: p_type => 'ELIG'
2107: );
2108: FND_DSQL.add_text(')');
2109: ELSE
2110: --l_budget_product_sql := l_budget_product_sql || ' UNION (' || l_temp_sql || ')';
2111: FND_DSQL.add_text('UNION (');
2112: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql

Line 2111: FND_DSQL.add_text('UNION (');

2107: );
2108: FND_DSQL.add_text(')');
2109: ELSE
2110: --l_budget_product_sql := l_budget_product_sql || ' UNION (' || l_temp_sql || ')';
2111: FND_DSQL.add_text('UNION (');
2112: l_temp_sql := OZF_OFFR_ELIG_PROD_DENORM_PVT.get_sql
2113: ( p_context => l_context,
2114: p_attribute => l_attribute,
2115: p_attr_value_from => l_attr_value,

Line 2120: FND_DSQL.add_text(')');

2116: p_attr_value_to => NULL,
2117: p_comparison => '=',
2118: p_type => 'ELIG'
2119: );
2120: FND_DSQL.add_text(')');
2121: END IF;
2122:
2123: END LOOP;
2124: CLOSE c_get_budget_market_qualifiers;

Line 2125: FND_DSQL.add_text(')');

2121: END IF;
2122:
2123: END LOOP;
2124: CLOSE c_get_budget_market_qualifiers;
2125: FND_DSQL.add_text(')');
2126:
2127: IF l_exclude_mark THEN
2128: l_denorm_csr := DBMS_SQL.open_cursor;
2129: FND_DSQL.set_cursor(l_denorm_csr);

Line 2129: FND_DSQL.set_cursor(l_denorm_csr);

2125: FND_DSQL.add_text(')');
2126:
2127: IF l_exclude_mark THEN
2128: l_denorm_csr := DBMS_SQL.open_cursor;
2129: FND_DSQL.set_cursor(l_denorm_csr);
2130: l_stmt_denorm := FND_DSQL.get_text(FALSE);
2131: --dbms_output.put_line('validate_market_by_all_lines: Budget exclude query:' || l_stmt_denorm);
2132: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
2133: FND_DSQL.do_binds;

Line 2130: l_stmt_denorm := FND_DSQL.get_text(FALSE);

2126:
2127: IF l_exclude_mark THEN
2128: l_denorm_csr := DBMS_SQL.open_cursor;
2129: FND_DSQL.set_cursor(l_denorm_csr);
2130: l_stmt_denorm := FND_DSQL.get_text(FALSE);
2131: --dbms_output.put_line('validate_market_by_all_lines: Budget exclude query:' || l_stmt_denorm);
2132: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
2133: FND_DSQL.do_binds;
2134: l_ignore := DBMS_SQL.execute(l_denorm_csr);

Line 2133: FND_DSQL.do_binds;

2129: FND_DSQL.set_cursor(l_denorm_csr);
2130: l_stmt_denorm := FND_DSQL.get_text(FALSE);
2131: --dbms_output.put_line('validate_market_by_all_lines: Budget exclude query:' || l_stmt_denorm);
2132: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
2133: FND_DSQL.do_binds;
2134: l_ignore := DBMS_SQL.execute(l_denorm_csr);
2135: --dbms_output.put_line(l_ignore);
2136: END IF;
2137: -- not product eligibility for budget, validation is true.

Line 2155: FND_DSQL.init;

2151: OPEN c_get_offer_customer;
2152: FETCH c_get_offer_customer INTO l_offer_type, l_offer_qualifier_id;
2153: CLOSE c_get_offer_customer;
2154:
2155: FND_DSQL.init;
2156: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
2157: FND_DSQL.add_text('SELECT ''OFFR'', ''N'', party_id FROM (' );
2158:
2159: IF l_offer_type IN ('LUMPSUM', 'SCAN_DATA') THEN

Line 2156: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');

2152: FETCH c_get_offer_customer INTO l_offer_type, l_offer_qualifier_id;
2153: CLOSE c_get_offer_customer;
2154:
2155: FND_DSQL.init;
2156: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
2157: FND_DSQL.add_text('SELECT ''OFFR'', ''N'', party_id FROM (' );
2158:
2159: IF l_offer_type IN ('LUMPSUM', 'SCAN_DATA') THEN
2160: -- for lumpsum and scandata, market eligibility can be only one customer

Line 2157: FND_DSQL.add_text('SELECT ''OFFR'', ''N'', party_id FROM (' );

2153: CLOSE c_get_offer_customer;
2154:
2155: FND_DSQL.init;
2156: FND_DSQL.add_text('INSERT INTO ozf_temp_eligibility(object_type, exclude_flag, eligibility_id) ');
2157: FND_DSQL.add_text('SELECT ''OFFR'', ''N'', party_id FROM (' );
2158:
2159: IF l_offer_type IN ('LUMPSUM', 'SCAN_DATA') THEN
2160: -- for lumpsum and scandata, market eligibility can be only one customer
2161: IF l_offer_qualifier_id IS NULL THEN

Line 2200: FND_DSQL.add_text(')');

2196: x_return_status := l_return_status;
2197: RAISE fnd_api.G_EXC_ERROR;
2198: END IF;
2199: END IF;
2200: FND_DSQL.add_text(')');
2201:
2202: IF l_offer_market_sql IS NULL AND l_offer_mark = FALSE THEN
2203: x_return_status := fnd_api.g_ret_sts_success;
2204: x_valid_flag := fnd_api.g_false;

Line 2208: FND_DSQL.set_cursor(l_denorm_csr);

2204: x_valid_flag := fnd_api.g_false;
2205: RETURN;
2206: ELSE
2207: l_denorm_csr := DBMS_SQL.open_cursor;
2208: FND_DSQL.set_cursor(l_denorm_csr);
2209: l_stmt_denorm := FND_DSQL.get_text(FALSE);
2210: --dbms_output.put_line('validate_market_by_all_lines: offer query: '|| l_stmt_denorm);
2211: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
2212: l_offer_market_sql := l_stmt_denorm;

Line 2209: l_stmt_denorm := FND_DSQL.get_text(FALSE);

2205: RETURN;
2206: ELSE
2207: l_denorm_csr := DBMS_SQL.open_cursor;
2208: FND_DSQL.set_cursor(l_denorm_csr);
2209: l_stmt_denorm := FND_DSQL.get_text(FALSE);
2210: --dbms_output.put_line('validate_market_by_all_lines: offer query: '|| l_stmt_denorm);
2211: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
2212: l_offer_market_sql := l_stmt_denorm;
2213: FND_DSQL.do_binds;

Line 2213: FND_DSQL.do_binds;

2209: l_stmt_denorm := FND_DSQL.get_text(FALSE);
2210: --dbms_output.put_line('validate_market_by_all_lines: offer query: '|| l_stmt_denorm);
2211: DBMS_SQL.parse(l_denorm_csr, l_stmt_denorm, DBMS_SQL.native);
2212: l_offer_market_sql := l_stmt_denorm;
2213: FND_DSQL.do_binds;
2214: l_ignore := DBMS_SQL.execute(l_denorm_csr);
2215: --dbms_output.put_line(l_ignore);
2216: END IF;
2217: