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.AST_GRP_CAMP_PVT dependencies on DBMS_SQL

Line 676: dbms_sql.define_column(p_cur_get_grp_camp, 1, P_grp_camp_Rec.GROUP_CAMPAIGN_ID);

672: -- Debug Message
673: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: Define Columns Begins');
674:
675: -- define all columns for AST_GRP_TEST view
676: dbms_sql.define_column(p_cur_get_grp_camp, 1, P_grp_camp_Rec.GROUP_CAMPAIGN_ID);
677: dbms_sql.define_column(p_cur_get_grp_camp, 2, P_grp_camp_Rec.GROUP_ID);
678: dbms_sql.define_column(p_cur_get_grp_camp, 3, P_grp_camp_Rec.CAMPAIGN_ID);
679: dbms_sql.define_column(p_cur_get_grp_camp, 4, P_grp_camp_Rec.START_DATE);
680: dbms_sql.define_column(p_cur_get_grp_camp, 5, P_grp_camp_Rec.END_DATE);

Line 677: dbms_sql.define_column(p_cur_get_grp_camp, 2, P_grp_camp_Rec.GROUP_ID);

673: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: Define Columns Begins');
674:
675: -- define all columns for AST_GRP_TEST view
676: dbms_sql.define_column(p_cur_get_grp_camp, 1, P_grp_camp_Rec.GROUP_CAMPAIGN_ID);
677: dbms_sql.define_column(p_cur_get_grp_camp, 2, P_grp_camp_Rec.GROUP_ID);
678: dbms_sql.define_column(p_cur_get_grp_camp, 3, P_grp_camp_Rec.CAMPAIGN_ID);
679: dbms_sql.define_column(p_cur_get_grp_camp, 4, P_grp_camp_Rec.START_DATE);
680: dbms_sql.define_column(p_cur_get_grp_camp, 5, P_grp_camp_Rec.END_DATE);
681: dbms_sql.define_column(p_cur_get_grp_camp, 6, P_grp_camp_Rec.ENABLED_FLAG, 1);

Line 678: dbms_sql.define_column(p_cur_get_grp_camp, 3, P_grp_camp_Rec.CAMPAIGN_ID);

674:
675: -- define all columns for AST_GRP_TEST view
676: dbms_sql.define_column(p_cur_get_grp_camp, 1, P_grp_camp_Rec.GROUP_CAMPAIGN_ID);
677: dbms_sql.define_column(p_cur_get_grp_camp, 2, P_grp_camp_Rec.GROUP_ID);
678: dbms_sql.define_column(p_cur_get_grp_camp, 3, P_grp_camp_Rec.CAMPAIGN_ID);
679: dbms_sql.define_column(p_cur_get_grp_camp, 4, P_grp_camp_Rec.START_DATE);
680: dbms_sql.define_column(p_cur_get_grp_camp, 5, P_grp_camp_Rec.END_DATE);
681: dbms_sql.define_column(p_cur_get_grp_camp, 6, P_grp_camp_Rec.ENABLED_FLAG, 1);
682:

Line 679: dbms_sql.define_column(p_cur_get_grp_camp, 4, P_grp_camp_Rec.START_DATE);

675: -- define all columns for AST_GRP_TEST view
676: dbms_sql.define_column(p_cur_get_grp_camp, 1, P_grp_camp_Rec.GROUP_CAMPAIGN_ID);
677: dbms_sql.define_column(p_cur_get_grp_camp, 2, P_grp_camp_Rec.GROUP_ID);
678: dbms_sql.define_column(p_cur_get_grp_camp, 3, P_grp_camp_Rec.CAMPAIGN_ID);
679: dbms_sql.define_column(p_cur_get_grp_camp, 4, P_grp_camp_Rec.START_DATE);
680: dbms_sql.define_column(p_cur_get_grp_camp, 5, P_grp_camp_Rec.END_DATE);
681: dbms_sql.define_column(p_cur_get_grp_camp, 6, P_grp_camp_Rec.ENABLED_FLAG, 1);
682:
683: -- Debug Message

Line 680: dbms_sql.define_column(p_cur_get_grp_camp, 5, P_grp_camp_Rec.END_DATE);

