DBA Data[Home] [Help]

APPS.CSP_PRODUCT_TASK_PVT dependencies on CSP_PRODUCT_TASK_PUB

Line 470: P_PROD_TASK_Rec IN CSP_PRODUCT_TASK_PUB.PROD_TASK_Rec_Type,

466: ,X_RETURN_STATUS => X_RETURN_STATUS);
467: End Delete_product_task;
468: -- This procudure defines the columns for the Dynamic SQL.
469: PROCEDURE Define_Columns(
470: P_PROD_TASK_Rec IN CSP_PRODUCT_TASK_PUB.PROD_TASK_Rec_Type,
471: p_cur_get_PROD_TASK IN NUMBER
472: )
473: IS
474: BEGIN

Line 502: X_PROD_TASK_Rec OUT NOCOPY CSP_PRODUCT_TASK_PUB.PROD_TASK_Rec_Type

498: END Define_Columns;
499: -- This procudure gets column values by the Dynamic SQL.
500: PROCEDURE Get_Column_Values(
501: p_cur_get_PROD_TASK IN NUMBER,
502: X_PROD_TASK_Rec OUT NOCOPY CSP_PRODUCT_TASK_PUB.PROD_TASK_Rec_Type
503: )
504: IS
505: BEGIN
506: -- get all column values for CSP_PRODUCT_TASKS table

Line 532: P_PROD_TASK_Rec IN CSP_PRODUCT_TASK_PUB.PROD_TASK_Rec_Type,

528: dbms_sql.column_value(p_cur_get_PROD_TASK, 22, X_PROD_TASK_Rec.ATTRIBUTE15);
529: END Get_Column_Values;
530: -- This procedure bind the variables for the Dynamic SQL
531: PROCEDURE Bind(
532: P_PROD_TASK_Rec IN CSP_PRODUCT_TASK_PUB.PROD_TASK_Rec_Type,
533: -- Hint: Add more binding variables here
534: p_cur_get_PROD_TASK IN NUMBER
535: )
536: IS

Line 583: P_PROD_TASK_Rec IN CSP_PRODUCT_TASK_PUB.PROD_TASK_Rec_Type,

579: 'CSP_PRODUCT_TASKS.LAST_UPDATE_LOGIN,' ||
580: 'from CSP_PRODUCT_TASKS';
581: END Gen_Select;
582: PROCEDURE Gen_PROD_TASK_Where(
583: P_PROD_TASK_Rec IN CSP_PRODUCT_TASK_PUB.PROD_TASK_Rec_Type,
584: x_PROD_TASK_where OUT NOCOPY VARCHAR2
585: )
586: IS
587: -- cursors to check if wildcard values '%' and '_' have been passed