676: dbms_sql.define_column(p_cur_get_grp_camp, 1, P_grp_camp_Rec.GROUP_CAMPAIGN_ID);
677: dbms_sql.define_column(p_cur_get_grp_camp, 2, P_grp_camp_Rec.GROUP_ID);
678: dbms_sql.define_column(p_cur_get_grp_camp, 3, P_grp_camp_Rec.CAMPAIGN_ID);
679: dbms_sql.define_column(p_cur_get_grp_camp, 4, P_grp_camp_Rec.START_DATE);
680: dbms_sql.define_column(p_cur_get_grp_camp, 5, P_grp_camp_Rec.END_DATE);
681: dbms_sql.define_column(p_cur_get_grp_camp, 6, P_grp_camp_Rec.ENABLED_FLAG, 1);
682:
683: -- Debug Message
684: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: Define Columns Ends');

Line 681: dbms_sql.define_column(p_cur_get_grp_camp, 6, P_grp_camp_Rec.ENABLED_FLAG, 1);

677: dbms_sql.define_column(p_cur_get_grp_camp, 2, P_grp_camp_Rec.GROUP_ID);
678: dbms_sql.define_column(p_cur_get_grp_camp, 3, P_grp_camp_Rec.CAMPAIGN_ID);
679: dbms_sql.define_column(p_cur_get_grp_camp, 4, P_grp_camp_Rec.START_DATE);
680: dbms_sql.define_column(p_cur_get_grp_camp, 5, P_grp_camp_Rec.END_DATE);
681: dbms_sql.define_column(p_cur_get_grp_camp, 6, P_grp_camp_Rec.ENABLED_FLAG, 1);
682:
683: -- Debug Message
684: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: Define Columns Ends');
685: END Define_Columns;

Line 698: dbms_sql.column_value(p_cur_get_grp_camp, 1, X_grp_camp_Rec.GROUP_CAMPAIGN_ID);

694: -- Debug Message
695: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: Get Column Values Begins');
696:
697: -- get all column values for AST_GRP_TEST table
698: dbms_sql.column_value(p_cur_get_grp_camp, 1, X_grp_camp_Rec.GROUP_CAMPAIGN_ID);
699: dbms_sql.column_value(p_cur_get_grp_camp, 2, X_grp_camp_Rec.GROUP_ID);
700: dbms_sql.column_value(p_cur_get_grp_camp, 3, X_grp_camp_Rec.CAMPAIGN_ID);
701: dbms_sql.column_value(p_cur_get_grp_camp, 4, X_grp_camp_Rec.START_DATE);
702: dbms_sql.column_value(p_cur_get_grp_camp, 5, X_grp_camp_Rec.END_DATE);

Line 699: dbms_sql.column_value(p_cur_get_grp_camp, 2, X_grp_camp_Rec.GROUP_ID);

695: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: Get Column Values Begins');
696:
697: -- get all column values for AST_GRP_TEST table
698: dbms_sql.column_value(p_cur_get_grp_camp, 1, X_grp_camp_Rec.GROUP_CAMPAIGN_ID);
699: dbms_sql.column_value(p_cur_get_grp_camp, 2, X_grp_camp_Rec.GROUP_ID);
700: dbms_sql.column_value(p_cur_get_grp_camp, 3, X_grp_camp_Rec.CAMPAIGN_ID);
701: dbms_sql.column_value(p_cur_get_grp_camp, 4, X_grp_camp_Rec.START_DATE);
702: dbms_sql.column_value(p_cur_get_grp_camp, 5, X_grp_camp_Rec.END_DATE);
703: dbms_sql.column_value(p_cur_get_grp_camp, 6, X_grp_camp_Rec.ENABLED_FLAG);

Line 700: dbms_sql.column_value(p_cur_get_grp_camp, 3, X_grp_camp_Rec.CAMPAIGN_ID);

696:
697: -- get all column values for AST_GRP_TEST table
698: dbms_sql.column_value(p_cur_get_grp_camp, 1, X_grp_camp_Rec.GROUP_CAMPAIGN_ID);
699: dbms_sql.column_value(p_cur_get_grp_camp, 2, X_grp_camp_Rec.GROUP_ID);
700: dbms_sql.column_value(p_cur_get_grp_camp, 3, X_grp_camp_Rec.CAMPAIGN_ID);
701: dbms_sql.column_value(p_cur_get_grp_camp, 4, X_grp_camp_Rec.START_DATE);
702: dbms_sql.column_value(p_cur_get_grp_camp, 5, X_grp_camp_Rec.END_DATE);
703: dbms_sql.column_value(p_cur_get_grp_camp, 6, X_grp_camp_Rec.ENABLED_FLAG);
704:

Line 701: dbms_sql.column_value(p_cur_get_grp_camp, 4, X_grp_camp_Rec.START_DATE);

697: -- get all column values for AST_GRP_TEST table
698: dbms_sql.column_value(p_cur_get_grp_camp, 1, X_grp_camp_Rec.GROUP_CAMPAIGN_ID);
699: dbms_sql.column_value(p_cur_get_grp_camp, 2, X_grp_camp_Rec.GROUP_ID);
700: dbms_sql.column_value(p_cur_get_grp_camp, 3, X_grp_camp_Rec.CAMPAIGN_ID);
701: dbms_sql.column_value(p_cur_get_grp_camp, 4, X_grp_camp_Rec.START_DATE);
702: dbms_sql.column_value(p_cur_get_grp_camp, 5, X_grp_camp_Rec.END_DATE);
703: dbms_sql.column_value(p_cur_get_grp_camp, 6, X_grp_camp_Rec.ENABLED_FLAG);
704:
705: -- Debug Message

Line 702: dbms_sql.column_value(p_cur_get_grp_camp, 5, X_grp_camp_Rec.END_DATE);

698: dbms_sql.column_value(p_cur_get_grp_camp, 1, X_grp_camp_Rec.GROUP_CAMPAIGN_ID);
699: dbms_sql.column_value(p_cur_get_grp_camp, 2, X_grp_camp_Rec.GROUP_ID);
700: dbms_sql.column_value(p_cur_get_grp_camp, 3, X_grp_camp_Rec.CAMPAIGN_ID);
701: dbms_sql.column_value(p_cur_get_grp_camp, 4, X_grp_camp_Rec.START_DATE);
702: dbms_sql.column_value(p_cur_get_grp_camp, 5, X_grp_camp_Rec.END_DATE);
703: dbms_sql.column_value(p_cur_get_grp_camp, 6, X_grp_camp_Rec.ENABLED_FLAG);
704:
705: -- Debug Message
706: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: Get Column Values Ends');

Line 703: dbms_sql.column_value(p_cur_get_grp_camp, 6, X_grp_camp_Rec.ENABLED_FLAG);

699: dbms_sql.column_value(p_cur_get_grp_camp, 2, X_grp_camp_Rec.GROUP_ID);
700: dbms_sql.column_value(p_cur_get_grp_camp, 3, X_grp_camp_Rec.CAMPAIGN_ID);
701: dbms_sql.column_value(p_cur_get_grp_camp, 4, X_grp_camp_Rec.START_DATE);
702: dbms_sql.column_value(p_cur_get_grp_camp, 5, X_grp_camp_Rec.END_DATE);
703: dbms_sql.column_value(p_cur_get_grp_camp, 6, X_grp_camp_Rec.ENABLED_FLAG);
704:
705: -- Debug Message
706: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: Get Column Values Ends');
707: END Get_Column_Values;

Line 768: DBMS_SQL.BIND_VARIABLE(p_cur_get_grp_camp, ':p_GROUP_CAMPAIGN_ID', P_grp_camp_Rec.GROUP_CAMPAIGN_ID);

764: -- The following example applies to all columns,
765: -- developers can copy and paste them.
766: IF( (P_grp_camp_Rec.GROUP_CAMPAIGN_ID IS NOT NULL) AND (P_grp_camp_Rec.GROUP_CAMPAIGN_ID <> FND_API.G_MISS_NUM) )
767: THEN
768: DBMS_SQL.BIND_VARIABLE(p_cur_get_grp_camp, ':p_GROUP_CAMPAIGN_ID', P_grp_camp_Rec.GROUP_CAMPAIGN_ID);
769: END IF;
770:
771: -- Debug Message
772: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: Bind Variables Ends');

Line 1061: l_cur_get_grp_camp := dbms_sql.open_cursor;

1057:
1058: -- Debug Message
1059: JTF_PLSQL_API.Debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: Open and Parse Cursor');
1060:
1061: l_cur_get_grp_camp := dbms_sql.open_cursor;
1062:
1063: -- Hint: concatenate all where clause (include flex field/line level if any applies)
1064: -- dbms_sql.parse(l_cur_get_grp_camp, l_select_cl || l_head_where || l_flex_where || l_lines_where
1065: -- || l_steam_where || l_order_by_cl, dbms_sql.native);

Line 1064: -- dbms_sql.parse(l_cur_get_grp_camp, l_select_cl || l_head_where || l_flex_where || l_lines_where

1060:
1061: l_cur_get_grp_camp := dbms_sql.open_cursor;
1062:
1063: -- Hint: concatenate all where clause (include flex field/line level if any applies)
1064: -- dbms_sql.parse(l_cur_get_grp_camp, l_select_cl || l_head_where || l_flex_where || l_lines_where
1065: -- || l_steam_where || l_order_by_cl, dbms_sql.native);
1066:
1067: -- Hint: Developer should implement Bind Variables procedure according to bind variables in the parameter list
1068: -- Bind(l_crit_grp_camp_rec, l_crit_exp_purchase_rec, p_start_date, p_end_date,

Line 1065: -- || l_steam_where || l_order_by_cl, dbms_sql.native);

1061: l_cur_get_grp_camp := dbms_sql.open_cursor;
1062:
1063: -- Hint: concatenate all where clause (include flex field/line level if any applies)
1064: -- dbms_sql.parse(l_cur_get_grp_camp, l_select_cl || l_head_where || l_flex_where || l_lines_where
1065: -- || l_steam_where || l_order_by_cl, dbms_sql.native);
1066:
1067: -- Hint: Developer should implement Bind Variables procedure according to bind variables in the parameter list
1068: -- Bind(l_crit_grp_camp_rec, l_crit_exp_purchase_rec, p_start_date, p_end_date,
1069: -- p_crit_exp_salesforce_id, p_crit_ptr_salesforce_id,

Line 1087: l_ignore := dbms_sql.execute(l_cur_get_grp_camp);

1083: -- Execute
1084: -- Debug Message
1085: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: Execute Dsql');
1086:
1087: l_ignore := dbms_sql.execute(l_cur_get_grp_camp);
1088:
1089: -- Debug Message
1090: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: Fetch Results');
1091:

Line 1101: IF((dbms_sql.fetch_rows(l_cur_get_grp_camp)>0) AND ((p_return_tot_count = FND_API.G_TRUE)

1097: LOOP
1098: -- 1. There are more rows in the cursor.
1099: -- 2. User does not care about total records, and we need to return more.
1100: -- 3. Or user cares about total number of records.
1101: IF((dbms_sql.fetch_rows(l_cur_get_grp_camp)>0) AND ((p_return_tot_count = FND_API.G_TRUE)
1102: OR (l_returned_rec_count 1103: THEN
1104: -- Debug Message
1105: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: found');

Line 1108: -- dbms_sql.column_value(l_cur_get_opp, 1, l_opp_rec.lead_id);

1104: -- Debug Message
1105: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: found');
1106:
1107: -- Hint: Developer need to implement this part
1108: -- dbms_sql.column_value(l_cur_get_opp, 1, l_opp_rec.lead_id);
1109: -- dbms_sql.column_value(l_cur_get_opp, 7, l_opp_rec.customer_id);
1110: -- dbms_sql.column_value(l_cur_get_opp, 8, l_opp_rec.address_id);
1111:
1112: -- Hint: Check access for this record (e.x. AS_ACCESS_PVT.Has_OpportunityAccess)

Line 1109: -- dbms_sql.column_value(l_cur_get_opp, 7, l_opp_rec.customer_id);

1105: JTF_PLSQL_API.Debug_Message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'ast', 'Private API: found');
1106:
1107: -- Hint: Developer need to implement this part
1108: -- dbms_sql.column_value(l_cur_get_opp, 1, l_opp_rec.lead_id);
1109: -- dbms_sql.column_value(l_cur_get_opp, 7, l_opp_rec.customer_id);
1110: -- dbms_sql.column_value(l_cur_get_opp, 8, l_opp_rec.address_id);
1111:
1112: -- Hint: Check access for this record (e.x. AS_ACCESS_PVT.Has_OpportunityAccess)
1113: -- Return this particular record if

Line 1110: -- dbms_sql.column_value(l_cur_get_opp, 8, l_opp_rec.address_id);

1106:
1107: -- Hint: Developer need to implement this part
1108: -- dbms_sql.column_value(l_cur_get_opp, 1, l_opp_rec.lead_id);
1109: -- dbms_sql.column_value(l_cur_get_opp, 7, l_opp_rec.customer_id);
1110: -- dbms_sql.column_value(l_cur_get_opp, 8, l_opp_rec.address_id);
1111:
1112: -- Hint: Check access for this record (e.x. AS_ACCESS_PVT.Has_OpportunityAccess)
1113: -- Return this particular record if
1114: -- 1. The caller has access to record.